Hello community, I’m currently migrating from Google Sheets and Glide to Airtable. Glide’s dynamic filters / automatic relations are missed and I’m struggling to recreate those in Airtable. :-/
Each row in my table represents an item ordered from a vendor, items may be part of an order of multiple items from multiple vendors. How can I automatically relate items within one order that are supplied by the same vendor. The purpose is to create a roll up per vendor, for example to send a single automated email to the vendor per order instead of each single item.
In Glide I would simply have a formula field combining the OrderID and VendorID, which creates an automatic relation. How can I achieve similar functionality in Airtable?
(I’m wondering if this can be down within Airtable or needs to outsourced to Integromat, Zapier…)