Versions Compared

Key

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

...

Page Tree
expandCollapseAlltrue
rootAttribute Functions@self
excerpttrue
searchBoxtrue

 

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)

Performance

Certain functions can be evaluated on the client and expressions including only these functions will be evaluated on the client. Expressions including other functions must be evaluated on the server. The following functions can be evaluated on the client: 

  • And 
  • Dot (e.g. _form.UID) 
  • Equals 
  • Greater than 
  • Greater than or equals 
  • IsEmpty 
  • IsNull 
  • Less than 
  • Less than or equals 
  • Minus 
  • Not 
  • Not equals 
  • Now 
  • Or 
  • Plus 
  • Today 
  • Try