Hello and I would echo all the thanks for rolling out this feature. It looks like a valuable addition.
I’m wondering if it can be used to pass information between tables. I’ve tried to setup some processes but they appear to be restricted to work with 1 table/sheet at a time. My scenario is this:
Order Details table with a qtyDelivered column - linked to a Products table via ProductID
Products table with an Inventory field - key field is ProductID
I want to take the value of qtyDelivered in the Order Details table and update the Inventory in the Products table whenever a new row is created.
Have struggled to get this done conventionally and before going too much further with this feature would like to make sure it can be done.
Any help would be appreciated.