Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 fields which could contain an Account Name. I want to look in the 2 fields and pull all data from the fields containing the name. The Account name could be spelled differently in each. I do not want the user to have to do a global search and then select all matching values
Example:
AccountName =Design Studio
ProjectName = DesignStudio
I created an input box for the user to enter the name(s) and store into a variable. I created 2 list boxes, one for AccountName and one for ProjectName. I had to use Alternate state on each. I set a trigger on the variable from the input box to select the matching values in the 2 list boxes. I now want to take the values in each box and apply to my chart. How do I get this to work?
Maybe a search box restricted to search only in your Account- and ProjectName fields could be a solution.
You could also change the search mode to match your requirements.
hope this helps
regards
Marco
You may also concatenate both fields and display in a listbox (with seach-functionality).
HTH Peter
I have tried the concatenated listbox but cannot get the "Input box" value to select the possible values.
Hi,
maybe like this:
=ValueList($(=chr(39)&GetFieldSelections(AccountName,chr(39)&','&chr(39))&chr(39)),$(=chr(39)&GetFieldSelections(ProjectName,chr(39)&','&chr(39))&chr(39)))
hope this helps
regards
Marco