Create a Flag


Updated over a week ago

Flags are the act of assigning a value of one to specific Formulas and Objects, to aggregate information in a useful way. Dimensions (typically identifiers) are combined with common functions and operators to create Formulas that will help your explore your form data.

Common Functions

The most common functions when working with flags are:

  • If and Then – to assign a value to an Object, if-then logic is used

  • IsNull – commonly used to find out if something doesn’t exist

  • Max and Min – paired with flags on two or more Objects, max and min can help point to all or none of those Objects having flags

  • Count and Sum – these are commonly used to find aggregations of flags in a table

Common Operators

  • In – this syntax operator is used in every flag created, it gives the flag the proper           context to mark the correct information.

  • <, <=, =, >=, > these operators are usually part of the flag Formula to decide the              parameters of the condition that generates the one value that is assigned

Most flags are formatted in the following manner:
=(If [Object] fits defined parameter here Then 1) In (contextual ID here)

Example of a Flag:

A flag that would mark a form as “taken” would involve the following Objects:

  • The form’s unique ID (e.g. [Response ID_xx])

  • The subject’s unique ID (e.g. [Participant Site Identifier])

It would be written like this:
=(If [Response ID_xx] > 0 Then 1) In ([Participant Site Identifier];[Response ID_xx])

Did this answer your question?