Other Questions

Hi! I’m new to formulas, and I can’t figure that one out, even though I’m sure it’s pretty simple. I’ve got a table with a multiple select field, and I’d like to know at a glance how many of these multiple selects were selected in each row, so I’m making a formula field COUNTA ({name of multiple select field}) but all it does is tell me 1 if there’s something in there, and 0 if there’s nothing. It doesn’t count how many items I’ve selected. Can anybody help me find the right formula? Many thanks in advance!

has anyone tried to to zap a record from airtable that has an attachment and move it to Evernote via zapier? there are so many attachments fields associated with airtable, I think I have tried all of them but no luck moving an attachment to Evernote

If you link to an image on the web (or through dropbox or google drive) does it still upload that image into your airtable storage space? In other words, does it count towards your data limit?

I came across an issue recently where a linked record column in table ‘A’ without the option to allow multiple linked records, still contained some records with multiple links to records in table ‘B’. Upon researching the matter it turns out that when you duplicate a record in table ‘B’ it duplicates the entire record including the column tracking the reverse link to records in table ‘A’ and therefore causing the record in table ‘A’ to now contain a second link to the newly created record. I understand why this is happening, as duplicating the record in its entirety includes the linked records column, however i am not sure this is the correct behavior, certainly if it violates a constraint added in another table

Does anyone else think its stupid to have the view selected in page designer auto default to the view you are in?! !@$#%L# once it set it it should STAY! never have i needed the selected view of records that a page is designed for to CHAAAAAANGE! unnecessary functionality that probably took way longer to build than it would have to do it correctly!!! rant over. maybe im the only one but i print at least 1 wrong batch every time because of this.

Hello! I’m looking for the ability to create colored fields (colored rows too) and have them be the same color in that row. I have a large table and I need certain fields to draw the eye. I created a couple of single select fields which I’m settling for until Airtable [hopefully] comes out with a better option but my question is, is there a way to make all single select fields in the same row the same color? Right now if I want to do that it would be a terribly long [and painful] manual process of changing every single select field in every row. If this option is available I would LOVE to know about it, if not, Airtable is it something that is in the works? Thanks!

In November, I contracted with a small IT company, Deytah, which I located through the Airtable Community to develop a specialized map app that our nonprofit research project needs that would consist of an interactive, georeferenced map of medieval cemeteries that associates specific graves on the map with entries in AirTable. Deytah produced an almost complete app, currently in github, (GitHub - deytah/airtable-app-polygon-mapper: Display and edit GeoJSON geometry with Mapbox in Airtable) that filled almost all of our requirements. However, before completing the final adjustments, the company simply vanished: Since December 21, we have had no communication from them and have been unable to reach anyone associated with the company. We are looking for someone with knowledge of React and AirTable who can make the final adjustments and corrections to the app.

It’s as basic as can be. I created a view, created a shared link/embed, lock the view and then try the links and or embeds on another system (not logged into Airtable). Regardless of the lock setting viewers are able to see and interact with Filters, Groups, HIdden Fields, and sorts. Here’s a test table that reacts exactly same as all others : Airtable - Grid view Additional Info : Using the embed code kinda works. On the webpage, the iFrame does limit interaction, however the “View larger version” allows full access to the Filters, Groups, HIdden Fields, and sorts. Thoughts?

I am encountering something strange- a checkbox brought onto my sheet from another sheet in the same airtable book is being recognized by formulas when it is checked, but is not being recognized when unchecked. The field is called 'Exclude" and this formula works: IF((Exclude),1,0) and it returns a ‘1’ for all records where exclude is checked However this formula does NOT work- it’s returning a 0 for every record IF(NOT(Exclude),1,0) I tested the exact above on a boolean checkbox that is a field on the sheet itself (eg, not brought in by lookup), and the IF and the IF(NOT( both work as expected Is there something about the way a lookup formula treats un-checked boolean values that is not returning valid data? when accessing the same field via an API I get FALSE for the unchecked rows, however in airtable’s own formulas, it’s not recognizing it as unchecked . Stumped, and need some help, thx!

I’m trying to copy and paste content out of PDF files generated from Airtable Page Designer Block and having problems. Opening the pdf in illustrator reveals that there is no text content in the PDF, just vector elements. Am I missing a setting here, this would lead to huge PDF files that are fairly useless for sharing data. Anyone else notice this?

Hi everyone! So, I’m having a real problem here and I don’t know how to solve it. My Airtable base receives data from clients/users using, of course, the Airtable form. The problem is: you can’t limit or restrict what the user is sending as a attachment. (IMO that’s a HUGE flaw, not only because isn’t safe but also compromises the reliability but that’s not what I came here for). What I think it may work is: maybe I could run a script that verify the file or files in attachment field and deletes if that type of file isn’t in my whitelist (PNG and JPEG). Yet, I have not a single ideia of how to build that script, beside knowing that has to be in Javascript. Also I don’t even know if it is feasible. Has anyone ever tried that? Does anyone knows somekind of workaround?

If I set a field to be required AND only visible under a specific condition and that condition is not met, will it stop the form from submitting because a hidden field is set as required? It sounds stupid, but I literally ran into this only a couple months ago elsewhere with a form builder product that will go unnamed… but it wasn’t smart enough or well engineered enough to know that if a field is hidden, it shouldn’t be required unless it is visible no matter what. So then it would output a validation error telling people “You need to fill in field XXXXX” and they can’t see the field or even know it exists. Super poor UX there. I could probably test this and find out but I figure I’ll ask here in case there’s something functional I may be overlooking or additional info.

