Solved

Hi everyone! I am almost done, I just need your help with the last part! I have a Zap that creates an email draft that sends an invoice when in a certain view. I initiate the process by checking an airtable checkmark, which then applied the invoice to the needed view. Sweet! AND it’s making the draft email just like I want! Heck yeah!!! Now, what I want it to do is delay for one minute (no problem) and then update the record that just triggered it by checking a checkbox. Is there a way to easily do this by referencing the record that triggered the whole thing? (This will then remove it from the view, per filter instructions) Thank you so much for any help!

I manage base full of events that can be displayed as a grid or calendar Each event at least 1 tag (for example: event-movie tag-fun, event-yoga tag-sports) I’m looking to create a few different iCal links from this base Each link will subscribe to events contain only one tag For example: iCal link that shows only sports events Can it be done? any recommendations?

I’m trying to use the Airtable JS library to pull a list of records filtered by a Linked Record field, and although I can verify the data from a certain record by pulling by ID, I cannot filterByFormula for this particular record using a Linked Record field where multiple records are linked. I’ve also just went straight to postman to ensure it wasn’t the JS library but in fact the API itself. I found an answer here on how to use filterByFormula with Linked Record fields, however the solution is not working although I’ve followed it to the T: https://community.airtable.com/t/filterbyformula-multiple-select/2075/8. It actually works with Linked Record fields that are 1:1 and not when 1:many. Please see my description of the problem here: filterByFormula option does not work when used for the following scenario (filtering on Linked Record field with multiple records): Tables: Albums, Songs, Categories Albums have a Linked Record field for Categories Songs have a Linked Record field for a

Hello all, This is my first post to the community. I’ve seen other posts similar to this topic, but they don’t quite address what I’m trying to achieve. I’m having an issue with a nested IF statement and not sure whether a combination SWITCH/IF would be best for this formula. I have two columns - column 1 (Date) and column 2 (Location) that is single select. I want a third column (Status) that returns a value based on what is populated in the first two. Logical Argument 1: If column 1 (Date) is not blank OR column 2 (Location) is ‘Outside Area’, the Status column should return “Yes”. Logical Argument 2: If column 1 (Date) is blank the Status column should return “No”. Any help would be greatly appreciated. @Jeremy_Oglesby

Following is how a formatted SendGrid email message appears in email. {Current Date} Friends of Niños Adelante, Inc. PO Box 1624 Sonoma, CA 95476-1624 Alejandra & Todd Hinkie 46 villiage Way PMB 167 Port Ludlow, WA 98365 USA Dear Alejandra & Todd, Little did we realize when we welcomed the first few students into the college beca program for the 2005-06 school year that we would be supporting 100 students in college by the fall of 2020. Thank you for your involvement and dollars which are truly making a difference in the lives of many in Zihuatanejo young people. Each year Friends of Niños Adelante utilizes general funds to cover students whose sponsors are unable to meet the total beca amount or have had to drop out of the program (approximately $10,000 this year). Our commitment, of course, is to provide full becas for all students who qualify. Since all the contributions for becas from our sponsors go to the kids, we need to be able to have funds for special needs situations

Greetings, Airtable Experts! Our small team is currently using both Todoist and Airtable to track our tasks :white_check_mark: . Ideally we would like to use Airtable exclusively (one stop shop!), but are finding it very hard to give up an incredibly useful Todoist Feature: the ability to email tasks to a project. You simply copy the link Todoist provides, paste in the TO section of an email, customize the subject line with due date/priority/tags, press send–and presto, there’s a new task in Todoist w/a link to the email. :thinking: Is it possible to accomplish something similar with Zapier/Airtable? I have a clunky work-around, namely saving a PDF of the email, then create the task in Airtable and upload the PDF. Any assistance would be appreciated!

Hello, I have a database that is updated live (through an integration), but some records can go directly to archive (via a filter). I am trying to build a formula that will identify as many archivable records as possible and mark them with :white_check_mark: . Such records would march either of the following criteria: marked (manually) as non-actionable in a multiple-select field type OR contain a certain word in a single line field (e.g., if a single-line cell contains ‘no-reply’ => archive) I already have a formula for the former, but I wonder if a formula that would combine both is possible to build.

