I have a dialog field (PickValues) that “Uses View dialog for choices” and “Allows multiple values”. The list of unique values stored in “PickValues” are separated by a comma. I need to embed a view in this document that only shows the documents selected so a user can double click any one of the results to navigate to the document.
Unfortunately I don’t know script but am pretty sure I need script code to accomplish this… create a collection or something. The “Show single category” of a simple embedded view won’t work.
If someone could kindly send me the code, it would be greatly appreciated!!!
As I understand your question, you’d want to show & select any document with any one of the values. But it could be an indefinite number of values selected to display.
While it’s possible, most solutions go wild with categories awfully quickly. The strategy is to sort the options, and then create all the permutations where you want a specific document displayed.
With an indefinite number of categories to select, the number of categories goes wild very quickly. Permutations are like that. And there is a limitation on the view size that you’ll hit after a small number of documents.
You might be able to handle the permutations of 2, maybe 3 selections without as much trouble.
Thanks for your reply, I always appreciate those who take time to answer questions in the forum!!!
I did come up with a work around which isn’t pretty but works. I use the results in the “PickValues” variable in a radio button field that is set up to use a formula for choices. The formula is a DBLookup of “Pick Values” which produces a radio list of the “PickValues”. The user selected radio value is then fed into an embedded view so the user can double click and open the selected record. It’s an extra radio button click for the user to see a record but it works.
By the way, I don’t think I was able to explain my initial goal clearly enough but I’m good for now.