Ask the Community

I have created a blank interface where submissions that come in to the "Requests" table are used as the basis for creating records in the "Jobs" table.I've identified that the biggest potential for user error is not having the correct Job selected in the right-side dropdown. I'd like to limit the dropdown's selection to only Jobs that are linked to the Request that is selected in the left-side dropdown.Nothing I've tried so far has worked. Any ideas?

I am trying to track when i should expect a project back based on the amount of days given to return. The first return length is 70 days or 10 weeks. The second time it is submitted is 30 days return. Column: Submitted date: (constant)- user entered Columns: Expected Project Return (date) DATEADD({SUBMITTED Date }, 10, 'week')) This checks out good.  when I have a Resubmittal column(date) I would like the Expected Project Return Date to now show DATEADD({SUBMITTED }, 30, 'day')) So in short i want the expected return date column to update once the resubmittal date is updated. 

I'm using the CSV Import extension to import data into an existing table. I am trying to preserve a linked field relationship so that when data is imported, it does so into a linked field. I understand this is possible, however, the linked field I am working with is linked to a table that is synced from another base.When I try to import, I get an error message saying "You can't create records in 'Table' because it is a synced table." Are there any workarounds or is this just a limitation of Airtable? If I turn off the field (complete_machine_sn), I don't get an error message. At the end of the day, my goal is just to import the data and preserve the linked relationship, as I have downstream workflows that required that linked relationship.

I'm looking for a way to customize the Fields, and their order, that appear in an Expanded Record's preview cards for that Linked Field.It seems Random, or customizable?  I know in a normal grid view, I can specify the Linked Record field to use a specific view, and set the order in that view...but that doesn't seem to affect the expanded record's preview cardanyone have experience solving this? 

I have and “hours” table whose rows consist of the following relevant fields:An email address of an event participantNumber of hours participation in an eventYear of the event participationThere will be separate rows with the same email address for each event where hours are recorded.I want to create a query (filter, group by,…) that answers this question.  Which people (email address) participated in at least one event in both 2022 and 2023.Following one suggestion, IGrouped the rows by email addressCreated a new field, called “yrs active” that is defined by the formula “arrayunique(year)”.  On the email address group by line, it indicates the number of unique values found so I assumed I could apply formulas or filtering that operated on just those unique values.Created a second field, “In 2022 and 2023” defined by the formula, AND(FIND("2022", {Yrs Active}), FIND("2023", {Yrs Active}))thinking that at the group by level, if the unique values contained both 2022 and 2023, th

Hi all,I have some entries in my data table for multi-year contracts. I have one field that shows the number of months the contracts span (using the formula (DATETIME_DIFF({End}, {Start}, "days"))/30). I used days instead of months because if a contract ran from 1/1/24 to 12/31/25, it would count that as 11 months.I also need to know the total of months in every year of the contract (e.g. 12 months in 2024, 12 months in 2025, 6 months in 2026). Can anyone help?Thank you!

I did a quick search and couldnt find what i am looking for so i apologize if this has been asked and answered already. I have a Word Press site using the Airpress plugin to pull data from one of my bases. Everything is working as it should but i am trying to figure how to input the airpress shortcodes into the header of my virtual pages for metatags. Has anyone been able to do this using Airpress? If not, is it possible, using the API, to build a custom template that will use airtable data for metatags? Airpress shortcodes work great in the body and so far it has done everything i need it to do except this.

Hello, I am trying to contact Airtable support. The page https://support.airtable.com/docs/contacting-airtable-support?contact_support=true says to go to your homepage, click help, and click message support. When I do this, there is no form, I am sent to the bot chat which is horribly unhelpful. How can I contact support? My issue is that I have registered my organization as a non-profit and I have been accepted. I want to take advantage of the 50% discount but I have paid already. I read that I cannot be refunded but I can have the extra money I paid added to my Airtable credits. This is yet to happen.I also have the notification to utilize my discount but Airtable wants me to downgrade to plus and pay the price of pro to do so - 144 annually per user - this is the Pro rate not Plus.    

I believe this will be a fairly common request and it’s something I noticed right off the bat when designing a dashboard interface for one of my “aggregation tables” for an e-commerce store that’s being fed data from Shopify. Use Case: New Customers vs. Churned Customers in a given Cohort Year Currently, it seems I have to create two separate charts, like so… Ideally, I would like to lay these two charts “on top of each other.” They’re both drawing data from the same table, so the X-Axis is the same. The Y-Axis is just 2 different columns’ values in the same table & rows.

On a yearly paying plan, if after 3 months I decide to cancel, do I get the money back for the remaining 9 months of subscription? Or do I get Airtable credit? Or nothing ?

