We're using Formfacade to ensure people can upload files with their Google Forms. It works really well!
When someone fills in the form, we automatically add the info to a Google Sheet, which also works great.
The file gets a unique number in front of the filename, corresponding to the submission number (also the number that gets mailed in the confirmation mail to the person filling in the form).
2 questions about this:
1.) The filename currently consists of this number, 1 answer of a field, and the original filename. Is it possible to have the filename take 2 answers from the form instead of just 1.
2.) Is it possible to get/see the unique submission number when the information is added to the sheet? For now, this is kind of the only way for us to connect the information to the file that is being uploaded.
I though I could just 'guess' the number myself since it's a incrementing number, so I can just count the rows in the sheet — BUT, I noticed abandoned forms also get a unique number, so this is not possible.
So in short: is there a way to get this number in the sheet?
Thanks in advance.
When the user submits the form, Formfacade generates a unique number for that response. Since the unique id is generated after the response is submitted, it cannot be recorded in Google Forms. So, when you sync the google forms responses to google sheets, it will not be available.
The link to the uploaded files will be recorded as the answer for the file upload question in Google Forms (+ Google Sheets). This link include the file name as uploaded by the user. The format for the link is: https://formfacade.com/uploaded/form_id/response_id/item_id/file_name.
When you set up the sync to Google Drive, the default file name includes the unique id and the name of the file as uploaded by the user. For example, PFxxxxxxx - <default_name>. If you map the name or email field in the Summary settings, the file name will include this field as well. For example, PFxxxxxxx - <email> - <default_name>. You should be able to match the response in Google Forms based on this email or name field.
The unqiue id in the file name in the Google Drive folder will always match the unqiue id displayed in the Formfacade Responses page.
Fri Jun 07 2024
| 3 Replies
