Other Questions

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.

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.

I have a base in Airtable where we create products for our Amazon account but there are hundreds of records to sift through. Each product has its own unique SKU that matches the Amazon product listing. I want to be able to download a report from Amazon showing all the products that are not selling and be able to take that list of products, compare/filter them to the products in Airtable and update the status of the product record. Is there a way to do this in bulk?

At the office where i work, we use airtable for almost everything. However, the current notifications when being mentioned in a record are terrible. Is there a way i can make airtable audibly notify users when they’re mentioned in a record or someone comments on them? I asked airtable directly but they said i could use mobile notifications which doesn’t make a sound on the computer and they also mentioned turning on the chime block. Which, doesn’t have that feature, only when new records are added. Can someone help me find a way around this? Recap, I want my computer to make a loud sound when i’m mentioned in a record.

I’ve got a table of collaborators. I’ve got a table of projects. And I’ve got a table of documents. Each document is linked to a project and a collaborator. I need to know how many documents are assigned to each collaborator, broken down by project. So Collaborator 1 has 2 documents for Project A and 1 document for Project B, Collaborator 2 has 1 document for Project A and 3 documents for Project B, etc. I’m trying to figure out how to do that. Any suggestions?

Dear community, I am new to airtable and would like your assistance on best practice on how to consume a json file and use linked relations within the airtables. i have a json file with structure like this: [ { "title":"first title", "publicationDate":"2021-02-02", "geo":[ { "country":"US", "lat":45, "lon":55 }, { "country":"UK", "lat":65, "lon":55 } ] }, { "title":"sec title", "publicationDate":"2021-02-02", "geo":[ { "country":"BR", "lat":4, "lon":5 }, { "country":"UK", "lat":65, "lon":55 } ] } ] Ideally I would like to have two tables: Pub and Geo. When inserting the above resu