Changes

Template / Type Formula

435 bytes added, 15:39, 19 July 2017

→‎Using Trigger Points

==Using Trigger Points==

Trigger Points Point syntax can be used with template formula to trigger the formula template formulas under specific conditions e.g. trigger specific template formulas for specific UTA types and statuses. Double colons will be used to separate the formula trigger and the formula itself.<pre>{"formula trigger" : [{"field 1" : "field 1 value"}]}::template formula </pre>

 

Each condition can be a combination of type and status.

<pre>

{"formula trigger" : [{"field 1" : "field 1 value", "field 2" : "field 2 value"}]}::template formula

</pre>

Each type/status condition can contain multiple type / status names , each delimited by comma wrapped within quotes. <pre>{"formula trigger" : [{"field 1" : "field 1 value1, field 1 value2"}]}::template formula </pre>

Double colons In the example below the Current Date field will only be used to separate the formula trigger updated under 2 conditions: * Type is 'Type 1' or 'Type 3' and the formula itselfstatus is 'Submitted' In the example below * Type is 'Type 2' and status is 'Draft'

<pre>

{"formula trigger" : [{"type" : "Type 1,Type 23", "status" : "Submitted"}, {"type" : "Type 2", "status" : "Draft"}]}::@ level1.Current Date@ =now()

</pre>

 

==Manipulating dates in template formula==

• ← Older edit
• Newer edit →

Ciaran Donnelly

Smartstaff, administrator

4,478

edits