Other Questions

I don’t want to see colors when sorted, or by category or anything. I do not want to see colors provided by AirTable (or any apps/programs). How can I turn off all colors? Or make them all grey? But even that is way too dark and ugly. I am not a programmer, so please don’t say change CSS. I simply cannot do that. WHY must programs use such arbitrary colors? Not even a decent color scheme like analogous or complementary colors or anything. (No offense, but as an artist, the colors really really really upset me. I am getting physically sick looking at them. Please don’t hate me. I love this app, but gosh, the colors are driving me crazy. Oh no no no.) Thanks in advance. Great, amazing, phenomenal app otherwise.

Hi Everyone, I duplicated a base which I’ve done many times, but this time entries from the associated form did not start at 1. Is there anyway to edit the existing entry IDs if the form is still open/accepting submissions? Essentially I want to edit the current entry IDs so that they go from 1 and increase in numerical ,order, then have the future entries follow that order. Thank you.

How many sync connections can I get? With Pro account it says 10. Does it mean any direction? Many to one: B -->A C–>A D–>A E–>A I assume this counts as 4 connections for table A. Now the other way around - One to many: A -->B A–>C A–>D A–>E Would this count as 1 connection? Or will this count as 4 connections from table A. Anybody knows the definition of the limits? The question was asked here … kinda … but no answer other than suggestion to file a support ticket. Here: What are sync limits? Airtable Sync With the Pro plan, there are “20 synced tables per base”. Does this mean that a table can only send its data out to 20 other tables? Or does it mean that a table can only have incoming data from 20 synced tables? Or both … or something else? Thanks.

Hey guys, I am trying to build a base that allows my investing firm to manage our pipeline. This is what I have: Sheet which has Companies (under “Name”) One of the cells for each Company is “Existing Investors”–this links to another sheet (Investors) where the "Name"s are investors The investors are categorized into different buckets in another column – one of those categories is “Direct Competitor” Given this information, I would like to have a different sheet where all the companies are companies which have an investor that is a Direct Competitor. Then I’d like to add more columns for additional analysis we would do that we don’t care for in the broader group of companies Make sense? All suggestions are welcome

Hi! I have two tables with data that’s pulled from another site through Zapier. Table 1 shows a list of registrants for an online class (User ID, Name, Email, Course Name fields), and Table 2 shows a list of users who completed a class (User ID, Name, Email, Course Name, Completion Status fields). I’m trying to set up an automation that would add link records in the two tables, so that I can see which people who registered for a course actually completed it (by adding a Lookup field in Table 1 that would pull in the “Completion Status” field from Table 2). Creating a manual link each time someone completes a course is possible but would take up a lot of time. The problem is that each person might register for and complete multiple courses and would have multiple records in each table. So an automation that links records just through the Name or User ID fields wouldn’t necessarily work. Is it possible to set up an automation that would link records only if the User ID and Course Names b

I categorized this post under “support” because I suspect it can be accomplished without any additional functionality from Airtable but, if not, it may be more appropriate as a “feature request.” Is it possible to have a field that calculates the distance (in miles/kil) between two address fields? I am trying to create a base to log miles driven for business since the IRS requires a milage log to take advantage of the “standard mileage deduction.”

I’ve got a massive mailing list that has the entire address in one “address 1” field. To make matters worse, there is no uniformity to how the “address 2” section is written. There are STE, Suite, suite, and SUITE. In an ideal world I can extract everything after a STE, Suite, suite, or SUITE designation and copy it into another field. Then I would like to delete all of the “address 2” text from the Address 1 field. Is this possible? I’m open to using google sheets or excel if need be. Thanks for your time!

Hi everyone, Currently using the Map extension to map farm locations for a project. Is there a way to include polygons on this map? The polygons would basically be catchment areas. If not directly in/through airtable, could this be done on the google cloud side of things and then reflect in the map extension on airtable? If so, any info on how to do that would be handy. Secondly is there a way to then embed this map into an interface, or a webpage on a separate site? Thanks in advance :slightly_smiling_face:

Hello everyone—when I filter a column in a base, Airtable adds a green background for all cells in the column. Is it possible to disable this coloring? (likewise for grouping and sorting, only with the colors purple and orange) I can appreciate what the designers were trying to accomplish (clues in the user that automatic processing will occur on that column), but the visual disruption it creates in my case is not worth the indication (I would argue it’s better to just color or otherwise format the header row only if that is the aim).

Hi Airtable Community, I’m having issues embedding a view into Notion. When I embed an airtable view into Notion like before (I have a whole website full of embeds that worked in the past and still do) it doesn’t work anymore and now just shows the link: I’ve seen a similar query posted 15 days ago but it just today got closed. Has something changed in the Airtable settings maybe?Any help would be really appreciated. Thanks in advance!

Since Ive got more than 99 records, I would like to access to the URL of the next page to see the complete Raw Data or to set the limit to more than 100 so all records are in the same page, how could I do it? thanks

Hi, I have an Airtable database where I have used the create link feature for sharing the table. So, people can join my database with their email as a Read Only user. But unfortunately, they did not get the option like filters, sorts, groups, etc. option. How can I make filters, sorts, groups, etc. options enable for my Read Only users?

