Automation passes test but doesn't work IRL

[Raintiger1971]

Hi there,

I have this automation I have built and it looks right to me and passes the test. The test data populates in the destination table. But when I manually enter data into the source table nothing happens.

Here is the automation:

 This is the destination table. The Article Number "F25NSECVR" was populated when I ran the test.

This is the source table. I manually entered "F25TEST" and nothing happened.

 

 

[kuovonne · Accepted solution]

When the record is created, all of the fields are blank, so the automation run does not pass the test. You will need to use a different trigger or create your record using a form. One possible trigger is “when record meets conditions” and put the test for the text in the condition for the trigger.

[Raintiger1971]

Thank you so much! It took me a minute to figure out what you were trying to explain but now I get it. Posting the setup here in case it's helpful for anyone else.