Ask the Community

Hi all, I am not sure if I am going about this the right way, so I’d appreciate some ideas. Goal: I have two tables. A “detail table” and a “main table”. The “main table” has a related list “link to another record” field to the “detailed table”. In interface designer, I am hoping to create a search that lets me find records from the “main table” and by selecting an item it lets ‘grabs’ the related list of items from the detail table. So, if I select three records from the main table, that each have 3 records in the detail table, it would show me the total of items from the detail table = 9. Appreciate any thoughts! Thank you!

I don't know if it is possible.. we know that on excel we can have live data and refresh the table to include the new data. And we know that we can link an excel file to airtable and export the data on it.So my question is can we create a dynamic airtable table that refresh every time I refresh the excel file?I don't know if it is something impossible.. Thank you🙏 

Hello,I am trying to create a web app using Airtable and Softr. I have already created a fully functional application, but now I want to scale it so organizations can create their own profiles and customize them as they like without affecting other users. I am thinking of creating separate databases for all organizations and connecting them with a central database, similar to how we do it in native PostgreSQL. However, I seem to be stuck with Airtable. Can anyone help me achieve my goal? 

I am new to Airtable. I am wondering whether you can send an email to an airtable record. Eg a follow up item to be added as a task. (This can be done in Evernote and other task programs). Thank you in advance

My company exports a .csv file every week containing the current inventory of the same objects.  Each object has a count that may change week over week.  We copy this .csv into an airtable weekly.  I would like to capture the old counts from the prior week so that I can track the differences week over week.  How can I set up a scheduler to move the values from the "This Week's Apples" field to "Last Week's Apples" field automatically?

I'm sure this an easy one - but I am stumped.  Here is the scenario: I want to create a view so I can send out a daily report that shows all records that are on tomorrow's service schedule, yesterday's service schedule, and 2 weeks ago service schedule.  The current airtable filter options of tomorrow and yesterday work great until it comes to the weekend - meaning on my Friday report, the Monday activity is not showing up and on my Monday report, the Friday activity is not showing up.  I have created formula fields that calculate the next work day but Im still stuck on how to filter it.  I tried to filter using "is after" "today" but then it gives me all records in the future when I just want the one next workday.  Maybe I am approaching this all wrong and making it more difficult than it is - but my brain is not computing 

i have a record table like this (simplified)idcreated at (datetime)category(text or link to category table)contentcatrgory record count (?)12025-1-2cat-1 222025-1-1cat-2 132025-1-1cat-1 1my idea ist to use a formula like this:count records, where category = category and {created at} <= {created at}somehow, all my approaches fail. tried rollup and formula.if it helps, category fields are linked to another "categories" table. but i could not filter over linked cecords, because that would require linking two times -  to the categories table and then back.i want to avoid using an automation, because i have a large number of existing records, and an automation seems hacky for me. if there is no other way, i'll go this route, though.i'd be glad for a hint or a lin to a documentation for a similar case 🙂

I’d like to integrate photos into Airtable but would prefer not to have to upload them directly as an attachment but would prefer to link them to someplace outside of Airtable. Currently I do this with an Evernote link. But ideally I could find a way to link it directly to my “Photos” app on the iPhone. The impetus for this is to avoid redundancy of having a photo stored in multiple places (Photos and Airtable, or Photos and Evernote). I store all my photos automatically to iCloud so I was hoping there is a way to link directly to a photo or link directly to an album? (Selecting photos and using the “Copy iCloud Link” feature doesn’t work b/c that link expires in 30 days…) Anyone know of a way to do this? Or any other interesting ways of tackling this problem? Thanks to this awesome AT community

Hi! I'm new at this. I want to send a scheduled email to a subgroup of contacts and pull in specific Airtable data into the body of the email and pull in the email addresses from the database. I'm using the gmail integration.In the "To" field I'm using the + to pull in email addresses from the base structure and the test keeps failing. It says "Invalid email address in the "to" field: fldU4hKNRZaMDR6U3".  The other fields in the body of the email that I'm pulling in from the base structure say FIELD ID instead of what the actual field name is and so I think those are also not working properly. I feel like I must be doing something incorrectly. PLEASE HELP. Is the email address in the To field what will act as my key to pull in all the other relevant data? I'm not clear if I need to set up a lookup/key mechanism here since the trigger is a specific time and not meeting a condition. To get to the subset of companies I plan to add a condition. THANK YOU!  I'm havi

I have filled this form but I didn't receive a reply. Is that working? How long does it take for the team to respond?Or have I to do anything else?Thanks!

Hello! I have a field in every record for zip code (number field) I am looking to have a sheet to count up how many records I have in a specific zip code. Interfaces can give me a chart on the zip count but I can not figure out how to get a table of it. I can group by zip code in the table by I need that data in it’s own table.

I'm based in the UK and we've had an integration working on a booking database for over a year which automates the creation of an Outlook event when a booking is made. No changes have been made to this automation but today the events which are in Airtable as dd/mm have started coming through as mm/dd. I'm really at a loss with this and what I need to be looking into.

Hello!I am trying to create a graph to show how many records where submitted in each month of each year, and for some reason I just can't think of a way to accomplish this.Example Jan 2020 =1, Feb 2020 = 3 .......... 12 2024 = 89, 1 2025 = 90 sorted in orderAnyone know how to do it?

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?