How can I auto populate the start of the week and the end of the week?

Jump to Solution
4883 21
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I’m very new to airtable but have learned a lot by watching tutorials and searching the community. I’m not sure if I’m searching for the right thing for this particular issue though.

I’m setting up an airtable for a client who has a form that needs to be completed by his clients on a weekly basis. He needs to know who hasn’t submitted the form 3 days past the day he sends it out which will be on the same day each week.

For instance, he’ll send the email with the form attached to be completed every Monday and if someone doesn’t fill it out by Thursday, we need to automate an email to follow up and remind them to complete it.

I’m thinking I need a field dedicated to auto-populating whatever the current day is or at least a formula that shows when the week starts and when it ends.

What formula do I need for this? This is literally the last thing I need in order to complete this airtable setup but I can’t figure it out.

Any help would be greatly appreciated!

1 Solution

Accepted Solutions
7 - App Architect
7 - App Architect

Try this. Change “Date” to whatever date you want and the formula will return the monday of that week.

DATEADD(Date, -WEEKDAY(Date, "Monday"), 'days')

See Solution in Thread

21 Replies 21
7 - App Architect
7 - App Architect

Is it an Airtable form or an external form?

Hello, thank you for responding. It’s an Airtable form.

And the person filling out the form need to manually enter her/his name? Or does each client have their own Airtable account?

I have it set up to where all they have to do is select their name. I’ve added all of their names into Airtable already. Hopefully this screen shot will come up so you can see what I mean. (These are all fake names I made up to test it out). They don’t have their own Airtable account, but the coaches assigned to each client will have one.

Screen Shot 2021-09-22 at 3.15.25 PM

Great! Have you added a “Created time” field to your table?

Yes, I have a “Date Submitted” field. I have a place on the form that asks for Today’s Date that they select and it goes into a “Date Submitted”.

You don’t need to do that. There’s actually a type of field called “Created time” that will automatically show you when the record was created. I.e. when the form was submitted. I’ll have to think about what to do next :slightly_smiling_face:

Oh wow!! Ok That might be better because I was thinking what if they accidentally select the wrong date.

I’ll create a “Created Time” field now! Thank you. And thank you for taking the time to help me walk through this!

Also, I wanted to add that this is the formula I’m using to show that they are 3 days overdue. I’ll have to change “Date of submission” to the “created time” field though.

IF(DATETIME_DIFF(TODAY(),{Date of Submission},‘days’)>3,“Overdue”)

7 - App Architect
7 - App Architect

Will you have a separate table for each form, or is it the same form and table every week?