Ask the Community

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 :)

Many enterprise security policies require applications to timeout after a period of inactivity. Airtable currently doesn’t provide this functionaly; instead it offers a fixed web session length.Enabling this means Airtable users get logged out in the middle of their work (they could be presenting, in the middle of updating a formula, or deep in analysis). If you’re using the Airtable app and have multiple windows open, all of your Airtable windows close out when you log in again.Please update this feature to align to other SaaS products - thanks!

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 comp

We are stating to use portals - and we have our internal Jira linked with automatic status updates. The external clients with access to the portals want to do the same with their Jiras. Any ideas on how to make this work?

Hi there, I want to send HTML emails from AirTable using the Send Outlook Email action in Automations. I need them to contain embedded images with external links and a call to action button at the bottom. Please can someone tell me if this is possible and if so how?

Hi, I am trying to construct a daily email to summarise data. I have all the data I need, but I cannot get the email to structure correctly. I have used HTML to make a table for the data, but when the email sends the formatting is awful. I’m looking for a way to get the table to display correctly, does anyone have any ideas? Ideally I want the table to sit in the white space with the other text I have attached a copy images to show the issue and what the raw form looks like

Is it true that Airtable is fairly limited in its ability to allow you to use HTML formatting for send email? Is the solution then to have to use SendGrid or another service that could help out with email automation?

Hey everyoneRan into something interesting and not sure what is going on.I have a table called assignment with a Start Date and End Date field that are used for Date dependencies and to calculate duration.I have an Interface button called runs an automation. In that automation is a script that will use the End Date of the record, calculate a new start date (which is one day after the end date) and a new End Date (which is 3 months after the new start date).I have another script later in the automation that will duplicate the record and insert the new start and end date into the Start Date and End Date field for the duplicated assignment.Interestingly, the Duration is not updating when the new dates are added.In the attached image the, the top record is the source and the bottom record was the duplicate created by the script.I created a test formula to calculate the works days to validate what I am seeing. The top record

Hello team, hope you’re doing well.Is there any way to share or extract the schema of an automation in the aim to share with functional people, non technical just to make sure that we are respecting the functional specifications.

I help run a marketing agency and I need to be able to create a table that shows how much each agency member will get to take home each month. There are 2 members that take payouts each month, but at different rates depending on who is the lead (70%) and the support (20%) - the business gets a share as well (10%). These percentages are average, but we do sometimes adjust them. I have a table for the projects which show all live projects. In the project tracker I list each project, the full fee, who is the lead, who is support, the start date /end date and the percentages that each gets. I would like the new table to show month over month, how much each should be getting paid based on all projects which they are staffed on (and the percentage) what they should be paid each month.

Hello,I would like to use Airtable’s Multi-source syncing feature. In the long term, I need to add around fifty bases in one view. I’ve done it with three sources so far, and I’d like to know whether this is possible or if there is a limit to Multi-source syncing.Thank you very much!

Hello!I am currently working on a form and want the ability for individuals to make multiple selections and get specific emails depending on their responses. For instance, we have 3 trainings with their own Zoom calendar invite that individuals can select on the form. Lets say Jane picks Training 1 and Training 3. We have an automation to send Jane an email that contains a Zoom calendar invite for Training 1 but want an automation that will also send her Training 2 in the same email. Is that a possible automation? Or is there a different way to do this? My organization currently cannot connect Zoom to our Airtable so that isn’t a potential solution unfortunately.  Please let me know your thoughts or if you need clarification on anything!

Hi everyone — hoping for some guidance on best practices in Airtable.I have a table with a column that represents a numbered list (1–100). The order matters. When I insert a new record after, say, item #51, I’d like all rows below it to automatically renumber, so the list becomes 1–101 without manually updating each value.In other words: Current state: rows are numbered sequentially Action: insert a new row in the middle Desired result: all following rows shift +1 automatically I’m trying to understand: Whether this can be done natively (formulas, views, sorting, etc.) Or if it requires automations or scripting And what the recommended pattern is for maintaining ordered lists like this in Airtable I’m open to restructu

I have an automation that sends students an email thanking them for being a part of a short-term trip with the school and I was wondering if Airtable or an extension that I do not know of, could track the engagement of the student on if they opened the email, or if they clicked on a link, etc. I want to make sure that the email is the most optimized to get the most survey responses possible!

Hello,I'm building a new business (creating adult study abroad programs, targeted at the US market) and using Airtable for product management and CRM. I had initially planned to use Mailchimp, via a Make integration, for both marketing and transactional emails, but I have hit a wall importing my initial contact list from Airtable into Mailchimp. I am not a developer and Mailchimp support has been confoundingly bad (2 weeks of effective radio silence, then 3 days of denying that their platform integrates with Make), so Mailchimp and I are going to have to part ways.I am looking for recommendations for a marketing email platform that I can integrate with Airtable - either directly or via Make - without needing to code. Does this exist? I have read on other posts here that Sendgrid integrates directly...but I don't know if this is the best solution. Here's what I need:- robust no-code email editor (similar to Mailchimp)- ability to update contact list based

Hi! I need some help, we have a team of people who are linking their gmail accounts so we can send email automations through their personal gmail accounts. I have the automations set up and each team member is going in to link their accounts. Four of the team members were successful, but two people are having issues.The drop down to add their account is not available (greyed out so they can’t click it and add their account). Any ideas on what is going on and how to fix it?

Hi Everyone,I have an idea that I am really struggling with and would appreciate some help. GoalCreate a script/Automation that loops through table 1 to find matching record based on multiple conditions and link those records with table 2.Base structure:ListingListing contains all the properties we have in our portfolio and has various field types. For this specific idea, here are the ones that matter:House_Listing_Price (number)House_Budget_Range (single select)House_ViewType (multiple select)House_bedroom (#)House_land_type (single select)House_property_type (single select)House_region (linked records -> third table containing list of region)OpportunitiesList of all active house searches we have for clients. For this specific idea, here are the ones that matter:

I genuinely for the life of me cannot create a second interface. im on a teams plan thats set to expire in a few months so i did downgrade but should still have benefits from it.I have a table with 23 rows that I want to give to clients. the link and everything works great and they can take all the actions required.Where I’m having issues is when I try to create a second interface, I click new interface and it just adds it as a page. I genuinely do not see a way to create a second interface.I even go back to “data” then back to “interfaces” and it just puts me back into edit mode for the first interface.Genuinely losing my mind