Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Page Tree
expandCollapseAlltrue
rootAttribute Functions@self
excerpttrue
searchBoxtrue

Child pages (Children Display)
alltrue
depth2
excerptTyperich content

Concepts

This section introduces some key concepts that are crucial to understanding how these functions work in PhixFlow. The concepts are should be fairly straightforward for anyone used to using excel, or any type of database. But PhixFlow is capable of supporting some complex transformations, where needed, and it is important that you are comfortable with these concepts before setting up elaborate function configurations.

...

  • + (add; can also use the attribute function sum)
  • - (minus; can also use the attribute function sum, reversing the sign of the second operand)
  • / (divide)
  • * (multiply)

Responsive Attribute Functions 
Anchor
client_functions
client_functions

To improve performance, the functions listed below can be evaluated by the client rather than the server. These are useful where you want an expression to be evaluated quickly, for example in formatting rules.

If an expression includes:

  • only the following, client-calculated functions, the whole expression is evaluated on the client.
  • any other function, the expression is evaluated on the server. 

Functions that can be evaluated on the client:

  • And
  • Contains (from version 8.2.6)
  • CountElements 
  • Do
  • Dot (e.g. _form.UID) 
  • Equals 
  • Excluded
  • Greater than 
  • Greater than or equals 
  • IsEmpty 
  • IsNull 
  • Less than 
  • Less than or equals 
  • ListContains
  • Minus 
  • Not 
  • Not equals 
  • Now 
  • Or 
  • Plus 
  • Switch
  • Today 
  • Try