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

[RavitejN]

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!