Send reminder based on multi-select text field of users

Question

I have a project tracking app that has a projects table with a 1:many relationship to a resources table (1 project can have many resources). The resource name is a user field. There is a multi-select field in the projects table to capture the resource names.

I would like to send a reminder to the users in the multi-select field (from the projects table) that triggers when a status report is due.

How do I convert the multi select field of users to show as a recipient in the 'Remind Whom' field of the Reminder, and thus send the emails to each of the users?

------------------------------
Colleen Burch
------------------------------

MarkShnierYou · Answer

Can you clarify the question? You say that the Projects record has a multi select field for the Users > is this a data entry field? If so what is the field type? Is it a list user field type?

But then you also say that you have a child table of Resource Assignments to the project. Are those in fact the users that you want to notify?

I am confused by the two possible sources of users to notify.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community