Other Questions

Hi Airtable Friend, I inherited my dad’s small bookselling business (26,000 books) and have been organizing his records into an Airtable base. Jumping ahead, I started googling how to embed a table view of this base onto a website and I can’t find anything that explains how to make this embed searchable and filterable. Potential customers aren’t going to want to scroll through 26,000 book records to find books they want. Any guidance and/or resources would be much appreciated because, without this, I’m afraid all the time I’ve already spent on this Airtable base has been wasted. I do have the paid version, in case that opens up more relevant possibilities. Thanks in advance to anyone who can point me in the right direction!

I have a table (Donation Levels) that lists donor levels: Column A lists the level ( ie: Patron, Benefactor, etc). Column B lists the dollar amount of each level ( ie $250 for Patron, $500 for Benefactor, etc) In our Donor Records table I have a lookup field for the Donor Level that pulls from Col. A, and then automatically populates the Donation Amount by pulling from Col. B. So each time I record a donation, I enter someone’s name, pick the Donation Level and then the amount fills automatically. However, we also have the option for someone to donate an amount that is not listed. If I choose “Other Amount” from Col. A, then of course the Amount that is pulled from Col. B is blank. So what I would love to do, in that case, is to type in the amount. Is this possible?

Is it possible to nest dates from 4 different tables in one column? I would need something like that: snipboard.io Upload and share screenshots and images - print screen online | Snipboard.io Easy and free screenshot and image sharing - upload images online with print screen and paste, or drag and drop. I have already rolled up dates and linked to other records but I can’t link to more than one tabl

Hello Airtable fans, I use Airtable to manage a very large collection of recipes. There are often times that I would like to duplicate large numbers of these recipes so that I may change them slightly. It’s become very time consuming for me to duplicate each recipe one by one and assign a new ID to them. As a work around, I create a CSV with the original recipe info, change the ID and then re-upload to create new records. Is there some other way to do this? Has Airtable ever considered a batch duplication feature? Thanks! Leslie

Automation doesn’t trigger any runs although test goes OK and even performs the triggered action. But after that - no runs I’ve been using Automation for a month, it went good. Anyone has similar issues?

Hi there, I found that when I read the gallery cards in the share view, there is a unique URL link for each card. May I know is it possible to retrieve the direct URL link of each gallery card? If yes, how?

Is there any way to color code web clipper action buttons in the Chrome extension? For example: I have a few actions that are for personal things, and a few for work. I’d love to have two colors so it’s easy to use the corresponding, correct actions.

Hi everybody, I really enjoy Airtable but I need help ; I tried to search into the forum without being able to find a solution. I have different tables structuring a kind of OLAP application (entities, customers, Phase, Months, etc…) In a Data table (used to import datas), I tried to merge data by selecting an unique ID created with formula (association of 4 datas). Unfortunatly, Airtable does not allow to select the result of formula as identity My table has significant number of colums and an only selection is not sufficient to make the job. At last, I am not at all, an expert in scripting to automate this process. Do you have any ideas, suggestion to help ? Thanks a lot

Why this error appears? When I press the button, I want to make it connect to that url. plz help me

I downgraded to a free plan yesterday but a few hours later I still got charged for the new month. Need support team help but can not find the support team email address? From the FAQ articles, it guides to click “help” then “contact support”, but while I do this I only see a robot chat pops up. How can I get the refund?

Necesito ayuda para una base para organizar consultas medicas.Gracias

