1: Surveys
Posted by Bulmer on 07/02/24 16:17

I use a survey as an order form, one of the questions is "please enter your phone no." All numbers whether mobile or landline begin with a zero. However the survey does not save the zero, which means I have to add it to me records. How can I rectify this little niggle, not a major problem.

Thanks

Mike

2: Re: Surveys (response to 1)
Posted by Joe Oldak on 08/03/24 21:59

Sorry for the slow reply!

I imagine this is the difference between using a number type vs a string type to collect the number. Since of course with a number a leading 0 means nothing.

You could try changing it to a string type of text box instead and see if that does it.

Thanks

Joe

3: Re: Surveys (response to 2)
Posted by Bulmer on 09/03/24 14:41

Hi Joe,

Sorry, I have tried TEXT, Numbers & Integer and none store the prefix of 0.

Thanks

Mike