Mobile and Land Line number formatting

[TotalSolutions]

I want the Mobile number to be formatted as: +91 12345 67890 in which the +91 is the Country Code and rest is the 10 digit mobile number and there should be a single space between +91 and the mobile number and also single space between the first 5 digits of the mobile number and the remaining 5 digits.

Also I want the land line numbers to be formatted as +91 22 12345678 in which the +91 is the Country Code and 22 is the City Code and rest is the 8 digit land line number and there should be a single space between +91 and the City Code and also single space between City Code and the Land Line Number.

How can appsheet know which one is moble number and which one is landline and how do I format it accordingly?

Above works when I add a mobile and landline numbers on my iPhone so there should be some way to do the same in Appsheet.

Please help. Thank You!! God Bless!!

[1minManager]

Total_Solutions:

How can appsheet know which one is moble number and which one is landline and how do I format it accordingly?

When you set a column as a Phone type you can set whether you can call, SMS or both. Though these are just Y/N, not dependant on a rule

Total_Solutions:

I want the Mobile number to be formatted as: +91 12345 67890 in which the +91 is the Country Code and rest is the 10 digit mobile number and there should be a single space between +91 and the mobile number and also single space between the first 5 digits of the mobile number and the remaining 5 digits.

You might be able to do this using

help.appsheet.com

CONCATENATE()

Merged text from parts

and

help.appsheet.com

LEFT()

Left-most characters of text

Simon@1minManager.com

[Steve]

Total_Solutions:

Above works when I add a mobile and landline numbers on my iPhone so there should be some way to do the same in Appsheet.

Nope. There is no way for AppSheet to distinguish between a land-line number and a mobile number. You would have to implement that logic yourself.