David17

This looks really good! I am half-way there. I am trying to hide the field on the submission form. I put an html (I don't know html) block before the field and after. I clicked on source and typed in <div style="display:none;"> but Caspio changed it to <div style="display:none;"></div>. I tried putting just </div> in the 2nd html block. Can't seem to get it to work.

Users choose 1 option from the drop down listing of event descriptions. In the drop down box definition we have "Field for value" as the numeric id which is stored in the table. However we also want to put the Event description in the table. There is only one field for "Field for value" so how can we move both the event description chosen and the event id to the table?

One last question: Can you tell me how to call this function, if possible, with another field called Age18to24 to prevent minus numbers being entered?

Now that I have the other code working I would like to try this code on another field. I imagine I would just insert this at the end of the other code and change the field name. How would I call this function to edit a 3rd field too? Tried to post this to Vitalikssssss but I don't think it worked!

Amazing! It worked! I had no idea it was case sensitive. I see that it works by preventing the entry of a negative number when the form is being filled out. I thought the footer was only activated at submit time. Anyway thank you very much for all your help!

Hi; Very strange that mine doesn't work. I didn't create the form but when I edit it the first page it highlights submission form. Not sure if that indicates it is a submission form or not. But I also tried the alternate code. Should this display an error message on a minus entry? Everything goes fine but it puts the -value into my table. Attached is how I defined the adults field on the form.

Thanks for the information. I don't know javascript so i am flying blind. I couldn't quite get it to work. Here's what I did: I put this code in the footer. I turned off the HTML editor before entering this. The name of the field I am trying to edit is adults. <script> document.addEventListener('DataPageReady',checkInput); function checkInput(){ let input = document.getElementById('InsertRecordadults'); input.min = "0"; input.type = "number"; input.setAttribute("oninput","validity.valid ||value='')"); } </script>

The table contains a field of type number and it is a text field on a datapage form. We want to be able to flag it if the user enters a negative number or a letter on the form. Is there javascript to do this or any other way to do this?