Hi, so i am really confused how to get UK telephone numbers into Google Sheets and subsequently AppSheet. I found the only way i can get the UK phone number into Google Sheets is to set a custom number format (as Google sheets won’t let me enter a number with a leading 0 without removing it, so found I could add a “+44” instead), see 1 in pic.
With the number formated like so, see 2 in pic:
So this gets Google Sheet at least storing a UK formatted number correctly… BUT…
Now in AppSheet whether I tell it the format is a number or a phone, it just shows the number without a the 0 or the +44… (but shows the icons if set to phone to call or message which is what i want BUT this won’t work without either the leading 0 or +44 as part of the number)
See 3 in pic
Any clues as to how I need to store the data OR get the data presenting correctly?
(sorry for the reference to a single pic, says a new uesr can’t add more than one pic per post;))