Other Questions

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 2n

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!

Hey Airtablers, I’m trying to create a base that tracks expenses and income, but between a few people. For simplicity, let’s just imagine it’s a cofounder and who just started an online business and we need to track our expenses (a 50/50 split), and our income (also a 50/50 split). For reference, here’s what I have so far: https://airtable.com/shrC0MHyoAl0PJoBV What I’m trying to build is a base where we can easily see and keep track who owes what. At the end of the month, we should do some reconciliation so that my cofounder’s expenses and mine are equal (hence the 50/50 split). I had a similar (working) setup on a LibreOffice spreadsheet, but I’m trying out Airtable for this to see if I can build something a bit more intuitive. (Gonna give the Form view a shot as well so we can enter these expenses more easily.) Ideally we’ll want to do some more advanced re

Hello. Two weeks ago I had introduced two newbie basers. It made me want to create a way to introduce new users to each other and airtable. Yet I wanted to influence people outside of vertical base talk. We are at an inflection point and I want people designing lives, community networks and inspiring each other. So I created an event! 600 People have signed up 14 Speakers 3 Vendors The event will be streamed live (if I can get it to work) and last from noon-5pm EST (GMT -4), this Friday, Sept 18, 2020. Chris Dancy

What time are the free trainings? Are they conducted in EST? I am in CST and would want to convert the time. Thank you- Tracy

I’m trying to develop a short survey that is also functionally a database? So ideally when people enter a longform text answer, they can also add a “category” to the answer that is a single select from a list. Then we need to sort based on that category, so the user sees their own answers sorted by the categories. I can design it pretty well in airtable, but can’t seem to fin a way to connect it to a website or form platform so that a user could use it from the front end effectively. Is this possible? TIA!