I have built an Airtable structure that utilizes the Created date/time field type to track when a record is added. This Airtable solution will replace an Excel version of the same data.
The Excel version contains 2 years worth of data with it’s own creation date column.
When I come to import this data into Airtable, the Created date/time field is going to return a value of the import date/time and rightfully, not the real creation date from Excel,
This means when I develop charts such as Records added by month, the imported data will always be linked to the import month. I will not be able to use the Created date/time field to analyse the historical data.
What is the best way to only have to use one creation field date (without the user manually choosing the creation date on a form) to track the actual creation date of both historical and current/future data?