Updating a secondary dropdown based on the primary dropdown's value

Need help Database
1

Hi.

I’m going to try to keep this simple. I have a dataset displayed in a repeating row. It includes a “category” dropdown and a “description” dropdown, both of which are defined by option sets. I’ve managed to set the filter for the “description” dropdown so that it only displays the description options based on whatever category I’ve defined them in. Everything works just fine.

I have two popups set up - one to “add data” and one to “edit data” with which I’d like users to be able to use. For the “add data” I’ve disabled the “description” dropdown until a “category” is selected. Works great.

My problem is with the “edit” popup. When a user clicks the edit button, the popup appears and the data for that row are displayed. The problem is this: I can’t figure out how to set the “description” dropdown to (1) empty itself on the condition that the “category” changes" and (2) to populate the dropdown with only the specific category data when the “category” changes.

I really need to ensure that these dropdowns work properly or it will mess up my dashboard. Any ideas? Thanks!

2

Have you tried using states as initial values? Then all you need to do is update the states with the right field values when the popup opens.

4

I haven’t tried that but I’ll give it a shot and report back. Thanks for the idea.

5

Well, I can’t seem to get this to work.