Other Questions

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.

Hi, I am creating a life project tracker in which I have multiple layers of records so I start with “Broad areas”: Health Work Investing Within “Investing” I have 3 “Subgroups”: A. Equities B. Debt C. PE And within “Equities” I have 3 “Todos”: i. evaluate long short ii. rebalance portfolio iii. set stop loss I have a master sheet in which I have linked each broad area to its respective subgroup as a record, and they come up automatically when I add to either sheet. However, when I then link “Todo” to “Broad areas” in the same sheet, the cell doesn’t populate with the aggregated "Todo"s of all “subgroups” within a “Broad area”. I.e. in my master sheet I want to be able to see Investing in one cell → all the subgroups within investing in the adjacent cell (auto pop) → all the aggregated todos associated with ANY of the investing subgroups in the next adjacent sell How can I make them autopopulate? Thanks

So I have a table (Table 1) with employee names and some details. And I want to create another table (Table 2) with one of the Fields being a name Field. And I want it to pull in the names from Table 1 into it’s name Field. If a user gets deleted in Table 1, I’ll love for their row/Records to be deleted in Table 2 as well. Is this possible? Thanks a mil in advance for your response!

There seems to be a problem in using Lookup fields in Module settings. I had a dev base which I used in Integromat and for that the lookup field shows up as an array and I get to select an item of the array. (See Screenshot) However, I copied the dev base for production and now the same lookup field shows up differently. This causes problems in my Integromat scenario. Stuck on this critical issue in Live system! Any suggestions appreciated!

Dear Airtable, I have been trying to send an email to support, Can anyone clarify some of the concern. I am new to airtable. Is this white-labelled? Where it is hosted, provider and geolocation? Can you use a server in Australia? Can we do commission splits? Integration with wp? Can we embed a complex form in wp websites? User access level? Can we record the deleted data entries in the filed? Can we get help to implement the database? API integration help? Support level? Custom view for a different level? Complex queries execution? Can we migrate specific data to our custom report? Uptime and deserter recovery plan? Can we do auto address verification and filled? How to communicate with customer service? Please advice

Hello, I have two fields that I want to update when one of them updates. The fields are “EN Course” and “DE Course”. When “EN Course” moves to the status of Live (drop-down select) I want DE Course to update to “Evaluate For Translation”. What is the best formula to do that? Thank you!

My complaint is similar to the one found here: Problem: Scrolling Desktop Airtable in Safari on iPad Pro not functional Ask the community On iPad Pro running Safari with Airtable Desktop, one cannot scroll the screen to see additional records or additional fields beyond the initial screen. Using any browser on iPad Pro 12.9”, the Airtable Webapp, which otherwise functions perfectly when using a mouse and keyboard, will not scroll. It’s literally my ONE bottle-neck. I can live with the wildly under-featured app since it’s at least rock-solid reliable, as long as I can occasionally access the web app for more complete functionality, accept, as it turns out, the webapp doesn’t scroll in table view using the mouse unless I select a cell and then use arrow keys to keep moving from cell to cell until the window scrolls to adapt. Not practical. I’ve tried Infinity, ClickUp, and every other platform you can imagine. Airtable wins if this one problem is fixed.

How to see when a column or data in that column was last added and apply that to many columns to see what date/time they were last used? This article does not state how to apply modified time/date to all columns in an airtable and that’s what I seek.