I am trying to search for records in Airtable from Integromat and unable to figure out how. I have created a scenario where I get a unique id to be searched for in Airtable via a webhook. After linking the webhook to Airtable, I selected the option “Search records”. There is a field called “Formula” and I am not able to figure out what it means.

Curious to know if it’s possible to batch upload new records (via Excel sheet) into an already existing table while using the Grid View? Trying to figure out if there’s a way to do this without having to manually input each new record one at a time using the “+”. For context–my team is using our base to track program participants and we’ll likely be adding new participants every quarter. We’re hoping to avoid having to manually input new records each time. Any info would be appreciated!

I’m looking at migrating museum collections records in a Filemaker database to Airtable. We have close to 30k records in the inventory. I consulted Tim Dietrich’s post on migration from Filemaker to Airtable but there’s no mention of images being migrated. I have 1-3 photos linked to each record and close to 30k records to migrate. Had anyone had success migrating images along the data? We can’t manual link images each record. Thank for your help. Dorota

I got two relate tables (bases). table A with fields including a field to pick up date(s) fields from table B (multiple dates) table B with date fields (column). I need to insert a formula fields (column) with result the last date (1 result) from related table B. Example in base A in the field “dates” i’ve got 5/11/2016, 6/11/2018, 9/12/2017 (picked up from tabel B) In base A i need a formula field “last date” with the nearest (or greatest) date 6/11/2018 How can i get that? Thnak you

Hi everyone, On the linked table, I am struggling to figure something out. First, I should clarify the table’s purpose. I want to visualize related pieces of content from different POV’s. Example: in the Category column, when I mark something “security cameras” I then also mark the column beside it (“associated categories”). These “associated categories” are other categories (per the Category list) that possibly have overlapping content with the “security cameras” Category. My goal is to start by looking at “security cameras” with all its associated links (see the “link” column) and then also visualize the links from all the other “associated categories.” My primary goal here, if it helps, is to count the number of total links (content pieces) I can pull from. Right now, the best solution I have is to manually filter the Category column, starting with my main category, and then adding all the other ones after it. This is okay, but I know Airtable’s capabilities can do better, and I’d a

I have 2 bases for 2 different parts to handle, I sync the invoice table to base constract and constract table to base invoice. When the base contract creates a new contract it will be synced through the base invoice. At the invoice table, the base invoice I link the record to constract no, and when I create an invoice that attaches the contract code, the contract information will be synced through the base contract, but one thing is the Invoice column no. it does not automatically show the corresponding invoice code. This is picture illustration: air|700x432 I put the 2 base test link here: Invoice ( Sign up - Airtable ) 2.Constract ( Sign up - Airtable )

I have a column which automatically brings ‘time duration’ information from RescueTime through IFTTT which has a string format such as ‘3h 35min’ or ‘28min 52sec’. Since the information is saved as a string format, I would like to create a new column which converts this string into duration format. AFAIK, the datetime_parse function of AirTable can recognize only one format. Is there a method to recognize multiple string formats as in the above examples? Thanks.

This may sound like a silly question but is there a shortcut to enter a new record? I have tables that are sometimes hundreds of records long and don’t want to scroll to the bottom just to click the plus sign to add a new record. Also trying to avoid using the context menu to insert a new row. Is there no quick add button anywhere at the top or did I miss it somewhere?

I have a group that uses a function (eg. “determine the quarter based off the date”) to group the table (output is “Q1”, “Q2”, etc) Unfortunately once grouped, and because the grouping relies on a function, you cannot from that view add a new row of data. To add data, you have to switch to an ungrouped view, add a line, and switch back…a very clunky workflow. It would be nice if we can add data to a table even when viewing it via a formula. I understand why you can’t add directly to a group, because the calculation (“Quarter”) relies on data that you haven’t yet entered. So it can’t be added directly to a group, but you should be able to add a new item anyway (somewhere generically at the top?), and the tool can manage where it’s moved in the group view on the calculation, the same as it does when you edit an item. Am i making sense? IS there a workaround other people use to deal with data that is grouped via a formula calculation? Switching views is too difficult for most workflo

I’m trying to create PDFs I made in Page Designer using the “Save as PDF” feature in Chrome. However, sometimes it smushes the letters together. It does not do this when I use Mac’s “Print Using System Dialog” and save as a PDF, however that method causes my hyperlinks not to work. The issue seems to be how Chrome is rendering the fonts when creating the PDF, but I haven’t been able to find a fix. Examples below: Smushed: Normal:

Help - I accidentally deleted a whole load of columns instead of hiding them - can I get them back?

Hello, I’m a new user and looking to set up a quick questionnaire. I discovered pretty quickly that there are character limits on the Single Select Field option which is causing parts of the options to be cut off. I saw references to using Linked Records to get around the character limits, but I’m struggling to see how exactly to do that. Is there a tutorial that I can follow to see how this is done? Thank you in advance!

Is it possible to change the format of records sent via e-mail? We’re not satisfied with the way the records appear in the recipients’ mailboxes but since we have a large data base and ususally share only a couple of items, granting access to the base as a collaborator is inconvenient. Alternatively: Is it possible to extract a couple of records to another format (e.g. Excel) while still maintaining its originial form? The records are comprised of several photos and tags and text so visual representation is really important.