- EssilorSalesOpsAsked on December 19, 2012 at 02:44 PM
I have people wasting their time looking at requests that do not have valid account numbers. Account numbers have to be a 10 digit number (as a string because it may start with a zero).
How can i enforce this, or at least send a notification if this rule is broken?
- JotForm SupportabajanAnswered on December 19, 2012 at 02:57 PM
This is doable but would require getting a copy of the form's full source, embedding it into a web page and adding a script to the said page. I'll be back later today (Barbados time) with a solution.
I'll be back.
- EssilorSalesOpsAnswered on December 19, 2012 at 03:07 PM
Look forward to it. This solution wont break the google integration or anything I hope? :-)
- JotForm SupportabajanAnswered on December 19, 2012 at 03:12 PM
Hopefully not! (Murphy's Law: Anything that can go wrong will.) Honestly, I don't know but my colleagues should be able to shed some light on that. Somehow, I doubt that it will though.
- JotForm SupportabajanAnswered on December 19, 2012 at 03:29 PM
Actually, the solution is simpler than I thought. Since you already have the field set to accept no more than 10 characters, you just need to set numeric validation on the said field.
With the form loaded in the form builder, click the field and then the Validation button and then Numeric, as illustrated below:
Save the form when done and it should work like this clone.
- EssilorSalesOpsAnswered on December 19, 2012 at 03:52 PM
I also need to make sure the field isnt less than 10 characters too though... Also, forcing numeric will mess up the leading zero too, right?
- JotForm SupportabajanAnswered on December 19, 2012 at 03:58 PM
Of course. Sorry about the misunderstanding. The source code will indeed need to be used. I already have a pretty good idea of the script needed. So, I shan't be too long. (Knock wood)
As far as the leading zero is concerned, that shouldn't be a problem.
- JotForm SupportabajanAnswered on December 19, 2012 at 04:17 PM
Please test this form and let me know if it's working as you wish.
Looking forward to hearing from you.
- EssilorSalesOpsAnswered on December 19, 2012 at 04:22 PM
This is working exactly as I need it to!
Just let me know what I need to do to get it up and running on my server and i'll be in business!
- JotForm SupportabajanAnswered on December 19, 2012 at 04:53 PM
Here's what to do:
1. Get a copy of the form's full source, as explained in this user guide (Just copy the code highlighted in yellow: Don't click the "here" link to download the complete form files)
2. Paste the code into the body of a web page of your choice
4. Save the changes
If you would like clarification on anything, we'd be happy to help.
Do let us know how everything works out.
- EssilorSalesOpsAnswered on December 20, 2012 at 10:49 AM
We are using google sites. it rejected part of the form source when I tried to use a html box to enter it?
- EssilorSalesOpsAnswered on December 20, 2012 at 12:01 PM
OK Hosted the page elsewhere and embedded it on our site as an iframe.
Excellent work my friend!
Please add the mimum field size as a feature request!!!!
- JotForm SupportNeilVicenteAnswered on December 20, 2012 at 12:53 PM
Kindly open a new forum thread for your request so we can attach a ticket to it.
- JotForm SupportabajanAnswered on December 21, 2012 at 08:48 AM
I'm really happy to know that this solution worked out for you.
Thanks for the compliment :)