Skip to main content
Solved

Attendance Tracker Automatically Create Record for Present

  • August 22, 2022
  • 12 replies
  • 148 views
C
Forum|alt.badge.img+2

Is it possible to create an automation that will create a record at the end of the day if a student is not marked absent they will be counted as present.

I have a form for teachers to fill out when a student is absent. However, I want to create something that will also count when a student is present, not just the change to present. For example, if there is a class of 4 students and everyone is in attendance then I would get a record at the end of the day where 4 different records were created saying that all students were present.

Is there a script that is possible for this? Currently, my automation is grouping all four “present” students into a single record and I want a different record for each.

Best answer by Mohamed_Swella1

Yes, the records in the view are the ones that are present as of today.
Help with this formula would be great. I’m not sure how to write a formula to have it trigger at a specific time and date.
Help with this automation would be helpful whenever you have a chance.


Hi @Carrie_Moy ,

Sorry for the late reply.

IF(OR(AND(DATETIME_FORMAT(NOW(),'H')>=13,DATETIME_FORMAT(NOW(),'H')<=24),AND(DATETIME_FORMAT(NOW(),'H')>=0,DATETIME_FORMAT(NOW(),'H')<=1)),"Trigger")

This formula only works on GMT timezone (we can change it to whatever timezone you need). So this basically triggers at 1 PM GMT up to 1 AM GMT. You can change the numbers as needed.

You can then put an extra filter in the view you made that has the present students to include this new formula field and set it as Not Empty.

The automation will then work on this new view as a trigger to create whatever records you need in the attendance table.

12 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • August 22, 2022

I don’t know JavaScript, so for me personally, the easiest way to do this would be to use Make to create an automation that does a search once a day for the students that you’re looking for, and then creates new records for those students.

Your Make scenario could be as simple as these 2 steps:

Other people might have other ideas for you as well. There are also workarounds to do this sort of thing with Airtable’s native automation steps, which I describe in more detail in this BuiltOnAir podcast episode:

Mohamed_Swella1
Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Carrie_Moy ,

Welcome to Airtable Community !

If you are creating a record for absent, this means you are linking the absent to the student, correct? Or is it a separate record without any linking?

If so, then you can create a view in the Student table where there is no record created today which means they are Present. Please this view you can send the daily email or you can create the records you need

C
Forum|alt.badge.img+2
  • Carrie_Moy
  • Author
  • Participating Frequently
  • August 22, 2022

Hi @Carrie_Moy ,

Welcome to Airtable Community !

If you are creating a record for absent, this means you are linking the absent to the student, correct? Or is it a separate record without any linking?

If so, then you can create a view in the Student table where there is no record created today which means they are Present. Please this view you can send the daily email or you can create the records you need


Thank you! I have a form that can be filled out allowing the teacher to change the status from present to absent. That then links the form submission to the student table. I want present to do the same kind of linkage. The student table already has students and new records will not be created each day. I want a new record in my form table for each student when the student status does not change to absent. Is this possible?

C
Forum|alt.badge.img+2
  • Carrie_Moy
  • Author
  • Participating Frequently
  • August 22, 2022

I don’t know JavaScript, so for me personally, the easiest way to do this would be to use Make to create an automation that does a search once a day for the students that you’re looking for, and then creates new records for those students.

Your Make scenario could be as simple as these 2 steps:

Other people might have other ideas for you as well. There are also workarounds to do this sort of thing with Airtable’s native automation steps, which I describe in more detail in this BuiltOnAir podcast episode:


Hi Scott,
I would prefer to use a native automation in AirTable if possible. Do you know where in the video I should focus?
~Carrie

C
Forum|alt.badge.img+2
  • Carrie_Moy
  • Author
  • Participating Frequently
  • August 22, 2022

I don’t know JavaScript, so for me personally, the easiest way to do this would be to use Make to create an automation that does a search once a day for the students that you’re looking for, and then creates new records for those students.

Your Make scenario could be as simple as these 2 steps:

Other people might have other ideas for you as well. There are also workarounds to do this sort of thing with Airtable’s native automation steps, which I describe in more detail in this BuiltOnAir podcast episode:


Hi Scott,
I would prefer to use an airtable native automation is possible rather than investing in a third-party application. Do you know where in the video I should focus?
~Carrie

Mohamed_Swella1
Forum|alt.badge.img+17

Thank you! I have a form that can be filled out allowing the teacher to change the status from present to absent. That then links the form submission to the student table. I want present to do the same kind of linkage. The student table already has students and new records will not be created each day. I want a new record in my form table for each student when the student status does not change to absent. Is this possible?


Yes, that is possible with the automations.

If I understand correctly, you already have an automation but it creates one record only, we can start from there, share a screenshot of it if you like.

