Welcome to the community, @Jim_Brown!
You might be better off creating one unified form, and then conditionally show/hide the other fields based on the options that the user selects.
If you want to stick with separate forms, Airtable does not have any built-in way of letting you know which form the submission came from. You could take the approach that you’re already taking, and then automate the copying & pasting of records from one table to another.
Or, one of the most common workarounds is to just add a field to your form that is required to be filled in, but make sure that that field is unique to that form. So, the presence of a value in that field would indicate which form was submitted.
Welcome to the community, @Jim_Brown!
You might be better off creating one unified form, and then conditionally show/hide the other fields based on the options that the user selects.
If you want to stick with separate forms, Airtable does not have any built-in way of letting you know which form the submission came from. You could take the approach that you’re already taking, and then automate the copying & pasting of records from one table to another.
Or, one of the most common workarounds is to just add a field to your form that is required to be filled in, but make sure that that field is unique to that form. So, the presence of a value in that field would indicate which form was submitted.
@ScottWorld Thanks! I’ll stick with this solution.
@ScottWorld Thanks! I’ll stick with this solution.
There is now an alternate approach to this with current Airtable automation features that allows you to distinguish between forms that use identical fields and without using a prefill.
You can create an automation using the "When a form is submitted" trigger. This trigger lets you identify a specific form to use for a subsequent action, like entering the name of a form into a field.