Objective: send a book to a potential customer.
I have 2 tables:
1 - books 2 - customers
In my table 1 - books, I have a column “sent” and a virtual column “last email”. The virtual column is populated with the LASTROW email from 2 - customers.
When I add a customer (and select the book at this time) I want it to be sent to this customer.
My workflow to update the tables 1 - books works, when I add a customer and select the book (reference), it add + 1 to the column “sent”.
All the workflows work when I test them separately and when I add a customer it add 1 to my column “print” but this change is not taken into account and does not trigger the email.
Is it normal ?