Is it possible to Populate custom fields with default fields on change order calender.

[Edgar Louw]

Hi Community

 

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.

 

Regards

 

Edgar Louw

[Giedrius Bekintis]

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 

[Edgar Louw]

Gutis Thanks will communicate this and see if we can start with it. I thought that much.