This would lead to a filter where if the field "has any of" the values set, then the records containing those values would be shown in the shared view. For example, in multiple select fields, the filter_ operator would function more like the filterHasAnyOf_ operator. However, by using filter_ Airtable will do its best to choose a filter that makes sense for the field you are filtering values by.
Using the generic filter_ operator will typically yield the same result as the filterEquals_ operator's output. Make sure to remove the existing query string from your URL before adding a new one. If your URL has a question mark already then that means it already has a query string. So, our final URL with our filtering conditions would be >_Project%20lead=Cameron%20Toth.
Then take your share URL, which in our case is:, and add a question mark ( ?) followed by your query string. For example filter_Category=Brand%20identity&filterContains_Project%20lead=Cameron%20Toth. To combine the filter rules together into a query string you use the & symbol. Our second rule would be filterContains_Project%20lead=Cameron%20Toth because both “Project lead” and “Cameron Toth” have a space in them. Our first rule would be filter_Category=Brand%20identity because “Brand identity” has a space in it and the URL encoding for spaces is %20. Field IDs are available through our API, or through the Field Manager (Pro and Enterprise only).īack to the task at hand. So, for our category value to be used in the URL we would want to encode it as Brand%20identity, where %20 is a space.Ī field ID can be used instead of the field name. You may also use the Airtable ENCODE_URL_COMPONENT() function in a formula field. Query strings don’t support many characters like spaces or commas so you need to URL encode fields and values when they contain those special characters. Our filter has two rules:įiltering condition rules are written in the format filterxxxx_ with your own field and value. We’ll be building a share URL filter for this share:, one that represents that “The Category field equals Brand identity and the Project lead field contains Cameron Toth”. To build a filtering condition, first, think about what you want to express in words. You can also use Airtable formulas to help construct a query string.
Airtable formulas remove special characters how to#
Query strings are a developer feature of websites, but in this article we’ll explain how to use them. To add filtering conditions you need to add to the query string of a URL. In those cases, you might create a view in Airtable for each person and generate a share view link matching each person or consider using Interface Designer to share data with more granular permissions set. This feature does not limit what data is loaded, instead, it loads the entire original shared view, and then applies additional filtering conditions to it. Users can easily remove this condition in the "Filters" menu, so you shouldn’t use this feature to hide private data. For example, the URL will take you to a shared view where a condition is showing just the records where the “Category” field is “Brand identity”. We are currently rolling out new filter operators to have more options when constructing encoded share view URLs.Īfter creating a share for your view you can add more filtering conditions to your records in the URL. At the moment, some functionality listed in the article below is not available to all customers.
0 kommentar(er)
