You can assign that view to a client account so that when they log in they only see submissions from Vancouver.
Since standard filters are entirely customizable, you can construct them for whatever is relevant for your form.
Creating a filter is pretty self-explanatory, but here's a few comments about some of the less obvious things.
The second column on the View filters page lets you choose your "operator". An operator is just a logical rule like "==" (equals) or "!=" (not equals). There are two sets of operators which appear, depending on the form field you selected.
- Other fields: for all other fields, you will see three options: "Equals", "Not
Equals" and "Like".
- Equals: The submission field must be exactly equal to the value or values defined in the values column for it to appear for the client (N.B. I don't believe this is case-sensitive).
- Not Equals: The submission field must not be equal to the value or any of the values defined in the values column for it to appear for the client.
- Like: The submission must be "like" the value entered, in other words it must be a string that contains the string found in the values column.
- Not Like: as you'd expect, the opposite of "Like".
The two pairs "equals/not equals" and "like/not like" are similar, but different. For technical readers, the "like" operators correspond exactly to the SQL "LIKE" clause: they allows you to do pattern matching on the form submission content - not strict tests for equality.
For example, consider these two rules:
- Submission ID, Equals, 10: This will filter out everything except the single submission with the submission ID value of 10.
- Submission ID, Like, 10: This will show any submission whose submission ID contains 10, so : 10, 100, 101, 102, 4010, etc.
Remember that for dropdown fields, radio buttons and checkboxes, you need to define the field value not the label here. Form Tools always stores the values of the form fields, not whatever the label happens to be.
To save you the bother of having to define multiple, similar filters for the same form field, you can use the pipe ("|") character to list multiple values for a single filter.
For example, if you had a form containing a "department" dropdown and would like to filter out all submissions other than those headed to the Arts or Humanities departments, you could use the "Equals" operator, and enter "Arts|Humanities" in the values string. If you would like to show everything except Arts and Humanities, you could use the "Not Equals" operator, and use the same "values" string. Hopefully, this should work the way you would expect, but here's a breakdown of the logic for both cases:
The following page contains three more examples for common uses of the filters.