Hello,I'm wondering if there's a workaround to import data into linked fields. For example, I'm importing monthly salary information to a data table and the employee name corresponds to the primary field of a different table. Airtable only imports the non-linked fields.Would it be possible to import the employee name as a different field then run a script to create the linked record ? Or any other ideas will be appreciated.Thanks,Mark 

I have shared a view using the share link. I want to see the number of people who have clicked on the link. Is it possible?

Heya,We have an interface where we display charts from a base. However, I am wondering if there's a possibility to adjust the data incoming from the base before it gets displayed.For example, there's a field that we need to reformat in a specific way before it gets picked up by the charts.

Have a view with many columns, and would like to distinguish individual “groups” by adding background colors to these groups. Can do?

Hi,I went to make a new interface in the record list style and can't seem to find that as an option anymore, but my existing interfaces are fine. Is it still an option?

Hey there,First of all thank you for your time and your help 😉I've made some pretty basic automation, when a record matches certain conditions, I trigger the action "send mail" (airtable default one). The field "To" is filled with a roundup type of field which has a formula "ARRAYUNIQUE(values)". It keeps the unique mails attached to the record.My issue is that it works 30% of the time. The failure to run is always caused by : "The "To" input is empty"Which is not, the field is never empty, it always has one or several mails. And it being not empty is a condition to trigger.I can't find what's common to success or common to failure.Any ideas ? 🙂  

The example image for the new Record Review interface shows a profile photo (attachment field?) in a column, next to another column with multiple fields (team, start date, manager etc.). See screenshot.How is this layout created? This is the best I can do:How do I put the name fields and status field stacked on top of each other, next to the photo field?

Is there a way to put totals or aggregations at the bottom of (or any where for that matter) a list in Interfaces? I am not using the blank option - I'm using the Airtablke supplied ones because you cannot embed ones created from blanks into a website. They are always at the bottom of columns in the base grids. It is vey inconvenient to have to add things up with a calculator  every time Look something up. Is there an Automation that would do this?Thank, Scott

Hello, I manage two different teams - Team A & Team B. Both of these teams have their own separate base with their own projects. How I capture all of their projects into one grid table without having to do manual entry? I would like to have them sync together since their projects can associate with eachother. 

Hi all!Is it possible to create a sync-ed table (from JIRA or Salesforce for example) that will import data but also allow to create records?So it's a mix of sinced records + manual?thanks!

We have a form which pulls the initial data, but there are situations where we need more information. We want to put a button in the interface that connects to a different form, but the url address is dynamic, not static. Ideas on how to accomplish our goal: Make the url address static so it goes to the form each time.Viewer/commenter could openUse an automation button that populates the form and updates the record it was triggered from. Can someone with viewer/commenter access use this button?Create a template that will link to the record, but don't think this data will be able to be pulled for reporting which is not helpful long-term. Can someone with viewer/commenter access use this button?

Hi everyone,I'm hoping some of these questions can be answered simply or, at the very least, passed along to the developers who might implement some of these features in the future. I'm currently on a trial of it and I represent our organization that wants to use these functionalities to build little dashboards and tools to help our teams and colleagues scattered across the country. I was recommended this service by AI, in fact, when I was asking for specific features I need. It's amazing what it can do and I'm clicking around and building things that are really going to make a difference and be useful.However, I've come across a few stumbling blocks that are quite frustrating. Unless I can find a way around them, I don't know if I can recommend using this for our organization.Firstly, there's the issue of displaying attachments/thumbnails. I had this idea of creating a records overview where users could click down the side to show different entries. I'm trying to build a vacancy datab

I have set up an airtable form that I will send out to a large audience. I do want to restrict the access to multiple email domains for security purposes but it seems like I can only do just one email. Is it possible to do it for multiple? 

I'm having a mental block on something, and I'm sure someone will point out the right way to do this, and I'll privately say "oh, of course", but for some reason the coffee and adderal hasn't kicked in yet....I'm trying to make a member contact form that has a link to a specific person to populate an email table.I have two tables:Member - a list of people including status, name, email address etc...Email - a table that has all the email fields that I use an automation script that takes certain status values "Send" and sends those out and changes the status. I use this script method instead of the pure automation because I have several other scripts that generate emails from templates to send emails out.We essentially have a wiki page with a page for each users's profile (for example: <Jeff's profile >. I want to have a link that uses id=record_id() of a row on my members table, which ties to an individual. When they hit the link, it pulls up the name, member photo, and some

Hello guys,I'm struggling to achieve the desired results here. First: I have a formula that return a number between 1-156 based on the created time of a record:(VALUE(DATETIME_FORMAT(CREATED_TIME(), '0.smh'))*(156-1))+0000 Although I want this formula to return an integer and not with decimal values.What to I need to change here? Thanks in advanced.