Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Have one field depend on another field

688 3
cancel
Showing results for 
Search instead for 
Did you mean: 
TboneSuarez
4 - Data Explorer
4 - Data Explorer

Hi.  It's my first day. I'm trying to create a maintenance log for my laundromat. I created a base with the following tables: Washers, Dryers, Maintenance Requests.  The Maintenance Request table is populated by a form I created for my staff to request maintenance. On it I created a field called 'Machine Type' where you select washer or dryer. The next field is 'Machine ID' and if you select washer under 'Machine Type' I'd like it to give a drop down menu showing the Machine ID's from the 'Washers' table and if you select 'Dryer' I'd like it to pull the machine ID's from the 'Dryers' table.  Can I do this?

3 Replies 3
Shannon_Bradley
7 - App Architect
7 - App Architect

Absolutely no trouble doing this sort of thing. Just a matter of using linked fields and lookups. I popped together this base with a form that has them all connected. Feel free to use any of it that you like 🙂 https://airtable.com/app7C4z65Vln9t70L/shrLGNVU0PxuU47TM 

Shannon_Bradley
7 - App Architect
7 - App Architect

How odd...I swear I posted my reply to this. May duplicate!

Anyway, yes this sort of thing is a pretty simple setup, utilizing linked tables and lookup fields. I popped together this quick base that has what you mentioned and a form that connects them. Hope it it helpful! https://airtable.com/app7C4z65Vln9t70L/shrLGNVU0PxuU47TM 

Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

@TboneSuarez 
There are quite a few ways to accomplish your goal. This is my recommendation:

- Combine the Washers table and Dryers tables into one Machines table (instead of 2 tables, it's just 1)
- In the Machines table, have a selection for whether the item is a washer or dryer
- For the name of the machine records, write a formula to concatenate the name. Example: "CONCATENATE({Machine Type} & " - " & {Machine ID})

This way, when they fill out the form, they will see a list of all washers & dryers with IDs to select from.