Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 01, 2023 03:22 PM
Hi, I have a field of clothing sizes which varies for each garment record. Ideally I'd like to be able to set up a single select field with options that vary depending clothing sizes held in the multiselect or linked field for that particular record.
I can display the options so the user manually picks one of those out of all the sizing options, but it would be nice if the options presented only pertained to the specific garment.
Is there a way to do this? Any thoughts would be much appreciated!
Jun 01, 2023 09:12 PM
Unfortunately, dynamic/dependent dropdown values are not possible in Airtable. One solution is to employ naming conventions that combine values like "garment: size," although not always ideal.
Jun 01, 2023 11:14 PM
Thanks for clarifying! I have it set up two tables for the two SKU levels garment and garment-size so there is a workaround whereby you select the size you want from garment-size when grouped by garment.
The original intention was to use a script to auto compile all the garments assigned to a person, then the person goes in and selects the size they want from the garments and I then join the garment and selected size to make the garment-size SKU to link back to the inventory. It might still work in a clunky way but I guess it's probably easier/simpler to just get them to select the sizes they want directly from the garment-size directory.
Thanks again!
Jun 02, 2023 03:09 AM - edited Sep 02, 2023 06:19 AM
Jun 02, 2023 03:57 AM
Ah thanks for the links, I'll check them out as that might well be something we can make use of.
Much appreciated!