Hi. I’ve set up a few automations with no problems, but I am not sure how to do this one… or if it can be done.
I have an AutoDate column, so when a form entry comes in, it auto-dates the entry of the form. However, I need to then copy that date over to another column (also called Date). That second column, called Date, is used in another formula in the sheet, and I need to be able to edit it (in a way I cannot edit the AutoDate column). But since they are the same 95% of the time, it would save me time if it could auto-populate.
So, in short, how can I automate copying date from the Auto-Date field to the Date field? Is this possible?
If you want a way to copy a single or multiple fields, you can also check out our On2Air Actions app - specifically the Copy Field function
If you use Actions, you also get an additional 60+ features that integrate with Airtable.
Features like creating Google Docs automatically with Airtable data, bulk create, edit, or delete multiple records, set default field values, copy fields, perform financial calculations, sync Google Sheets, and more.
The inability to test a step doesn’t mean that the step is set up incorrectly. It just means that you haven’t successfully tested all prior steps that come before it. Each step must be tested separately, and later steps can’t be tested before testing prior steps. Also remember that if you change the configuration of your table, or any of the data related to the automation trigger, you’ll need to re-test everything from the trigger on down to ensure that it works with your changes.
The setup in your screenshot looks correct. Once you’ve tested the prior steps, I’m pretty sure that this one will work.