Automatically Calculating an End Date
We have ~80 Employees and need to keep a historical record of what jobs they have worked on. Crew assignments are made by entering a new record when an employee changes jobs so the only data entry per...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou would need to set up an Automation or a Pipeline to Trigger on a new job created and search of old job record that do not have an end date and populate that date.
I suggest that you make a formula field to calculate the start date of the job record minus one day or one business day and then have that field available to use in your automation or a pipeline to populate the end date of any previous jobs which do not have an end date.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I suggest that you make a formula field to calculate the start date of the job record minus one day or one business day and then have that field available to use in your automation or a pipeline to populate the end date of any previous jobs which do not have an end date.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------