I have a "numeric field" which will contain a 10 digit number; the fist 4 digits being the date of birth (DDMMYY).
I would really like to have another field where the DOB is automatically calculated from this. I'd appreciated any help - I have pretty much zero knowledge of scripting.
Solved! Go to Solution.
Views
Replies
Total Likes
ok, I think I can see the problem. CHI is a numeric field and not a text field. Therefore the CHId is not a string but a digital number - that means that "0101191234" is actually a numeric value of 101191234. That cannot be dismantled with substring.
Change the CHI field to textfield and then try again.I tested your fields with the correct type and then it works:
To force format and length of CHI limit max characters
Display and validation patterns text{9999999999} and error on validation
Thanks kprokopi - the script works fine on the form you sent. But when I copy and past those 3 fields to my own form, it does't work and I get a huge number!
Yours: https://imgur.com/gallery/9ucexUm
Mine: https://imgur.com/gallery/NLojPoo
I also looks like the date format is different in the 2nd box - I don't why this could be, as I just copied across from your form to mine!
Edit: this should have been a reply to the other thread about the 2 date fields, sorry! I've commented there also.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies