Other Questions

Is there a way to update an Airtable record with changes made by API to a row in Google Sheets? I know Integromat has a ‘Watch Records’ module that does this but I believe it only works with manual changes to a Google Sheet. I have a JotForm that I use as a sort of approval workflow. The JotForm gets sent back and forth to different people and every time a JotForm is edited, JotForm makes the changes to Google Sheets but these changes don’t make it to Airtable as these changes are done by JotForm by API.

Hi, I’m new to Airtable programming, so I apologize if this is obvious for the most of you… Is it possible to directly retrieve external data from another website (through their API) ? I’m working on a personal movie db, and it would be nice, that if I give in a column the unique IMDB id, it will get me the IMDB rating automatically in another column ? If not possible via Formula, how should I proceed ? Thx for any helpfull reply

Hi all, I have a view of a table shared with non-Airtable users. They can view the table fine with the link I gave them. My table has a notes column and I’d like to reference another record within the same table by saying “please see here”, with "here " being a URL link to another record. As an Airtable user, I can click the link and it works - I can see the other record. However, the non-Airtable users get blocked. They’re being asked to request access to the entire base, which I would not like to do. Is there a way for the non-Airtable users to view the record URLs in the comments section without creating a new column for linked records? Thanks!

Hi folks, I have embedded into a web page: A table Containing a lookup field From a synced table - and it looks like this: At the moment, expanding the record in the lookup field only opens up the one cell: But I want it to open this: Can this be done? So many thanks for your attention. Shawn

This is probably a stupid question but when designing a table, should the primary key (first column) be unique or not? In my case, I have Projects and Tasks like Projects (Fix House, Fix car) Tasks (Repair bathroom sink, buy new steering wheel, replace lug nuts) Should the primary key be the Projects or the Tasks? In other words, should the table design look like?

I think that Google Fusion Tables is shutting down, which means that my choropleth maps (i.e. maps with states and other areas shaded) will no longer be accessible. I want to move everything to Airtable, but on the Map block I only see the ability to identify points and not areas. Any ideas?

I have a view of a table shared with non-Airtable users. They can view the table fine with the link I gave them. My table has a notes column and I’d like to reference another record within the same table by saying “please see here”, with "here " being a URL link to another record. As an Air table user, I can click the link and it works - I can see the other record. However, the non-Air table users get blocked. They’re being asked to request access to the entire base, which I would not like to do. Is there a way for the non-Air table users to view the record URLs in the comments section without creating a new column for linked records?

Does anyone have a Zapier workflow that ingests an Airtable table and then creates a Google Map that includes all records? In a magical world, there’d be a way to layer multiple views, updated dynamically, on one map. Thanks in advance!!!

