Sep 05, 2024 11:28 PM
Is it possible to subsequently edit an existing data record using a form, for example to change a status. without making the change directly in the table?
Solved! Go to Solution.
Sep 09, 2024 02:46 AM
Could you provide screenshots of your tables? Here's how I'd set it up:
Sep 05, 2024 11:55 PM - edited Sep 05, 2024 11:55 PM
No, that is not currently possible with Airtable’s forms.
The best way to do this is to use Fillout’s advanced forms for Airtable.
Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.
Hope this helps!
— ScottWorld, Expert Airtable Consultant
Sep 06, 2024 05:00 AM
I have a table "people" and would like to use the name from it when I fill out a form. When the form is filled out, the name used and other information should be entered in the “Booking” table. how do I get that?
Sep 06, 2024 05:41 AM
re: Is it possible to subsequently edit an existing data record using a form, for example to change a status. without making the change directly in the table?
Hm, I'm not too sure I understand. Editing an existing record has to have a change made in the table, no?
If it helps, Airtable has a guide on how to update records via an Airtable form here: https://support.airtable.com/docs/use-case-update-records-via-a-form
---
re: I have a table "people" and would like to use the name from it when I fill out a form. When the form is filled out, the name used and other information should be entered in the “Booking” table. how do I get that?
Does the "Booking" table have a linked field to the "People" table? If it does, you can use that field in your form and you'd be able to select the right person when filling it out
Do note that this means the primary field of the "People" table is visible to anyone who has access to your form though!
Sep 06, 2024 07:50 AM
The "Persons" table contains all relevant master data and is therefore only used for information purposes. All room bookings should be entered in the Bookings table using a form. In the form itself I wanted a drop-down menu that would show me all the names from the "People" table. When the form is sent, all the data should be transferred to the "Bookings" table.
Sep 06, 2024 07:57 PM
Yeap that sounds straightforward. Try creating a form in your "Bookings" table that includes the linked field to the "People" table
Sep 08, 2024 10:04 PM
Thank you for the helpful information, unfortunately I don't know much about Airtable yet. How exactly do I have to proceed?
Sep 09, 2024 01:52 AM
The following fields are linked in the "Bookings" table: Date of birth, Email, A formula field that contains the name and date of birth.
In the form (interface) the data records (names from the People table) are displayed but when I submit the form, the fields "Name", "Date of Birth" and "Email" in the "Bookings" table are empty and all other data that does not match Table "People" linked exists.
Sep 09, 2024 02:46 AM
Could you provide screenshots of your tables? Here's how I'd set it up:
Sep 09, 2024 03:38 AM
Thanks for the quick help. I managed to use the data records of “people” in the form and enter them into the “bookings” table when submitting the form. Thank you