Other Questions

Hi guys, I would love to get your help/creative ideas regarding Airtable automations. The company I’m working for has about 70 clients and it keeps growing. We’re in the middle of updating their bases to a new layout with multiple new features with a dependency on the automation features. Currently, we have a pro user with a limit of 50K monthly automations per base. We’re planning on moving to the enterprise plan, and unlock the possibility of 500K automations per month. Our problem starts when we’re thinking about the future. If we’ll add more clients - we’ll add more automations. Each base has about 60 columns, many of them depend on automation as said before, which leads me to the point that maybe even 500K automations won’t help us out here. In general, our product generates leads for our clients. It means that every day each client has 2 digits of new records (depends on their plan). Eventually, it means that for each record, a large number of automations will be activated. Anoth

Airtable currently functions as the AP module for the company I’m working for. We are considering transitioning to another software. If we unsubscribe from Airtable will we still be able to access the data stored in our account?

I want to develop a timesheet form, with Date, Project, Employee, Task and number of hours worked. Given that there is likely to be several employees working on the same project and perhaps the same tasks, many of the records will contain much of the same information, is it possible to start the form with it loaded, pre-filled, with the same information as the previous entry?

I imported a report from a supplier webpage (table Quotes). This report is a list which contains Customer ID, Quote #, Product ID, Product Name, and other features. Each Quote # could have several Product ID´s. On the other hand, I created a table with Designs. Each design is associated to only one product ID. I want to get the info associated to the product ID, like Name, dimensiones, etc, from the Quotes table, but the primary key (first column) in Quotes is the Customer ID. How can I search and get info associated to a specific Product ID? Something like VLOOKUP function in Excel, where I can search a specific data and get the info in the next columns.

I’m planning to use Airtable as a backend for some submission. The estimated load is about 2400 submissions per hour during high traffic time, and many of them will come from Zapier as well. One of the fields is a video/image submission. It is critical that we do not lose submitted data. I’m a very new to Airtable. Is it something Airtable will be able to handle without loss of data or major hiccups?

Ok we’re having some family fun playing ping pong and we want to track games. Ideally, we would be able to track game results, player stats such as wins/losses, points per game average, total points, etc. While also keeping track of game stats like who played who, what the final score was, the game date, etc. I can’t seem to figure out how to track the game info and also have a table to that calculates player stats. The issue is having player 1 and player 2, so when I connect the Players table to the Games table, I have to connect it twice because there are two players. Anyway, here’s the base: Airtable Ping Pong Stats - Airtable Explore the "Ping Pong Stats" base on Airtable. Any help greatly appreciated!

Hi guys, I am playing around with Airtable to see whether this could help our small eating disorders clinic (and me as the manager!) make us more efficient to see people and communicate with them. I have worked out how to send an email to myself automatically once someone has been waiting for more than 60 days, but I have not yet worked out how to include their name and/or email address in the automatic email to me so I can then get in touch with them. (Or how to send an automatic email to them directly?). I would really appreciate your input a lot. Thanks heaps, Kathrin

I’m attempting to use the XML app, and after I drag in the XML file, it requests an XPath. Is there a way to figure out what the Xpath might be just by looking at the XML file? I saw another answer in which nested data was going to prove problematic. The example that Airtable provides in their documentation doesn’t show the imported XML file, so I’m not able to figure it out by that example (XML import app – Airtable Support) The data that I’m attempting to import is the data filed with the SEC to show stock ownership. A sample, such as this one from Berkshire Hathaway, is here: https://www.sec.gov/Archives/edgar/data/1067983/000095012321002786/0000950123-21-002786-3286.xml Really appreciate any help here. I attempted things like “InformationTable” and “\InfoTable” (without the quotes of course) and other variations of those things, and Airtable didn’t recognize any of them.

I built a tool that syncs Airtable to Webflow without fussy zaps or tedious integrations. You simply map your Airtable columns to your Webflow CMS fields and click sync! It’s the perfect solution if you want full design control of your website with Webflow, but want the power of Airtable as your backend. It takes care of all the complicated tasks of keeping them in sync and converting and syncing your Airtable data into your Webflow CMS. Detect new, modified, or deleted records in Airtable and update Webflow accordingly Convert Airtable Rich-Text fields into HTML for Webflow’s Rich Text fields Convert links between Airtable records into Reference/Multi-Reference fields in Webflow Set Option fields in Webflow based on values from Airtable Generate embed code for YouTube links for your Webflow Video fields Upload Airtable image fields into Webflow Image fields Here’s a demo of me creating a job board in under 10 minutes. Unlike many Airtable apps, you don’t need a PRO account to use

I’d like an easy/simple way to share read-only views of a half-dozen tables and a few blocks. How do I share some tables in a workspace, but not others, and how do I make sure that the blocks are also shared correctly? This is just to give a specific user a read-only report of their relevant data.

I want to know if it is possible to unlink the records from my calendar and grid. I am trying to plan my social media content in the calendar but want to create specific posts on the grid. Is this possible?

