Other Questions

Hi! Im kind of new here in the community, never used it before. Hope that i can find some answers here. I have an enrollment table that joins a student with 1 to 8 classes and im hoping to do it individually in order to be able to control each class´ status for each student. That said, i have 1 to 8 columns that link a class record to classes table. My current challenge is to merge those linked records into 1 column. Is it possible to do it? any ideas? I´m posting an image to show some perspective. Tks in advance.

Hello! I am working for an Independent cinema and I am writing down each film ever shown. I have looked on other treads and tried stuff out myself, but I can’t seem to find a solution to my problem. As I write the Film Title in my main field, I would LOVE to have a chechbox field(or something like that) that automaticly checks if the film has been shown before. And I would also love to have a field that counts how many times it has been shown. Is this possible? All the best Andreas

I’m trying to import a large spreadsheet to a new table. The spreadsheet has about 8.5k rows and about 30+ columns. I’ve tried to import it via both the Google Sheets and Excel importer and in both occasions (on several attempts) it shows the correct data/sheet to import but on clicking ‘Import’, it just hangs on ‘Importing your data…’ with a spinning circle (and a greyed out background). I’ve even left it for 24hrs and it’s still on the same page. I’ve cancelled and started again several times and the same thing keeps happening and there’s never any evidence of even a partial import (it never even creates the new table). Can someone please advise only I’m not a enterprise client (I’m a Pro Client) so they’ve advised I contact the forum. Thank you Stephen PS I’m importing in from the Mac Desktop Client not via the Web Client.

Hi, I am trying to embed an Airtable view onto my website but it seems only four categories are displaying. I found this previous post but there was no answer to it, but it’s the same problem I am having. Anyone have any tips? Additionally, I want to know if there are any tips for messing with the CSS design for the card layouts. I can’t seem to find id’s in the inspect pop-up. I’ve seen websites that uses Airtable and I want to know how to design the layouts Thanks!

Hello. At this moment I’m using Airtable to keep track of my clients. We are a boiler service company. I ahve a main database and an appointments data base. Right now it works like this: when I eneter a new appointment it generates a new record in the main database, also generates an event in the google calendar and a new row in an excel spreadsheet. The problem is that if I modify something in the appointment database it won’t modify also in the main database. How can I do that?

Hi All, We are a group of engineers interested in building custom apps that can be integrated inside Airtable as we think Airtable has everything in it. According to us, it’s one application that fits everything. We as a group want to understand if there are any use cases on which we can build an app and place it on the airtable marketplace as a free open source app. All suggestions, ideas and use cases are welcome. Thanks

Trying to move records to another record by cut and paste. I use command X. It says its cutting. I paste into a 2nd base but those records are still in the original base. Am I missing something? Why cant I cut records out of one base? TIA

Hello, Is there any way to allow only some fields to be editable in a view ? Through sync’ed bases / views / anything? Regards, Ruchika

Greetings, I would like to know if this is possible in Airtable. I am looking to have a form. In one of the blank fields, the user will be able to select a date from a (Selection Options). Once the form is submitted by the user, I would like to hide or delete the option the USER selected from the (Selection Options) for the next person who will use it. I would like to know if this is possible or where can I find more information about it? The purpose of this is for me to schedule a meeting with the user and the next user would not have access to the scheduled meeting the user before already did. Thanks in advance!

Hi all, I’m trying to create a formula that helps me trim a product specific link to its root website link. For example, I have: https://freestar.co/products/12-x-bottles And want to get: https://freestar.co In some cases, the links are https://www. and sometimes they are are above (without the www). Could you help me out?

Hi guys, I’m looking for a way to build and implement a messaging app. This app should take the conversation log from a webpage and to allow the user to respond from Airtable, while sending his response back to the same webpage. Can anyone please guide me about the best way to execute this process? I thought of building a composer with React, but I didn’t got to the bottom of it. If needed, I’m willing to pay for consultation. Thanks so much for your help.

Hello Airtable community! I have been playing around with Airtable trying to send an automated slack message with either a list or a grid (grid preferred) where I can place different information from my table. This can be done when I am emailing, but for some reason on Airtable I receive a weird code. If there is no solution, is there at least a way where I can format my message to go out as a list? Please help me solve this! Best, Ines

I saw this formula on one of the tutorials on Airtable’s website and would like to use it but can’t figure out how to create the formula in Airtable. Can someone help me please? Thank you! I circled the formula in the screenshot below. Any help would be greatly appreciated!

I’d like to have a zap that takes a new lead of ours and creates/updates them in a base we have for leads. Within this base, we have a multiple select column that indicates the source of the lead. As leads can enter our world in many ways, we are looking to capture all the ways they’ve interacted with us prior to arranging a sales call, or becoming a client. I have no issues creating a zap to do this, EXCEPT when it comes to the source field which is the multiple select. Is there a way to ADD to the list instead of having the field wiped of what is already there and only showing the source provided by the zap that just completed?

