Often, there is a need to apply a reference qualifier on a reference field based on whether it's a new record or an existing one. Out-of-the-box (OOB), this distinction cannot be determined.
A workaround is to call a function from a script include in the reference qualifier, passing current.sys_created_by.
- For a new record,
current.sys_created_byis empty. - For an existing record,
current.sys_created_byis populated.
Using this method, you can differentiate between new and existing records and apply your reference qualifier logic accordingly.
You can implement something like this in a script include and reference qualifier:
