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

[Shauna_Renee]

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!

[Per_Carlen]

Is it an Airtable form or an external form?

[Shauna_Renee]

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

[Per_Carlen]

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

[Shauna_Renee]

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.

[Per_Carlen]

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

[Shauna_Renee]

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”.

[Per_Carlen]

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:

[Shauna_Renee]

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”)

[Per_Carlen]

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