limiting portal results

[jcarson]

Is there a way to limit the results returned by a portal.

For example, I have a bunch of entries associated with a contest that all show up in a portal. What if I just wanted to see the entries from everyone from Texas in the portal?

Thanks,

Jeff

[QuinTech]

On the left side of your relationship, make a field named StateSelection, with a drop-down menu that includes state names attached to it. Make a second field name CalcStateSelection, equal to

Case ( 

  IsEmpty ( Trim ( StateSelection ) ) , 

   "All" , 

   Trim ( StateSelection ) 

) 

On the right side of the relationship, make a field called CalcContestState, equal to:

ContestState & "All"

Add a join between the CalcStateSelection and CalcContestState to the original relationship.

This works because of the multiline key on the right side: A left-side selection of "All" will match everything on the right side, while selecting a specific state will match only the selection.

J

[jcarson]

Thanks, works just like I want it to.

[jcarson]

Ok, now I've got a follow-up question. If I wanted to select multiple states, is there a way to do that with a drop down menu? or would I have to switch to check boxes which take up more space than I would like

[QuinTech]

No easy way with a drop-down. You'd be best off with checkboxes.

Off the top of my head, I can't remember if the Trim function gets rid of pilcrows (the that separates entries in a checkbox field). If your portal suddenly doesn't work and you can't figure out why, consider removing the Trim function.

J

[comment]

You can (or at least on a Mac you can) shift-click to select multiple values from a popup. Command-click for non-contiguous selection.

[QuinTech]

Now that I try it, you can do it on Windows, too. Another v7 thing I didn't know. comment, you are giving me an education today! (Just like any other day, really )

J

[jcarson]

Thanks comment it did work, I just had to figure out that I had to hit enter after I clicked on my selections for it to actually register. Thanks for all your help too QuinTech.