I am trying to customize the stock management demo app. I have three tables: Products, Sales, Purchases.
What I am trying to do is trigger an email with the following template:
On <<[TimeStamp]>> there was a material withdrawal of product <<[Product Barcode]>> for the amoun ot <<[Quantity]>> pieces, leaving a current stock of <<[Current Stock]>> pieces.
The problem is that all variables, for the exception of <<[Current Stock]>> are read and parsed correctly in the email.
I believe the problem is that the variable <<[Current Stock]>> is a virtual variable on the Products Table and it is no present on the Sales Table, from which the email is triggered.
I’ve looked everywhere to find a way to call from the table Products the variable <<[Current Stock]>> so I can insert it in the email.
Can someone help me with how should I fill the template so the <<[Current Stock]>> is shown after the materials withdrawal?