Plugin Mode

Hierarchical filtering of lookups

Summary

Change how a lookup field’s value is selected to selection from a dropdown. You can set up to 3 stages for the dropdown.

Smartphone support

This plugin supports smartphones.

How to use

Choose the lookup and arrange the fields used for narrowing down its choices. Letting users work from broad to specific categories helps them find the right record among many candidates.

When it runs

Depending on the settings, this customization runs at the following times. Any configured conditions are also evaluated.

  • When you open a record creation or edit page

The page-display and field-change triggers exclude inline editing from the pencil icon on the list page.

Parameters

Enter or select a value for each setting unless it is marked optional.

Lookup Field

Select the lookup whose candidates will be narrowed down in stages.

The following field types can be selected.

  • Lookup (text)
  • Lookup (number)

Stage 1 Field

Choose the first filtering field, typically the broadest category.

The following field types can be selected.

  • Text
  • Number
  • Calculated
  • Radio button
  • Drop-down
  • Link
  • Date
  • Time
  • Date and time
  • Lookup (text)
  • Lookup (number)
  • Record number
  • Created by
  • Created datetime
  • Updated by
  • Updated datetime
  • Status

Fields inside tables cannot be selected.

Select from the app referenced by “Lookup Field”.

Stage 2 Field

Choose a field for further narrowing the candidates selected at the preceding stage. This setting is optional.

The following field types can be selected.

  • Text
  • Number
  • Calculated
  • Radio button
  • Drop-down
  • Link
  • Date
  • Time
  • Date and time
  • Lookup (text)
  • Lookup (number)
  • Record number
  • Created by
  • Created datetime
  • Updated by
  • Updated datetime
  • Status

Fields inside tables cannot be selected.

Select from the app referenced by “Lookup Field”.

Stage 3 Field

Choose a field for further narrowing the candidates selected at the preceding stage. This setting is optional.

The following field types can be selected.

  • Text
  • Number
  • Calculated
  • Radio button
  • Drop-down
  • Link
  • Date
  • Time
  • Date and time
  • Lookup (text)
  • Lookup (number)
  • Record number
  • Created by
  • Created datetime
  • Updated by
  • Updated datetime
  • Status

Fields inside tables cannot be selected.

Select from the app referenced by “Lookup Field”.

Notes

You can configure up to three levels of filtering.

The following actions and conditions are useful when building similar behavior in customization mode.

Actions

Conditions