I’m trying to generate a list of mobile number to send an SMS via the Send Message Workflow, but I can’t seem to get the query working…
There are 3 tables involved
- Classes - key, title, Related Registrations By Class * Students - name (is the key) * StudentToClass - _computedKey (appformula of CONCATENATE([Class],": ",[Student])), Class, Student, Related Registrations By Student
The computed key provides restrictions so that the system will not allow the same student to be registered for the same class twice.
I’ve tried several directions for getting the information by interrogating the tables in different ways… but nothing seems to work. i.e.
From Students
SELECT(Students[Mobile], IN(“someClassID”, [Related Registrations By Student]))
From StudentToClass
SELECT(Student[Mobile], [Class]=“someClassID”)
One primary issue is that the Workflow TO field is not attached to the Expression Builder, so it’s difficult to build elsewhere and move over…
Thoughts, suggestions?
Thanks in advance all…
LinkedIn
Twitter