Hi Airtable! I have a base that I created in which I will be adding Notes from Apple. There are duplicate records, but there is no key, except for a formula to create different record ID’s. This ID is unique for all records, including duplicates. My question is how do I create a unique key, when each of the fields are not unique in my base. Fields: DATE *these dates are not all different SUBJECT *some are the same NOTES *the titles are either too varied or the same TIME CREATED *some of the same records will have different times FORMULA *creates a different record ID, even if it’s a duplicate Perhaps the formula can be adjusted to create the same ID for all duplicates, based on another field? If so, I don’t quite know how to do that. I have created a share link to my base, I thought it might be easier. I would appreciate any help. Thank you, Mary Kay P.S. For some reason my share link looks like this. If you go to the last record, there’s a link (View larger version) to view the who

Still putting together a Base to track my Fitness Instructor business. I have tables for Client Names, Classes Offered, and an Income table that tracks which clients attended which classes and how much each paid for each class. I also have Assistant Instructors for each class. There is one Assistant in each class I teach, but it can be any of 3 different people. I track who the Assistant was for each class in the Classes Offered table. Assistants are paid a percentage of the total income from that class. Now, with these 3 tables, I’m at a loss to figure out whether or not Airtable is able to track how much each of the instructors is owed (total and per class), and if Airtable can also track my payments to the Assistants, and keep a running balance of each of their “accounts”. I’ve not found any examples of Airtable being used for accounting tasks, so I greatly appreciate any help in determining of Airtable is the right tool for the job; OR if it is, some assistance in designing the Bas

Hi everyone, Looking for a way to do a multi-step filter within AirTable. Here’s an example of the filters I would need: Where Level 3 Org is Org1 OR Where Level 3 Org is Org2 AND Job Family contains Job1 OR Where Level 3 Org is Org3 AND Job Family contains Job2 Is this possible? It looks like no since you cannot nest filters together in that way. I can do these filters in individual views, but I need an aggregated list in the long run. Any thoughts?

I have a unique situation that I couldn’t find an answer to, possibly to my lack of patience. But I am trying to create a pricing sheet of products. I have two manufacturers. I have installer and wholesale accounts that only get a discount on one of the manufacturers’ products. I was trying to come up with a formula that calculated the accounts discount automatically since I change prices every so often, but want it conditional to the one manufacturer it applies to. I need it to be that if the manufacturer cell says SCF, the installer sell is retail * .9, and wholesale is retail*.75 and if the manufacturer cell says Maven, installer and wholesale are both same as retail. Is this possible??? (I tried attaching a screenshot of my table, and it’s not letting me so I’m explaining it as best as I can)

Airtable Masters, I have set up related tables with rollups and lookups in the past, but this problem has me stumped. I am trying to determine a process capacity by looking at each order and determining the number of units due between the current time and the due date of the order. I have read several post where similar questions are asked, but no answers given. Is this even possible with Airtable? Thanks in advance for any ideas!

I have a table where users submit events that happen on a weekly and monthly basis. For example: a yoga class every Saturday at 9am or a group run the first Sunday of every month. I don’t want to add a ton of records of that same event but would like the original date field (Event Date) to be updated so that it populates the next coming date. So process would be: Event is submitted Event Date is populated with first class date ex: 5/20/20 After the first class date passes, it is updated to the next coming date: 5/27/20 Is there a formula that’ll auto-update that Event Date field? Or at least spit out that new date in a new formula field?

Hi all, New to Airtable and by no means a whizz when it comes to formulas. In short, I need to create a formula that will return a date of the 1st day of last month. In other words, today (May 21st), the field should show a date of April 1st 2020. As soon as we hit June, that date should change to May 1st 2020. Any idea how I could do this? Thanks all…

