New Bug Encountered: Phone numbers are not catched with workflow

[dev2]

Hi all,

I’m trying to send SMS with a workflow (I created and paid Twilio account and Twilio number).
Previously I used to send an email instead, using the field “To” this way : “[Mail]” (without quotes)
Now I’m trying with : “[Tel employe]” (without quotes) for the SMS workflow.

The log result as a failure, and the error comes from the “To :” field, which catches nothing.
Here are the details:

Complementary informations:

• for the user I’m showing, he is supposed to receive both email and sms (on my tests at least)
• the email workflow works
• with SMS, all recipients are supposed to be from Switzerland. I tried with “004179” beginning, with “0079” beginnings, with “+4179” beginning, with “79” beginning,
• all column informations comes from a Google Sheets importRange function (and catching email works fine)

I have no clue of why this does not catch the phone number, do you have any idea ?

Many thanks

Aurelien

[Phil]

I can investigate if you provide:

1. Your account id
2. The app name
3. The workflow rule name

[dev2]

HI @Phil

Thanks for helping.
Here are the asked informations :

1. 1021166
2. Outillages_v1b-1009434
3. Debut Resp Outillages SMS

[Aleksi]

Just curious… try to use Alpha 2-code as a country code and see if that helps. You can find the list from https://en.wikipedia.org/wiki/ISO_3166-1

[dev2]

Hi @Aleksi

If this is what you mean, it’s already the case.

[Aleksi]

No, I mean the TO phone number.

[dev2]

1. I tried that:
   

   
   
   ==> that gave was a failure.

2. I tried another typing (the “usual” one):
   
   ==> that gave a failure

Do you think I should type phone number differently ?

• the one with the arrow is the one supposed to be picked by the workflow
• the other one, on top, is an example of how I use to type phone numbers

3. Just in case, I just tried typing a phone number instead of a column name:

==> And this one worked fine, my user received the SMS.
Here is the log : it interpretated the 0041 country ID in the +41 country ID

[Aleksi]

What I have used is CH79… meaning without the country code +41.

[dev2]

Aleksi:

CH79

I’m not 100% sure, but I would say this is the first configuration I tried (first picture in my previous post)
Do you think I misunderstood ?

[Phil]

I looked at application “Outillages_v1b-1009434”.

You are getting the SMS “To” value from the “Tel employe” field in table “Employes” but that field is empty in every record in the Employes table. That is why the Report is saying that “To” is missing.

The “To” field is expected to contain a phone number that is optionally preceded by a +.
The phone number should not be prefixed with the country code “CH”.

Please try the following:

1. Populate the “Tel employe” field in table “Employes” with valid phone numbers in the form +41798271599
2. Change the expression in the “To” property to [Tel employe]
3. In Country Code specify “CH”
4. Try the Report.
5. Check the Audit History and see what it reports.

[dev2]

HI @Phil

Thanks for your help.
I don’t know what make you tell the [Tel Employe] field is empty is the Employes Table, I’ve been checking it various time in case.

BUT, thanks to your message, I just noticed that, because phone numbers where at first written with “0041” formatting, at generating the table, the [Tel Employe] type was “Number”.
I changed it as a “Phone” type, and replaced every “0041” in the table with a “+41”.

I tried it, and report is successful !

I’m still waiting for my user to tell me if that worked for him (5:50 AM here), but log seems OK, with his phone number appearing in the “To” row.

I will write you back if he did not received it, but in the meantime : many thanks !!!

Aurelien