What are Placeholders?

Definition

A variable used for setting up a Business Rule. Placeholders are replaced with corresponding values during rule execution.

“Table Field” Placeholders: These placeholders use the format [Table ID:Field ID]. Any table and field within Business Central, including ISV or custom extensions, can be used.

Fixed Placeholders:

• [USERID] :- Replaced with the User ID.  

• [TODAY] :- Replaced with today’s date.  

• [W] :- Replaced with the work date.  

• [CDT] :- Replaced with the current date and time.  

• [CT] :- Replaced with the current time.

• FIR[Table ID:Field ID] :- It retrieves the table's First record within the applied filters.

• LAS[Table ID:Field ID]:- It retrieves the table's Last record within the applied filters.

• MIN[Table ID:Field ID] :- It retrieves the table's record which has Minimum value within the applied filters.

• MAX[Table ID:Field ID] :- It retrieves the table's record which has Maximum value within the applied filters.

How to Use?

These placeholders use the format [Table ID:Field ID] for the current value. And for the previous value, placeholders use the format {Table ID:Field ID}.

For Example:

• If you want to use the value of the "Location Code" field of the "Sales Header" table, then you will write the placeholder as [36:28] for the current value.

• And if you want to use the previous value of the "Location Code" field of the "Sales Header" table, then you will write the placeholder as {36:28} for the previous value.