I know how to do this but you would need to push a button on the job to "put it in focus" for the current user. Then the results would instantly display on the job. It would probably take an hour or two of consulting time to set up but along the way you would learn the "User Focus" technique. The technique is all native no JavaScript.
The basis of the technique is to push a button on the job to put it in focus. By putting it in focus I mean to edit or create a record in a user focus table where the key field is the user ID of the current user. The attributes of the current job get looked up into the user focus table and then from there the attributes of the current job are then looked up down to the Creators table. Creators which qualify with then be "illuminated " based on a formula calculation.
Then the report link of all creators which would be on the jobs form would have a filter for only the illuminated qualified creators.
Feel free to contact me directly by the email in my signature line if you would like some one on one assistance to get this set up.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
