May 24, 2022 10:59 AM
We use Airtable for Work in Progress at our golf cart repair shop. We have numbered cones that we physically put on customer carts in for repair. My goal is to limit the number of units that come in for service to 20 units.
I want to create a field on the service table that corresponds to the numbered cones. So I would match a service ID to a cone number.
Ideally, I would like to use a single select and once I assign “1”, I would like that option to be unavailable for the other records on that table. Right now single select will allow me to keep selecting “1” for all of the records on that table. I also tried setting up the cones a separate table and using a linked field. That didn’t work either.
Open to any suggestions! Thank you in advance!
Solved! Go to Solution.
May 24, 2022 11:53 AM
Hi @Nick_Rotundo
Here is an idea.
I am assuming once the repair is complete the Cone comes off the Cart and is reentered into the pool.
May 24, 2022 11:53 AM
Hi @Nick_Rotundo
Here is an idea.
I am assuming once the repair is complete the Cone comes off the Cart and is reentered into the pool.
May 25, 2022 06:22 AM
This worked great! Thanks for your insight