Other Questions

I am using grouping in several of my views and I was looking at the “guide to grouped records” page from Airtable and saw that I should be able to hide no grouped records - so records that are empty in the field I’m grouping by. I went to do that, and I do not have that icon on my grouping dropdown. I saw that if I changed the field I’m sorting by to something else, it appears. The fields I’m trying to sort by are “calculated fields” and I only want to see the records in these views if those values have been calculated, otherwise I don’t want to see them. Any clue how to fix this on the grouping level or do I just need to filter them out? https://support.airtable.com/hc/en-us/articles/221747587-Guide-to-grouped-records#:~:text=Once%20you’ve%20grouped%20your,or%20hide%20no%20grouped%20records. This is where I saw that as an option, at the very bottom.

Hi all, I’m trying to figure out a way where we can manage comments or mentioned. For example, currently, when someone mentions me in a topic/entry in a comment. I only see it on the activity tab on the home page. Is there another place to see all mentions? Can I build a dashboard or a table to manage that?

how do i fix this bad view on mobile mode? tks

I’m making a small CRM system, and trying to figure out if there is anyway to send messages with Instagram via Airtable? It seems possible to connect the two together with Zapier or Integromat, but can’t seem to figure out how to send messages.

How do I calculate for how many records the status changed from New to something else and the count number can be shown on the chart?

Hello all! Thank you all so much in advance for your help. I am brand new to Airtable. I am incredibly excited to use it as I see so much opportunity here but I’ve found it overwhelming and intimidating to get started. One of the first things I am trying to do is track my startup investors, specifically how many have invested in different rounds and what their total investment is. To simplify it, the first column would be Investor Name, second row would be Investment Rounds, and third column would be Total Investments. Lets say I’ve had 5 rounds of raising capital. If John Doe invested in $100K in Round #1, $150K in Round #3, and $200K in Round #5, I’d want those 3 to be listed under Investment Round and on Total Investments to add up his total investment of $450K. Can someone please help me do this? I have created it with their name and I have a 2nd column that lists the different Rounds that they have invested in. I was able to do this by creating a new table called “Rounds” where I

I currently have a membership database in ACCESS and the membership number is the primary key. I want to get this into Airtable and keep the current membership number as the primary field so that it auto increments when a new record is added. I have read the article " How can I change the primary field in my table?", but it does not work. Or is there some other way of ding this? Thanks for your help. Mark

We are a charity that uses Airtable for client management. We collect demographic data of our clients and then link their profile to the dates when we have contact with them. We hold cases for 6 months and review them at the mid-point, i.e. three months. The contact dates automatically link to the client’s record through the linking process (AUTO Contact D in the screenshot). I want to create a field that automatically calculates the review and close dates for each client. I thought a combination of LOOKUP and a FORMULA might achieve this but I’ve not found a way to do it. I would greatly appreciate some guidance.

Is it possible to show lottiefiles as Airtable? In Aitable’s Apps, there is a JSON editor, but you can use I can’t get the JSON to be displayed properly. I want to display lottiefiles, but can’t get JSON to be displayed? lottiefiles.com Featured animations from our community Featured collection of Free Lottie Animations created with Bodymovin.

Rather is shoudl ask , if you’d like to open the app! Heres the screen shot. fyi : the search app is already installed.

So, I am using a base to manage travel information for a group of people. I currently have 3 tables - one for Passengers, one for Flight Reservations and one for Flights. What I would like to do is create an Itinerary in the page designer that shows a single passenger with their corresponding flights, as well as the information for those flights. I have been able to create a page with the passenger name, and their flight reservation and flights, but I am stuck not being able to get the flight information on the page. For context: The Passengers table has their personal information, contact info, etc… and is linked to flight reservations through the passenger primary field (their name). The Flights table is then linked to the flight reservations table through the Flight Reservations primary field - on the Flights table, I am able to lookup the passengers on each flight. I am wondering if there is maybe an intermediate table that I need to create to do this?

