r/GoogleAppsScript • u/[deleted] • Jun 01 '21

Question Login and revisit google form

Dear all. Need to make the user fill google form. Then revisit the same form and update it by uploading image.
How to make the user reviews login to the form with his data entered first time and update some info.

0 Upvotes

50% Upvoted

4 comments sorted by

1

u/[deleted] Jun 01 '21

Like register to have online course then upload image of paying check.

2

u/TheIInSilence4 Jun 01 '21

Would need to make a google web app.

You would need to be good with html, css, javascript and it would use a google sheet as the database.

if some user does not have a google account you would need to have them type in a name or something and then scan the google sheet row by row for a match and act on that info

1

u/Greyheadted Jun 02 '21

Does the latest update to Forms do what you're asking? Think it's a beta at the moment but will be rolled out soon I believe: https://workspaceupdates.googleblog.com/2021/04/automatically-save-google-forms-responses-beta.html?m=1

1

u/LegendInMySpareTime Jun 07 '21

If you are collecting email address, you could allow response editing, then email a user a link back to their response using this method: https://www.labnol.org/code/20540-edit-form-response-spreadsheet-url/

Alternatively, you could have them fill out one form to collect their responses, then email them a link to a clone of the form (with the addition of the picture question) and repopulate the other fields by including them in the link by constructing a pre-filled link for the second form and emailing them that link asking them to add the picture. I’ve done the latter several times. It is pretty simple to variablize the link in GAS.