phone

To convert a value to a phone value

With this function, you can display a formula field as a phone field with a call button. By clicking on the button, you can place a call via your phone client.

By clicking the little phone, you can place a call via your phone client

There is no validation if the passed content is a phone number indeed.

This is quite useful if you have a text which contains a phone number, and you'd like to extract the phone number to convert it to a callable phone number.

Syntax

phone(any)

Return

phone

Examples

phone(myNumber) To convert a number to a phone value.

phone(911)

Result: The phone number will be shown as a phone field (see above) where you can place a phone call directly.

phone(string) To convert a string to a phone value.

phone(Customer.phone)

Result: [phone] (Shows the phone number of the linked table Customer.

One more example

You receive a message like this:

Hey Claudia,

here’s my phone number: [phone].

Please give me a call, so we can discuss what we will include in our next presentation.

Kind regards, Sam

With a regular expression, you filter the phone number, which will be shown in your respective formula field.

phone(extractx(Message, "\+(\d|\s)+\d"))

Result: [phone] (Extracts the phone number out of the text message and shows it in a field with the call button.

See also

email To convert a given value to an email value