Community
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.
Comments (3)
Jun 3, 2024
File name When you set up the sync to drive, the file name will include the unique id for that response. The default file name is PF#####_filename where PF##### is the unique response id generated by Formfacade and the filename is the name of the file as uploaded by the user. If the name or email fields are mapped in the Respondent settings, then this will be included in the file name. When the email field is mapped, the file name will be PF#####_<email>_filename. Otherwise, if the name is mapped, the file name will be PF#####_<name>_filename. We do not have the option to include multiple fields from the form in the file name. Unique ID When you sync the Google Forms responses to Google Sheets, each field in the form will be added as a column and each row will be a response. Only the answers for the fields in the form will be synced to google sheets. The unique id generated when the response is submitted will not be included in google sheets.
Jun 7, 2024
So, there is no way to get this unique number in my sheets? It does add a link to the file that someone has uploaded, but the URL doesn't contain the filename. It sounds like you do know what the unique number is when the form is submitted, right? It would help so much if I can connect the correct file to the correct sheets entry automatically. The field that is now used to create the filename can be the same multiple times. Last question: will the unique number of the filename (the PF#####) always be the same number as the unique number connected to the response from the form?
Jun 7, 2024
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.
Add your comment
Add photo