topic Re: Append dropdown to text box in Dashboards & Visualizations

Append dropdown to text box

mwdbhyat — Mon, 17 Feb 2020 08:20:33 GMT

Hi there,

I have a dashboard with 3 dropdown inputs and a text box. I am trying to get whatever i select from the 3 dropdown boxes to appear in the adjacent text box, essentially just appending the tokens to the whitespace and only running when they appear in that box and i hit "submit". The selections from the dropdown need to be in " ". I also want it to then clear previous selections if i go back and change one of the dropdowns again.

Has anyone got any thoughts on how i could achieve this?

Currently this almost works - i just need to figure out the append part properly:

<fieldset submitButton="false">
<input type="dropdown" token="mainSection">
  <label>Main Section</label>
  <fieldForLabel>MainSection</fieldForLabel>
  <fieldForValue>MainSection</fieldForValue>
  <search>
    <query>| inputlookup bla.csv
| fillnull value="(empty)"
| fields MainSection
| dedup 1 MainSection</query>
    <earliest>-24h@h</earliest>
    <latest>now</latest>
  </search>
</input>
<input type="dropdown" token="subSection">
  <label>SubSection</label>
  <fieldForLabel>SubSection</fieldForLabel>
  <fieldForValue>SubSection</fieldForValue>
  <search>
    <query>| inputlookup bla.csv
| fillnull value="(empty)"
| search MainSection="$mainSection$"
| fields SubSection
| dedup 1 SubSection</query>
    <earliest>-24h@h</earliest>
    <latest>now</latest>
  </search>
</input>
<input type="dropdown" token="dataLine">
  <label>DatalineName</label>
  <fieldForLabel>DatalineName</fieldForLabel>
  <fieldForValue>Dataline</fieldForValue>
  <search>
    <query>| inputlookup bla.csv
| fillnull value="(empty)"
| search MainSection="$mainSection$"
| search SubSection="$subSection$"
| fields DatalineName Dataline
| dedup 1 DatalineName</query>
    <earliest>-24h@h</earliest>
    <latest>now</latest>
  </search>
  <change>
    <eval token="chosen_dls">$chosen_dls$." ".$dataLine$</eval>
  </change>
</input>
<input type="text" token="chosen_dls">
  <label>selected</label>
</input>

Thanks!

Re: Append dropdown to text box

gcusello — Mon, 17 Feb 2020 08:36:09 GMT

Hi @mwdbhyat,
When you speak of thext box, a Single Value coulkd be useful for you?
If yes, see this example with two dropdowns and the choosed values displayed in a Single Value box, then you can use the tokens also for your searches.

<form>
  <label>Search Box</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="token1">
      <label>token 1</label>
      <choice value="One">One</choice>
      <choice value="Two">Two</choice>
    </input>
    <input type="dropdown" token="token2">
      <label>token 2</label>
      <choice value="Three">Three</choice>
      <choice value="Four">Four</choice>
    </input>
  </fieldset>
  <row>
    <panel>
      <single>
        <search>
          <query>| makeresults | eval search_box="$token1$ $token2$" | table search_box</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="drilldown">none</option>
      </single>
    </panel>
  </row>
</form>

Ciao.
Giuseppe

Re: Append dropdown to text box

mwdbhyat — Mon, 17 Feb 2020 09:00:43 GMT

Unfortunately it needs to be exactly as i described it above.. i suspect there may be a need for some JS to make this work the way I want it to!

Re: Append dropdown to text box

gcusello — Mon, 17 Feb 2020 09:39:17 GMT

Hi @mwdbhyat,
You could modify CSS and put an HTML box in the input section to use to display the tokens, but I cannot help to do this!

Ciao.
Giuseppe