1. Is there any way to add an integration and run it on previous submissions?
A: Yes, but this depends on the integration type. For supported Google integrations such as Google Calendar and Google Sheets, you can run the integration on previous submissions.
To do this, add the integration to your form, then navigate to the Submission database. From there, you can open an individual submission and choose Run now for the available integration, such as Google Calendar or Google Sheets. You can also select multiple submissions and use the bulk options in the submission database to run the integration on all or selected submissions.
Note: Google Drive and payment integrations only run when a submission is first created and the integration is already configured. They can’t be applied retroactively to past submissions.
2. If you edit the Google sheet, will the changes push back to Formstack or does it only go one way?
A: Any time you edit a Google Sheet, you will need to go into the integration settings in Formstack and refresh your sheets via the green refresh arrows in order for the data to sync and send properly.
3. Can attachment links be sent to a Google sheet?
A: Yes, you will just need to map that field from your form to a field on your sheet and the file upload URL will be included in that cell in the sheet and accessible by clicking on the link in the sheet.
4. Is there a way to show a list of options from a Google sheet on the forms?
A: At this time it is not possible to pre-populate fields on a Form or pull data from a 3rd party database with any tools we offer.
You could potentially build this yourself or with the help of a developer if you host the form on your own server via the Advanced HTML embed code. But, that is something you will need to completely develop on your own as it is outside of our supported functionality. Here is a link to our developer tools in case you are interested: