Other Questions

Is it possible to change in roadmap/gantt views when quarters start and end? I would like to have Q1 start where Q4 is currently and so on. Thanks!

Hi. I got two Airtable bases… in the second one I’m bringing tables from the first one, which I then use to create linked fields in other tables. In a MAKE scenario, before proceeding to next module, I need to sync these tables in AT. I’d like to execute the manual syncing process at a certain step from within my MAKE scenario… how can I get around doing this? Is it possible? Are there options/workaround via API calls, AT automations, or even bringing Zaps into MAKE, or using other 3rd party tools? Any guidance is appreciated. Thanks!

Help! I have a base which about 75 people need to view every day (multiple times a day), so I have been sharing the read-only base view which does use a password. Now it’s failing to work and saying “Login expired - please re-login.” Yes, they re-enter the password and try refreshing the page. As soon as we try to add a filter, error message appears. Does anyone have any solutions for this or know why it’s suddenly happening? Thanks in advance! The error box can be dragged to the side and use the base, so that’s what I’m telling my users to do. But super lame?!? Can anyone help me get rid of this bug? Communicating with Enterprise support is ridiculous. Every response takes +24 hours and so far they can’t ‘replicate’ the issue even though I’ve sent them a video showing the issue.

I accidentally added a collaborator to my account. I didn’t realize that I would be billed again for inviting a colleague to join Airtable and be a collaborator on my account. Is it possible to speak to someone at Airtable about this charge? Can we remove the collaborator and get a refund or a partial refund since I really don’t want a collaborator for the workspace? Thank you, Wendi

Hi community :wave: . How can you see the date a comment was left on a record? At the moment, our set up only shows the number of days since the comment was left. I need to see the actual date.

I have a 2 columns that would be amazing to use as a single select. Unfortunately, I need a formula to find them. Is there a way to use scripting to run a formula to enter into the column allowing it to be used as single select?

I created a table that syncs with two different google calendars (mine and person2). This table is then linked to our contacts table to have a history of the meetings we’ve had with each contact. There are times where both myself and person2 will meet with a contact and these instances are creating separate records in the meetings table and then both records are being linked to the contact. How can I avoid this duplication? I thought that I could use an automation to search when a new record is created for another record where the google calendar ID is matches the new record but the airtable ID doesn’t. After that, I was planning on creating a script to delete the found record. However, because this is a synced table, I wondered if this would simply end up running infinitely because the event will attempt to sync each time Airtable sees that there is no record for the event and then the automation would delete it, rinse and repeat.

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.