...
You can create a filter that will prompt users to enter a value, and filter based on that. For example, if you have data which contains people's names, you could create a filter like:
Name contains
_prompt.EnterName fx
Filter on Current User
If your data contains details of the user, you may be able to filter based on the currently logged in user. For example, to set a filter where the owner equals the current logged in user, add a condition to the filter:
Owner equals
_user.name fx
Enter a list of values for an "Is In" or "Is Not In" filter
If you want to select a set of records which have a field set to one of a range of possible values you can do this by selecting the "Is in" or "Is not in" comparator from the drop down list and then simply typing the list of values into the edit box to the right of the comparator as a comma separated list like this:
Country Is in
England, France, Germany ABC
Alternatively, you can enter the comparison value as expression:
Country Is in
["England","France","Germany"] fx
...
- one value from the list, the filter condition changes to:
- either
Equals
- or
, when the selected condition isnot Equals
not Equals
- either
- multiple values from the list, the value field is automatically changed to an expression, and the filter condition changes to:
- either
Is in
- or
when the selected condition iis set to IIs not in,
s Is not in.
- either
Tip | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
There are some scenarios where PhixFlow cannot generate the list of values for a filter picker list.
In these cases, PhixFlow automatically hides the icon
|
Description tab
Field | Description |
---|---|
Description | Description of the Filter. |
...