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
Jul 12, 2021 08:20 PM
Hello,
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.
Jul 12, 2021 09:05 PM
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”.