Solved: Two way reference - Page 2

Mark_11 · 10-26-2019 12:23 AM

Hi,
i’d like to know if is possibile to have a “two way” ref.
Let me clarify…
I would like to have a dropdown cascade that allow me to go dip in a exactly selection; it work like a filter.
Do i have a way to manage this in a different way? I’d like to have a system that autofill backward if i already know what i will choose in the second dropdown…
for example:
if i have [categories] [item]
like

fruit / apple
fruit / pear
fruit / orange
vegetable / peas
vegetable / bean

i normally have a dropdown to choose the categories so the second dropdown i have a filter with the SELECT function to find what i need. But if i’m sure to what i want as [item], how can i skip the first dropdown and if i can, will it autofill?

Suvrutt_Gurjar

Hi @Mark_11,

Yes the requirement mentioned by you indeed seems to be tricky. Please exlpore if following approach with teh mentioned workaround helps. Workarounds:

There are two columns for Items( or in the test app that I am sharing the column called document, which is lowermost in hierarchy )
There are two views.Teh employee who is confident of entering last column document can use the “Reverse Flow” view.The employee who wishes to fill in by hierarchy, can use “Normal Flow” view.

A few images are below
Image 1: Normal view and Reverse View

Image 2: Normal Flow.Here the user goes in the hierarchical flow of selection: Continent, Country and Document

Image 3 : Reverse flow.Here the user only selects the Document name . The Continent and Country are filled in by an action after the form is saved.

Image 4: The action fills in continent and country in reverse flow.

Image 5: Please note the table structure. It has two columns for Document ( the lowermost column in the hierarchy)

I modified a sampleapp dependent dropdowns for this functionality The app is available at Dependent Dropdowns

View solution in original post