Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Return unique dates from all records in a table

Topic Labels: Formulas
286 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I’m trying to organize some data from a csv upload. In the csv upload, there is a “Date” field, and I want to create a daily summary of all records per day. For ARRAYUNIQUE(values) to work, I’d have to link all of the records with that date. However there are many days from one single upload. Is there a way to get all unique days from the whole table, or a way to link all records per unique date?

Thanks!

1 Reply 1

Welcome to the Airtable community!

There is no out-of-the-box feature to automatically link records by date.

However, a custom script could generates the links for you. You can also create the links using a third party integration service like Zapier or Integromat.