I’m trying to set up automation between some databases.
What I want to achieve is an update of the quantity of products in stock, specifically:
I have these databases:
- in stock
- recipes
- each recipe page contains an inline database with the relevant ingredients and their quantities; the ingredients are linked to the stock database
- the recipe database has a button property that I want, when pressed, to retrieve the ingredients used and their quantities, and then subtract them from the quantities in stock
I’ve tried using search object, but the rows in the database with the values aren’t being returned. How can I fix this?
Also how can i get the child database id of a page?
