Ask the Community

Hey all,so weirdly enough, when I setup the formula for a total time calculated it shows this: 120 minutes, correct?However the resultant display shows this:Just curious, why is it showing up as 0:02 instead of 120, even though in the sample it shows it’ll be 2?

When you have multiple independent instances of the same database schema (Base) along with their corresponding user interfaces (UIs) and separate data records, you might be looking for efficient methods to implement changes to the database schema or UI across all these instances. What strategies or solutions are available for applying updates or modifications to the database schema or the UI consistently and effectively to all instances?To provide some illustrative context. I would like to add a Field 3 to the Master-BASE and rollout this change to all instances.MASTER-BASETable AField 1 (Single Line)Field 2 (Number)Table BField 1 (Email)MASTER-UIView 1 Instance1-BASETable AField 1 (Single Line)Field 2 (Number)Table BField 1 (Email)

Airtable novice here! I’m trying to create a set-up that will field team names and scores from a typeform trivia survey to create a simple leaderboard to sync to the commonninja leaderboard widget. After *so many hours - whyyy* I finally got the simple set-up ready but for the life of me, cannot get the new entry from typeform trigger automation to work. It seems to fail at the Update Record step. See screenshots of two set-ups below - any help would be so greatly appreciated! Also open to any other solves that might reduce the number of apps I’m bringing in. Also note that I have to set Team Name as a single select with options in order to connect with typeform properly. Arghhh. Halp!!!! Set-up 1 Attempt 

Hey,I have a “project management” table where I keep all my projects, with a lot of different linked records.When I change the status of a project to “send invoice” I have an automation that sends an very basic email to my accountant that looks something like this: Hey!The Project "PROJECT NAME" is done.Send invoice to “COMPANY NAME”:  “AMOUNT” + VATInfo: “NOTES”Contact: “CONTACT NAME”Email: ???Best//OscarI have ran into a problem however, I can’t for my life figure out how to add the “contact’s” email adress. Since the contact is only a linked record from “people” where all the details for that contact exists. I do NOT want to add an email field to my project view, since I have a LOT of people and different other linked records there, it will become a mess. Can anyone help?THANKS!!/O

Hi there! I have an automation currently setup in Airtable that sends a slack anytime a tag is updated when an order comes through our system. The automation sends the customer name and total in the order and a link to the image. I am trying to find a way for it to send an actual attachment of the image, as currently I have an employee going in and manually sending it. This is what Airtable support said below. And attached is an image of what the automation looks like.  Let me know if anyone can help guide me through this. Thanks!  “As a workaround, this could be achieved by setting up a custom script in your automation that uploads the file directly to Slack. That path does require some scripting knowledge and familiarity with Slack’s API.If that’s of interest, you might consider reach

I am working in grid view and need to move several records to different places in the same table. For example, record 101 needs moved to 43, etc. Can someone show me how to do that?

