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

Limit Field Values of an item based on values of other items with matching group field

Topic Labels: Automations
435 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi Guys,
I am evaluating AirTable for our warehouse inventory tracking and i am enjoying it.

I was wondering if someone can help me in answering the following Scenario:

  • I have items that belong to the same Purchase order for a specific Job, and typically all items on that order would come from the same supplier.
  • So my items would have a POnum Field and a SupplierName Field. And based on the above, all items with the same POnum should have the Same SupplierName.
  • So is there a way to limit the drop down of the supplier filed so it only shows that same SupplierName from a previous item with the POnum, OR set the value directly for the SupplierName instead of limiting the dropdown?

I hope this clear.

0 Replies 0