Mobile App Builder – Dynamic Filtering of Consumables Based on Selected Stockroom (Reference Field)

RavitejN
Tera Contributor

3 weeks ago

Hi Community,

I am working on Input Form screens in Mobile App Builder and need help with dynamic reference filtering.

Background (Native UI behavior)

  • One Stockroom can have multiple Consumables
  • In the Stockroom record, Consumables appear in the related list
  • In the Consumable table, there is a reference field to Stockroom
  • This works correctly in the native UI

Requirement

In Mobile App Builder – Input Form:

  • I have two reference fields:
    1. Stockroom
    2. Consumable
  • When a user selects:
    • Stockroom 1, only the consumables belonging to Stockroom 1 should be shown
    • Stockroom 2, only the consumables belonging to Stockroom 2 should be shown

Example:

  • Stockroom 1 → 10 consumables → Only these 10 should appear
  • Stockroom 2 → 3 consumables → Only these 3 should appear

This should behave similar to a dependent reference field.

What I Tried

I configured Input Attributes for the fields:

  • For Stockroom field:
    • Source table: alm_consumable
    • Source field name: stockroom
  • For Consumable field:
    • Source table: alm_consumable
    • Source field: sys_id / display field

However, this setup does not filter the consumables based on the selected stockroom.
The Consumable field still shows all consumables regardless of the chosen stockroom.

Questions

  1. Is dynamic filtering of one reference field based on another supported in Mobile App Builder Input Forms?
  2. If yes, what is the recommended approach?
    • Input Attributes?
    • Reference Qualifier?
    • Data Item / Scripted source?
    • Any Mobile App Builder limitation?
  3. If not supported out of the box, is there any workaround or best practice?

Any guidance, examples, or documentation references would be very helpful.

Thanks in advance!

0 Helpfuls
  • 316 Views
1 REPLY 1

21121A3359
Tera Expert

3 weeks ago

Hai @RavitejN 

Yes, this requirement is similar to dependent reference fields in the native UI, but Mobile App Builder currently has some limitations compared to classic platform forms.

For Input Forms in Mobile App Builder, standard Reference Qualifiers and dynamic dependent filtering do not always work the same way as in the native UI. Input Attributes alone typically only define the source table/field and do not automatically create contextual filtering between reference fields.

A recommended approach would be:

  1. Create a scripted data source or Data Item that filters alm_consumable records based on the selected Stockroom.

  2. Use the selected Stockroom value as an input parameter and query:

stockroom=<selected_stockroom_sys_id>

  1. Bind the Consumable reference field to this filtered data source instead of directly referencing the table.

Another possible approach is:

  • Use a Mobile Client Script / UI Rule (if supported in your app experience)

  • Refresh the Consumable field datasource whenever Stockroom changes

Also verify:

  • alm_consumable.stockroom relationship is populated correctly

  • The Consumable field is using the correct display value and sys_id mapping

From current platform behavior, dynamic reference qualifiers in Mobile App Builder are more limited than Workspace or Native UI, so scripted filtering/data items are generally the more reliable workaround.

You may also want to review whether the app is using:

  • Classic Mobile

  • Now Mobile

  • Mobile App Builder (UI Builder-based)

because filtering capabilities differ slightly between them.

If you find a clean out-of-box method for dependent reference filtering in Input Forms, please share it here as it would help many others working with Mobile App Builder.

If this helps, please mark it as Helpful.

0 Helpfuls