Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Select an option from a list and input a value?

Topic Labels: Scripting extentions
247 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I am using Airtable to track food products that are added to a pallet and then record the date codes for shipping.
I would like to have my employees be able to select one of our 20 products from a list and then input the code date for that selected product as they build the pallet. There may be up to 10 products on a pallet. Is this possible?

Single Select Product 1---->Input code Date (020221)
Single Select Product 2---->Input code Date (050323)
Single Select Product 3---->Input Code Date (061926)

1 Reply 1

Hi @Justin_Cain - I recommend this as a base design for the scenario you describe:

3 tables - Pallets, Pallet Items and Products. It all comes together in the Pallet Items table, which has linked fields to both Pallets and Products:

Screenshot 2021-02-10 at 21.55.05

This is the place where you can add your code date to each product on a pallet