Skip to main content
Submit a ticket

Conditionally Show or Hide Fields on a DET

  • Updated

DET fields can be hidden using the ‘Display Conditionally Based On:’ field option

However, this option can only use Boolean fields, or ‘True/False’ fields, as its condition to show or hide.

As such the best way to make DET fields show or hide depending on a different field type (such as a number or text field) is to use a ‘helper field’, which uses a formula to calculate whether the condition is true or false.

The fields we need are:

  • The Condition field – the field we will check to match the condition
  • The Helper field – the field we will use to calculate if the condition is true or false
  • The Result field – the field we want to show or hide based on the condition

Creating the Helper field

  1. Create a new Boolean field to use as the ‘Helper Field’
  2. Add the helper field to your DET

  3. In the field settings, click ‘Enable Auto-Generate Formula’

  4. Save and reload the field settings page.
  5. Tick the ‘Auto Calculate on Save’ and ‘Auto Calculate on Mobile Sync options
  6. Press ‘Manage Auto-Generate formula’ and enter the conditional formula using the formula tools provided.

  7. First insert the ‘If Statement’ to the formula head

  8. In the first two values, enter the name of the Condition field, and the value to match
     

  9. In the ‘THEN’ statement, enter the number 1 

    The number 1 designates ‘True’, which means the value matches

  10. In the ‘ELSE’ statement, enter the number 0 

    The number 0 designates ‘False’, which mean the value does not match

  11. The formula will look something like this:
  12. Save and close the formula editor. Save the changes to the field

Setting up the Result field

  1. Open the field settings of the Result field
  2. Scroll to the bottom of the settings window and click ‘Show Advanced Options’

  3. Locate the ‘Displays Conditionally Based On’ setting, and select the helper field from the dropdown list

  4. Save the field settings.

 

To test and use the configured field:

  1. Open a job card
  2. Navigate to the condition field and enter a matching value into field.
  3. Click Save and reload the page
  4. Locate the helper field and the result field.
    •  Check that the helper field displays the correct value (checked if True, unchecked if false)
    • Check that the Value field is not hidden.

Related articles