Two forms, one record

Ruby_Sniderman · ‎Aug 31, 2020

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 · ‎Aug 31, 2020

@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 · ‎Aug 31, 2020

@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:

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