Re: Automation - Add Record with formula

Automations, in my experience so far, are very finicky.  Try using a formula-date field to automatically calculate your "tomorrow" date; and use that when pushing a date field into a field in a table.  

I have had to rebuild automations which mysteriously do not populate the data I required, after making multiple "updates" to an automation - so one good test is to figure out the entire automation and rebuild it and test with the new one (then do all the naming and commenting after you ensure it works).

A screenshot of your automation setup would also be helpful here.