Jump to content
  • 0

Data Validation in In line Edit


Question

Hello - I need help in improving the JS code below. I would like to  add data validation upon updating a record via In line Edit in a Tabular form. Any feedback is much appreciated.

 

<script>
document.getElementById("Mod0InlineEdit").onclick = function() {
    window.alert("check");
    if(document.getElementsByName("Mod0InlineEdit")[0].value > 100 {
    window.alert("save!");
    }
      else if (document.getElementsByName("Mod0InlineEdit")[0].value > 1000 {
    window.alert("do not save!");
        return false;
    }

    else {
        window.alert("do not save!");
        return false;
    }
}

Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Hi @NeoInJS ,

I was able to create validation check for Inline edit with jquery. You should wrap your fields in div with ID.

Also, you need to disable ajax on your report and paste the following script in the footer.

You can use following code as an example.

Header

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<div id="cbform-improvement">

Footer:

</div>
<script>

$("#cbform-improvement #Mod0InlineEdit").click(function(e){
    window.alert("check");
    if(document.getElementsByName("InlineEditHours")[0].value > 100) {
    window.alert("save!");
    }
      else if (document.getElementsByName("InlineEditHours")[0].value > 1000) {
    window.alert("do not save!");
        return false;
    }

    else {
        window.alert("do not save!");
        return false;
    }
});
</script>

Hope this helps.

Regards,

@Vitalikssssss

Link to post
Share on other sites
  • 0
12 hours ago, NeoInJS said:

Hello - I need help in improving the JS code below. I would like to  add data validation upon updating a record via In line Edit in a Tabular form. Any feedback is much appreciated.

 

<script>
document.getElementById("Mod0InlineEdit").onclick = function() {
    window.alert("check");
    if(document.getElementsByName("Mod0InlineEdit")[0].value > 100 {
    window.alert("save!");
    }
      else if (document.getElementsByName("Mod0InlineEdit")[0].value > 1000 {
    window.alert("do not save!");
        return false;
    }

    else {
        window.alert("do not save!");
        return false;
    }
}

 

Hi NeonInJS,

You may try this code:

 

<script>
var caspioform = document.getElementById('caspioform');
var inlineEdit = document.getElementById('Mod0InlineEdit');

inlineEdit.onclick = function ()
{
    if (confirm('Do you want to Update?'))
    {
              if(document.getElementsByName("InlineEditNameofYourField")[0].value > 100 {
              window.alert("Successfully Updated");
              caspioform.submit();
              }
              else if (document.getElementsByName("InlineEditNameofYourField")[0].value > 1000 {
              window.alert("Invalid Input");
              return false;
             }
    }
    else
    {
        return false;
    }
};
</script> 

 

regards,

Franchiser

 

Link to post
Share on other sites
  • 0

Hi,

I'm trying to modify this function to get the value for a calculated field in the Caspio report datapage.  Do you know the equivalent syntax for

var orderStatus = "InlineEditOrderStatus";

 var Status = document.getElementsByName(orderStatus)[0].value;

for Caspio calculated fields?  Have tried using cbParamVirtualX as per the documentation but it returns null.

thanks,

Link to post
Share on other sites
  • 0
On 8/9/2020 at 9:19 AM, AtayBalunbalunan said:

You can inspect the calculated field element.

 

image.thumb.png.dfd5e1faff066debc0e7225b5a87a488.png

 

One way to get the value is by this code.


document.querySelectorAll(".cbResultSetCalculatedField")[0].innerHTML;

 

Thanks Ataybalunbalunan, much appreciated. 

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...