I’m very new to airtable and trying to do what I imagine should be simple. I just want 7 rows with dates, starting with today, going forward 7 days. I want these rows to update every day so that I don’t have to do it manually.
I’d like to be able to do something similar with hours of the day, showing the current hour of the day and listing the next 8 hours in each row.
How can I accomplish this?
Rows and not fields?
Welcome to the community, @brandon_bednar! :grinning_face_with_big_eyes: Could you share more details about your use case, and the end goal you’re trying to achieve? There’s not enough detail currently to have a clear picture of what you’re doing.
Have a field {Add Days} that says how many days to add for that row. Then use this formula field:
DATEADD(TODAY(), {Add Days}, 'days')
Have a field {Add Days} that says how many days to add for that row. Then use this formula field:
DATEADD(TODAY(), {Add Days}, 'days')
How do I get it to auto generate all the days of the year? I’m looking to set up a social media calendar, and want a list of each day of the year. Jan-Dec.
Thanks!
How do I get it to auto generate all the days of the year? I’m looking to set up a social media calendar, and want a list of each day of the year. Jan-Dec.
Thanks!
That is a different use case. In order to generate a new row for each day of the year, you must create new records. The original poster wanted to have only seven rows without adding more rows.
If this is a one-time generation of records, you can use keyboard shortcuts to generate a lot of rows quickly.
That is a different use case. In order to generate a new row for each day of the year, you must create new records. The original poster wanted to have only seven rows without adding more rows.
If this is a one-time generation of records, you can use keyboard shortcuts to generate a lot of rows quickly.
Gotcha.
Maybe I’ll start a new thread for my question.
Thanks for the info!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.