Phone number validation

Ask for Help
1

I have a form with a phone number text input field. It seems to allow users to type anything in, i.e. they can submit if they type “a” into the phone number field in the add form. Is it possible to require a valid 10 digit number and show the number pad instead of alphabetical keyboard?

4 Likes
2

The text fields are really useless for the time being and can’t even validate emails

1 Like
3

@jake_z you could do the validation in google sheets and reject the submission.

4

Explain more

5

Hi @Yasin_Hassanien,

IT isn’t really an elegant solution but it is workable dependant on your requirements and if instantaneous feedback is something you can do without.

I will go find my previous post on this…

6

You can do the validation yourself if needed. I have addressed this question a few times and there is a way to workaround this issue.

The gist of it is, have the user enter all the information that requires validation into user fields (not in a form) and validate it. Once all values have been validated, a form button appears. Once the form is opened all the values previously entered are shown (no longer editable) for confirmation and then the user submits the form.

In this way you can validate the input prior to accepting the form entry. It’s not ideal but it is really only one extra click from the user… Not too much of a price to pay.

From a users perspective it also feels ok I think as it’s the confirmation page you have in many websites that make you click accept and if you don’t like what you chose, have to back out and change it.

The validation is done on sheets rather than glide as you can do any sort of validation in sheets. The tradeoff is speed. Since it’s going into and from sheets the validation will take 3-5s round trip possibly.

1 Like
7

Consider this other workaround: Data entry mask on phone or email component? - #3 by kiptoo

8

Hi jake_z,

Now that Glide is integrated with Zapier, you can automate the checking, verification, and formatting of phone numbers. Here’s how you can set it up step-by-step:

  1. Create a New Zap in Zapier:

    • Log in to your Zapier account and create a new Zap.

  2. Set Glide as the Trigger App:

    • Choose Glide as the trigger app.
    • Select the trigger event (e.g., “New Record”).
    • Connect your Glide account and set up the trigger to detect when a new phone number is added.

  3. Add OpenAI API as an Action:

    • Choose the OpenAI API module as an action.
    • Set up the action to take the phone number and country name fields from the Glide trigger.
    • Create a prompt in OpenAI to format the phone number correctly based on the country.

  4. Add Numverify as Another Action:

    • Choose Numverify as the next action.
    • Pass the formatted phone number from the OpenAI response to Numverify.
    • Set up Numverify to validate the phone number.
    • Learn more about Numverify phone number validation here

  5. Update the Record in Glide, Google Sheets, or Another CRM:

    • Add an action to update the original record in Glide, Google Sheets, or your chosen CRM.
    • Use the verified and formatted phone number to update the record.
    • Configure the action to ensure the updated phone number is recorded in the desired format.

  6. Test the Zap:

    • Test the Zap to make sure it’s working correctly.
    • Ensure that a new phone number added to Glide triggers the Zap, formats it using OpenAI, verifies it with Numverify, and updates the record accordingly.

  7. Turn on the Zap:

    • Once everything is set up and tested, turn on the Zap to start automating the process.

By following these steps, you can automate the phone number verification and formatting process using Glide, OpenAI, Numverify, and your CRM of choice through Zapier.

Hope this helps

Christopher