topic Re: Textbox Validation Issue in Splunk Search

Textbox Validation Issue

vivek_manoj — Wed, 12 Apr 2017 09:53:34 GMT

I am trying to validate the testbox to accept only numeric not any other character. How to do that?
Thanks in Advance.

Re: Textbox Validation Issue

gcusello — Wed, 12 Apr 2017 10:03:22 GMT

Hi vivek_manoj,
I think that it's not possible to do this!
if you haven't high numbers you could use as workaround a dropdown list, but obviously it isn't the same think!
Bye.
Giuseppe

Re: Textbox Validation Issue

DMohn — Wed, 12 Apr 2017 10:04:44 GMT

Have a look at this blog entry from Splunk: https://www.splunk.com/blog/2016/09/21/using-html5-input-types-on-splunk-forms/

This will point you in the right direction.

Just to summarize the recommendations from the mentioned post: You have to include the following code fragments:

In your dashboard, include a custom JavaScript File like this:

<form script="set_input_types.js">

Add an id to the XML code of the field to be validated:

<input type="text" token="numbers" id="numbers_only" searchWhenChanged="true">
    <label>Numbers only</label>
</input>

Create a .js file in your app's appserver/staticdirectory, named set_input_types.js (or the name you assigned in the dashboard). Then include this code in the .js:

require(["jquery", "splunkjs/mvc/simplexml/ready!"], function($) {
    $("[id^=numbers_only]").attr('type','number')
});

This will provide a HTML5 number input field. You will have to restart the splunk server (or reload it) for the changes to take effect.

Please note - this will only work in fully HTML5 compatible browsers.

Re: Textbox Validation Issue

vivek_manoj — Wed, 12 Apr 2017 11:28:17 GMT

Its not working. Its showing nothing.

Re: Textbox Validation Issue

DMohn — Wed, 12 Apr 2017 12:29:34 GMT

Can you please post the code you have implemented? It is quite hard to debug your errors if we don't know what you have coded.

Re: Textbox Validation Issue

DMohn — Wed, 12 Apr 2017 12:59:46 GMT

Another addition: I have edited the original answer to clarify the steps you have to take. Please verify.

Re: Textbox Validation Issue

vivek_manoj — Wed, 12 Apr 2017 13:34:10 GMT

Yeah bro, I have used the same thing and restart the splunk and used the _bump also.

But its not working. Nothing is happening.

Re: Textbox Validation Issue

loggar — Wed, 12 Apr 2017 14:09:56 GMT

Convert your page to HTML, set an id to your input textbox like:

<input type="text" token="numbers" id="numbers_only">
     <label>Numbers only</label>
 </input>

..then put this in script below

$(document).ready(function() {
    $('#numbers_only').on('keyup', function() {
        if (/^\d+$/.test($(this).val())) {
            // Contain numbers only   (do something if contains only numbers)
        } else {
             //do something if contains nonumeric
            alert('nonnumbers')
        }
    })
});

..and that should work and check on every keyup in text input

Re: Textbox Validation Issue

vivek_manoj — Wed, 12 Apr 2017 19:00:47 GMT

Hi Loggar,

I tried and I am attaching the snapshot of the code. Please look into it.

<form>

  <row>
  <panel>
    <html>
      <script>
      $(document).ready(function() {
     $('#numbers_only').on('keyup', function() {
         if (/^\d+$/.test($(this).val())) {
             // Contain numbers only   (do something if contains only numbers)
         } else {
              //do something if contains nonumeric
             alert('nonnumbers')
         }
     })
 });
      </script>
     <input type="text" token="numbers" id="numbers_only">
      <label>Numbers only</label>
  </input>
    </html>
    </panel>
    </row>
</form>

Re: Textbox Validation Issue

niketn — Wed, 12 Apr 2017 19:32:59 GMT

@vivek_manoj You can use change event handler for text box and within the same you can use eval with match to accomplish numeric field validation. Following is run anywhere code and needless to say it is Simple XML, without the need for HTML or JS.

Following statement should do the trick for you: <eval token="validationResult">if(match(value, "^[0-9]+$"), "Numeric", "Not Numeric")</eval>

You can try more complex regular expression validation like decimal, negative etc based on your use case. Following is only for digits 0 to 9.

<form>
  <label>TextBox Numeric Validation</label>
  <fieldset submitButton="false">
    <input type="text" token="selText">
      <label>Enter Only Digits</label>
      <change>
        <eval token="validationResult">if(match(value, &quot;^[0-9]+$&quot;), &quot;Numeric&quot;, &quot;Not Numeric&quot;)</eval>
      </change>
    </input>
  </fieldset>
  <row>
    <panel>
      <table>
        <search>
          <query>| makeresults 
 | eval Text="$selText$ is $validationResult$" 
 | table Text</query>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">cell</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
      </table>
    </panel>
  </row>
</form>

Re: Textbox Validation Issue

niketn — Sat, 28 Oct 2017 16:42:35 GMT

@vivek_manoj, I am not sure whether you had tried the run anywhere dashboard example for text box JavaScript Validation. Can you please check and confirm? This is purely Simple XML hence does not require JavaScript or Reboot/Refresh/Bump of Splunk.