Other Questions

Hi all, I’m working as a lean consultant. Helping teams to reach their business goals. I currently experiment with a system that uses excel and trello but they are not connected. I believe airtable could solve this. The solution would be a great product that could help 1000’s of teams all around the world. So I have a vision. I have a mvp. I just need help to get it working in a lo code to like airtable. Could anyone help me with further resources? Ideally I would speak with an air table expert and show what I have already and explore if air table would be able to connect my two parts. Thanks so much for your time, Alexander

I’m trying to calculate and then visualize Net Promoter Score (NPS) from a table of evaluation scores submitted through a form. NPS = (% promoters - % detractors) / total number respondents Where: promoter values = 9-10 detractor values = 1-6 total respondents = 1-10 I’m new to Vega and got stuck pretty quickly. I’m pretty sure I need to do a calculate transform step, but not sure how to assign e.g. “promoter” to values of 9 and 10. Is binning the approach, or is there some conditional logic that could work? I’m interested in ways to do this without Vega as well, but I like not having to add extra fields to my table if it is possible to do the calculation within the app module. Thanks in advance for any assistance!

For example, we have created a form, but we do not want everyone to be able to see certain fields at different levels within the company. Thank you.

Can anyone tell me why when I insert one column in a view does not reflect in all other views ?

Hi there Airtable community. I watched some videos and read some posts. I need confirmation if Airtable can do what I need. Here’s the main actions that we are looking for: Logged in members must be able to search for only 1 specific entry. In this case a specific vehicle according to its chassis nr If we have a record of the vehicle, I need to a) display the service history, b) be able to add a line (not change the current info). If no record exist, then I need the use to be able to create a new entry/record Only paying members/users will be able to search ALL records. Not only the records they created Please note that i dont want to display all the entries in the table when logged in. I only want 1 entry to show after it has been found in database. Think of it as a pay per view system. Thanks for your time. I think Airtable is the way to go but need to hear from the experts if I am on right track here.

While someone was filling out an Airtable form connected to one of our bases, they accidentally closed the tab the form was in. They spent almost two hours filling out the form. Is the data lost? Is there some way to retrieve it? Command + Shift + T brings up an empty form. Thanks!

As a new user on the free platform, collaborating with two others. How do I find out how much of our records usage we have used? Ie: 15%, 55%, 95%??? would like to know. Robert.

Hi, I’m looking to create airtable for youth football (soccer) team I’m coaching. I want to keep stats about number of games each player had, number of goals and assists they had. I have a table with all my players in separate rows, and a table with games they played. In the latter one I need a column with goal scorers. I have used Link function to link player name which then is counted against each name showing a number. So that works fine, as long as each player scored only once in a game or had one assist. But if my striker had a hat-trick I’m not able to link his name 3 times in a cell… Is there any other way to do it? cheers

Hey everyone, Is anyone else having trouble adding attachments? I am on the pro plan and should not be near my limit but it is not allowing me to add any attachments. Anyone else having this issue?

Does anyone know if a Gantt Chart can be configured to show record names by people assigned? My base tracks class names and dates (the primary defining fields for the table) along with people who are assigned to each of those class instances. The people are assigned in a separate column. I’m able to configure a Gantt to show class names, based on the start and end dates. I can even add the assigned people’s names to the label. However, I’d like to show names of people on the left side of the chart, with date range along the top side of the chart, then color blocks would be instances that each person is teaching. I just can’t figure out how to get the left side to organize by person instead of by class. Thank you for any advice!

In a form, I am creating a dropdown (multiple selection) menu. My options seem to be too long and we can’t read them all. Is there a way to fix that?

Hi All. I need help signin into my account on the DEsktop app. When I try to sign in with my google email I get an error message: Couldn’t sign you in This browser or app may not be secure. Try using a different browser. If you’re already using a supported browser, you can refresh your screen and try again to sign in. How do I fix this?

Hello - I can’t seem to get the fill handle to work. Anyone else having this issue or know how to resolve? Thanks!

Does Airtable have any plans to significantly increase the record limits on the Pro plan? I am a huge fan of Airtable, and I use it a lot of small organizational projects. However, the 50k record limit is a real barrier to doing any serious project on the platform. I am working on a database of real estate property records. My county has 150k properties, meaning the base would end up having over 500k records (buyer, seller, property, etc). Tadabase.io offers 1.25M records at their $575/mo plan.

Hi, I’m super new to using formulas. I’d like to do an IF formula for my “Published date” column with the “assigned week” column. So if the dates are less than 2 weeks time it will get “first two weeks” if its more than two weeks it will get the “last two weeks”. My formula: IF({Published date}) < 14, “first two weeks”) ,IF({Published date}) > 14,“last two weeks”) Please advised… Thanks in advance!

I am working on a script that creates a record based on the user input. I am struggling to get a document upload to save with the newly created record. I read the follow thread: How to creat a record while using input.fileAsync Scripting app My question as below: I use this script: Let attachment = await input.fileAsync('Pls upload the cargo packing list') Then I want to create a new record with one field as MultipleAttachment. I want this MultipleAttachment field having the attachment input above by input.fileAsync. As per the API, the MultipleAttachment written format as below: Array<{ url: string, filename?: string, }> How could I achieve my goal? I don’t know how can I have the url of the uploaded file by fileAsync. … and was curious if a solution for this has been created yet. Is there a way to programmatically host this file through airtable without bringing in another storage service? I am attempting to create some automations

Hey guys, I have a weather station that logs data to an Airtable every 5 minutes. I can easily access daily summaries if I group the records by date/day, but I cannot use them for anything. So, as suggested in this forum, I created another table to act as “pivot”, linked records by date/day, and then used rollups to get minimum, maximum, and averages. What I would like to do is have this system update automatically. I’ve tried to update the linked field, both using the logger (a POST curl) or airtable automations, but it remains unchanged. Is another way to do this? Thank you

Hi there, total newbie here… So I am working on airtable via a different org as a collaborator and I really like it so I want to install it for my own company, this company has many subdivisions providing same service but from different domains. So I have 2 questions. I want to be able to continue to work on my original collab org and my oiwn company airtable at the same time. The data is not related so those airtables do not need to be connected in any way, I just want to be able to log in in both organisations but with different logins at the same time from the same browser. Is this possible? As our company has different divisions, we organise our contacts with a field that defines the division by domain. Now if we want to notify a contact in our airtable is there a way to link this to the domain of the division so it looks like the person generating the notification for a division A send this from a division A email whilst B contact sees this as a division B email? Thanks in a

Hi, friends! Okay, I am setting up a group of databases for a client on Airtable. I love it but I am having issues connecting all of them to one another. The app we are building is meant for users to be able to book private charters. There is an additional functionality that will allow the user to submit a route request and then be notified when there is a flight that matches their criteria - ie from Denver, CO to Aspen, CO. So, I have 4 databases. The airport codes. Each city has multiple airport codes associated with it. For example, there are 3 airports associated with “Denver, CO”. The flights. This info flows through directly from admin adding the flights in our app. Notification requests. This info flows through directly from users submitting a request in the app. Users. With all of the user info. Any idea how to connect multiple databases to one specific column? In addition, is there a way to populate when a flight is added from a certain airport that falls under the c

I’m looking to use Airtable as a database for my website that is a marketplace. My website allows neighbors to share referrals with one another. First, I don’t like the design limitations of the “embed view” option…is there an app that you suggest within the AT marketplace that will allow for more customization for both mobile and desktpop? Secondly, and more importantly, I need googlebots to crawl my pages with the referrals on them…and embedding an iframe isn’t going to help me from an seo standpoint. Is there a AT app or work-around solution for people needing the data to be published in a text readable format? Thank you in advance for your help! And I apologize if this question has already been addressed and I didn’t see it in the archives.

I’ve been banging my head here for a bit and ready to give up. I am trying to get Page designer PDF output and copy paste it into a word document. I only want three text fields. Name, Title, Description. The output from PDF has a variety of problems if copy past to a new document. All kinds of corrupted characters, combos of “fi” appear to be vectors, not text. So all kinds of words have issues. Dan Gri􀂣ths , 􀂡lled Line Breaks throughout the Description text block. Should be clean text. I tried galley with an embed to see if I could copy/paste html from the embed but the Desctiption field is truncated. I can’t figure this out, is there any way I can get clean output other than CSV. So far the best result is to export PDF, then convert PDF to Word using an online service. This fixes the line breaks but still have corrupted characters and bookmarks. Open new word in Google docs, copy into notepad ++ and back to clean up a bunch of other stuff and I’m finally at clean text

I have created a large database. It has 46 rows and 15 columns. I attempted to download this base as an Excel worksheet. First, I downloaded it as a .CSV file. Then I saved it as an Excel sheet, but the result was very poor. All the rows and columns were out of whack. This does not happen to me with smaller bases, like those with 5 columns. The 5-column bases download neatly as Excel sheets. Why does this not happen this larger base and how can I fix it?

Hello! I need to import xml feed to my airtable, is there any way in which I can do this? The xml feed is in here: https://feed.omegacommerce.com/f/hnc01/feed.xml

Is it possible to use more than a single logical operator for filtering results? So far, I see there is only the option to filter based on the AND logical operator or the OR logical operator. Is it possible to combine these? For example: WHERE (“Status” contains “active” AND “Due Date” is within “1 month”) OR (“Status” contains “started” AND “Due Date” is “empty”) Otherwise, I need two separate filters and cannot see projects side-by-side easily.

Hello Airtable community. I am a designer whose brain is hurting after struggling to get a decent grip on building dynamic databases in Airtable. I have a lot of questions, maybe you have some of the answers? This is my Airtable: Airtable - Hodebra aktiviteter Q1: How can I make sure that any tasks that are marked complete (logget in Norwegian), are reset to incomplete every night (Ikke logget in Norwegian). I have tried to schedule automation, but I can’t find out how to describe the record ID, when using “changing a record” as action. I would like to change ALL the records that has been completed back to incomplete. Q2: How can I summarize the values in a specific field (Score aktivitet) based on the field “Device.ID” In other words, how can I calculate how many points the user (Device.ID) has in “Score akivitet”, “Score sammen” and “Score meningsfylt”? Q3: How can I track which task is most completed? In my Airtable, I have several views. The first view “Alle aktiviteter” should onl