I have two tables Projects and Approvals. Projects are "approved" through an approval form that feeds entries to the Approval table. I have setup an approval form that dynamically pre-populates a record identifier in the URL from the Projects table.
I have setup an automation to run when a new entry appears in Approvals table
When I test the Find Records step using the dynamic Record Identifier filed from the form - the test shows me 0 results. But if I copy/paste the same record id and use the static mode - it returns 1 result correctly
The automation ALSO works when it is Live - I'm just not able to use the testing function as it always returns 0 results. Any ideas please?