Other Questions

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

Hello everyone, I'm new to AirTable, about a week in. I originally became interested in AirTable due to an outdated process used by the company I work with. My concept was to use AirTable to be able to keep track of Critical Loops (Our businesses term for Freight Claims and problems with shipments) I’m trying to learn more about this program, I’ve already found tremendous use from it, but I had a question, being new to this program I’m still trying to learn the ins and outs as I’ve never used something like this before. Within our company we have 3 planners, (These are the individuals that are responsible for the vendors that ship up raw parts) I’m trying to find a way to link the 50+ vendors that each of these individuals have. For example when we file a Critical loop we input the supplier name. Is there a way to set it up that when a suppliers name is put into the record, that it automatically tags the planner that’s responsible for that vendor. Thanks.

Hi all, I have developed a management tool where I have all the information about trainings, trainers, students and program managers. I have all the sessions of each program in a table so I can create a Calendar View to manage dates and times in one view. Recently I started to share with the students the “Sync to an external calendar” link to add the schedule of the sessions so if we change something in the schedule they are up to date automatically. Everything is working well. In the description of the event in the ICS format Airtable dumps the link to the record. I would like to remove that friction to students so they have all the information in that description field. Is there any way to personalize the information shared in the event description? Thanks in advance. Cheers.

I’m not very tech-friendly, so I’m not sure what the best way to go about this request would be - any advice is very much appreciated! I keep all of my orders in a table - each individual birthdate is imported with each order in its own column (DOB). I would like to find a solution to automatically update a separate column (ZODIAC) with the corresponding Zodiac sign depending on the day/month of birth. I can’t seem to make it an automation in Airtable with if/then parameters because I can’t select a date range without the Year included. Does this make sense? Any tips? Thanks in advance!

Is it possible to create permission groups for users? Right now my company has a pro plan workspace that has a few bases that we do not want to share with the broader team. What the means is every time we hire a new employee, we have to individually add them to multiple bases since we can’t invite them to the entire workspace. Creating multiple workspaces isn’t an option since paid plans only apply per workspace. Ideally, base access would be set at the team/group level and users could be added to those teams/groups. How do other people at companies with growing teams manage this?

Is that possible to create a view that put together data from 2 different table like join tables in a select?

Is there a way to show a dotted line relationship in the org chart app?

I have a database of things, which all have measurements. Sometimes one item will share parts with another item. I was wondering if I could take the measurements from one item (which is a linked field) and populate the measurements fields in the variant item. Basically, when someone is filling out the form view and they select a record to reference (which is a linked record, as they can only add already created records from a dropdown), it will take the measurements from that linked record and add it to the record that is currently being created. Record one: Car Name 1 Car Body 1 Car Measurements 1 (separate fields for height, width, length) Record two: Car Name 2 Linked record to “Car Body 1” (because they have the same body) Measurements auto-populated from “Car Measurements 1” into the blank height, width, length fields.

Hi again, An issue I’m having is that when I go to a view shared via a private link that has already been grouped, one or all of the groups seem to be expanded by default even if I collapse them all in my workspace. Is there any rhyme or reason to this? Thanks, Blake

My next one seems trickier. I have a Sales data sheet with multiple lines of different data for the same products. A new line is created for any difference in sales variable (Annoyingly) for instance. lets say Line 1: Product 1, 10 sold, on Domain#1, for £5.99 Line 2: Product 1, 3 sold, on Domain#1, for £2.99 Line 3: Product 1, 5 sold, on Domain#2, for £5.99, with 10% discount Line 4: Product 2, 9 sold, on Domain#2, for £5.99, with 20% discount Line 4: Product 2, 3 sold, on Domain#1, for £9.99, with 10% discount Is there any way to create a single record for each product with all the variables?

Hi guys, I am having a challenge connecting my Google Sheets with Airtable. I have done a screen recording here for proper context. Thanks.

Hi all, One of the fields in my base is date/time, and I want a particular view to filter results to exclude anything created in the last hour (as an example) - what’s the best way to achieve this? For context, all records in my base start out as a particular lifecycle status, I’m trying to capture the ones that get stuck in the first status for more than an hour. This would give enough time for the records that move more slowly through the statuses to be moved on and not appear in my filtered view.

It appears that I’ve merged some records accidentally and lost data. Is there a way to undo this? I’m looking at the record history and don’t see the old information, unfortunately. In this screenshot, this record should have more than one hour of history. (Edited to remove identifying information)