I am trying to have a manager see the value inside survey question (not by email trigger -> email) when subordinates completes the survey.
Objective is giving a manager ability to see the value subordinate(s) entered inside survey, and overwrites/not overwrites.
So, I was trying to use Contact List Trigger, but the way it updates the data in Current List is only related to the area for surveyor (in this case subordinate).
Is there any way we could have subordinates update the value in someone else's value (in this case, manager) as well?
So basically, it updates data in whole rows.
For example in SQL, it updates the data in whole rows without a row designation/'where' statement:
Something like: UPDATE ContactList
SET Metric = "50" 
Question
use Contact List Trigger to update someone else's value
Maybe when you use contact list trigger, and use authentication to link the surveyor to the contact list, try not to link the surveyor to the surveyor's contact, instead link it to a generic shared contact, so all surveyor are linked to the same contact, use it as a shared database. but when you update data in this shared database, you only update the embedded data field with the surveyor's name in it.
1 person likes this
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.