Hello. I need to find a way to extract a value from a valuelist based on a partial match only.
For example, the valuelist contains the following data:
If my search value on the list was "12x16", I would want "s123-12x16" to be returned from the calculation.
There would not be any circumstance where more than one match was possible. There would also be the possibility of no matches.
Hopefully someone can help as I've tried everything I can think of to no avail. I'm able to do it if I know the exact match, but I can't find a way to get it to work when I only have a partial match.
Many thanks in advance...
I'm baffled by this one. I have a few logins set up with different privilege sets attached. I have a button on my main layout with the one-step "Re-Login [with dialogue:On]" script step attached. Next to the button I have a little merge field displaying the name of the current Log-in account.
Logging in either way at the beginning is working fine, as expected. When I try the Re-Login button and enter a different account, the merge field displays the change appropriately . . . but the privileges aren't changing over accordingly!? This happens in either direction -- whichever account I start with, those privileges remain in force. (One of the accounts is all-access, the other has a very limited Privileges Set).
I can't fathom what's amiss here -- any suggestions?
Is there a way to do the opposite of the filter function? For example:
Field 1 contains the text “dog cat giraffe crocodile”
Field 2 contains the text “dog giraffe”
I would like field 3 to be a calculated value which displays “cat crocodile” ie it removes from field 1 whatever words are typed into field 2.