How to save phone numbers in DB?

Saving a Users phone number is not working because the default phone number option is for US phone numbers, but I am in the UK. A standard UK number looks like this:

+44 01323 123456 (landline)
+44 0777 123456 (mobile)

I have tried saving as text, but I get an error:

This thread suggests saving phone numbers (as text) and prepending them with a [+][countrycode][phonenumber] . How do I add a [+], I mean where do I add that?

1 Like

What ‘type’ is your phone number field in the db? And what ‘type’ is the input set to? In any case there’s obviously a mismatch there.

As you say, phone numbers should be saved as a text (they are not numbers).

If you want to add “+” then you can just add that before the input’s value.

Although there are a couple of plugins for formatting and displaying phone numbers that are worth looking at (one by Zeroqode and one by BDK).

There is no input value field?

No, I mean you save it in the workflow when you write to the database.

Or are you not worried about saving the + to the database and only want to display it in the input?

I’ve tried to add a ‘+’ sign (see arrow below) but it won’t accept it?

As long as your phone number field is s text (which it should be) then it should work.

(make sure you click in the dark grey box before the input’s value and not on it)

2 Likes

Ah got it, thank you. I think it was just fiddly to add the ‘+’ to the string but when I deleted and did it again it worked.

1 Like

Hey I am having the exact same issue. I am very new and have no idea what im doing. I dont seem to be able to input the + into the string because mine is only showing the fields not letting me chose the input. I get all other types of data in my data base but no phone numbers so I am assuming its because the phone number is starting with a 0. I have it set up as text not numbers.

I’m not sure I understand the issue?

Why exactly can’t you enter the + into the Phone Number field for the new interested Person?

If it’s set up as a text field then you should be able to do it no problem.

Perhaps clarify the exact issue you’re having in order for someone to be able to give you more specific help.

It is a bit fiddly to get the ‘+’ but it does work. That said, I found that I can save phone numbers without a ‘+’, I just save them as Text and whatever the user inputs will be what get’s stored in the DB.

Thank you!!! I have figured this out, I didn’t need to enter =input data for my other fields so that was a little confusing but i was able to do it for phone number and it worked for me. For anyone else having the same issue it was actually very tricky to get the + in front i had to try a few times but it is possible I think the hard part is clicking on the correct space between the = and the input value. :slight_smile:

1 Like