Accepted Solutions
Hey Michelle!
I’m so glad you’re finding the community forum useful as you integrate Airtable into your workflow! If you’d like to reference the table I used to show you how it all works together, feel free to check it out here in the contacts table. Here’s more information on the two formulas you’re looking to create:
1. Date of First Interaction
Assumptions: (without knowing the exact names of your Fields, these assumptions will let you know where you need to adjust in your own base)
-This is displayed in the Contacts Table
-We’re going to base this formula on a condition being met in the linked table for interactions (an interaction date/time is recorded).
-The Field is going to be called Date of First Interaction
-The Interactions Field is a Lookup Field
Create a Rollup field and configure it like this:
2. Days between referral coming in and Date of First Interaction
:checkered_flag: DATETIME_DIFF({Date of First Interaction}, {Date Created}, ‘days’)
Assumptions: (without knowing the exact names of your Fields, these assumptions will let you know where you need to adjust the field names within your formula)
-We’re going to base this field on the field called Date of First Interaction which was created in the first step as well as the Field called Date Created
For this formula, we’ll be using: DATETIME_DIFF([date1], [date2], ‘units’)
It returns the difference between datetimes in specified units. Default units are seconds. (See list of unit specifiers here.)
The difference between datetimes is determined by subtracting [date2] from [date1]. This means that if [date2] is later than [date1], the resulting value will be negative.
Hope this helps you! Please let me know if you have any questions!
Hey Michelle!
I’m so glad you’re finding the community forum useful as you integrate Airtable into your workflow! If you’d like to reference the table I used to show you how it all works together, feel free to check it out here in the contacts table. Here’s more information on the two formulas you’re looking to create:
1. Date of First Interaction
Assumptions: (without knowing the exact names of your Fields, these assumptions will let you know where you need to adjust in your own base)
-This is displayed in the Contacts Table
-We’re going to base this formula on a condition being met in the linked table for interactions (an interaction date/time is recorded).
-The Field is going to be called Date of First Interaction
-The Interactions Field is a Lookup Field
Create a Rollup field and configure it like this:
2. Days between referral coming in and Date of First Interaction
:checkered_flag: DATETIME_DIFF({Date of First Interaction}, {Date Created}, ‘days’)
Assumptions: (without knowing the exact names of your Fields, these assumptions will let you know where you need to adjust the field names within your formula)
-We’re going to base this field on the field called Date of First Interaction which was created in the first step as well as the Field called Date Created
For this formula, we’ll be using: DATETIME_DIFF([date1], [date2], ‘units’)
It returns the difference between datetimes in specified units. Default units are seconds. (See list of unit specifiers here.)
The difference between datetimes is determined by subtracting [date2] from [date1]. This means that if [date2] is later than [date1], the resulting value will be negative.
Hope this helps you! Please let me know if you have any questions!
