Hi,I am trying to automatically create or update records based on certain criteria from another table. It's to create invoice with line items. The process is the following:1. if a record's date field is today, create a record in table A.2. then find ...
A quick update.I played around by adding a random delay script at the beginning of the automation which is easy to implement but still not solving the race condition problem.In the end, I created a script to add the invoice records first then did wha...
@CalvinAndHobbes wrote:If I'm understanding your scenario correctly, the issue here might be that you're trying to update the same line item field in the invoice table with a set value, which is determined at the same time from both updates. If you t...
