Skip to main content

Hello there,

 

I want to create a form in Softr, connected to my Airtable DB, where my employees will input their availabilities for “next week”, so I need to generate automatically the “next week” concept.

 

I have created a table “weeks”, with the following columns :

  1. Week number
  2. Year

 

To generate the concept of “is next week”, I want to create a date field “today” that updates automatically on a daily basis, and then in the field “is next week”, put a formula.

 

However, I don’t know how to automate the update of the date at “today’s date” .

 

Can you please help ? :)

 

Hey ​@Vanessa D,

Are you looking for the following formula?
 

Today()

 
Do note that you can further format this to something like:
 

DATETIME_FORMAT(TODAY(), "MM/DD/YYYY")


Hope this helps!

Mike, Consultant @ Automatic Nation

Hey ​@Vanessa D,

I’m glad you reached out to the community for help!

 

Airtable has a TODAY() function which you can use in a formula field. So, to create a formula for “Is Next Week”:
 

AND(
  WEEKNUM(TODAY()) + 1 = {Week},
  YEAR(TODAY()) = {Year}
)

 

ChatGPT can also be a really helpful partner for you as you build out your Airtable base. And, if you get stuck with ChatGPT, the community will always be here to help 🙂

Hello ​@BuildForAT and ​@Mike_AutomaticN ,

 

Thanks for your inputs !

 

Actually is the daily automating that gets me stuck (I want to set up an automation so that every day the field updates to “today” - because I guess that TODAY() sets the value of the day it is input, but does not updates (but maybe I’m wrong ?!) ? 😅

Hello ​@BuildForAT and ​@Mike_AutomaticN ,

Also, I believe the TODAY () formula is not recognized as a DATE field format so when I want to use it for calculating “next week” it does not work ?!

So this one will actually update automatically meaning it will be a different value tomorrow without you having to change anything 👍

Yes, the TODAY() function is a DATE and you can also format it as a DATE, which is great!

If you would like to calculate the next week number, you can use this formula:
 

WEEKNUM(DATEADD(TODAY(), 7, 'days'))

 

Reply


Terms & Conditions