Smtxwiki: 1 revision imported

2020-05-25T20:44:31Z

1 revision imported

← Older revision	Revision as of 22:44, 25 May 2020
(No difference)

Smtxwiki at 12:39, 18 September 2017

2017-09-18T12:39:45Z

New page

This is an example on how to use the IIF function in the form builder or within a workflow variable. The IIF function is defined like this:
IIF (When arg1 true then return arg2, else return arg3)

In the example below, we want to validate if a value equals a certain string, when that is the case, I want to return the value 'Yes', otherwise 'No'
IIF ('#REPLACE-FORMFIELD-ValueToCheck#' = 'CheckedValue', 'Yes', 'No')

Please note the quotes around the text strings, but also around the internal label reference fields.

Another example : you want to check if a number (GETALa) is higher than 10

IIF ('#REPLACE-FORMFIELD-playfieldform||GETALa||#' != '' && TONUMBER('#REPLACE-FORMFIELD-playfieldform||GETALa||#') > 10, 'Yes', 'No')

sidenote: field GETALa was a text field, so we need to use TONUMBER to make it a number. To avoid errors when the field is empty, we added the first part, that checks if it is different from empty.

The next example shows a more complex usage of the IIF function, in combination with other functions. We are now checking if a certain string exists within a given form answer. If it exists, we return 'Value1' if not, we check for another value and when that is found 'Value2' is return, otherwise 'NoValue' is returned.
IIF(INDEXOF('#REPLACE-FORMFIELD-ValueToCheck#','Value1Check') >= 0, 'Value1', IIF(INDEXOF('#REPLACE-FORMFIELD-ValueToCheck#','Value2Check') >= 0, 'Value2', 'NoValue'))

If you want to know if a number is between 10k and 100k
IIF (ToNumber('#REPLACE-FORMFIELD-DANew||PrixTotal||#') <= 10000, 'below10k', IIF (ToNumber('#REPLACE-FORMFIELD-DANew||PrixTotal||#') > 100000, 'above 100k', 'between 10k and 100k'))

UsingIIF - Revision history

Smtxwiki: 1 revision imported

Smtxwiki at 12:39, 18 September 2017