Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Automations from form

Topic Labels: Automations
371 1
Showing results for 
Search instead for 
Did you mean: 


I am new to Airtable. I run a storage facility and am trying to use the product to automatically update availability status when an intake form is submitted by a new customer. So ideally they would fill out the form, include their unit number on the form, and then an automation would change the availability status for that unit to Occupied in the table. However, I’m not sure how to use the same form for multiple units/records or if it is possible. I’m wondering if I should create a unique form for each unit but that seems like a lot of work and may become hectic. Do you have any suggestions?
Thank you.

1 Reply 1

You may not need an Automation at all.

If you have a table for [Units] and a table for [Intake Forms], and those tables are linked together, you can set up a system that uses a Formula field to display “available” or “occupied” depending on if the unit is linked to a form record that is currently “out”.