General

Re: Compound filter on drop-down list.

shniggens — Thu, 27 Oct 2011 20:13:17 GMT

Never mind I figured it out. The State = State filter needs to be "or"'d at the end of the other ones. It works great now. Thanks. I owe you a beer.

Re: Compound filter on drop-down list.

shniggens — Thu, 27 Oct 2011 20:02:17 GMT

That works great by itself, but if the form field does not equal DC, I need it to just match states (State = State). When I add State = State at the end of the filter, it just uses that filter only.

Re: Compound filter on drop-down list.

Jimmy — Thu, 27 Oct 2011 19:42:09 GMT

There's a problem with your logic. What you need is

FormFieldState = "DC" AND (SharePointState = "DC" OR SharePointState = "MD" OR SharePointState = "VA")

But since AND has a higher precedence than OR, you can't just fix this by switching two of the ANDs with OR. Your options are:

Change the OR part to be one expression:

FormFieldState = "DC" AND

SharePointState = "DC" OR SharePointState = "MD" OR SharePointState = "VA"

Or make it three separate filters

FormFieldState = "DC" AND

SharePointState = "DC"

FormFieldState = "DC" AND

SharePointState = "MD"

FormFieldState = "DC" AND

SharePointState = "VA"

Compound filter on drop-down list.

shniggens — Thu, 27 Oct 2011 19:35:40 GMT

I have a drop-down that pulls venue information from a sharepoint list. Currently it is filtered to only pull in venues where @ State = State (another field in my form). This works fine.

The problem is, in some areas, say Washington, DC, we may need a bigger radius than just state.

So I tried adding more filter to it

Sharepoint State = Form Field State (the basic filter) or

Form Field State = "DC" and

SharePoint State = "DC" and

SharePoint State = "MD" and

SharePoint State = "VA"

But it still only uses the basic filter (State = State)

Any suggestions or workarounds?