Ask the Community

Please who can help me with intermediate and advance airtable products I can do and upload on my upwork profile.

Hello the Community !I received a message informing me that I needed to upgrade my Airtable access. I assumed this was because I had reached one year of usage, so I proceeded with the payment of the requested USD 240.However, after logging into my account, all my databases disappeared. I can no longer access any of my bases, and I would like to know how I can recover them or regain access.Last year, I paid for Airtable with my personal email/account, and this year I made the payment using my professional email/account. Could this be the reason why I no longer see my databases?Thank you in advance for your help — this data is essential for my work, and I realy appreciate your support.Kind regards,Alexandre

Hello everyone,In short, I am trying to use an automation to combine multiple single select linked fields into a single multi select linked record.I have two bases: projects and team. Depending on the complexity and size of the project, there may be 5-15 resources assigned. We assign these resources through their own single select linked field so that we can utilize the timeline/utilization function. This makes doing things for the entire team complicated - such as creating a distribution list for the team members -  as we have to create a lookup field for each resource's email, another field to combine them, and another field to format it. I thought a simple automation could address this issue. It is pretty simple: when one of the 15 single select linked records is updated, it updates the multi select "team" field with all the assigned resources. I am running into two issues: 1)If I don't put a separator, then the multi select merges them all together (Instead of the field h

Hi everyone,I’m facing an issue with an Airtable automation and would appreciate some help.In my automation, I’m trying to Find records whereProject Number  contain  Project Number fxBoth the values are sameIt give error:-  Invalid filter on Project Number (Invalid filter value: [ "P454" ])Could you please the solution for it.

In the United States, an invoice is very different from what the government of Mexico asks for. If the invoice issued in Mexico by Airtable does not have the requirements that that government (SAT) asks for, the expenses in Airtable are not deductible and therefore are much more expensive for all that business that is paying taxes and that is operating within of the law. How can I get an invoice from Airtable with the requirements of the Mexico SAT so that I can deduct the costs of my ads? Invoices issued by Airtable do not meet these requirements. For example, the document must have the RFC (TAX ID) of the issuer and also the RFC of the recipient, and the folio.

Why do milestones created in my “Critical Path” interface (Program Plan table) with linked Workstream and Function Area field not show up in my “Plans by Function Area” interface (Plans by Function Area table), even though milestones created from the Plans interface do show in Critical Path – and how can I make additions from both interfaces appear in each other? 

HELP!When I’m in the specific Events tab that my web-integrated interface pulls from, I see all the information I’ve selected to display by customizing the labels. However, when I copy embed code and plop into to the HTML editor on my webpage, this is all I get: What the heck am I missing?????  

Hello - I duplicating an automation and was able to make 7 duplications but I am not able to duplicate anymore. Is there a limit on how many we can duplicate? 

I’ve run into a problem that I can’t solve.I’m using a Rollup field, and I need to get the total for the previous month.I’m using the filter “Date – is within – the past month”, but it gives me the total for both the current and previous months.When I set fixed dates for the previous month (from the 1st to the last day), the calculation works correctly.Below, I attached a screenshot with my filter settings and the result.I expected the numbers to be the same with this configuration, but they are different.The issue is that I can’t use fixed dates, because I need the period to be calculated dynamically.  

I’m working on a script in an automation (triggered when new record enters a view) where I need to collect some variables (from the record that triggered the automation) to include in an outbound web hook. I’m getting an error on the record.getCellValueAsString lines:TypeError: Cannot read properties of undefined (reading 'getCellValueAsString')let inputConfig = input.config();let recordId = inputConfig.recordId;const table = base.getTable("table_name");let record = table.recordId;let var1 = record.getCellValueAsString("field_name");let var2 = record.getCellValueAsString("field_name");

Is there any way to control the image sizes I get served from an Airtable Attachment field via API? My API docs tell me I can access “thumbnails” in sizes “small” (width 72 on one image), “large” (width 1024 on one image) and “full” (3000 on one image)… But… “full” is not a thumbnail at all, it’s the source image. “large” is too large. “small” is just too small. It feels like there’s a missing middle size here. But it’s not supplied. Is there any way to constrain the size of an output image?

Hi team!I have to create an app to analyze interviews, extract discussed topics and suggest social media posts, based on the topics. Similar to the one Alex McDonnel showed here.It should have three datasets: Interviews, Topics and Posts. Omni created the app and filled it with some examples. Everything looks great, but when I add the new interview no topics or posts are created.Could you tell me how to fix it? 

Hi everyone, I have a question about automations and what the best practices are when dealing with external API calls.We have an automation that enriches records by pulling data from Google Maps. Every time a new record is added to the table, a second automation is triggered: it uses an enrichment API to find an email address from the website, verify it, and then update the record.The issue is that this enrichment step takes a few seconds for each record. Because Airtable runs automations one-by-one and queues them, this causes huge backlogs of pending automations, which slows everything down and sometimes causes the system to get stuck or bug out.My question is:What’s the recommended best practice to avoid infinite queues or stuck automations when using external APIs that take a few seconds to respond?Should we batch records? Or is there a better architectural approach?Any guidance or suggestions would be greatly appreciated.

I’m perplexed as to why buttons created in the data view cannot yet work in Interface view.  How has this not been worked out?   

Hello, I am syncing my calendar to Airtable, but once I did so out of the items on the calendar it is broken up into two separate kinds of events, so a sure-fire way to be able to separate and organize them is item one right now I have an automation whenever and events/ record is created it tags (single select) either one or the other with Nobody edit permission as very rare will items float between the different types. Secondly, so many of the calendar meetings are canceled or deleted. I want Airtable to follow when that happens, but also snap back live on the calendar if it is brought back into the calendar. Anything to help me head in the right direction would be appreciated.

Currently using Airtable to store all my Training Recordings for teams. I have a interface built out for these training but when it shows up blank in the interface because there is no thumbnail/preview in the data side. I can click onto the recording which will play the video but there’s no thumbnail. Am I able to customize a thumbnail image or add a picture?

Hello All,Please my Airtable <> Docpotion integration was successful, script runs fine, generates pdf invoice in attachment field when, but unfortunately I cannot view the invoice generated and when I download the file, it also does not render in pdf format. Had series of calls with the founder/support of Docupotion, all looks good from their end. Please I need all the help I can get with getting this issue resolved or any other means to achieving same outcomes This is a major blocker to a major project completion.I have attached screenshot for easy of issue Thanks in advance 🙏🏽 

I would like to build a field agent(s) that extract data from an attachment uploaded to one field, and the enters the extracted data into corresponding fields in the same record. Example: .jpg or .pdf contains a customer’s name, DOB, email, etc. I would like for the field agent to then extract the data from the attachment and enter it into similarly titled fields, i.e. name, DOB, email, etc. Is this possible? Any insight/instructions? Thank you! 

Hi!I have setup email automations through Airtable (trigger: when a record enters a view - action: to send email through gmail).The issue is the email is being sent at midnight, which makes it evident that it is not a personal email from our team. How can I setup either the filter on the view, or the trigger/action so that all of our emails are sent at 8am PST? We have an enterprise account, so I feel like this has to be an easy solution, however everything I'm finding seems to incorporate like four additional columns and formulas, which seems really inefficient...

I have an automation that 1st Finds Records from a table then Inserts the Found Grid into an Email. I have static Emails and also want to Use Emails from the Found Records.  If all the Found Records Emails match is there a way to just add 1 instead of it putting in multiple identical Emails in the To:I imagine maybe a script but do not know how to write those. Bull

HiIs anyone encountering intermittent issues with the API.Sometimes it take 2 min to get data, at time a few seconds?

So as we know, we can now enable the creation of records in tables that have been synced from other bases. It's great. Massive improvement. But can someone confirm for me whether we should be able to do the same using the Create Record action in Automations? Should spend my time doing a workaround or bug hunting? Because it isn't working for me.thanks,

Hi folks,In Chrome and other Chromium based browsers there seems to be a print to PDF bug. When my users attempt to print an interface the print dialogue pops up as attempting to print 20k+ pages of records when the reality is that it should be somewhere between 7-10 pages only. Has anyone else encountered this issue?

buongiorno a tutti, ho bisogno di aiuto perchè non riesco a concludere quest’operazione:mi occupo di vendita di merce, ho creato una griglia con varie informazioni, tra le quali esiste la colonna nella quale viene visualizzata la data della merce in uscita.mi piacerebbe che quando questo cliente risulta “uscito” venga spostato in un’altra grigliacosì da avere un elenco di clienti da consegnare, e nell’altra griglia merce uscitagrazie 

Hello everyone, I started a new job at a company where I’m trying to structure how Airtable is used.We have a view that’s publicly accessible, but we don’t know which account it’s tied to. We want to delete it, but without knowing the account, it’s impossible.Do you have a way to help? Thank you for your help.Maxime