How is everyone limiting their extensions? With only being allowed 10 extensions on the Pro Plan and me not being large enough for an Enterprise plan I don’t know how I am supposed to function as a team. I have loved Airtable up until this extension limit. The Interfaces function does not work near as well as Extensions and I can’t see the data they way I want. In order for me to continue to run my business from Airtable I NEED to have more extensions. Currently I use 57 and had originally planned on continuing to grow that number so I could fully transition from our other CRM to Airtable. I am unable to do that if Airtable is going to limit the use of Airtable.

How can I make a drop-down menu read-only, so that the user cannot by accident create a new pop-down value? I have this problem myself when testing my database. Thanks

I am trying to use a script in order to identify duplicate records in a table Description: Duplicate record field = Participant Name Desired outcome: When a duplicate record (repeated Participant Name) is created in the table labeled “Ops: Program Hub” Add a CHECK in the field “Duplicate” THIS IS THE SCRIPT I HAVE - and it is currently not working. I am VERY new to scripts and would appreciate any help! // the table to check let table = base.getTable(“Ops: Program Hub”); // the record we’re searching for duplicates of // we need to create a ‘recordId’ input variable connected to a record trigger let config = input.config(); let recordId = config.recordId // the field to save duplicates in. this should be a self-linked record field let duplicatesField = table.getField(“Duplicate”) // query the table and find our record according to its id: let query = await table.selectRecordsAsync({fields: }); let record = query.getRecord(recordId); // search for duplicates let foundDuplicates = q

Hi there, I’m learning scripting to help my company parse its Airtable rich-text fields to HTML. It’s a big ask and I’m looking for guidance (my boss can’t afford this solution). I installed the Script extension and am watching the official help videos, but the output from either a console.log or output.text doesn’t match the example values from the API help page. I.E. From Output.text(fieldString): (from the preview window in the scripting editor) The SO will: Set up delegated Google Account to support the SO with delegation of ongoing security tasks From API Example page: “The SO will:\n1. Set up delegated Google Account to support the SO with delegation of ongoing security tasks \n” I read this official Airtable Markdown article, but found little help in how I can work with the contents, so that I can eventually learn the Regex expressions to parse them into HTML. Any help on how I can accomplish this within the Scripting extension? I feel working with the API on some local develo

So in search extensions say I search up like “walmart” and all the Walmart tabs come up how can I print that?

Hello Dear, I using Airtable pro plan for nearly 4 years, paying at once, so after a long time, I miss the mail to pay the amount overdue 5.65 USD. When i realize the pro plan had already been downgraded to the free plan, I can not pay the 5.65 USD overdue, i have to pay the annual fee, ( lost all creadit remaining). So someone please help me to pay that overdue or do i can get back creadit remaing . Thank you

I am building a CRM. I have one table that is all leads. I then want to use zapier to send over interactions from my phone services to another table for interactions points. I have it set up as a linked record look up, but Zapier isn’t liking this. I do want these records to be linked. Thanks!

Hi, We have previously had a “form” from within the base as an “Extension” - however as of last week the message we are now getting is " This website does not allow embedding". Just wondering what has changed? And are we still able to use our created forms (view) as an extension? Cheers, Jenna

Hi - So we are a camp and I’m trying to tally the amount of children attending a certain week. In AT they have 1-8 or Full listed as their enrolled sessions all as a multiple select choice. How and where can I have tally’s as so how many in that specific group are coming weeks 1, 2 and so on?

When linking tasks to predecessors/successors in the gantt view, it will show up in table view. But when I add from the table view, it will not show up in the gantt view at all. The field type in the table is “link to another record”. How can I fix this?

I have a pre-existing order number in the format of “LS003456” that I would like to auto-generate. I’m using a second field with autonumber and then a formula like this: CONCATENATE(“LS00”, AutoID) which gives a result of: LS00185 LS00186 LS00187 Is it possible to modify the formula so that there are always 6 digits after the “LS” and any leading zeros are maintained? My end goal is to have a sequence like: LS000001 LS000002 LS000003 … LS999999

I have one table with a list of products and their delivery date. I have another table with a list of marketing campaigns and a “Go Live Date” and a “End Date”. I simply want to have this information together in one view so it’s easy to tell what products are getting marketing love and which are not. But, I can’t seem to find a way. The point is to on any given week to see what marketing activities are occurring and what products are arriving in store. Any suggestions? Thanks in advance!

Hi all – I am simply trying to calculate the average of a column containing numbers produced by a formula. It is a “Formula” column, but the output of the formula is a number. The database contains all of my projects, and the column in question calculates the number of “days to complete a project” by subtracting the date I was assigned the project from the date I completed the project. I have about 50 rows in the database (one for each of my projects), and I simply want to calculate the average of the column so I can keep track of how many days I am taking on average to complete projects. This is something that would be very simple to do in Excel, but something that I’m really struggling to figure out how to do in Airtable. I see that it’s fairly easy to find the average of a column formatted as “Number” by using a grouping and then selecting Average from the dropdown menu. However, this does not appear to be an option for columns formatted as Formula, and I fear that that is the probl