Extracting telephone data so report can send SMS

Arizno
New Member

I am trying to create a report that at 4pm sends me a text message for a task marked “Urgent” that is not complete.

On the bottom where it asks you to list the telephone number I do not want static information. I want to populate the telephone number of the user that task belongs to. However I have this message to contend with.

"This formula is not evaluated in the context of a row, so column values are not available."

Is there a way to pull the telephone data from my USERS table that has a column with the telephone numbers in it?

0 5 427
5 REPLIES 5
Top Labels in this Space