Hi all, I use Airtable to be the database of my Webflow website (through syncing via powerimporter). One of the important field is a rich text field (a summary for a marketing resource). It’s great that we can include links, but my problem is that I need a link that could be “relative” and send to a specific section of the page (marked with an id like "). The problem is that it seems Airtable automatically adds “http://” to whatever I type ("#example4" in this example). Is there a workaround? Thanks! Sylvain

Does anyone know a script that I can use as follows: 1) take a field that has a string of 10-12 Comma Separated Values (CSV) and 2) randomize the order of those 10-12 values? I’m not a technical person, so I’m sorry if this is a rudimentary question…

Hi Airtablers! We have a lot of helpers from WWOOF & WorkAway. We have a capacity of a maximum of 10 people at a time and I need a good overview to not be overbooking at any time. We have an arrival and departure date, so we can see how many people we have each day in the calendar view. But it is not an easy overview. I would like a chart on a dashboard. But how do I get a count for each day of how many people are booked, so I can make the chart? All the best :high_brightness: James Family in the Forest

We are using SendGrid and want to insert a field into the email. We’re able to do it, but since our field has multiple values, the results are that all of the entries get listed one after another which makes it very difficult to read. Is it possible to set this so that there’s a line-wrap to make each piece of data coming from that field appear on a separate line? Thanks

Hello! Is it possible to change the text color of some fields in the form via e.g. script?

For example, I notice it seems possible to create a table and link a form to it in order to gather the data. What added benefit is there say here to using an MS Form and Excel? I would just like an idea of the potential benefit before investing too much time researching Airtable. Many thanks. PS. For context my job role so use of the software would be for managing and coordinating projects.

Uploaded Excell spreadsheet satisfactorily, but when press Upload, it says ’ An Error has Occurred, Sorry your request conflicted with another change’. This occurred a couple of times with the first Sheet being imported but then it suddenly it worked ok, despite not changing anything. Trying to import into another Sheet in the same Airtable Table it unfortunately just keeps on repeating the error message.

Importing spreadsheet from Excell, Column headings ignored, first data row below Excell column headings are taken as the Airtable sheet headings. Ok headings can be manually corrected in Airtable but as there are over 50 columns, that’s a bit tedious. What might be gong wrong, any solutions?.

Hi all– I have a function that requires a rollup to concatenate values in numerical order. But I can’t seem to control how the rollup is determining the sequence. I’m basically using this type of logic: Either: Display X most recent linked records OR Display all linked record up to a year prior to most recent record - #2 by Justin_Barrett And yes, I want to show the last three records… but the rollup function is aggregating the results in a weird sequence. The result is that it gets the last 3 entries according to the rollup, but it’s not actually the last 3. It sometimes throws an entry out of order, although for the most part the results seem to be as predicted. Hmm.

Using the google sign-on in the desktop app now shows an error from Google: “This browser or app is not secure” and then does not allow logging in Please resolve

Hi, I have a M query below which works fine in Power Bi Desktop but fails in Power Bi Service due to Query 1 Dynamic Source Refresh error. I understand that I need to add amend to add a Relative Path to make this work but after numerous attempts am now stumped. Any suggestions please? let Pagination = List.Skip( List.Generate( () => [Page_Key = “init”, Counter=0], // Start Value each [Page_Key] <> null, // Condition under which the next execution will happen each [Page_Key = try if [Counter]<1 then “” else [WebCall][Value][offset] otherwise null, // determine the LastKey for the next execution WebCall = try if [Counter]<1 then Json.Document(Web.Contents(“https://api.airtable.com/xxxxx”, [Headers=[Authorization=“Bearer keyxxxxxxx”]])) else Json.Document(Web.Contents(“https://api.airtable.com/xxxxx?offset=”&[WebCall][Value][offset] , [Headers=[Authorization=“Bearer keyxxxxxxx”]])),// retrieve results per call Counter = [Counter]+1// internal counter], each [WebCa

Used the page designer to do an 84-page presentation to a client. Then tried to save this presentation (single pages) as a pdf using Mac (running Catalina). It initially created a pdf but then gave an error message when I tried to open it saying I needed to “Save as Adobe PDF” because the file was corrupted. When I tried again and saved as Adobe PDF nothing happened. Every time I try the Airtable app screen goes black or freezes and I have to force quit and start over. ADDENDUM: I am able to create a pdf in the web version of Airtable, just not when using the app. Additional question - is there a way to retain live links.

I get this exception: Exception thrown: ‘System.Net.Http.HttpRequestException’ in mscorlib.dll An error occurred while sending the request. - System.Net.Http.HttpRequestException The program ‘[10796] Test.vshost.exe’ has exited with code -1 (0xffffffff). The code of Airtable.net in github is at link: GitHub - ngocnicholas/airtable.net: Airtable .NET API Client The code I wrote for using of Airtable.net APIs: private async void GetRecord(string id) { using (AirtableBase airtableBase = new AirtableBase(appKey, baseId)) { Task task= airtableBase.RetrieveRecord(appTable, id); AirtableRetrieveRecordResponse response = null; try { response = await task; } catch (System.Net.Http.HttpRequestException ex) { Console.WriteLine(ex.Message.ToString() + " - " + ex.GetType()); //throw; } if (!response.Success) { string errorMess

Super newbie question, but hoping someone can help! I have a table with about 15 fields. I would like two of these fields (full name and email) to be synced to a DIFFERENT table, so I can easily export to CSV these two fields ONLY for email newsletters. What is the easiest way to do this? Thank you!!