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)
