I have an automation with multiple actions and it’s failing, presumably as action 2 needs to wait a little until action 1 has competed. Is that possible?
Here is what I have:
Trigger: on ticked checkbox
Action 1: copying date and single-select fields to text fields with the same value/name
Action 2: find records using the text fields in Action 1
Action 3: update records
When I test the automation, it’s successful. When I split this autoamtion into two automations, it works fine. But when I have them sequencially in the same automation, with single trigger, Action 2 fails.
It says the fieds in Find Records have invalid filters. I’m guessing the text fields in Action 1 are not yet filled before Action 2 has started to find records. Is that possible?
My gut says that’s not the case. My experience with automation actions is that each action fully completes before moving on to the next action. My gut says that something with the filter settings might need to be tweaked. Would you be willing to share screenshots of your automation steps?
I deleted the Date field update in Action 1, and changed the find to the original single-select fields and the automation worked!
Wondering if there is anyway not to manually enter the date in month/year format in a text field. The text field is required as a dynamic value in actions cannot be a formula or date field, if I am not wrong?
Sorry for the delayed reply. I’ve reviewed these notes several times, and I’m completely lost. There are still pieces missing for me, like other setup details from your automation. Could you please post screenshots of all automation steps and all relevant table fields?