I can’t figure this out. Please help.

Hi Team, I am using Airtable automation to create a record on a different Table after a Form is submitted. Everything works fine except when I try to use the automation on a multi-select field. In the Action section I’ve chosen a field that is a multi selected. It seems that it only allows me to do a new list instead of taking the values across. When I test the automation I get the following error. Can someone help? Thanks.

Hi there! I want to create a search tool to embed on my website that would allow the visitors to search in my Airtable records. …is this possible? Thanks,

I have differnt bases for diffent types of leads, like LA leads in one base, NY leads in one base. I Wanna be able to see all the nation leads in one base so as to eliminate duplicate records or do more research because two leads can be of same company and I want the records at same location to quickly do some research.

We want to be able to see the bird eye view of the company information like revenue, profit, comments. company name, employees, etc Kindly let me know if that sorta template exist .

I’m trying to figure out if the “Lightning” symbol synced records will add to the 50k record count.

Hustling bookseller’s back. So I inherited thousands of books from my dad, and he, erm, didn’t have a lot of foresight when it came to the way keywords would be used in searches – especially not on Amazon, which has a standard set of keyword values that are permitted to booksellers. What I want to do is create a formula field that looks at Dad Keyword “AMERICANA #7833” and renders only AMERICANA, leaving off the useful-only-to-Dad random characters. Sometime he’d stick in letters, punctuation – I have no idea what he was thinking (but bless him, he knew how to find good used books). What kind of formula might work here? Thanks in advance to anyone who takes a crack at this!

I’m having a random issue and I’m not sure why. I have some forms in page designer and one of the fields is a formula that calculates today’s date, so when the letter/form is sent it has the right date at the top. For some reason, it is pulling yesterday’s date. I’ve tried refreshing and reloading the page designer forms, the whole website, etc. It still is showing the wrong date, but the formula column on the table is correct. Why is it pulling yesterday’s date? I’ve included some screen shots to show what I mean.

This was brought up a few times over the last couple of years, but it would be nice to have this ability to have this exposed on a form. This adds the flexibility to allow users of the form to add what is needed. If it could be turned on when needed that would be great!! :grinning: Or add another type of single and multi select that would allow this functionality.

Is there a way to query a range of records provided by the API? I’d love to be able to cache the first 500, then load subsequent records on demand. The current pagination flow makes this difficult since the offset seems to be unique to the time it’s called. I’m looking for something similar to this SELECT * FROM table limit 500, 600

Hi lovely airtablers! Just a quick and simple one I hope? How would I create a field that automatically denotes whether a record is a duplicate on a single field only? I have orders that share the same order code and I’d like to know which line items are part of the same order. This duplicate field could be a checkbox or a single text field and should denote all records that are part of the same order code. Any help would be gratefully received. Thanks Claire

Bookseller here trying to survive by listing on Amazon. I have lots of books that are so old ISBNs didn’t exist when they were published. For those books, Amazon offers what they call a “GTIN” exemption. So I have two fields: (1) a single line field called {Product ID}, which contains an ISBN if available, but is, otherwise, left blank; and (2) and a formula field called {Product ID Type}, which needs to contain “ISBN” if {Product ID} is NOT blank or “GTIN” if {Product ID} is blank. I have no idea what might work here. Fingers crossed that one of you do. :slightly_smiling_face:

Today is a HUGE day, and I’m very grateful for all of the hard work that the Airtable team has put into sync. Thank you. Now that this magical day is finally here, I’m wondering what the easiest and most reliable way to integrate a synced table into my existing bases. Currently we have the following (3) bases: Main Base MB - contains source-of-truth table for all projects called Jobs Consultant Base CB - contains information for consultants Internal Base IB - contains information for internal project management Both CB and IB currently have a subset of the Jobs table. That subset table was manually created in the absence of Sync. How do I most easily integrate the sync’ed Jobs table into CB and IB? There are almost 1,000 records in the subset tables in CB & IB that should now use the synced Jobs table instead. Thank you!