Other Questions

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!

The export to PDF creates a very small print chart for a Project of 23 tasks spanning over 6 months. A. Is there a way to save the chart for viewing by all collaborators? B. Is there a way to split the print by dates? I need to be able to share this with my client and team.

Good morning! I just recently signed up for the Pro Version, and one of the main reasons was the Mapping Block. I am totally lost when it comes to setting up the API. Is this something I’ll have to pay for as well? I have no idea how to set this up and what it’s going to entail as far as ongoing use. Any help (in layman’s terms) is very appreciated.

I’m trying to create a “depended on by” column in a gantt that will automatically pull all of the tasks (text field) for which a given task is listed as a dependency (linked field). For example, if task 1 is listed as a dependency for 5 other tasks, I’d like this new field to automatically list those 5 tasks. Does anyone know if this is possible/how to set this up?

Can anyone tell me how to print out my hundreds of poems once I finally get them tagged and sorted into books? They vary in length from 4 lines to 140 lines. Page Designer seems to give me ONLY a fixed height field, nothing automatically expanding or contracting to show the whole poem and nothing to go to an additional page. I found this thread. Is this really a dead end? It seems like content management and printing would be essential features for Airtable.