Help

Unique Single Select Status on a Dataview/Table

Topic Labels: Views
Solved
Jump to Solution
1191 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nick_Rotundo
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

Hi @Nick_Rotundo
Here is an idea.

  1. Have a table of Carts
  2. Have a table of Cones (1-20)
  3. In the Carts table add a field that is Link to another record: Cones
  4. In the Cones table, create a view “Available cones” with a filter: Where the new linked Carts field is empty
  5. Then edit the field from Step 3 to Limit the record selection to a view: Available cones

I am assuming once the repair is complete the Cone comes off the Cart and is reentered into the pool.

See Solution in Thread

2 Replies 2
Vivid-Squid
11 - Venus
11 - Venus

Hi @Nick_Rotundo
Here is an idea.

  1. Have a table of Carts
  2. Have a table of Cones (1-20)
  3. In the Carts table add a field that is Link to another record: Cones
  4. In the Cones table, create a view “Available cones” with a filter: Where the new linked Carts field is empty
  5. Then edit the field from Step 3 to Limit the record selection to a view: Available cones

I am assuming once the repair is complete the Cone comes off the Cart and is reentered into the pool.

Nick_Rotundo
4 - Data Explorer
4 - Data Explorer

This worked great! Thanks for your insight