- Getting started with Airtable
- Introduction to Airtable basics
- Contacting Airtable Support Updated
- Airtable home screen
- Glossary of Airtable terminology
- Airtable technical requirements
- Feature differences between Airtable on desktop and mobile
- Airtable keyboard shortcuts
- Using Markdown in Airtable
- Adding descriptions in Airtable
- Finding Airtable IDs
- Airtable Automations
- Automations Overview
- Automation feature walkthroughs
- Integrated automation walkthroughs
- Airtable automation walkthroughs
- Linking existing records using automations
- Conditional groups of automation actions
- Repeating groups of Airtable automation actions
- Creating recurring records using automations
- How to delay Airtable automation runs
- Prevent automations from triggering by mistake
- Use automations to timestamp status updates
- Automation Triggers
- Airtable Triggers
- Airtable automation trigger: When record matches conditions
- Airtable automation trigger: When a form is submitted
- Airtable automation trigger: When record created
- Airtable automation trigger: When record updated
- Airtable automation trigger: When record enters view
- Airtable automation trigger: At scheduled time
- Airtable automation trigger: When webhook received
- Airtable automation trigger: When a button is clicked
- Airtable automation trigger: When email received Updated
- Integrated Triggers
- Airtable Triggers
- Automation Actions
- Airtable Actions
- Airtable automation action: Send email Updated
- Airtable automation action: Create record
- Airtable automation action: Update record
- Airtable automation action: Find records
- Airtable automation action: Sort list
- Airtable automation action: Run a script Updated
- Airtable automation action: Generate with AI
- Integrated Actions
- Airtable automation actions: Slack
- Airtable automation actions: Google Workspace
- Airtable automation action: Send MS Teams message
- Airtable automation actions: Outlook
- Airtable automation actions: Jira Cloud
- Airtable automation actions: Jira Server / Data Center
- Airtable automation actions: Salesforce
- Airtable automation action: Create post in Facebook Pages
- Airtable automation actions: GitHub Issues
- Airtable automation action: Hootsuite post
- Airtable automation action: Send Twilio SMS
- Airtable Actions
- Airtable Bases
- Using Airtable Cobuilder
- Airtable bases overview
- Creating and managing Airtable bases
- Structuring bases in Airtable
- Moving bases between workspaces in Airtable
- Creating and managing tables in Airtable
- Creating Airtable base share links
- Importing third-party data into Airtable
- Using insights in Airtable
- Troubleshooting Airtable base performance
- Airtable Betas
- Collaborating in Airtable
- Airtable Enterprise Support
- General Enterprise information
- External badging in Airtable
- Using app library and components in Airtable Updated
- Ask an Expert beta overview
- European data residency at Airtable
- Airtable user groups overview
- Airtable Enterprise API
- Creating and managing data retention policies in Airtable
- eDiscovery APIs in Airtable
- Airtable and data loss prevention
- Accessing Enterprise audit logs in Airtable
- Set up Jira Server / Data Center to connect with Airtable
- Admin panel pages
- Airtable admin panel overview
- Users - Airtable enterprise admin panel
- Airtable admin panel user details
- Groups - Airtable admin panel
- Workspaces - Airtable Enterprise Admin Panel
- Bases - Airtable admin panel
- Interfaces - Airtable admin panel
- Data sets - Airtable admin panel
- Managed apps - Airtable admin panel
- Components - Airtable admin panel
- Reports - Airtable admin panel
- Settings - Airtable admin panel Updated
- Managing Enterprise organizations
- Managing Enterprise admins in admin panel
- Using Organizations
- Organization branding for apps in Airtable
- Enterprise Hub in Airtable
- Enterprise Hub: Org unit assignment with user groups Updated
- Deactivating, removing access, and reactivating users in the admin panel
- Managing user access to workspaces and bases
- Airtable Enterprise Key Management Updated
- Custom terms of use New
- Enterprise SSO
- General Enterprise information
- Airtable Extensions
- Airtable Fields
- Fields Overview
- Attachment
- Date-based fields
- Formula
- Getting Started with Formulas
- Formula Foundations
- The essentials of Airtable formulas
- Formula writing tips for beginners
- Troubleshooting formulas
- Basic calculations
- Conditional statements
- Logical arguments
- Working with dates
- Displaying DATETIME_FORMAT using the date field in Airtable
- Working with date functions in Airtable
- Calculating the difference between dates in Airtable
- Supported DATETIME_DIFF unit specifiers in Airtable
- Supported DATETIME_FORMAT format specifiers in Airtable
- Using the DATETIME_PARSE() formula in Airtable
- Working with timezones
- Record functions
- Text functions
- Numeric functions
- Common Solutions: Beginner
- Common Solutions: Intermediate
- Common Solutions: Advanced
- Long Text Field
- Linked Record Field
- Linking records in Airtable
- Limiting linked record selection to a view in Airtable
- Dynamic filtering in linked record fields
- Linking to one, many, or a subset of Airtable records
- Converting existing fields to Airtable linked records
- Reordering record links in Airtable
- Understanding linked record relationships in Airtable
- Number-Based Fields
- Other Fields
- Rollup, lookup, and count fields
- Select and user fields
- Integrating with Airtable
- API
- Getting started with Airtable's Web API
- Creating personal access tokens
- Airtable Webhooks API Overview
- Service accounts overview
- Airtable Web API - Using filterByFormula or sort parameters
- Airtable API Deprecation Guidelines
- Airtable API: Common troubleshooting
- Managing API call limits in Airtable
- URL length limitations for web API requests
- Integration services
- Third-party integrations via OAuth overview
- Troubleshooting disconnected OAuth integrations in Airtable
- Options for integrating with Airtable
- Third-party integrations - Common troubleshooting
- Low-code integrations - Common troubleshooting
- Integrating Airtable with external calendar applications
- Visualizing records from Airtable in Tableau
- Visualizing Airtable records in Microsoft Power BI & Power Query
- Integrating HubSpot with Airtable
- Using Zapier to integrate Airtable with other services
- Using Zapier's Multi-Step Zaps to find and update records
- Using IFTTT to integrate Airtable with other services
- Integrating with AWS Lambda & DynamoDB
- Developer tools
- API
- Airtable Interface Designer
- Interface Designer overview articles
- Interface layouts
- Interface elements
- Adding and removing elements in interfaces
- Adding layouts to interfaces
- Formatting elements in interfaces
- Interface element: Button
- Interface element: Calendar
- Interface element: Chart
- Interface element: Filter
- Interface element: Gallery
- Interface element: Grid
- Interface element: Kanban
- Interface element: Number
- Interface element: Record picker
- Interface element: Text
- Interface element: Timeline
- Learning and Resources
- Managing Airtable
- Airtable Policy
- Airtable Records
- Airtable Sync
- Airtable Views
- Airtable Workspaces
- Print
- Share
- DarkLight
- PDF
All plan types | |
| |
Platform(s) | Web/Browser, Mac app, Windows app, and mobile apps |
Understanding and using shared view URL filters
After creating a share for your view you can add filtering conditions in the URL that will determine which to records will be revealed when the view is loaded on a browser.
For example, the URL https://airtable.com/shrsa57bWpEecPtzp?filter_Category=Industrial%20design
will take you to a shared view where a condition is showing just the records where the “Category” field is “Brand identity”.
Common considerations
Users can easily remove this condition in the "Filters" menu, so you shouldn’t use this feature to hide private data.
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.
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.
Inputting a URL filter
To add filtering conditions you need to add to the query string of a URL. Query strings are a developer feature of websites, but in this article we’ll explain how to use them. You can also use Airtable formulas to help construct a query string.
To build a filtering condition, first, think about what you want to express in words. We’ll be building a share URL filter for this share: https://airtable.com/shrsa57bWpEecPtzp
, one that represents that “The Category field equals Brand identity and the Project lead field contains Cameron Toth”. Our filter has two rules:
Category equals Brand identity
Project lead contains Cameron Toth
Filtering condition rules are written in the format filterxxxx_{Field}={Value}
where you replace {Field}
and {Value}
with your own field and value. 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. You may also use the Airtable ENCODE_URL_COMPONENT() function in a formula field. 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.
Note
A field ID can be used instead of the field name. Field IDs are available through our API, or through the Field Manager (paid plans only).
Back to the task at hand. 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
. Our second rule would be filterContains_Project%20lead=Cameron%20Toth
because both “Project lead” and “Cameron Toth” have a space in them.
To combine the filter rules into a query string you use the
&
symbol. For examplefilter_Category=Brand%20identity&filterContains_Project%20lead=Cameron%20Toth
.Then take your share URL, which in our case is:
https://airtable.com/shrsa57bWpEecPtzp
, and add a question mark (?
) followed by your query string.So, our final URL with our filtering conditions would be
https://airtable.com/shrsa57bWpEecPtzp?filterEquals_Category=Brand%20identity&filterContains>_Project%20lead=Cameron%20Toth
.If your URL has a question mark already then that means it already has a query string. Make sure to remove the existing query string from your URL before adding a new one.
Supported URL filter operators
Note
Using the generic
filter_
operator will typically yield the same result as thefilterEquals_
operator's output. However, by usingfilter_
Airtable will do its best to choose a filter that makes sense for the field you are filtering values by. For example, in multiple select fields, thefilter_
operator would function more like thefilterHasAnyOf_
operator. 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.
The following filter operators can be used when constructing a custom share view URL:
filter_
filterEquals_
filterNotEquals_
filterContains_
filterNotContains_
filterGreater_
filterGreaterOrEqual_
filterLess_
filterLessOrEqual_
filterIsAnyOf_
filterIsNoneOf_
filterHasAnyOf_
filterHasAllOf_
filterEmpty_
filterNotEmpty_
Using the "Or" operator between filters
When creating an encoded URL you will use the & symbol to combine multiple filters together as outlined in the example above. However, there may be times when you would rather filter records with the "Or" conjunction rather than the "And" conjunction. In these cases, you'll add the string &filterConjunction=or
to the end of the encoded URL. So, using our use case above:
If we modified the URL to be:
https://airtable.com/shrsa57bWpEecPtzp?filterEquals_Category=Brand%20identity&filterContains_Project%20lead=Cameron%20Toth&filterConjunction=or
Then, any records in the view equaling "Brand identity" in the category field or containing "Cameron Toth" in the Project lead field would be shown.
In this way, each And conjunction in the resulting URL is modified to be an Or conjunction instead.
Note
Using the
filterConjunction=or
string in an encoded URL is all or nothing. This means that there is no way to create a mix of And and Or conjunctions between filters.
FAQs
What kind of views support shared view URLs?
URL filters can be applied to Grid, Calendar, Gallery, Gantt, Timeline, and Kanban view shares.
I want to create a view to share with multiple people, but I want to filter the view for each person so they can't see the other people's records. Can I use shared view URL filters for that?
URL filters can be removed by anyone you send the link to so you shouldn’t use this feature to hide private data. In those cases, you might create a view in Airtable for each person and generate a share link for each group or consider using Interface Designer.
I'm stuck, where can I find help?
If you’re having trouble there are developers/experts who can sometimes help on our Community Forum.