Hello - I'm hoping someone can point me in the right direction. I've been asked to create an analytic app that:
1. Allows users to retrieve all records under their name from a Google sheet.
2. After they receive the selection, they should be able to further retrieve a specific record from that selection.
3. They should then be able to update any fields within that record.
4. The updated record should overwrite the prior one in the same Google Sheet.
Is this at all possible? I'm able to retrieve the filtered records in a browse. It would be great if my users could further use this App Results window to select the record to update, but any interface functionality that would let them do this will work.
I'm intermediate-level and still learning. I'm familiar with the Google tools and fairly complex workflows, but do need some extra coaching with analytic apps.
Thank you for your help with this!