How to trigger the calculated field automatically once condition is met instead of saving the record on the form

[Abhishek Kumar8]

The field “Pen Test Compliance Status” is not updating its value until the dependent records (below) are saved/updated, but it should update when the conditions of the calculation are met.

u_pentest_app_inventory table contains a field called ‘Pen Test Compliance Status’ which is calculated based on a few other values. The other values are:

u_pentest_appl_inventory table – ‘Last Full Test Date’ and ‘Is Testing Required’ fields

u_pentest_deviation table – ‘Pen Test Deviation’ field calculated as Y/N

Is there a way to set it so that “Pen Test Compliance Status” gets calculated and updated on a reoccurring/scheduled basis instead of waiting for a saved record to trigger it?

BR - Before ( insert/update) - u_pentest_appl_inventory : calculate pen test compliance status(compliant/overdue/no testing reqd/never tested) and is testing required ( yes/no) based on the conditions

BR - Before ( insert/update) - u_pentest_deviation :  calculate Pen Test Deviation ( Y/N)

will the scheduled job work here to trigger them automatically in the backend without saving the changes on the form as BR does here?

Any help on this is really appreciated.

Thank you,

Abhishek Kumar

[Abhishek Kumar8]

yes, I have tried the On change() script but showing an issue while setting the value.

Could you please let us know if it's possible to apply the on change () script on a field "A" ( text-field) present in a table "AB" and the value should be set for a field "B" ( choice-value - Yes/No) present in another table "CD".

Thank you,

Abhishek Kumar