Ask the Community

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:  

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 than MailChimp, please let me know. p.p.s. As of today’s writing, Outfunnel can do most but not all of this (like adding un/subscribes to Airta

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 How can I insert the result of this formula in the Attachment field? Can I somehow receive other info about a video by the link or video ID? (I understand that is another question and big topic, but maybe you have some useful links to read) Thanx!

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 completed (Copy Creation, Brand Review, Registration Page Live, etc.) Each task has its own start date and end date specific to that event's timeline I don't want to manually create 27 tasks every time you start a new webinar Ideally every time I

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

Hello everyone,Does anybody know a good resource or place where I can find examples of professionally built Airtables across various industries, preferably ones that I can interact with and explore?I feel like seeing examples of what other people have done will help me become a better builder and guide my own future designs. Thanks!

Recently I have noticed that the more compact menu that is displayed when a record is clicked in calendar view seems to have reduced functionality. Specifically, I can no longer edit fields from that menu and ‘multiple select’ fields seem to not allow for options being chosen from that menu anymore. However, when you click to expand that record view, everything works as its supposed to. The photo I have attached points out what I am referring to.   I have tried this with multiple records, newly created records, different fields, and I have already closed and reopened Airtable. Any help or insight is greatly appreciated!

Hi Guys,Our staff submit invoices to airtable page and Airtable generate the form with Xero id however currently Xero submission Id is empty hence please guide us how to sync the data connects with Xero.If there is no direct connection/integration we can find with Xero and Airtable please guide steps to fix it.ThanksRegards,Being

Can someone please let us know What is the status of CORS support for Oauth 2.0. In documentation it says development is in progress. By what time will this support be available?https://airtable.com/developers/web/api/oauth-reference#cross-origin-resource-sharing-cors

Hello community,I’d like to clean up our database a bit — especially fields and formulas that were created through “trial and error” and are no longer really needed.What’s the best way to check whether a field in the database is truly not being used anywhere? Do you have any tips or best practices so I don’t accidentally break something?

Is there a way to prevent people from making edits, or self-upgrading their account from a Viewer to an Editor? I am on Enterprise Scale and constantly have to check to make sure people arent self-upgrading to Editor and thus taking away seats, or using seats we do not have available.One solution I found was to make everyone only an editor, but then they cant configure or modify the base which means I, or my team, would have to configure their base for them which we cannot support. Has anyone here found a solution for this? Seems kind of silly that there isnt a setting within the Admin panel to prevent this from happening.

In Airtable, my base contains tables named "People" and "Events". Multiple people can participate in multiple events and share specific types of relationships as a consequence. For instance, Person 1 (Charles) and Person 2 (Amy) can both participate in an Event named "Marriage of Charles and Amy", forming a specific type of relationship (spouses) as a consequence, so that Charles is "spouse of" Amy and Amy is "spouse of" Charles. Likewise, birth events create "parent of" and "child of" relationships, and so on. Using a junction table, what would be the best method to illustrate the types of relationships multiple people can share as a consequence of participating in specific events?

Hi All. I have a problem that I hope is just a result of me missing something simple. I have an automation creating Outlook events from a list of Airtable holidays and birthdays. The “create” automations work fine. I was also able to capture the Event IDs from the Outlook events in the corresponding record in Airtable. Now I’m trying to generate a second automation for record updates using the event IDs and am running into an issue. When I input the data, the “Event ID” field shows up in the “Calendar” field, and the Event ID field is blank, so the automation won’t run. Photo included. Any ideas?  

Hi all. Fairly a newby (but just got my builder certification🤗) so bear with me!My supervisor developed a fairly complicated base that uses, among many other things, user and user attribute tables. To make user attributes dynamically editable by type (income, demographics, etc) in a Softr interface, he made each type its own linked record field on the user. So while the user has all of these linked attributes, they are linked records split across many fields (think Attributes (work experience), attributes (race), etc.)We’re now trying to clean up this base and reunify them in one linked attributes field, but there are so many linked fields at play that it’s a bit intimidating to get started. What’s the safest route here? Working in sandbox :)

Hi all, is there a way to integrate QuickBooks Online Plus with my Airtable workspace and bases? If there isnt already an existing integration, how do you get around it to sync with each other?

We have recently experienced some issues with read-only share links access.  It appears a user must have an account in Airtable to access a read-only share link.  Is this the case?

Hi everyone,I'm helping out with the technical logistics of an in-person event. I've set up a contact database as a Base and configured an automation that triggers an email to send when the record's status updates from "pending" to "invited." The automation includes a prefilled link to Typeform which is generated from a formula (and that in turn syncs back to the base). Happily, all these aspects work fine 🙂The only unexpected hitch I've encountered is that the automation seems to have trouble passing well-formed HTML over to the sender (in this case Google Workspace. I would use the built-in automation but want the emails to come from an owned URL).If I use very basic HTML like this the automation will render properly:But image tags simply refuse to pass (I tried scrubbing the HTML elements that might have caused compatibility issues with Google to no avail). If I pop in a designed HTML template with inline CSS ... nothing renders.I see that this has been discussed before