AnsweredAssumed Answered

Scripting Find with data from a field

Question asked by Stonely on Apr 8, 2013
Latest reply on Apr 10, 2013 by Stonely

Title

Scripting Find with data from a field

Post

     I have four fields in a layout:, each of which is filled by drop down menu consisting of numerous options for meeting selection: (1) future date; (2) group assignment 1; (3) group assignment 2; (4) group assignment 3. The drop down options presented for #2, #3 and #4 are identical. I want to develop separate lists for each future meeting and specific group assigned to for that meeting, no matter what field the assignment is made in.

     I have developed a script to find, for example, those assigned to "future date 1" and "planning group" with no problem. I would like to use this script to, for example, find members assigned to "planning group" for each of the remaining future dates without having to develop individual scripts for each option, resulting in a huge number of scripts. Ideally, I would like to find all members assigned to a future date, then use (copy/paste?) the date used in that script in the script to, for example, find members assigned to "planning group" for each future meeting. 

     Any suggestions would be greatly appreciated, as I've tired to solve this issue for some time.

      

Outcomes