Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to create a date range that is connected to a linked column?

Topic Labels: Base design Formulas
622 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kathleenxx
4 - Data Explorer
4 - Data Explorer

I have a table of Contacts where one column is the Companies where these contacts have worked. The Companies column is a lookup column to a table of companies. Contacts might have more than one company that they've worked for. I want to be able to attach a year range in some way to the company information, so that I can see that John Smith has worked at Company X between 2021-2022 and Company Y between 2022-2024. What are some ways I can think about doing this?

1 Reply 1
Shawn_Peters
6 - Interface Innovator
6 - Interface Innovator

You can parse the YEAR from both the MIN and MAX dates of a contract group belonging to the desired company.  I would likely use a script to do this,  triggered manually or automatically based on need. 

Depending on the overall use case,  there's a few options to render the info into a report or store it within the contract record as an array of start dates and most recent dates. (separate fields, or one,  depending on your level of need. Example: "2016|companName|2022, 2018|companyName2|2024".

Le would be glad to help,  if needed. 

shawnjp@gmail.com 

-Shawn
慄Time Wizard