Skip to main content

Timestamp for when checkbox has been checked


Show first post

29 replies

Forum|alt.badge.img+2

Already +1 the “Modified date” feature
So we only have two current solutions WITHIN Airtable:

  1. Manually enter the timestamp with the keyboard shortcut Ctrl; Sets the selected date/datetime field to now (see https://support.airtable.com/hc/en-us/articles/204143385-Airtable-keyboard-shortcuts)
  2. Use the linked table and Rollup feature: use the MAX formula on the date field. Only for “last date entered” which brings us back to option 1…

ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8776 replies
  • April 26, 2020

This is now finally a part of Airtable! Yay! :slightly_smiling_face:

Any modification date/time field now has the ability to ONLY be updated when a certain field (or fields) are updated. Great addition to Airtable.


Forum|alt.badge.img+1

Hey Everyone, I just wanted to throw my two cents into this convo.
My use case required a field to measure how long it took from the creation of the record to when a field was filled in.

My solution can work for any field type. Here it is.

Requirements:

Two Tables. Table 1 is where the field will be filled in. Table 2 is where the timestamp will be created.
A Created Time Field in Table 1- This is when the record was created
A Created Time Field in Table 2- This is when the Field was Filled In
A {Field} in Table 1- This is the field we want to add a timestamp to.
A {Forumla} in Table 1- This tells us how long it took to fill in the field
A Linked Record Field in Table 1 that links to Table 2- This keeps the data for each record separate
A Lookup Field in Table 1 that pulls the Created Time- This pulls in the timestamp to Table 1

Automation
Trigger:
When Record Match a Condition
Table 1
When {Field} is not Empty

Action 1:
Create a Record
Table 2

Fields:
Name
Record (Step 1: Trigger)
Record ID

// This creates a record in a new table with the record ID as the name of the record that the field was filled in for Table 1. Thus the Created Field in Table 2 is the Time that the Field in Table 1 was Filled in.

Action 2:
Update Record
Table 1
Record ID
(Step 1: Trigger) Record ID

Fields:
Linked Record Field
Record (Step 2: Create record)
Record ID

// This automatically links the Table 1 record with the Record in Table 2.

Now the Look-up field will pull the Created Time from the linked record and display it in Table 1. You now have a timestamp for when the Field was filled in.

Part Two:
Duration of Table 1 Record Creation until Field was Filled in

Formula Field:
DATETIME_DIFF({Quoted Timestamp},Created)


Forum|alt.badge.img+3
  • New Participant
  • 1 reply
  • August 1, 2023

Hey Jacob!

I know it's been 6 years since you opened the topic, but I'm new around here and found here because I had the same doubt as you did when I was creating a table to organize all studies. 

I wanted to, as the box was checked, the time to be shown at the next field. 

And, after some bumps and researches, came to this solution: 

 

IF({Start}=1,DATETIME_FORMAT(SET_TIMEZONE((LAST_MODIFIED_TIME({Start})), 'America/Sao_Paulo'),'H:mm'),0)

 

Most likely you don't need this anymore, but this might help others in the community. =D

Best vibes.

Ed. 

 

 

Reply