I have created a form under one tab, when I add another tab could I duplicate the form I created before under the first tab?

Hi! I’d love to see a formula App that allows you to combine Summary app numbers together. This would allow you to add mathematical formulas (primarily adding, subtracting, multiplying, or dividing) on various Summary Apps. An example of this would be: Summary App that displays “2021 Spring Quarter podcast downloads = 20,000 downloads” Summary App that displays “2021 Fall Quarter podcast downloads = 25,000 downloads” Formula App to combine spring and fall Summary apps together (which would equal “2021 total podcast downloads = 45,000”) Doing it this way would make it so you only would have to make 2 unique views (1 view for “2021 spring quarter” and 1 view for “2021 fall quarter”) instead of 3 unique views (1 view for “2021 spring quarter” and 1 view for “2021 fall quarter” and 1 view for “2021 totals”).

Hello Community, i have a “problem” about shared view with my clients that doesn’t have an Airtable account. They can open the view normally and see data, click buttons and so on without any problem. The issue occurs when they click the button that opens a form to upload new attachments: the problem concerns the update of new attachment in the shared view, they need to reload the view to see the new attachment while in my view this happens in real time without reloading. Anyone have a solution? Thank you, Alex

I would like to switch from Pro plan to Free plan for a few months while it will not be getting used. I currently have several thousand records, far more than the free plan will allow. When I switch back to Pro plan will all my records still be there?

I use airtable to track legal filing deadlines, and calendar view is great for seeing who on my team is responsible for what, and on what day. Sometimes there are things that I’d like to show on calendar that aren’t related to a specific project or filing, though. For example, if someone is going on vacation for a week, I’d like my calendar to be able to show that, even though there’s obviously no project associated with it. Is there some way to manually overlay unrelated calendar entries onto calendar view? Thanks!

The SimpleScraper (go to simplescraper dot io) Chrome extension looks super powerful and useful for sucking up data into Airtable!

I run a company that sends qualified leads to hardware distributors. Someone gets in touch with us via our site, and pass on their information to four distributors (out of several dozen, we pick the four best ones). Every week, we invoice each distributor for the number of leads we’ve sent them. So the records for a given week might look something like this What I want to be able to produce, is a view that shows how many leads each distributor had, and how much they owe. So from this view above, it should return: Complete Vending Services | 2 Leads | £100 Full House Coffee | 1 Lead | £50 Esprada | 1 Lead | £50 Underdog Coffee Company | 2 Leads | £0 Caffia Coffee Group | 1 Lead | £0 GMS ESpresso Ltd | 1 Lead | £0 Help?

Hello, is there a way to not show the bar between the table name and the table itself - I call it “view bar” (red frame) for now. With “Shared base link” the bar displays. With “Shared view links” they don’t but also the option to filter / sort a column on the top row is disabled. What I need is the in between: the “view bar” hidden but with the opportunity to filter / sort on the top (header) row. Thanks for any advice

Hi, So I’m trying to have a single select field type of small mammal species of the world, that should have a list of more than 300 species to choose from; so when i select an option from this field A, i need a formula field B to be automatically filled out with the relevant ‘Genus name’ based on field A. I have tried using SWITCH, but I am allowed to enter a maximum of only 150 species. Is there a solution that would let me add 300+ options to the formula field, without having to create or link multiple tables?I have no experience in coding, so don’t know if this can be done using the scripting app? Here’s what the formula in Field B-‘Genus name’ looks like: SWITCH({FIELD A},"Hairy-footed Flying Squirrel","Belomys", "Namdapha Flying Squirrel","Biswamoyopterus", "Grey-bellied Squirrel","Callosciurus", "Pallas’ Squirrel (Red-bellied Squirrel)","Callosciurus", "Grey-headed Flying Squirrel","Petaurista", "Large Red Flying Squirrel","Petaurista ", "Spotted Giant Flying Squirrel","Petaurist

Hi all - Looking to create a formula where based on the Publish Date of a record, the previous Weekday will become the Due Date. The Publish Date also have a time associated, so not sure if that causes issues - but the Due Date field doesn’t need a time. Where I’m hitting a roadblock is making sure the Due Date is always a Weekday, so not requests are coming in as Saturday or Sunday requests. Thank you all in advance!

Y’a t’il un moyen de contrôler l’accès à une base par un mot de passe ? L’identification à Airtable est un peu limite pour la protection de certaines bases avec des données confidentielles. Si cette fonctionnalité n’existe pas, son développement est-il envisageable ? Merci pour votre retour ! Damien