Ordering Enum/Ref Buttons, with dependent dropdowns

Hello Dear Community.

I"m creating an inspection App for a buildings suite, where I have a “Corridors” Database with columns ordered like so:

[Building] - [Floor] - [IDCorridor] - [SubIDCorridor] (KEY)

I Then have an “Inspection points” Database, which is used to collect data through a form. I want the users to be “guided” through the form in the selection of where they are doing inspections.

So I do have these 4 columns again, as Enum, pulling data from “Corridors” table with these settings :

  • [Building] > Enum/Text - Valid_IF : Corridors Database[Building]
  • [Floor] > Enum/Text - Valid_IF : Corridors Database[Floor]
  • [IDCorridors] > Enum/Text - Valid_IF : Corridors Database[IDCorridors]
  • [SubIDCorridor] > Enum/REF (to Corridors Database) - Valid_IF : Corridors Database[SubIDCorridors]

The Workflow is functionning as expected, and each subsequent field is correctly populated with data related to previously selected field. However the last Enum/Ref (SubIDCorridor) selection a doesnt appear in correct alphabetical/logical order (Buttons or dropdown, same issue…)

This despite the fact that they are correctly sorted in the “Corridor Database”…

Is there any way I can make these fields correctly ordered ?

Many thanks by advance !
Regards .

1 Like

For the valid if or suggested values formula for the circled column, try adding SORT() around your formula.


Alternatively, if you want to get really crazy, you might check out the following video

  • It shows how to create a really crazy inspection app

In the app you’re able to build out inspections/check lists/questionnaires/what-have-yous with various steps.

  • I wouldn’t suggest building your app this way, I’m just pointing out an interaction style that might inspire you. :slight_smile:

Happy Apping!