Sending A text

[blueocean]

Hi,

I have the following columns on my dispatch table in my security app:

Properties
Tech (Initials)

I’ve been sending text messages to my technicians once the app is synched, but is there a way to essentially say "You have a dispatch call at this [Property]?

would it be something similar to [Tech], [Property].[_Thisrow]…like a selection?

[Aleksi]

Hi @blueocean, you could try something like…
<<[Tech]&", you have a dispatch call at this "&[Property]>>

[blueocean]

Would that go in the formula slot, or would that go in the sms to section?

[Aleksi]

You can add it to SMS rule’s definition.

[blueocean]

Should I add a column in the back end with their phone numbers?
so it would look like

<<[Phone Number],[Tech]&", you have a dispatch call at this "&[Property]>>?

Sorry I need a bit more definition or maybe an example?

[Aleksi]

Please check this article how you can send SMS messages.

help.appsheet.com

Sending SMS from a Workflow Rule or Scheduled Report

A Workflow Rule can send an SMS when data changes. A Scheduled Report can send an SMS on a schedule you specify.

[blueocean]

I understand.

For this text string, what am I doing wrong?

<<[Tech]&", you have a dispatch call at this “&[Properties] for a &[Complaint]”>>

[Aleksi · Accepted solution]

Try with… <<[Tech]&", you have a dispatch call at this “&[Properties]&" for a "&[Complaint]>>

[blueocean]

Hey,

after tinkering around with it, I figured it out. Sorry I am getting used to this…thanks for your help!

[Aleksi]

You’re welcome