I'm looking for a way to populate value into "calculated" field that would display value in a record field. At minimum I need to display a value in a numeric field on VIEW and EDIT user event.
Pseudocode:
if (record_in_view || record_in_edit)
execute saved search;
calculate value based on saved search;
display value in a field;
At best I would like that field to display a value just like "built" field does on a Transaction > Work Order record does. It displays a value on VIEW user event but is also available as a value in Saved Search both as a filter and as a column.
So far I can only achieve it on EDIT by using CS script on pageInit to execute that saved search and setValue to the record field.
I tried to harness UE script's beforeLoad UserEventType and VIEW context but that would mean that record would be altered before load and it seems not to be setting a value - field remains empty.