Other Questions

I’m using a script that generates a QR code as an attachment. Here’s the structure. The script that I use (shared by someone here) will: 1. Generate QR codes for the record as an attachment. 2. If this record already has an attachment, skip it. // Change the names of this table/fields according to your base. let submissionsTable = base.getTable('⚙️ Realizacja'); let urlField = submissionsTable.getField('barcodes4.me [URL]'); let attachmentField = submissionsTable.getField('QR Customer'); let submissionsQuery = await submissionsTable.selectRecordsAsync(); let updates = []; for (let record of submissionsQuery.records) { let url = record.getCellValue(urlField); let attachments = record.getCellValue(attachmentField); // If this record already has an attachment, skip it. if (attachments !== null) { continue; } // Otherwise, attach the image at the URL. updates.push({ id: record.id, fields: { [attachmentField.id]: [{url: url

I am making a base for food production. I have a tab with all the data on barrels (filling, emptying and so on) and I need one of the views to show only the newest entry based on date but I can not figure out how to do it

Hey there, We built a Mail Merge add-on for Airtable. Check it out! You can send personalized emails based on information in your base. It’s open-source (< 30 lines of Python), so you can edit how the entire add-on works yourself too. Here’s how to enable it: Step 1 Install Blockspring Scripts for Chrome. Step 2 Go to a base. You might need to refresh the page once you get there if you just installed the extension. Step 3 Click the icon in the bottom left to open the scripts editor. Step 4 Import the “Mail merge” template. Step 5 Wait for the template to install. This may take a bit the first time. Step 6 Sign in with Gmail. Step 7 Close the editor then click on mail_merge in your base. Step 8 Fill out the form! You’ll need to select a column of emails, enter a subject line, and then write your email template (check out the video below for examples - it uses the mustache library). Here’s a video showing how the add-on works. Enjoy! And shoot us some feedback once you get a c

Hi all Is there any way of blocking a card from moving to the next stack until a checkbox field on the card is ticked? We’d like to make sure a number of checkbox fields are ‘done’ before a card can be moved to the next stack. Thanks - Jon

Yes I’m new. I have created a base with a table of all sales transactions, one item per line. So for example, an order with 4 different items would have 4 records, each with SKU, quantity, price paid, order date, etc. In the grid view, I’ve got a filter set up to specify an order date range, and I created a group by SKU so that we can see the total sales for each item. I want employees to be able to view the file, set a date range, and print it if necessary. However the filter is not available in the view share, and all roads seem to lead to being at least a full base collaborator to be able to set the date range. That’s too much, um, power. Am I missing something about sharing, or is there a better way to specify the date range?

Hi there! Does anybody know if there’s a way to specify more than one email domain when providing access to a view? Our company uses three different email domains due to how our organization is organized. Thank you.

I use Elementor Pro + Dynamic Content for Elementor to make forms for websites. With it, I can make style forms so that multiple fields appear on a single line and so that there’s less space between lines – which would make the bookseller form I’m creating way less intimidating to my data-entry partner. Can I use the Export feature in my form to get the data into Airtable? And if so, what should I enter into these settings to make it work… ENDPOINT URL: PORT: METHOD (GET, POST, or HEAD): ENABLE SSL CERTIFICATE VERIFY (Y/N): I really hope someone here has answers, because it’s far harder to get support from Elementor and Dynamic Content than it is to get support from Airtable and its community. Also really hoping the only answer is NOT Zapier because I can’t afford to add more Zaps to my account there. :grimacing: ETA: Alternately, is there a way to style Airtable forms from within?

Good afternoon, I created a duplicate copy of a database I use and excluded all the records. How can I now “send” that database to another person? Obviously, they would need their own Airtable account. I’m looking at the share options and a little confused. I won’t need any access to it upon sharing, I’m basically giving someone a copy of my empty database, for their usage. Thanks

I am considering using AirTable for a project sponsored by the European Research Council. However before making a decision, we need specific answers to basic questions: Does AirTable own any rights to data stored in it? Where are the cloud servers physically located? There are possible issues if data is stored outside of the European Union. What happens to the data should AirTable go out of business? Can data stored in AirTable be made to conform to the European Commission’s FAIR principles? https://www.openaire.eu/how-to-make-your-data-fair Can an AirTable be made open access? I am a bit concerned that I have been unable to find any link to any AirTable site where these questions can be asked of the company itself.

Airtable just updated (at least for me, don’t know if it’s an A/B test) the way you edit field types. Previously, if you double-clicked the field header, it opened a prompt to edit the field name and the type/formulas. Now, if I double click it it only let me edit the name. To change the field type/formula, I have to right-click it and chose “Customize field type”. Personally, I think it was a really bad change and a less practical UX. What do you guys think?

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 table. Anyone knows formula for that or could help me with ideal how to solve this?

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(recordMyTable2)) }) Thank you so much!

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 properly track latest changes, which job n

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