Hi,here is the solution to this frequently asked question. Just replace the value in delay( ) to change the time of delay. The maximum delay you can give is 30 Sec per action or automation will fail. For adding more delay the work way around is to add two scripts actions one below the other (See Image).function delay(ms) { var limit = new Date(); limit = limit.setMilliseconds(limit.getMilliseconds() + ms); while ((new Date()) < limit) { // do nothing ; } } delay(20000); //delay 20 second

Hello Community,I’m fairly new to Airtable and relational databases at that, but would like to create an application that helps me distribute allocations to my top accounts for my wine import and distribution business. We receive certain highly sought after wines in small quantity and need to distribute them to top accounts. Most of the time, accounts take the full allocation, but other times they just accept a portion of the offer or none at all. My post here is looking for guidance from experienced designers on the overall base structure and how I should develop and connect things. Here are my thoughts so farTables w/ - wines available / pricing, distribution of wines by account, total quantity of wines still available Table w/ - List of accounts with email information Interface showing each account their allocation **or Automation sending out an email with each account's allocation Maybe there is some way for

Hello everyone,I'm using an automation that links to my Outlok account, sending an email via Airtable.After a successfull 15 emails sent, I get the following error message.Microsoft reported an error while processing this action:This action is being rate-limited by Microsoft due to excessive requests.Does anybody knows why and could help me fix it ?Thanks, and kind regards

Hi Airtable community,I’m trying to set up an automation and could use your help.Here’s the scenario: Whenever a new record is created for a specific name (NAME 1) and a new name (NAME 2) (see screenshot for reference), I’d like the automation to trigger a notification to the specific people who have modified the  previous data in the past.  

I’m setting up a base that is hopefully going to help me organize my finances with my boyfriend. We have a joint bank account, and I need to be able to show how much money is going in and going out. It seems like he is not leaving enough money to pay for his bills. So, I’m wondering if I can calculate who owes what in the account. Like … I import the CSV of the bank account, then create a table for people (which would be just two), then add up the balances of all the expenses that are the responsibility of that person … What about stuff that is both our responsibility … would I create another person and then divide that into two … I’m so confused. :crazy_face: :frowning_with_open_mouth:

Hello!I have a question regarding the batch_upsert method in the pyairtable library.Does batch_upsert update records even if the incoming data is identical to what's already stored in Airtable? Specifically, will the “Last Modified Time” column be updated in such cases?Example usage (python):table.batch_upsert(records=batch, key_fields=key_fields, typecast=True) From my testing, it seems like some records are not showing an updated timestamp, even though they were included in the batch. I'd like to confirm if this is expected behavior.Thanks in advance!

My primary field is an employee’s full name in this format: Last, First. The catch is that some employees have a middle initial or a middle name, so it looks like this: Last, First Middle.I want to create two separate columns that separately extract the last name and the first name. I want the separate first name column to include the middle name/initial (if they have one).I’ve been able to create the last name field with this formula: LEFT({Person Name}, (FIND(",", {Person Name}, 1)-1))However, when I use that same formula for the first name field except with the RIGHT function it doesn’t pull out the first name correctly for everyone. RIGHT(

Hi everyone 👋I’m building matchmaking system using Airtable + Make, and I’m stuck on the neighborhood matchingHere’s my setup: Properties table{Address} field (e.g. Monterrey Street, Roma Norte, Cuauhtémoc) {Neighborhood} (single select → “Roma Norte”,Clients table {Preferred Neighborhoods} (multi-select or linked) – clients can choose multiple neighborhoods they are interested in. In Make.com, I also created a variable neighborhoods_string that looks like this (from {Preferred Neighborhoods} [] array) : Parres El Guarda|Isidro Fabela|San Pedro Mártir|Miguel Hidalgo 3ª Sección|San Andrés Totoltepec|Tlalpan Centro|Tlalcoligia|San Nicolás Totolapan|Héroes de Padierna|Jardines del Pedregal|Roma Norte What I want to achieve:

I can’t believe I couldn’t find an entry about this in this forum yet. Hmm ok, here’s my problem:  Every time I open Interfaces it goes straight into the editor and I have to click launch to use it. For me (main administrator and builder) it is annoying but works. Now my user back from holiday wanted to access and couldn’t. It gives a message that says to click on launch or ask the owner. No launch button though. I opened the interface on my side, had to click launch again did so and she could get in. This obviously is quite an annoying and NOT acceptable behavior. I have no idea where and how to change this behavior?Please help  

We are a small manufacturing company, and have moved most of our inventory into Airtable for our current build and possibly will continue to use for future buildsIs there a script I can use to stop duplicates from happening within a table? Is there a way to move about parts from one ”location” (which is already a table in the base) to another without physically having to continuously go into the data base?  continue question from above - is there a way to have 1 part but with multiple locations? We have parts that are stored in multiple staes (eg: flat parts and then folded parts but both are the same part) what is the best way to show this other than having multiple part numbers or prefixes for the same part.Hope that all makes sense…..

I am building a base for our clients. Goal is to have them access their data through a portal. They will want to print professionally formatted reports with our company logo and page breaks. Are the print options in portals the same as interfaces? If so,  this will not fit our needs. Would you suggest we use a 3rd party such as Documint?

Hi there, I have IFTTT applet that creates a new Airtable record when a Google calendar event begins. The description for the event comes in as HTML. I’ve been looking for a script that could convert the HTML to rich text so that it is more human readable in the base. I know about the Marked Preview app, but I don’t think that’ll be the best solution, since I will be embedding this base and I currently cannot embed apps. Any help is greatly appreciated.

I'm curious about this new Portals feature and where it is going. Is anyone using Portals? What is your experience?- vs. existing third party portal app (e.g. Softer, Glide, Noloco)- Mobile availability- Setting permissions and inviting users (e.g. partners, vendors)- Price/value- Sharing interfaces already used internally as portals vs. creating dedicated interfaces- Collaborating with portal users via comments

So I have a few tables I am trying to figure out the best way to join them in order to create an interface that will display data from multiple tables. For example. I have a table Fund (which has contact information), a table budget (which has budget information for each of the funds.  There is a line item in budget that has each years fund budget. The common thread is there is a dept number for the fund in the fund table and a corresponding dept number in the budgets table.  I am trying to figure out the best way to report on each fund and their budget.  Particularly, their current budget (there is a field in the budget for each budget year), so in a nutshell, I want to see all the information from the fund table and the corresponding current budget for that fund from the budgets table.Its so simple to do this in excel or access but I cannot figure out how to link two tables to display the information in airtable.Any helps is appreciated. 

We have an event that is in multiple different locations. We have a form where they select which location they want to attend. I want to automatically send them the calendar invite when they fill out the form based on their response. Ex: We have an event on Monday in New York, Tuesday in Boston, and Wednesday in Chicago. If they select Wednesday in Chicago they will receive the outlook calendar invite for that specific event.

I created a form in Airtable and it gave me this html code: I embedded the code in my web site page here and it does work: https://captaintime.com/joint-venture-webinars/ However, it gives it a black background instead of the usual green on my site. I tried changing the background transparent to the hex color number and this didn’t work. Nor did changing backgroundColor=yellow to green. Not that yellow was showing anywhere anyway. Thanks,

So while updating my table coffee shops, I accidentally removed trading hours from MANY shops.I easily fixed this with Ctrl+Z, but now even though the data looks correct, the data is not being pulled from airtable to my website. If I duplicate the entry, same issue. But if I remake the entry EXACTLY the same, then it works. How can I resolve this? The issue is that airtable is showing me data that looks correct, but is syncing incorrect data.

Hello, We are having problem with Attachment Field.We use mobile devices to upload photos on airtable, but the photos are not getting uploaded...Anybody having same issue?From my observation, the Airtable mobile apps is not working.I tired with multilple devices, Galaxy S devices, Iphone, Ipad...Logged out and re-logged in, but its not working at all.

Hi Dear community Got a challenge when creating recipe management calculator When I need to create a new recipe or sub recipe I have to create the name and go to search for the new recipe and starr filling all the information as the field quantity  of the ingredients is not in the same table Please can somebody help me step by step instructions to solve this issue Tarik Kind regards