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_by is empty.
• For an existing record, current.sys_created_by is 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: