Community
Is it possible to pull the Response ID from formfacade to use on google sheets.
I can see on the collaborators email you use #${ORDERID()} but does this get sent over to google forms in any way.
I would like to use the ORDER ID as the RMA number
Comments (4)
Feb 26
Hi Rob, The unique ID is generated after the user submits the form. Therefore, it will not be recorded in Google Forms; only the answers to the questions in the form will be recorded in Google Forms and the linked Google Sheets. You can use Formfacade Reports or export the data.
Mar 3
Is it possible to use a hidden question in the form itself to generate a increasing number. for example I have created a question called RMA# and set to office only. What would be a formula to create an increasing number after each form is filled?
Mar 4
Hi Robert, you can use the sequence() formula to generate a unique (draft) id for each response and record it in google forms. Please note that these numbers may not be sequential, as some users might abandon their responses.
Mar 4
Perfect. Yes this appears to be working. Thank you
Add your comment
Add photo