Solved: Appsheet and Google Form - Page 2

alhazen · 02-21-2023 12:30 AM

Hi Guys,

I have a project management App. This app has a table called "job". "Job" has a column called [status]. So when the status is "completed" the bot is triggered to send an email notification to the client.

Is it possible for a bot to generate a google form link related to the Jobs table? This form will be used by the client to provide ratings and feedback on the results of work that has been completed.

Thank you very much for your help.

scott192

So, your Google Form is going to have a space on it that will be filled using the prefilled link from Appsheet.

I usually put some text on the google form to indicate to the user filling the form that the value in the field is 'Office Use Only' and they should not edit/change/tamper with the value. Unfortunately there isn't a way to hide a field on a form used for this purpose (yet! I have asked for it to be implemented...) so you have to trust your client not to mess with it.

The value you will put in here is going to be the [ID] of your Job...whichever field is holding that uniqueid() you will insert it in here. I say 'you', but of course I mean your bot. This will trigger when the [Status] field is set to 'Complete' or whatever value you need that triggers the feedback bot.

The bot will send an email to the user or users that you require to comment on the form. The email will have some boilerplate text as is usual and will include the concatenated expression that builds the prefilled url out and includes your jobid.

Anybody that clicks that prefilled url will end up with your feedback form with the specific linking field already filled in.

You should get the results of each form submit sent to a sheet and bring that sheet into Appsheet. You can then set the specific field with your jobid in it as a Ref type back to your Jobs table.

View solution in original post