#Airtable form view filter how to
#Airtable form view filter free

For example, text fields will have filter operators like 'contains,' 'does not contain,' 'is empty,' or 'is not empty' number fields will have filter operators like 'is greater than' or 'is less than.' Which filter operators are available is determined by the field type.An operator - After selecting a field, choose an operator from the pre-populated dropdown menu.You can create a condition to filter out records within the view you are currently viewing.Ī condition reads much like a sentence the example above can be read as: 'Show me the records where the DRI is Jordan Peretz.'

#Airtable form view filter free

For this guide, we will be using the 'Product catalog' template please feel free to create a copy of the base if you'd like to follow along! Conditions

#Airtable form view filter how to

One great example of how to use conditions is to archive old projects that are no longer relevant. You need to prevent people from seeing certain records in a view share link.You only need to focus on records that meet certain conditions (e.g., the records that have been assigned to me AND have not been marked as completed).You're trying to find a record or records that meet certain conditions quickly (e.g., records that have a due date after X date and before Y date).OverviewĪ condition is a rule you set that records must follow to be visible in that particular view. We also recommend reading the support article on advanced filtering to fullycustomize how your records are filtered by utilizing condition groups. This article will go over the basics of working with conditions.

When a record is filtered out based on a condition, it is not deleted-it's just hidden from the particular view you're using to look at your table. Var select = document.querySelector('#emoji_choice') įorm.One of the core features of views is the ability to filter out records from a view according to conditions you set. var form = document.querySelector('#voting-form') We’ll use Axios here, since it’s a nice dependancy-free Ajax library. Let’s POST the data, directly through JavaScript, via Ajax. When the user submits our form, let’s create a new entry in our database (Airtable spreadsheet). How about a form where you vote for a favorite emoji: A poll is a basic example of something we can design and build, and needs a database to be useful. We’re front end developers, so let’s build something functional. You get great JSON API’s for all the CRUD actions: Create, Read, Update, Delete. You can now not only view this data in Airtable’s nice UI, but programmatically access it. Then each row in the spreadsheet is an entry in the database. Those would be four columns in the spreadsheet: name (string), complete (checkbox/boolean), category (multi-select), photos (files). You’d want to store things like the name of the project, whether it’s complete or not, the category of project, and some photos. Imagine building “Project Progress Tracker”. This is what I want out of a data storage system.”Īirtable lets you build spreadsheets. For the first time, I felt like: “This is a database for me. I came across Airtable at a recent hackathon-esque event, when a fellow developer suggested we use it as a way to store and use our data.