Help

Edit records in the form

Topic Labels: Formulas
Solved
Jump to Solution
812 9
cancel
Showing results for 
Search instead for 
Did you mean: 
user2100
7 - App Architect
7 - App Architect

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?

1 Solution

Accepted Solutions

Could you provide screenshots of your tables?  Here's how I'd set it up:

Screenshot 2024-09-09 at 5.45.40 PM.png

Screenshot 2024-09-09 at 5.45.38 PM.png

Link to base

See Solution in Thread

9 Replies 9
ScottWorld
18 - Pluto
18 - Pluto

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

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?

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!

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.

Yeap that sounds straightforward.  Try creating a form in your "Bookings" table that includes the linked field to the "People" table

Thank you for the helpful information, unfortunately I don't know much about Airtable yet. How exactly do I have to proceed?

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.

Could you provide screenshots of your tables?  Here's how I'd set it up:

Screenshot 2024-09-09 at 5.45.40 PM.png

Screenshot 2024-09-09 at 5.45.38 PM.png

Link to base

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