I have a form that has a 17 digit Vehicle Identification Number field in it. I use the fields from this form to automatically fill in other forms, which is no problem. I have a field that I need to be automatically filled in that has 17 different boxes (i.e. fields). The field it draws from is 1 box (and can't be broken down into 17 different fields, too small an area). I am looking for a way, if possible, to have a formula that can pull the first digit out of the field containing the 17 digits and put it in the first box, the second digit and put it in the second box, etc. I know that each of the 17 individual boxes would have its own formula but have no way of knowing how to tell field 3 to grab the 3rd digit in the 17 digit field. Hope I've made sense! Thanks for any advice given!
Tony
Enter a calculation Formcalc script for fields with digits. Select field, than in Script Editor (Ctrl-Shift-F5) choose calculation event and Formcalc language.
For 3rd digit field script should be like this:
Right(Left(17DigitField.rawValue,3),1)
For 5th:
Right(Left(17DigitField.rawValue,5),1)
And so on.
Don't forget to change in script "17DigitField" to your name of field with 17 digits.
Hope that helps.
Andrey.