Client script and transform map

[PaulaaO]

Hi,

I'm working towards implementing an email integration and I am at the stage where I created the transform map, which works fine, however the table that gets the data import (sys_user) also has 2 fields that calculate the value based on other fields (which in turn get their data from the import).

Just to bring it to life:

-> contract start date (field gets populated via import)

-> 2 year tenure (fields gets populated based on the contract start date field value)

The thing is that before creating the data source and transform map I created a client script "onChange" to run on the 2 year tenure field so it would calculate the value based on the contract start date. This does work if I add the value manually, however it does not when the transform map is run.

I would appreciate some help on how to amend this - do I need to change the client script from "onChange" to "onLoad" or something else and can you point me to some scripts that could help me achieve that, as I don't have any experience in this dpt.?

Thank you 🙂

Paula

[Ankur Bawiskar]

@Paula 

Client script will only run from the front-end when somebody changes the value.

Client script won't help for data loaded from transform map

In your case you can use transform map onBefore script to set the 2 year tenure date based on Contract Start date

Sample script for help

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    // Add your code here

var contractValue = source.u_contract_start_date;

// do the processing here like add 2 years etc to this date and then set it on the another field

target.2_year_tenure_field = 'Your value here';

})(source, map, log, target);

Regards
Ankur

[PaulaaO]

Thank you @Ankur Bawiskar  for clarifying the bit around client scripts.

I do have 2 follow up questions if that's ok:

-> I imagine that any transform map script would only run if the fields get populated via the import right? Would not work if someone would update the fields manually (i.e. the contract start date would be updated and then it would trigger the tenure field to get updated as well)

-> in the script you provided, what formula would you recommend to use to add those 2 years?

Thank you,

Paula

[Ankur Bawiskar]

Hi,

That's correct.

If you wish to add 2 years when data is being loaded then you will have to use transform map script

If you wish to make this work from UI when manual change happens you can use before insert/update Business rule

Script for adding 2 years

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    // Add your code here

var contractValue = source.u_contract_start_date;

// do the processing here like add 2 years etc to this date and then set it on the another field

var gdt = new GlideDateTime(contractValue);
gdt.addYearsUTC(2);

target.setValue('2_year_tenure_field', gdt);

})(source, map, log, target);

Regards
Ankur

[PaulaaO]

@Ankur Bawiskar perfect, appreciate the confirmation and guidance on this.

I think I will create a business rule to have the tenure field updated as I want to make it possible to get updated when someone also updates manually the start date field.

May I ask something on the transform scripts?

-> can we create more than one script of the same type "when" (i.e. onBefore, onStart, etc?) with different order or is it best practice to collate the conditions into 1? I am asking this as I am looking now to apply to my transform map:

-> set Contract end date field as 31/12/2199 if the Contract type is 'Permanent' and

-> a short script to also update the fields for future data sources being ran against the same records (hope this makes sense)

Thanks again for all your help!!