I am trying to sync a field with a field in another table. OnChange I want this to happen

Jon M3 · ‎02-23-2022

Here is the code I have that verifies the value is synced. I added the if and for statement because it work 90% of the time and the other 10% failed. I think it might be a timing issue so I added the for and if statements however now it hangs - Thoughts?

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}
var cc = g_form.getReference('cost_center', populateReqForDetails);

function populateReqForDetails(cc) {
for (i = 0; i < 5; i = i++) {
if (cc == 'u_cost_center_code') {
return;
} else {
g_form.setValue('u_cost_center_code', cc.code);

}
}
}

//Type appropriate comment here, and begin script below

}

ccajohnson · ‎03-01-2022

From any Department record, select Configure > Form Layout
From there, click the Cost center [+] field, then select the top icon in the middle to expand the Cost center [+] to show all fields on the Cost Center form.

Select the Code field and add it to your form.
You probably should make the field read only with a UI Policy so users do not change the Cost center record by mistake:
- Make Code Read Only
Table: Department [cmn_department]
Short description: Make Code Read Only
Description: Makes the Code field from the Cost Center record read only
Order: 100
Global: true
Reverse if false: true/false
On load: true/false
Inherit: true/false
Create a UI Policy Action and expand the Cost center field to get at the Code field

Make the UI Policy Action for the Code field to be Read only

Let me know if you still need assistance,

View solution in original post

Jon M3 · ‎03-01-2022

Thank you so much for your help - I was doing it the hard way for sure!