We build two custom change fields called Implementation date and Est Completion Date. But business wants to use the Calendar but to do that without people needing to fill in the Scheduled start date and Scheduled end date themselves.
So we want to auto populate the Implementation Date in scheduled start date and Est Completion Date in Scheduled End Date, so that the calendar can display our changes.
We tried through the SQL DATABASE insert and update, That didn’t work.
We want to build a script for it but, there is already default Trigger and script on it to populate the Schedule End Date/Time when you fill in the Scheduled Start date/time and Schedule Duration to give you the scheduled end date, also scheduled end date is read only field.
What would be the communities recommendation be. Modify the existing script default in the system.
I would recomend you to create another spel trigger that will fire when Implementation date and Est Completion Date are updated an both of them are not empty. Then in you spell script you can calculate difference between those two dates ( Est Completion - Implementation date) and set default field Scheduled Start date/time to Implementation date and Schedule Duration to Est Completion - Implementation date. Then default CA trigger will fire and fill Schedule End Date/Time
Gutis Thanks will communicate this and see if we can start with it. I thought that much.