Hello, I have two tables (“Table 1” and “Table 2”) that are linked on a single field (“My Field 2”) with a many-to-many relationship. I’m trying to write a script to gets all of the records from the table Table 1 where the field My Field 2 does not contain a particular linked record from table Table 2. I know how to write this script normally, but because field My Field 2 on both tables Table 1 and Table 2 allow linking to multiple records I know that I need to use an array in the filter in my script and can’t seem to get that part correct. Code is below. If someone could help me get the array correct in the filter, I would really appreciate it! let tableMyTable1 = base.getTable("MyTable1") let queryMyTable1 = await tableMyTable1.selectRecordsAsync(); let recordsMyTable1 = queryMyTable1.records.filter(records => { !(records.getCellValue("MyField2").includes(recordMyTa

Hi there, We’ve just started implementing Airtable to facilitate job workflow between Design and Marketing departments. I’m curious if anyone has suggestions for best views that individual designers can set up to track their own jobs. View filtered to jobs assigned to them - got it. View filtered to initial due date - got it. Status field (to know if it’s in for design or out with Marketing) - got it. Beyond that, I’d love for all of the designers to easily be able to track when a job bounces back and forth between design and marketing. After the job has been sent out for the first time, that initial due date field is now irrelevant, so only sorting by that field will not properly sort jobs in a helpful sequence after a week or 2. I set up a “last modified” field so I’m testing out the usefulness of that. It seems to have potential! Thought I’d see how others are keeping track of jobs that have frequent back and forth, and setting up views to

Hello everybody! I’ve been using Airtable to manage an iPad inventory in an 1:1 environment at my school and I’m quite happy with the result. Awesome product. The thing is that, up until now, I have been storing iPad and student data in just one of our tables. Device iD - Device data - Student ID - Student data But this year some iPads are gong to change hands. Of course, I could just the records by hand, but it’s clear that it would be more elegant having two different tables and linking them. Table 1 Device ID - Device data - Student ID Table 2 Student ID - Student data My question is: Is there a simple way of doing it? I’m afraid I will have to create the two tables and link every record, one by one. Thanks in advance!

We are considering buying a Pro Account, we are not sure we can procure accounts for all users. If we layout Airtable using the proaccount, (including colors) can that still be accessed by free users? Please let me know. Best, Majella

Hello Airtable community! As many of you, I am really excited by the new sync and automation features but I am stuck. This is my first question so I hope I will be clear enough. I am working for a distributor and I manage 2000 product information (tech sheet, product description, photos…) from 80 different vendors. Some information can be sensitive so I cannot let my vendors access the data from other vendors. Since it is not possible to give a specific access to the Airtable base, I looked into the ‘portals’ proposed by Stacker or MiniExtension but the features are too limited for my need. So, I created one base per vendor so they can upload their product information and I synced them into one master base. But now, I have 80 different tables ^^’. This is why I would like to create an automation to gather all those product information within the same table. Do you know if it is feasible with Airtable automation? That would help a lot! Thank you,

I would like a record to be automatically updated with a text string equal to the name of the view. To be clear: If a record is visible in view, then (over)write the name of the view in the “view” column.

Hi Everyone, Very new to Airtable but I can’t find the answer here on how to solve my issue. (I’m sure I’m just doing something wrong)… I’m trying to convert a mm measurement into a UK shoe size (293mm == UK Size 10) I have a customer consultation table which takes in a mm value - I’d like it to lookup that input in a separate table and then return the UK Shoe size and add it to the consultation table (to save manually going back and forth). One issue is also needing it to ‘round up’ the mm field (UK size 9.5 is 286mm so 287,288,289,290,291,292 & 293 are UK size 10) Is there a way to do this?

I am trying to build a software for investment realestate. I have 2 data bases. One is my buiding the other is my clients. I want to see : 1) For one building all my relative clients and 2) For one client all my relative buidings There are 5 common criterias for each client and each buildings. These criteria are %, and text fields which are choose among a multiple choice Ie A client can search Office, wharehouse etc… But a building has alway on main destination Whare house (sometime 2 but it is rare) How can I match that in air table ? Is it possible ? Thanks for helping

Hi, the title says it all. I’m looking for a way to integrate an airtable form into a webpage where visitors can download a document. But before they can do that, they have to let us know who they are. Can I use airtable for this? Kind regards

I have a single select field “Day of Week” with Mon, Tues, Wed, etc, etc. I would like to be able to sort my table in that order - but it seems like we only have the option to sort alphabetically (which results in an incorrect order). Once this table is ordered properly, I’m assuming that order will refer over to the linked field in my other tables - is this correct? Is this sorting possible? Thanks for the help

Hello. I’m trying to create a zap with zapier that will trigger when there is a new airtable record in the view, and then it will post it to my social media. The problem is that I want to import the csv to the table instead of doing it all manually, but I can only import my file to the view when I create a new table, but if I’ll just create a new table with the csv already imported and then turn on the zap, it won’t post all of the imported content. So I want to create a filter that will clear the view, then turn the zap on, and then I’ll remove the filter. So I was suggested to create a filter something like this: one of the rows in the table: contains: eg: skdjfhksdjhfkjsdhfk But I didn’t understand how this will work and what should I write instead of skdjfhksdjhfkjsdhfk and instead of the example row in the table because he said I should write skdjfhksdjhfkjsdhfk but he sent a screenshot with kajdfhkjadfkjahfs So I don’t know which o

Hey Airtable Community! I’m currently trying to create a formula that can show me the highest performing employee at any given time based upon the total revenue produced by said employee. I currently have a Table within my Workspace titled “Employees” where I’m able to sort by the highest-performing employee by using a rollup from my “Customer Orders” Table. However, there is a table called “Clubs” where I want to be able to show the highest-performing employee in a separate field driven by a formula that reads a rollup of Employee-orders. Please refer to the photos below for more context: As you can see, each order placed within the club deposits to the “Clubs” table within the “Customers” linked records, along with a Lookup field showing the name of each employee responsible for each sale. I want to write a formula that counts the number of instances of each emp

Hi! You can see from the screenshots that my export as CSV does some crazy stuff to my records. Ideas on how to fix?

Hello everyone, I’m wondering if someone might know how to help with this. I’m looking to paste a LinkedIn URL into a field in a new record, and have this event trigger an AutoFill for the rest of the cells in that record, sourcing the data from the relevant fields at that URL? Example: Paste URL for User A Source and AutoFill: First Name Last Name Profile Picture About Me Section Phone (If any) eMail (If any) Company(ies) Job Titles etc. Is there any way to create an (automation/integration?) to AutoFill fields with data sourced from these kinds of specific fields on LinkedIn, or any other website? I hope this isn’t too complicated, this takes forever to do manually, ha. Thanks everyone.