How would I extract the last three numbers of a text field (in this case is a passport number) of a Cognito Form?
Cognito-forms – Extract numbers from a Cognito Form text field
cognito-forms
Related Solutions
I am a developer for Cognito Forms. Yes, your forms all have a smart Recaptcha built in. Most users will never see it, but bots will!
If for some reason you have issues relating to bot spam, please submit this as a Bug Report.
If you would like to have Recaptcha always appear for all users, please submit this as a Feature Request.
I am a developer for Cognito Forms. When you are building your form you can add any of the following types of fields:
In this case you added a Number field to your form to capture the Passport Number. Number fields in Cognito are specifically designed to capture and store simple numbers (Integer, Decimal, or Percentages) and therefore require the user to enter values that are actually real numbers.
For Passport Number, your best choice would be to select Textbox, as passport numbers often contain letters and numbers. This will eliminate the validation error you are seeing.
Related Topic
- Cognito-forms – Transfer text field to choice field in separate form
- Cognito-forms – How to build a form with repeatable sections in Cognito Forms
- Cognito-forms – Allow only numbers in Cognito Form phone field
- Cognito-forms – Receive Cognito Form results as Plain Text email
- Cognito-forms – Show submitter a serial number when they complete a Cognito Form
- Cognito-forms – How to reference a field on a different section of a Cognito form
- Cognito-forms – Prefilling a Cognito form
- Cognito-forms – Number field limitation
Best Answer
The help documentation for Text Functions is the best source of reference for any form of text manipulation in Cognito Forms:
https://www.cognitoforms.com/support/52/calculations/text-calculations
In this case, something like
=TextField.Substring(TextField.Length - 3)should do the trick.