Ask the Community

I’m trying to work out if I can create an automation to do multiple tasks or if they all have to be separate (which might max out my allowance)…I have a table which tracks my book contracts. Each contract may have up to 5 titles on it and each title could be produced in up to 6 editions.  I’d like an automation that creates a record in my edition table for each planned edition…So,Test title 1 HardbackTest tile 1 PaperbacketcI can get this to work if each automation is separate but feel like there should be a way to group it somehow. However, at the moment when I try to create a chain it comes up as ‘otherwise’ so it doesn’t run the paperback if there is a hardback. What am I missing? 

Hey Airtable fam,I'm trying to build a deal flow CRM in Airtable, and I'm looking for a way to automatically pull investor data from Pitchbook into my base. I'm currently doing it manually but it drains my time.I'm wondering if anyone has found a good way to automate this process. I've been looking at a tool called the Pitchbook Investors Scraper on Apify, which seems like it could work, but I'm curious if there are any other solutions out there.I'd love to hear how you're using Airtable to manage your deal flow and any tips you have for automating the data entry process. Thanks!

Hello all,I'm working on an automation that was working prior. Now when i changed fields on other tables (added lookups and notes that are not in automation) that were affecting it stopped working.I was working on a backup and I restored it back to normal and still not working.After running some test I see that the first step that is create record its not populating, therefore when I link back to that record it doesn't recognize it. None of those fields were changed but I did add lookups to that table and deleted a few fields that weren't necessary.I went back to revision history to see if I'm missing something but everything seems to be the same and now I cant link records. don't know what to do.Also the webpage asked me to refresh several times.The testing was working on the main CRM and when it stopped working on the backup it stopped working on the main as well (where I wasn't working at the moment)

I’ve built a database of grants and funding opportunities, and a survey that asks users the questions to determine their eligibility for the various grants. I have a table that lists the grants and how the various questions have to be answered to determine eligibility. I’d like to create a table that populates which grants a survey respondent is eligible for when a survey response is submitted. How would I go about doing that? My first thought is that it would be a formula, ie if Survey Q1=X, Survey Q2= Y and Survey Q3 = Z, Awesome Grant = Eligible, Awesome Grant = Not Eligible. But Airtable doesn’t allow formulas across tables. Then I thought an automation, or a junction table, but neither of these seem to be the answer when I dig deeper. So, rather than struggle for another couple of days, help?

Hi everyone,What are the recommended best practices for sharing complex Airtable bases with multiple stakeholders while maintaining data integrity, permission control, and performance—especially when using linked records and automations?Thanks in advance.

After extensive searching, I’ve confirmed that rollup functions do not support finding the mode of the values in the rollup field. I can’t be the only person who has come across this need, so I’d love to know what methods are available without using a 3rd party app. I’m not opposed to an automation, but would rather it be as simple and without the need for scripting if possible.

Should i sort it in  notion?] 

I would love to sync Airtable and ChatGPT w/ the new integration but I can’t find any details on security for this and how data is used. Any one able to give insight?

I have list of keywords and URLs. I want script, once in a month, go through those URLs and find if that keyword is still on that URL. Based on result, update field with the status, Exist / DoesNotExist I want to track my backlinks for SEO purpose, they are still live or removed. Any ideas?

Hi Dear Communauty, Facing a small challenge with my apps actually i need to create a recipe directly but i have to do it into 2 steps as I have diffrents tables and really dont know how to solve itif somebody can help to fix it i will more than happy Thanks 

I am going around and around a lot on this problem and still trying to fin. d the right way to go.I have a table of invoices. The invoices are numbered sequentially. Right now I have to enter each invoice number by hand after checking a summary table I made that lists the latest invoice number used +1 from a formula.I would like to have the “latest number used +1” inserted into the invoice number field of the new invoice being created. I imagine that it I not as hard was I am making it. I will tell you that I am TERRIBLE at automations. I find them unintuitive and frustrating. It’s probably me.But I am guessing that an automation is what I need..So invoice table is “Invoices: House” and summary table is “Invoice: Next invoice Number”. The summary invoice numbers in the “Invoice: Next invoice Number” table are in a rollup field and the Invoice Numbers in the “Invoices: House” field is a numbers field if that matters.Any help is appreciated.Be

I’m trying to create a form with múltiple tables, I have a table “Responses” that contains fields directly linked to the form, and i have a table “Sectors”, representing the sector that corresponds to that specific response (I have multiple other tables, but it’s not particularly relevant for this question”)When I want to manually add a Sector to a Response, it shows all responses and fields linked to this Sector (image for reference). I would like to know if its posible to just have the name showing, just like if it was a multiple selection field.Disclaimer: I cant use third party options like fillout. Currently:What i want:  

I have a list of names in the format John Smith MD or John Smith, MD (some with commas, some without) and I’d like them to be in the format Dr. Smith. Is there a formula that can do that for me?

