I'm trying to implement a "My Assigned Tasks" button whose action selects the currently logged on user (OSUser) from an already existing field (assigned_to). My problem is that the OSUser value needs 11 characters trimmed from the beginning, and this is proving to be difficult. I've put this in the script as a load statement, but get the obvious error that the OSUser field doesn't exist:
LOAD Right(OSUser, Len(Trim)-11) as UserName
Once I have the OSUser isolated to match the assigned_to field (which will match after the character trim) I might need some advice/suggestions on how to implement this via a button/bookmark combo or other method. Thanks.
That's exactly what I was looking for, mphekin12; but when I used the search statements you and Rob Wunderlich suggested, nothing happened when I clicked the button. Just to make sure, I did a control experiment with the following entries for the field & search strings:
Still, nothing was selected after I pressed the button. I don't understand, since I made doubly sure there were no extraneous values selected on the sheet I was working on. Am I using the wrong syntax?