If you want to display a section of your Clappia app based on certain conditions, you can do that using this feature.
Here we are taking an example of an employee management app for full-time employees and contractors. If the type of employee is full-time, you want to show a section which takes the employee's joining date and if the type of employee is a contractor, you want to show a section which takes the joining date and the planned exit date.
Here are the steps:
Add a new app or get into the edit mode of an existing application.
Add few input fields by dragging the software blocks from right to the left section.
Add new sections for which you want the conditional display, using the "Add Section" button at the bottom.
For the sections for which you want the conditional display, edit the section by clicking the pencil icon next to the section heading.
In the text area labeled "Display this section if", you can write an expression in the Excel syntax to decide whether to display this section or not. You need to use the variable names (the ones enclosed in parentheses) for the fields that you generated above. In the screenshot below, the section titled Full-time needs to be displayed only if the field labeled Employee Name (with variable name emp_name) is not empty and the field labeled Type of Employment (with variable name type) has a value equal to Full-time.
You can add similar logic to all sections. Once the app is saved, go to the Application Home by clicking the home icon at the top or by going to the My apps link at the left and then to your app. You will find only the sections which didn't have any conditions associated with them.
Once you fill in some values for the fields in this section, new sections will appear based on these values.
Make sure the variables used in the expressions are matching exactly with the variables generated in above steps (including the case).
If a section needs to be displayed if a field with variable name "field_one" is not empty, use the expression =(field_one <> "").
If a section needs to be displayed if a field with variable name "field_one" has a value "ABC" and if another field with variable name "field_two" has a value 1000., use the expression =(AND(field_one = "ABC", field_two = 1000)).
If a section needs to be displayed if a field with variable name "field_one" is not empty and if another field with variable name "field_two" is either less than 100 or greater than 100, use the expression =(AND(field_one <> "", OR(field_two < 100, field_two > 1000)))
Following are reference guides to relevant functions in Excel.