Hello,
I have a form that needs to use lookup select box to show the group names that are assigned to the requester. I need to have the lookup filtered based on the "requested for" instead of login user. Is there a way to have requested for as a filter to be used in filter/reference qualifier?
I have a lookup value field as group and here's my javascript and failed to show requester's group name:
javascript:'requested_for='+current.variables.requested_for
The result is still showing all group names in the selection box, instead I really need it to show only 1 group name since the requester is a member of that group.
Using gs.getUserID() will show correct selection box based on whoever is opening the form but when someone else do that, it will change the group name. I don't want it to change based on whoever opens the form, therefore I need somehow use the requested for filter.
Thoughts?
