topic Re: How to dynamically change dropdown values based on radio button selection in Dashboards & Visualizations

How to dynamically change dropdown values based on radio button selection

vn86893 — Mon, 09 Dec 2019 20:02:33 GMT

Hello,

I am planning to display some server in the drop down based on the selection of dropdown.
From the image, I want to select all servers in test10 series when 1.0 is selected.
i.e when 1.0 is selected I need to display test10-19 in a dropdown,
when 2.0 selected I need to display test20-29 and
when 3.0 is selected I need to display test30-39 in dropdown.

Re: How to dynamically change dropdown values based on radio button selection

jpolvino — Mon, 09 Dec 2019 21:16:35 GMT

This gets you pretty close I believe:

<form>
  <label>dynamic dropdown</label>
  <fieldset submitButton="false">
    <input type="time" token="dateTime">
      <label>Time</label>
      <default>
        <earliest>-60m@m</earliest>
        <latest>now</latest>
      </default>
    </input>
    <input type="radio" token="category">
      <label>Category</label>
      <choice value="0">1.0</choice>
      <choice value="1">2.0</choice>
      <choice value="2">3.0</choice>
      <change>
        <set token="mult">$value$</set>
        <set token="form.Server"></set>
        <set token="Server"></set>
      </change>
    </input>
    <input type="dropdown" token="Server">
      <label>Server</label>
      <fieldForLabel>Test</fieldForLabel>
      <fieldForValue>Test</fieldForValue>
      <search>
        <query>| makeresults count=10 | eval Test=1 | accum Test | eval Test=Test+9+($mult$*10) | eval Test="Test".Test</query>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
      <default></default>
      <initialValue></initialValue>
    </input>
  </fieldset>
</form>

Re: How to dynamically change dropdown values based on radio button selection

vnravikumar — Tue, 10 Dec 2019 07:06:09 GMT

How you are populating Server dropdown?

Re: How to dynamically change dropdown values based on radio button selection

vn86893 — Tue, 10 Dec 2019 14:57:50 GMT

These are static server names. Not necessarily need to be just 10 of them. There may be multiple servers. I can have a list of servers that need to populate in dropdown when a radio button is selected.

Re: How to dynamically change dropdown values based on radio button selection

jpolvino — Tue, 10 Dec 2019 15:27:11 GMT

Then you need to somehow label those servers so that when the 1.0 radio button is selected, it knows which servers to populate the drop down with. One way to do it is a lookup, but this requires maintenance to stay accurate.

If this is the case, then please add this detail and I'm sure you'll get a number of solutions. The answer I posted below would still work, but lines 24-27 would need to be updated to pick rows from the lookup table and assign the field for value and label correctly.