When I use the search extension in Airtable, it works well for finding a record. However, when I click on a record, it shows me the fields, but I would like to be able to edit them. I have a view that is very well organized, and I was hoping to see the record displayed according to that field arrangement, but unfortunately, I haven't found a way to do this.My goal is to quickly search for a record and, upon clicking it, display the specific information I need. So far, I haven't been able to organize the displayed information in the way I want.

I’m looking for help with integrations: My nonprofit uses Airtable heavily to track lists of people and their contact information. We also use MailChimp to send out updates to our partners, newsletter subscribers, etc. using that contact information. My question is this: Is there a simple way to establish a “Two-Way Sync” between Airtable and MailChimp so that they will always contain the same data, regardless of changes made on either side? I need a true “sync” that will: Update MailChimp with any changes entered in Airtable (add, remove, edit), and Update Airtable with any changes entered in MailChimp (subscribe, remove, edit). I’d rather pay a small fee per month for an established app to do this than build it in Zapier/Make, but either way is fine if it works. TIA, M p.s. If you know of a fix for this with an email marketing program other tha

I have 3 tabs. Tabs 1 and 2 are two batches of records. How do I select records from tab 1 and 2 where status is x, to populate tab 3. Then when I update a record in tab 3, I want the original record fields in tab 1 or 2 updated with status or other field updates and comments in the record in tab 3. 

Hi! I’m creating a base of videos from youtube. I have an attachment column in my base and I want to put there video thumbnail. All thumbnails have the same link but with different ID. For example: Link: https://www.youtube.com/watch?v=pAl9SayLzTE ID: pAl9SayLzTE Thumbnail link: https://i.ytimg.com/vi/pAl9SayLzTE/maxresdefault.jpg Questions: Is there a formula that will create a link to thumbnail with a known ID from another cell? So I need some formula that will insert ID in a template https://i.ytimg.com/vi/XXXXXXX/maxresdefault.jpg instead of XXXXXXX

Buenos dias He borrado una base por error. Manera de recuperarla???? Gracias

Team, subscribed to Airtable a month back. Created a workspace called “Rohit”, created two bases - “Sales Pipeline” and “Open item tracker”. Now Sales Pipeline base is completely gone. Can’t find anything. Was working on other things like importing data, building AI etc for a large excel database i have. But pls advise how can i retrieve my base “Sales Pipeline”

Was adding leads to a dbase and chugging along. Next thing I know, AirTable stops accepting any inputs. Checked my wifi, logged out and back in. Anyone have a similar issue? Any suggestions, tips or hints would be welcomed.  

I’m working on an interface that is all connected to Property Projects through the Record Picker. I’m trying to create elements that pull data from the subject property through the Record Picker. For example, I’m creating a Comps element. However, I need the comps to pull only from the Property selected in the Record Picker. It’s prompting me to create a condition, however, I don’t have the Record Picker as an option. What am I doing wrong? Thank you in advance! 

Dear community,In the company I work for, we have a base which contains a lot of sensitive data about clients. We are currently on the Team plan. I noticed that there is no inactivity log out in Airtable. The only safety measure I could potentially take is 2FA. Although, preferrably I would have 2FA, a inactivity log out and something that makes it only possible for colleagues to log-in when they are on their work MS365 account.I see this last thing is possible with SSO, but that's only applicable for business. Since we are a foundation, that is hard to afford for about 20 employees. I hope someone in the community can help us with this security issueThanks a lot,Sid

ContextI have my base created, and my main table is named the “Event Plan”, within this table, each row is the record (event name).In the second table, called my “tasks” lists all the tasks that an event requires. The Problem I’m FacingRight now, my airtable reuses the same task records across multiple events. So I have ONE "Copy Creation" task that links to all the events (because each event has this task). But this creates an impossible situation: that one task can only have ONE start date and ONE end date, even though the events run on completely different schedules. Your GoalI want to create an Airtable where:Each record/event in the table is a separate project with its own timeline Every record/event has the same 27 tasks that need to be co

Hi, I’m new to Airtable and have been working on this for 24 hours straight. I tried hard to find a Discord server for it, but sadly, there isn’t one.The main point is: I want to display a single piece of data alongside a bar chart in the interface. I keep getting confused about how to do it. Even ChatGPT misunderstands the issue as something related to login and doesn’t provide exact guidance. So, could someone kindly help me with this?

Hello,I’m trying to automate the population of resumes as attachments to a candidate table once a form is submitted.  I’m having trouble getting the resume file to attach to the resume field.  When I do it like this (within a loop through the uploaded resumes), I get an error saying “Invalid String”.  That’s likely because the “ContentReference” is a JSON formatted string.  I don’t see an option to insert the resume file itself, only metadata.  How can I actually auto-insert the resume file itself? Thank you,Robert