Adding and removing conditions from a condition group Meaning that each condition group can use either “And” or “Or,” but not both. Though three levels are the maximum depth level possible, you can still achieve complex and precise filtering by combining conjunctions with multiple levels of condition groups:Įach level of a condition group can have multiple conditions, but only a single conjunction. You cannot nest a group any deeper than the third level, as is represented in the greyed out option in the below image: You can nest condition groups for a maximum depth of three levels: This will create a nested condition group on the third level. The second way to create a new condition group is from within a second level nested condition group: This will add an additional condition group nested within the first level condition group we’ve been using up to this point: The first way is from the first level condition group, by clicking on the “Add condition group” button: There are two ways to create a new condition group. Advanced filtering is a feature with a delightfully mix-and-match feel that is best learned by doing. We strongly recommend playing with conditional groups as you read along. For example, we can create a rule to “Show chairs, AND those chairs must be in stock OR show furniture made of reclaimed wood”: Now the sky's the limit, and advanced filtering really takes off and flies.Ĭombining conditional groups allows you to start building more and more complex filters. Now let's expand on this concept: You can use conjunctions to combine and connect condition groups nested within other condition groups. In this article,we created a new condition group whenever we joined multiple conditions together using either of the two logical conjunctions (“And” & “Or”). So, to recap: a condition group is a combination of conditions connected together with a conjunction. This article will cover how to use conjunctions to logically connect condition groups with other condition groups. A condition group is a group of conditions connected logically together with a conjunction ( "And" & "Or" ). You can create a condition to filter out records within the view you are currently viewing. 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! Overview ![]() If you are unfamiliar with the basics of creating conditions to filter through your records, we recommend first reviewing this article. ![]() To be efficient, you need the ability to filter out irrelevant information-so you can focus on the task at hand.Īirtable is excited to announce the experience of filtering records is now better than ever, with the introduction of advanced filtering with conditions! With advanced filtering, you can create and combine condition groups to deeply customize how your records are filtered, allowing you to create highly specific and organized views for your workflows. However, Zapier appears to be seeing the commas and using them to break apart individual responses into smaller pieces that then get entered into Airtable incorrectly.įor example, if someone writes in “Planes, trains, and automobiles” into the “Other - write in” option of a checkbox question, instead of the response “Other - write in, Planes, trains, and automobiles” getting piped into Airtable as a complete, single response, it instead gets piped in as “Other - write in” “Planes” “trains” “and automobiles” all as different individual entries within the same cell.Īs you can imagine, breaking apart the responses like this is causing a lot of problems in being able to read and filter responses in Airtable, and is creating a bloated list of options within a given multi-select field.Nowadays, it’s easy to get flooded with too much information, making it hard to know what’s important. Commas are often included in these write-in fields, either by survey respondents or by Alchemer in how it formats data. My survey makes heavy use of ‘Other - write in’ fields, especially in the context of multi-select (checkbox) questions. To help with filtering in Airtable, I match each question type to the corresponding field/column type in Airtable so a likert scale (or other radio button question) is mapped to a single-select field, a checkbox question is mapped to a multi-select field/column, and open-text questions are mapped to single/long text field/column types. ![]() I’m using Zapier to send survey responses from Alchemer to Airtable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |