Other Questions

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 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 (

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 di

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

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 additio

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.

Hi everyone, I am trying to sync airtable rest api with snaplogic but the tables in the airtable are not passing as required. can anyone help me with the query parameters used in rest api https://api.airtable.com/v0/baseId=apqwyehayywkzjerAnv/tables=demoocontacts ?api_key=keyxxxxxxxxxxxxxxx Is baseid , tables, api_key are the exact parameters? Does anyone know how to get data in airtable to snaplogic through the api?

I have an Airtable lookup field. In my test scenario it works correctly. I’m able to get it as an array and use it in module settings. I’ve cloned this scenario and in the new scenario it shows up as a text. Any idea?

I’m making a database of shared lessons. Each contributor will help with many lessons. Each lesson might have many contributors. Lessons have topics, description, age range, format, uploads. Volunteers have name, bio, and private contact info. I currently have a Public and Private view for Volunteers. How do I let the public (not signed in) looking at a Lesson easily go to the public view of the Volunteer, and vice versa? I can do it when signed in as owner, but I want the public to do it as well. I’m willing to create a guest account if that will work. Does this require a paid plan? Our budget is small, but we can probably afford the cheapest paid plan.