In-App Filtering available for General Availability

We’re releasing In-App Filtering for general availability. We want to thank all of you in the Community for your feedback from the preview program. You’ll be seeing this feature soon as we roll out…

For anyone who hasn’t seen, heard, or used it, here’s a recap:

App users can now filter items from a collection of records based on column values, and is available on both mobile devices and desktop computers.

Example: see enclosed screenshots
Your application has pastries that have a ‘price’ and a ‘type’ (Sweet vs Savory). In a view that shows all pastries, app users can now filter to see only the ones that are Savory and that cost less than $3.99.

How to enable in the editor:

  • Go to your Data Schema and make sure the ‘Search’ toggle is turned on for each column that app users should be able to filter on
  • Save your application

App users will see the feature after their next sync.

How do app users work with it?

After it’s been enabled by the app creator and after app users have synced their app, users will:

  • Click the Search icon
  • In the search bar, app users click on the filter icon
  • This opens the filtering widget
  • App users can then specify filtering values for each column
  • App users click ‘Done’ to get back to the view with the results

See screenshots below for visual details.

What are the supported views?

Only collection views are supported, namely:

  • Card, Deck, Gallery, Table, Map (primary table only), Calendar, Chart

The filtering mechanism currently does not support multiple tables at the same time. As a result, filtering on the Dashboard View is currently not available. Similarly, in the Map View it is only possible to filter records of the primary table, but not of the secondary table.

What are the supported data types?

  • Text
  • Enum
  • EnumList
  • REF
  • LongText
  • Name
  • ScanText
  • ChangeCounter
  • Number
  • PostalCode
  • Address
  • LatLong
  • ChangeLocation
  • DateTime
  • ChangeTimestamp
  • Percent
  • Decimal
  • Price
  • Url
  • File
  • Image
  • Drawing
  • Signature
  • Thumbnail
  • Video
  • Date
  • Time
  • Email
  • Phone
  • Color
  • Progress
  • Yes/No

Is the filter persistent?

If an app user sets up a filter on a view,

  • After looking at individual records of that filtered list, going back shows the filtered list
  • When the app user goes to another view of the same data set, the filter persists

Does it work offline?

Yes, as it applies to the data that was downloaded to the device.

How does this relate to Security filters?

This is independent of security filters. Security filters allow only certain data to be downloaded to the device. This new feature filters data that’s already been downloaded to the device.





9 Likes

Thank you so much for this feature.

Can you advise how to sort the enum lists (virtual column) shown in the filter options? They seem to be sorted according to physical row order.

Capture

Using the expression like SORT(Table Name[Source Column]) in valid-if does not work.

Very exciting that this is GA.
Thank you!

1 Like

Sorry to say this isn’t possible right now.

1 Like

When activating a Filter setting on a column in a Table view (probably other view types as well, I just didn’t test), it then removes that column from the view. I’m not surprised, as that is how it works for drill-down groupings, LINKTOFILTEREDVIEW, and inline child tables. But now we have yet another functionality to add to that list where it happens. As such, I think getting this feature request fulfilled has now become even more important:

3 Likes

Thank you for your acknowledgment.

A feature long awaited by the community. :heart_eyes:

I hope you will don’t stop there on this one, having more logical operator between filter would be really useful: Add is the only possiblity

Still a really nice feature that cover almost all users cases

this feature It’s something I’ve been waiting for a long time. Thank you!

1 Like