![]() To activate Advanced Filter you just need to switch it: Whenever you need to search for one or more than one record, the Airtable block offers you 2 options to "filter" those records: with the Basic filter or the Advanced Filter.įor some use cases, the basic filter would be enough, but if you want to set up specific conditions or more than one element to filter, Advanced Filters is the best option. Search an event that is after/before today or a certain day Search for records that a specific field is empty Search filter by more than X days from Today Search for 2 conditions (less than and text) ![]() Search filter numeric value bigger than X Search filter "contains" value in cell/column Set a timer to get the time spent during the flow Launching a bot depending on browser language ![]() Resume flow based on external process with Landbot API (Request, Set, Go) Generate a URL that has variables from user answers How to pass WordPress logged in user data to LandbotĬreate Dynamic Shopping Cart with JS and CSS ![]() Trigger a Global Keyword with JS (web v3)Ĭreate a Scale out of Buttons - Workaround Set the flow depending on the url path (for embedded landbots) Trigger Event if User Abandons Chat Using AWSĭisplay Bot During Business Hours Only (Livechat & Popup)Ĭookie consent banner (full page / full page embed)Īdd Captcha Verification (Non-Embedded Bots) How to not display Proactive Message to repeating Visitors Trigger Event if User Abandons Chat (For Non Developers) I’m looking to create a template as I will have 4 similar events each year, so it’d be helpful to be able to put the event date and those tasks will automatically fill in their start date.Create a Chat Transcript Variable with Pipedream (web bots)Ĭonditional Welcome: Direct the Flow of Your Bot Based on External Parameters Is there a formula that I can use in the formula column that will put a correct date in the formula field based on whether the task is a months, weeks or days task? 4) and for the weeks or days tasks I have it listed with # Weeks (IE 2 Weeks, 2 Days). In the column - right now- I have a whole number if it’s for months (ie. Project Start (Months/Weeks/Days Out) is the column that has the # of Months/Weeks/Days out we need to start working on the task. ![]() I’m using this formula in the column (the DATE and Project Start are the columns I’m having it pull data from): DATEADD(Date,-,‘months’)ĭate is pulling from the Date column that i have the first day of the event in. those that needed to be start 2 weeks out, etc. I had to go in each cell to change the formula for the specific task for those that were 1+ months out vs. In my google form/excel sheet I have formulas created so that all I have to do is put in the first day of the actual event into a column, and then another column has the # of months, days or weeks out that we need to start working on that particular task for the event. I’m putting together a checklist for a large event that has due dates- start and end dates included in the table. I’m a complete newb to airtable, so I’m still learning the intricacies to see if it’s something I can use in my role. I know Airtable is not a “spreadsheet” and that typically you cannot use different formulas per row/cell because of the database situation. I’m trying to see if there’s a way I can do this. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |