Is there a way for Appsheet to detect email responses, as a way to track task progress on App?
Unfortunately that’s not possible with a Google Apps Script support. A time triggered Google Apps Script can check your Gmail inbox for some search criteria and do that work.
Thanks LeventK for the quick response, Were just trying to create a task progress status view in our App. Our current process, is that we sent email request for a needed File and the other party attached the file through email response.
What we did with our App, is it sends automatic email for request , and and have the recipient Attached the needed File using the App, so a status change will be triggered and changes the task from Assigned to completed. However, the users refused to do it that way since they feel its more easy to just used the email. So from there we are just trying to find other ways that may be convenient for users…Any other suggestion please…?
Maybe this here:
Further, it’s my understanding that appsheet is actively pursuing deeper integrations with Gmail.
Are those “other party” official users of your app or are they outsiders? Provided they are official users of the app, then you can send them a deep app link via workflow email which will launch the app and the associated record in edit mode on the form, where they can select and upload their file. Then an UPDATES_ONLY triggered DATA CHANGE or WEBHOOK workflow can change the status.
If they are not official users of the app, create a public app, share the related sheet and table with this public app, create a slice from this table to only show the FILE type column in the form. With the email send the deep app link associated with this public app URL which will allow the users to edit that record but face the file upload part only, upload the file, save the record and change the status via a DATA CHANGE or WEBHOOK workflow.
Do you have any other solution in mind bud?
I think those are the best appsheet centric options.