Automating Data From One Table to Another, Automation Shown As Having Worked, Yet Field Is Empty

Yah, that's because at the point of manual record creation via a View Grid, a record is empty at its point of creation - triggering the automation whilst in its empty state, resulting in empty data.

There's been much discussion around this problem, so it's worth searching the forums and reading up on the various methods that you may use to address this.

If your users are entering in data via a View Form or an Interface Form, then your automation will work as expected on that form entered data.

Or if users are using the Grid View to enter data, then you're going to need a different trigger mechanism to use so that your automation only triggers on existing data (rather than data that's about to exist, but as it doesn't, results in an empty data payload).

Feel free to ask questions if you need further help finding a more specific solution.

Yeah, I was worried about that, thanks. I was wondering if doing some kind of lookup or adding a step in or something to create a delay, then adding something like a “if this record is not empty” condition and hoping that that might work.

Thanks!

Yah, it can be as simple as creating a tick-box field that the users checks when they're ready to submit their record to the automation.

Another method discussed is with a bit of formula field trickery, you can have the automation trigger 5 minutes after record inactivity.

I use both of the above in their various forms.