topic How to add dynamic value as default value in check box ? in Getting Data In

How to add dynamic value as default value in check box ?

snehalk — Wed, 12 Jul 2017 10:38:14 GMT

Hello Everyone,

Can we use dynamic value as default value for check box? currently am trying below code, but unfortunately don't know how to add my dynamic value current_month_year as checked in my form

<input type="checkbox" token="currentdate">
      <label>date</label>
        <choice value="*">ALL</choice>
        <default>current_month_year</default>

     <fieldForLabel>currentdate</fieldForLabel>
      <fieldForValue>current_month_year</fieldForValue>
      <search>
      <query>| makeresults | eval current_month_year=strftime(now(),"%Y-%m") 
| table current_month_year</query>
</search>

      <valuePrefix>"</valuePrefix>
      <valueSuffix>"</valueSuffix>

      </input>

Can any one help me here

Re: How to add dynamic value as default value in check box ?

knielsen — Wed, 12 Jul 2017 11:08:23 GMT

Hi,

This should do it:

<default>$current_month_year$</default>

Re: How to add dynamic value as default value in check box ?

snehalk — Tue, 29 Sep 2020 14:50:40 GMT

Hello Knielsen,

its taking as string "$current_month_year$" its not taking value

Re: How to add dynamic value as default value in check box ?

niketn — Wed, 12 Jul 2017 11:50:51 GMT

@snehalk, Checkbox input does not seem to accept token as default field.
Based on the example, seems like you want to use checkbox as toggle between All and Current Month. Instead of checkbox can you use radio input?

 <input type="radio" token="currentdate">
       <label>date</label>
       <choice value="*">ALL</choice>
       <default>$tokCurrentMonthYear$</default>
       <fieldForLabel>current_month_year</fieldForLabel>
       <fieldForValue>current_month_year</fieldForValue>
       <search>
           <query>| makeresults 
             | eval current_month_year=strftime(now(),"%Y-%m") 
             | table current_month_year</query>
           <progress>
                   <set token="tokCurrentMonthYear">$result.current_month_year$</set>
           </progress> 
       </search>
       <valuePrefix>"</valuePrefix>
       <valueSuffix>"</valueSuffix>
 </input>

Radio input allows passing default value as token: <default>$tokCurrentMonthYear$</default>. The same does not work with checkbox which treats it as string. This seems to be bug with Checkbox which handles multiple value. So your task would be achievable only through custom JavaScript if you have a constraint to use checkbox.

Re: How to add dynamic value as default value in check box ?

snehalk — Wed, 12 Jul 2017 12:19:53 GMT

Awesome!! Thank you so much!! @niketnilay, its working as expected! now i can go with radio input, instated of checkbox for now.

Re: How to add dynamic value as default value in check box ?

snehalk — Thu, 13 Jul 2017 14:51:36 GMT

@niketnilay, can we do the change in the order and label for radio? that is right now we are getting option like
1. All
2. 2017-07

Can we get like
1. Current Month

2. All

Here "Current Month" contain value "2017-07"?

Can you please help me here?

Re: How to add dynamic value as default value in check box ?

niketn — Sat, 15 Jul 2017 12:37:29 GMT

HI snehalk, Static options are displayed first followed by the results from the Dynamic Query. You can remove the static <choice> All and move the same to Dynamic option using the following query:

| makeresults 
| eval current_month_year=strftime(now(),"%Y-%m") 
| append [
           | makeresults 
           | eval current_month_year="*" ]
| table current_month_year

Another way to use query would be to use the following query,

| makeresults 
| eval current_month_year=strftime(now(),"%Y-%m") 
| appendcols [
           | makeresults 
           | eval All="*" ]
| fields - _time
| transpose column_name="label"
| reverse
| rename "row 1" as value