Hello all, I have question regarding a formula for the marking sheet for my university module: I want to compare my students’ final numerical grade (titled ‘total_grade_point’ field in image one) with a range in an adjacent conversion table. The second table contains a numerical range (image two), and I want to get the final string for my student’s grade. Basically, if you follow the images, I want to contrast my students’ grade point with the ranges in the conversion table, and then yield the grade string (zero, low fail, etc.). I hope this is somewhat clear. Thank you all for your help! :pray: Best, Manuel

Hi Just wondering if anyone has an integration for the add table action trigger? I’m using Integromat and that platform doesn’t offer ‘add table’ as a trigger. Airtable’s own Slack notification doesn’t appear to notify of new table actions. Thanks!

Hi! I’m new to AirTable and I’m not very advanced with using functions, but I think I will need to use at least a few to do what I’m trying to do. I currently have a column of what are essentially tags for a given gene’s function, and I’d like to convert them to tags in Airtable by making them each options in a multiple-select field. Is there a way to easily use the semicolons in the text as separators/delimiters to automatically generate the selections and convert the entries as they are to multiple select smoothly? Thanks in advance!

Hi, is there a way to compare strings that include same word(or part of the word), but not the whole phrase?

Hi, I’m trying to implement a very simple scripting block to send a single text message (as opposed to the “Send SMS” block, which we use for batches). Here’s my code, as suggested by Twilio’s API - const phone_number = await input.textAsync('Who are we texting today? (Phone #)'); const message_body = await input.textAsync('What do you wish to say to them?'); const accountSid = <<My Account SID>>; const authToken = <<My Auth Token>>; const client = require('twilio')(accountSid, authToken); client.messages .create({ body: message_body, from: <<My Twilio Number>>, to: phone_number }) .then(message => console.log(message.sid)); But then I get this error - ReferenceError: require is not defined at main on line 6 Any suggestion? Thanks!

Hi everyone, I’m building my CRM and I have two tables, one is the “Account” and the other “Register”. The client fills the form that it’s linked to the “Register” table, the account manager, based on the information provided by the client approves or not the client turning the Checkbox to 1. I want to create a new row for that client in the table “Account” when the account manager change the checkbox to 1. Can you guys help me? Or maybe I am overcomplicating everything. Thank you all! Best, Luis

Hello; I was testing out the maps block but it doesn’t seem show the map in the block on the dashboard, but instead says, “Please make this block bigger or full screen”. It works when fullscreened, but the screenshots / video example in the Map block article show it as being visible straight in the dashboard. Airtable - Support Map block The map block is part of Airtable Blocks, a Pro plan feature. Blocks let you extend the functionality of your bases: you can use blocks to bring new information into Airtable, visualize and summari... Has this changed, or is there something I’m missing somewhere to configure this?

Is there a way to automatically save(/see) who entered data into a base via the web clipper?

Hi! I’m trying to set up a CRM for some of our sales people and I’d like to auto-populate a ‘next step’ due date based on the selection they make for their ‘next step’. For example, if they select their next step as ‘Send follow-up email’, I want the due date to auto-populate for 2 weeks from when they entered the information. Or if they select their next step as ‘Place follow-up phone call’ I want the due date to instead auto-populate as 3 days from when they entered the information. Is this possible at all with a formula or would this require an external zap maybe in Zapier? Thanks in advance!

Several of the community examples in the Script Showcase are just broken links, all pointing to https://community.airtable.com/t/weekend-scripting-block-challenge-and-1-000-prize/28074/5?u=kasra which doesn’t exist. Does anyone know where I can find them? Showcase is here: Airtable Example Script Showcase - Airtable Universe There are tons of ways to use the scripting app, so the Airtable team has collected some of our favorite examples, both internally and from the community, to... thanks, Rory

Hey there, I have created single drop down statuses for my projects I’m working on (In Progress, Not Started, Recently Completed, Roadblocked, and Archived). I’d like to create a formula that says "If the project status is anything other than Archived and Recently Completed, AND has a past Target Completion Date that’s before today, status is: PAST DUE. Otherwise, ON TRACK. Ideally the way I’d like this to show up is to have another column with PAST DUE and ON TRACK options in a single select drop down, and depending on what the formula says, the drop down option changes. Is that possible? Thank you!