- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2025 03:31 PM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2025 03:44 PM - edited ‎Jan 09, 2025 03:44 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2025 03:51 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 10, 2025 07:37 AM
@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.
