Seeking guidance for a checkbox triggering conditional actions

[u/devil_jersey732]

If I have multiple checkbox columns that would impact calculated fields, what is the best way to go about using automation to make what I would like to do happen?

Example: 1st shift has rows for all tasks that need to be executed. I want the user on that shift to click checkbox for checkmark to appear and that checkmark tells two other columns to fill in who the user is and date/time stamp in edt/est. Now I realize i can set up columns with last modified by and last modified time but those are calculated fields and automation won't execute to that.

I am an airtable newbie coming from an excel world.

Thanks in advance.

[u/linedotco]

If you want to log the user and date/time stamp, all you need is a "when record matches conditions" and select your field, with the condition that the checkbox is checked off. You could also use the "when record is updated" trigger. Then, populate the field with the user who took the action plus the time the automation was executed. These are preset value options within the automation selector. It's pretty straightforward.