Question & Answer > View Question

how to configure the dropdown source to form id when using custom control in spreadsheet

Confluence User - 28 Sep, 2023

Hi there,

I was using spreadsheet with with two dropdown lists and wanna apply AJAX cascade with auto filled feature. However it did not apply the auto filled as expected since the user need to select the option in the second dropdown list which should be auto-filled.

Questions:

Do I need to use custom control for my case ?
And how to assign the Form ID to my custom dropdown?
Which option/attribute should applying the auto filled in dropdown?

Firstly, I did setup a form with two dropdown list and applying Ajax Cascading logic was working fine in form. (Without empty option the value will be filled automatically in the second dropdown).

Thanks in advance

Kim

spreadsheet;dropdown;ajaxcascade;autofill

2

Confluence User •

04 Oct, 2023 •

confluenceUser •

•

confluenceUser •

Hi, I suspect that the AJAX cascade does not work with two dropdown lists in a spreadsheet element. If you really need this behavior then you might need to consider adding some custom JavaScript.

Confluence User •

04 Oct, 2023 •

confluenceUser •

•

confluenceUser •

Hi Anders,

Thanks for your message. I think so.

However, I was not too sure how to manipulate values between the two dropdown lists.

Do you have any idea (just high level) for this kinda logic?? For example use FormUtil or some utility/ library good to start with?

Thanks.

1

CSV | Excel | XML | PDF

Your answer

Print

how to configure the dropdown source to form id when using custom control in spreadsheet

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-03ed7dfe-ffd7-4323-ac22-926e77081d49{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-686f171a-2621-4aab-bc8b-63b1629f4a31{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer