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;))
Instead of phone field, use text field. Then it adds the leading zero as well.
Set the spreadsheet column format to plain text.
Yeah so the problem with that (as mentioned in original question) is that if not a phone type then the phone and message icon wonโt be shown in the app as it doesnโt understand it is a phone number.
To also explain this further, I tried this suggestion just out of curiosity. Strangely AppSheet still removes the + if I format as a +44 number when stored?!?! So if i add +441234567890 it only stores it as 441234567890 which you wouldnโt expect if the type is text?!?!
As this didnโt work I have cleared all formatting from the Google Sheet and then set the field back to phone type. I canโt set the international dialing format with a + but through the AppSheet it now lets the leading 0 get storedโฆ hmmmโฆ all good as long as donโt need to store any kind of international number with the leading +.
The Phone column type does (some?) validation, and automatically configures the cal and send actions. If you use Text column, youโd have to do any validation yourself, but you could yourself add custom actions for call and send.
If the spreadsheet column format is automatic or some numeric format, itโs not AppSheet removing the leading plus, itโs the spreadsheet. Make the spreadsheet column format plain text.
Note:
OKโฆ so to explain this a bit further as it may help others in the future reading thisโฆ Yes I could set the column to be a Text value and validate it myself BUT (if my understanding is correct) the icons circled in the example below then do not appear as it doesnโt know to handle the number as a phone number and therefore show the icons. Iโd like the user to be able to press and call or press and message a contact like this.
Yes I have realised i am better of not trying to use Google Sheets as a correctly formated set of cells BUT just think of it as a repository with AppSheet doing the processing. So in my Google Sheet I have started to remove a lot of formatting and processing so we donโt get the two applications effectively fighting with each otherโฆ so iโm guessing this is also part of the learning curve to arrive at?
Mega! Iโm new hereโฆ lolsโฆ
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |