Other Questions

Hi, I have been having troubles with the ‘rollup’ field function. Every time I use it, it gives me this error message: Sorry, there was a problem saving this field. Invalid formula. Please check your formula text. Some context: As you can see, the field all the way to the right is linked with the other table: The second table is a feed of forms being submitted. In those forms being submitted, I want the “flight time” (duration field) to add up to the Flight time field in the first base, which is not working due to the formula being ‘invalid’. Thank you in advance.

I used Zapier to create a connection between freshbooks and airtable. Every time a student pays their invoice it automatically updates the record in airtable to list them as “paid”. However the field is a drop down with two options - paid and invoiced. After I sent data through Airtable the single select field now has paid twice! What am I doing wrong? “Paid” is spelled exactly the same way in Zapier and Airtable

I am trying to create a mentor request form & table for our community and I haven’t been able to figure out the setup to meet our requirements. Here they are: There will be a mentor request form that is sent out to all users in our community asking them to select an available mentor from a dropdown list. available means that the mentor has less than 2 mentor requests in the current month We would then keep track of mentor requests and close them as they get done How would one go about setting this up? Thank you for all your help!

Hi, I’m using airtable right now for some research - and I’m looking for a way to smartly collect notes, comments, observations, trends about a specific question in my dataset. Use case: 20 colleagues responded to my survey Question B asks for hobbies, multi-select, keywords the result will be 50 different keywords, approx Now I would like to go through the column B, check through the responses, identify trends, clusters etc. In the moment I’ve just created a fake dataset #1 to take notes in – but that doesn’t seem like the right way to go. Any suggestions how? thanks

Greetings Team, OK - Airtable Date Time values are confusing the daylights out of me. I do realize that Airtable likes to present datetime values in local timezone but to run incorrect math by using incorrect hours in GMT, even when we’ve explicitly set the values to local. What I can do in Excel in literally 1 minute has taken me hours and I’m still lost. For example, TODAY() with 24 hours turned on shows up as 3/4/21 16:00. Why 16:00 when I’m in PST? Today() should be set to the start of today at 00:00, no other random number will do. OK - then I try with the crazy SET_TIMEZONE examples (just to get today to behave). DATETIME_FORMAT(SET_TIMEZONE(TODAY(),‘America/Los_Angeles’),‘DD/M/YY HH:mm’). The result is still 3/4/21 16:00. My problem is that these random hour shifts mean that orders placed on 2/16/2021 at 8:52 am are being treated as placed on 2/17. I’ve tried the DateAdd formula and subtracted hours only to realize that Airtable doesn’t take the modified values. It’s still worki

Hi, I’m having a problem regarding data transfer from my Google Form to my Airtable account. Previously, when I’m doing testing, all the data can be transfer. After few times of testing, suddenly, none of the data been transfer to my Airtable account. Is there anything that I shouldn’t click but I clicked ? Please help me. Thank you in advanced.

I am using ZZbots to populate Airtable from a Google Sheet but I am having 2 behaviors: a pizzas field contains the list of pizzas for a given event. This field is populated wih up to 8 pizzas recipes that are comma separated Behavior 1: Airtable picks up the list an automatically split each pizza and link it to the correct linked pizza recipe from another table Behavior 2: Airtable does not split each pizza and considers the whole pizza list as a single recipe Any clue what’s going on?

I really, really wish there was a better chat function for individual records other than the activity screen. This would be solved if I, as an administrator, could turn on and off who gets an email when someone comments in the Activity. But we have content that can be touched by multiple different people, sometimes over months, and the folks who discuss it at the beginning don’t always need to get pinged when someone else is discussing it weeks or months later. The rest of my office are reluctant users, so being able to remove any barriers or extra work is essential to getting them to engage with it more fully.

Basically I want to have some method for a user of my form to add one or more participants and for that info to be placed into a single column. They sign up for a course, and indicate number of participants. Then should be required to provide the name, email of each participant. Is that possible without creating form that has a long list of inputs? I was expecting I could add a button, “Add Participant” that would present two input fields (name,email). User completes, and clicks “Add Participant” for each additional participant. THen when they submit that data is stored, comma delimited into a single column called “participants”… is this too advanced? Some way to achieve?

Hi everyone I’m writing a client-only javascript application that will run in a shared network folder. I’m Ok with risking the api key being visible among those of us that share the folder, but I just want to make sure that if I’m using airtable.browser.js, sending the key to Airable isn’t a security flaw. Is that correct? Thank you

I’m unable to reproduce Vega-Lite code, which works in other editors (example). In Airtable I just get an error message for the now() statement: "scale": {"domain": [{"expr": "now()"}, "2021-09-09T00:00:00"]} with error message: Incorrect type. Expected “null”. Is this a bug in the app or am I doing something wrong?

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.