No matter which method you use, you will need to spend time creating your own custom workflow to fit your needs. This would require time to learn one of the platforms (or learn how to script), or you can hire an Airtable consultant to help you.
Can you explain your use case a little more? I think there are definitely some easier ways than what has been proposed in this thread and ones that wouldn’t require you to write any custom code, scripts, or use Zapier/Make.
I’ve worked with forms a ton and can probably give you some pointers!
Alright got it working for you. No scripts needed :grinning:
First you are going to want to create a link to the form via a formula in your records table
That formula will need to be constructed via concatenate() and utilize the encode_url_component() formula as well. Here is my example formula I wrote:
Then when you invite your users to fill out the form, you NEED to give them the link in their record-row (which is a unique prefilled form link to them)
You can provide this via an automated email from Airtable or you can manually copy and paste that link and provide it to the correct individuals
Then you are going to want to write an automation that catches those new form submissions and updates the correct record. Heres my automation
I did my working example with an Airtable form (which you can do as well depending on the complexity of your actual form), but if you choose another you will have to do a few more steps. Depending on your form-provider of choice you have some different options.