What I would do is:

  1. There must be a Date field in the form table
  2. Using the linked field in the student table, create a Rollup field with ArrayJoin (anything actually would work) with the conditional filter Absent and Date is Today
  3. Create a new view in the student field (you can call it Present - Automation Trigger) where this new field is Empty
  4. Using this new view create an automation to create records in the form field with the status Present.
ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • August 22, 2022

Hi Scott,
I would prefer to use an airtable native automation is possible rather than investing in a third-party application. Do you know where in the video I should focus?
~Carrie


I don’t know if my trick will specifically apply to your scenario, but it might! I start my demo around 29:12 in the video.

C
Forum|alt.badge.img+2
  • Carrie_Moy
  • Author
  • Participating Frequently
  • August 22, 2022

Yes, that is possible with the automations.

If I understand correctly, you already have an automation but it creates one record only, we can start from there, share a screenshot of it if you like.

What I would do is:

  1. There must be a Date field in the form table
  2. Using the linked field in the student table, create a Rollup field with ArrayJoin (anything actually would work) with the conditional filter Absent and Date is Today
  3. Create a new view in the student field (you can call it Present - Automation Trigger) where this new field is Empty
  4. Using this new view create an automation to create records in the form field with the status Present.

Here’s the automation I have so far…
If a teacher marks the student in the form as absent, this will update the record in students table to be absent and the session attendance table will be linked to the student record.

  1. There must be a Date field in the form table
    YES, I HAVE A DATE FIELD IN THE FORM
  2. Using the linked field in the student table, create a Rollup field with ArrayJoin (anything actually would work) with the conditional filter Absent and Date is Today
  3. Create a new view in the student field (you can call it Present - Automation Trigger) where this new field is Empty
    I DID THIS AND HAVE RECORDS IN THIS VIEW
  4. Using this new view create an automation to create records in the form field with the status Present.
    COULD YOU PROVIDE A BIT MORE DETAILS ON THIS?
Mohamed_Swella1
Forum|alt.badge.img+17

Here’s the automation I have so far…
If a teacher marks the student in the form as absent, this will update the record in students table to be absent and the session attendance table will be linked to the student record.

  1. There must be a Date field in the form table
    YES, I HAVE A DATE FIELD IN THE FORM
  2. Using the linked field in the student table, create a Rollup field with ArrayJoin (anything actually would work) with the conditional filter Absent and Date is Today
  3. Create a new view in the student field (you can call it Present - Automation Trigger) where this new field is Empty
    I DID THIS AND HAVE RECORDS IN THIS VIEW
  4. Using this new view create an automation to create records in the form field with the status Present.
    COULD YOU PROVIDE A BIT MORE DETAILS ON THIS?

That is great. Im assuming the records you have in this view are the correct records? i.e. students whom were present?

We might need to add a formula field since you want to trigger this at a specific time I assume?

You can start a new automation that looks for records in this view and creates new records based on those records. Im currently not on my computer but I can do it later tonight if you want

C
Forum|alt.badge.img+2
  • Carrie_Moy
  • Author
  • Participating Frequently
  • August 22, 2022

That is great. Im assuming the records you have in this view are the correct records? i.e. students whom were present?

We might need to add a formula field since you want to trigger this at a specific time I assume?

You can start a new automation that looks for records in this view and creates new records based on those records. Im currently not on my computer but I can do it later tonight if you want


Yes, the records in the view are the ones that are present as of today.
Help with this formula would be great. I’m not sure how to write a formula to have it trigger at a specific time and date.
Help with this automation would be helpful whenever you have a chance.

Mohamed_Swella1
Forum|alt.badge.img+17

Yes, the records in the view are the ones that are present as of today.
Help with this formula would be great. I’m not sure how to write a formula to have it trigger at a specific time and date.
Help with this automation would be helpful whenever you have a chance.


Hi @Carrie_Moy ,

Sorry for the late reply.

IF(OR(AND(DATETIME_FORMAT(NOW(),'H')>=13,DATETIME_FORMAT(NOW(),'H')<=24),AND(DATETIME_FORMAT(NOW(),'H')>=0,DATETIME_FORMAT(NOW(),'H')<=1)),"Trigger")

This formula only works on GMT timezone (we can change it to whatever timezone you need). So this basically triggers at 1 PM GMT up to 1 AM GMT. You can change the numbers as needed.

You can then put an extra filter in the view you made that has the present students to include this new formula field and set it as Not Empty.

The automation will then work on this new view as a trigger to create whatever records you need in the attendance table.

C
Forum|alt.badge.img+2
  • Carrie_Moy
  • Author
  • Participating Frequently
  • August 23, 2022

@Mohamed_Swellam and @ScottWorld Thank you so much. Both of your solutions worked! I appreciate the help!

ScottWorld
Mohamed_Swella1
Terms & ConditionsAccessibility statement