I need to copy a record from one table to another table (or from one base to another base). The records I need to copy are the ones I label as “Expired”. The act of copying them will be done manually, that’s not an issue. What I am looking for is how to preserve the date in the Create Date field when copying the record.
Right now copying the record would trigger the Create Date field to be updated with a new date (=now date). What I want is the new copied record to cary over the original create date.
One solution I came with is to:
- In Table 1 (the record has Create Date field with the date)
- In Table 1 add another field called “Original Date”
- Set up Automation in AirTable or Integromat. It would trigger when this “Original Date” date field is empty.
- When copying the record into Table 2, this Original Date will be carried over (although the Create Date will have a new date =now date).
I haven’t tested Airtable Automations if it will work but I assume it should (another option is to use Integromat but I have limited number of credits there so I’d rater stick with automations).
Wanted to check for other ideas before I do this. The solution I came up is not a pretty one so wanted to check if there is another better way doing this.