Two forms, one record

[Ruby_Sniderman]

Hi,

I’m creating two forms- one that an interviewer fills out at the start of the day, and one that they fill out at the end of the day. I would like both of those forms to go to ONE record which would be based on the date. This would include all the information from both forms. When I made the two forms and tested they each created their own record and the date is in there twice.

Thank you!

[Zollie]

@Ruby_Sniderman, I don’t believe that’s possible. Forms, as you’ve discovered, only create new records - they don’t allow you to edit a particular record. For edit permissions, a user would need to be a collaborator in the base (a user you pay for).

You could, however, collect responses in a table and then use a linked record field to collect those responses together. The user inputting the form would need to know the name of the linked record they’re adding onto, such as one with their name associated with it. The downside is, responses will become a very tall table very quickly.

[ScottWorld]

@Ruby_Sniderman,

There are also external tools on the market that let you update existing records through forms. For example, this company makes several tools for this purpose:

miniExtensions

Tools and Integrations for Airtable - miniExtensions

Add new features to Airtable. Process unlimited records in bulk with scheduling and automation. An alternative to Zapier and Integromat

But there are other companies that do this as well, such as https://on2air.com/on2air-forms/ and https://www.stacker.app