I have three fields, two are field type Number, one is Formula. The objective is the sum of the numbers in the result field. (1() enter W, (2) enter D, (3) result (W*D) In fields (1) and (2) I have selected ‘allow negative numbers’ Each row has for fields (1) and (2( whatever numbers I enter, for example: W D Result 5 5 25 -3 -2 I expect -6 but what i get is 6 which means that the sum is 31, not 19 How can i ensure that when a negative number is entered, the result is substracted from the sum? I have found an inefficient way around tthis by having a fourth field Type: number and allow negatiive number, into which i enter the result manually, eg: Result 25 -6 (sum: 19) tia

Hey, New to Airtable here and can’t tell if I’m going crazy or I’m missing a trick. Hopefully the later! I have a USERS table that captures NAME, COMPANY, EMAIL ADDRESS ETC when a user signs up. I have a Clients Table that holds further client info e.g. COMPANY NAME (Link to users table), USERS etc. The problem I am facing is that I am trying to pull all email addresses of users associated with a COMPANY name, into a USERS field in the CLIENTS table. Hope that makes sense, and any help is massively appreciated!

Hey Everyone, hope you are doing amazing! I am having troubles with building my sales Interface. I have multiple blocks there as “Calls taken”, “Calls booked” but I can’t figure out how to make a “Closing rate” percentage block? From calls taken and calls closed. Can anybody help me? Thank you!

Is there a way to set up a lookup field without duplicates? I asked this here and I just noticed that the response didn’t fully solve the issue: The rollup formula ARRAYUNIQUE(values) still includes duplicates.

Hi, Is there any way to include more text in a gallery view. There should be another bullet point after Moving forward and the text is also cut off after denying/avoiding/struggling Seems like an important feature!

An api on my site where I’m using Airtable as a CMS can’t get metadata for field. Current API can get value up to 7 for each record through table on my site due to that reason. can any suggest a solution?

The dedupe app/extension works wonderfully for me, except whenever I select a field of type “checkbox” i.e. a Boolean, in the record to be deleted, then the merging still happens but there is an error message and the base has to re-load for about 30 seconds. This gets annoying if there’s a handful of records or multiple Boolean fields. And means I have to go through manually checking the newly merged record in case anything crashed in the process whilst page was refreshing.

I am using pre-filled forms to collect records from users. The form fields include linked records. I’ve just realized that anyone with the URL can simply remove the parameters at the end of the URL link to view the base form URL and as a result, will be able to see all of the linked records in those fields. For example, we have a link for a vendor to add a bid. It is pre-filled with that vendor’s information from a linked field. If the vendor is smart, they can remove the parameters from the URL to see the base form and then view all of the vendors in our table from that field. How can we collect data from users with pre-filled parameters in a way that they cannot access the base form?

I wanted to log an interface at a certain point in time (such as a certain day of the year every year) and collect the data. Ideally, I can create a report/log every few months and keep track of the data and manipulate it to see how it’s changing. Is that possible for Airtable? Thank you!

I have a view that contains all the records for a set of people. Some new information applies only to a subset of those people so I created a view that filters on the criteria for this subset. Is it best practice to add the new information in the original view or should I add new columns to the filtered view? I’m trying to ensure that my data stays clean as I build the table and add records. Thanks.

We use a LOT of different grid views. I am finding that when I need to duplicate a collaborative view (so then I can slightly tweak it for a different saved view) it defaults to making the duplicate a “personal” view. I want it to remain collaborative, or at least be able to move it from personal to collaborative, but it does not seem to allow me to do that. It’s a pretty frustrating issue. Any pointers? Thank you!

I have a pro plan (50k records per base). I’m trying to do CSV import of approximately 2k records onto a base of 24k records for an approximate total of 26k records on this base. What other reasons could I be getting this error? See screenshot.

Hi! I am trying to create a simple If formula that shows how much my clients owe me. So if the amount billed is equal to the amount paid, show £0 else show the balance. My issue is, I am trying to append the £ sign before the balance calculation but it doesn’t work. IF({Amount Billed}={Amount Paid}, “£0”, ‘£’ & {Amount Billed}-{Amount Paid}) It only works if I place the £ after the balance. IF({Amount Billed}={Amount Paid}, “£0”,{Amount Billed}-{Amount Paid}&’ £’) Any help on how I can accomplish this?

I want to create a Single Select field with a list of all countries so that users can fill it out in a form. What’s the easiest what to do this without having to add every single country individually? Thanks!

I’m pretty sure this is a easy fix but I keep going around in circles… I need to create recurrent task with about 3-4 subtask for multiple records… Record: Johnny Task: Offer letter Subtask: () send offer () send background () get references I’ve figured out how to link the sub task to task in the “Task” table, however when I link it to the “onboarding” table… and check off a subtask … the checkmark populates for all of the records… so now Joan, Johnny, and Mike have sent offers when that’s not the case. Please, what am I doing wrong?

I have a survey form asking participants of their confidence scores that feeds into a table. Here’s 3 sample questions, all 1-5 score: confidence with financials confidence with communication confidence with strategy These go into columns B-D. I’d like to then have a way to display, for a single respondent (record), a sorted list view of these 3 columns to show highest to lowest rank. E.g. someone responds 2, 4, 3 respectively. I’d like to create a table (preferably in Interfaces) that shows: Communication (4) Strategy (3) Financials (2) Is this possible?

Running into a problem creating an order tracking form. I have 4 tables Customer Info - name, address, etc… Product List - products and prices Orders - each row has customer name and product and product quantity purchased. Primary field is a formula concatenating Customer name and product they purchased Now I’m creating a 4th table Order summary by customer. Primary field is an Autonumber. Second column is a linked record to Customer Name pulled from the Customer Info table. What I want to do is group by customer, everything they ordered and the total they owe. Where I am running intotrouble is I can’t pull the Quantity field from the Orders table using a Lookup; I don’t know why. Please help! Thank you