Is there an easy way of creating a column (field) in Airtable that includes consecutive dates (ie. each record shows the next date on from the record before)?
The only way I find I can do this is to manually insert each date.
Another way would be to ...
I have a field containing scores with each record a day. I’d like to have another field showing the average (or the total) of the last 7 days’ scores.
I cannot find a way to do this having searched for hours. Thanks for your help
A year has gone by so I thought I’d check to confirm that chronological sorting is now available?
I am evaluating Airtable for heavy duty use. It’s such a basic requirement of a database it would be strange if it is not an available function.