Photo by bruce mars on Unsplash | How to Coda Calling and Texting?

How to Coda Calling and Texting?

Set up calls and send messages directly from a doc

database with prefixes per country
  1. Dial the IDD, which for majority of the world is 00 or 011.
  2. Add the country code from the country code list.
  3. Then dial the target number, leaving off the first zero if there is one.
Using text and chaining
If(thisRow.[phone number].Slice(0,1).Contains(0),thisRow.[phone number].Slice(2),thisRow.[phone number])

What about the 00 versus the 011

Well happily for us the exit code of any country can be replaced with a plus symbol according this source. That makes it easier, we do not have to format the numbers into something like 0032 but we can add + 32 and off we go. This plus also works for calling to the USA from Belgium and to Germany when you are in the USA.

we are (almost) ready!

SMS via Coda

An SMS has two important elements, the number (as shown above) and the text message. In the community you find a way to handle this:

The Format Function

To make texting work, we apply the function Format() for two reasons. First it is a function that permits you to separate variables from non variables (like text and numbers) in a structured manner. Once you see the logic, this one reads easier than Concatenate(). Second and not less important, this function permits you to format your function in two ways. Using hard returns you create white space in your text without the need of Character(10). This is very convenient. However, often you see it as below whereby behind the double dot you find the instructions for the amount of digits you want to see.

Format(“On {1} {2:00}”,Month,Day)
Creating a text message
the set up

Calling

Since you have seen how the format function is working, this one goes rather fast. Don’t pay attention to the outer if statements, they are just there to make it look nice. However the if statement on the inside that generates the FullNumber does matter as explained previously. This one strips the zero away in case there is one. This is variable 2. The prefix you have seen before and the ‘ + ‘ replaces the complexity of the 00 or 011. I put a white space between the prefix and the number as you can see, that reads better and with the format function, this is so easy!

Huizer Automation — Coda Expert on how to text and call with a Coda doc

--

--

I use Coda mainly for (HR) planning & (budget) calculations. Follow me to learn how to Coda with numbers. I blog at least once per week.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Christiaan Huizer

I use Coda mainly for (HR) planning & (budget) calculations. Follow me to learn how to Coda with numbers. I blog at least once per week.