It would be great if you could configure linked fields to only populate with records that match certain conditions. Those conditions being values entered in other fields on the same table.
EG: Table one
Field One = Retailer
Field two = Product Type
Field Three = Item ID/SKU = this field is a linked record field which only allows the selection of records whose fields match/contain the values entered in it’s shared table.
Field 1 Retailer = Allen’s Discount Grocery Emporium
Field 2 Product Type = Food
Field 3 Item ID/SKU, should only let me select Hot dogs, apples, bread… It should not let me select Rodent Killer XXX manufactured by Howie Liu’s Elimination Station.
For me, this seems to be air tables biggest limitation.