Dropdown tree picker for the custom table

[tkrishna29]

Hi,

I have one Tool table with 2 columns A & B.

Tool Table values are:

A a1, A a2, A a3, B b1, B b2, C c1, C c2, C c3.

I'm looking for a dropdown (probably tree picker) - where I can Choose column B options c2 through filter C.

I can use 2 dropdowns (dependent) to achieve this. I'm trying to see if there is a possibility to do this with Single dropdown list with a tree picker functionality.

I will selecting only 1 value at a time, not multiple values.

Greatly appreciate your help.

Thanks,

Krishna

[Tony Chatfield1]

Hi,

If you can build your source data in a hierarchical structure – IE with 'parent' field referencing the table. (self referencing self format)

with data like Parent A, Children 1,2,3,4,5 Parent B Children 1,2,3,4

you can create a tree picker format when you utilize this data table on your form simply bysetting the field type as reference and include the attribute tree_picker=true

If you have multiple child values with same or similar names, the below attributes allow you to specify addition fields that will be visible to the user during autocomplete\selection process without having to drill into the tables popup to see all fields.

//Note I haven’t actually worked through these 3 individually to see what they do specifically but they are referenced in a number of community posts

ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=’some other field(s) on the table’

Regards Tony

[tkrishna29]

Hello Tony,

Thanks for the response. 

As said, I created a table called "Tool Picker" with 2 columns Level 1 & Level2.

Level 1  - Type - Reference, Reference - "Tool Picker" (same table)

Level 2 - Type - String.

How can I add values to this table. The moment I try to add A or B to the Level 1 column, it wont allow as it is looking for reference. I wasn't sure how to add values to this table. Please let me if I'm not heading in the right direction.

Thanks,

Krishna

[Tony Chatfield1 · Accepted solution]

I think your need to add the values to the field you have called level2, then set parent by populating level1,
maybe rename the fields as name and parent to avoid future confusion for future generations.

[tkrishna29]

This helped. Thank you!