Other Questions

Hi, I am using a webhook triggered script to copy incoming data into 2 tables. None of the updated columns are links. let uwTable = base.getTable("ATDS data"); let crTable = base.getTable("Combined repository 2") let inputData = input.config() console.log(inputData) let validateRecord = async (newApplicationNumber) => { if(!newApplicationNumber || newApplicationNumber === "") { return true } else { let exisitingCases = await uwTable.selectRecordsAsync({fields:["Application No."]}); let existingApplicationNumbers = exisitingCases.records.map(r => r.getCellValueAsString("Application No.")); console.log(exisitingCases.records.map(r => r.getCellValueAsString("Application No."))); console.log(newApplicationNumber) return existingApplicationNumbers.includes(newApplicationNumber) ? false : true; } } let isValid = await validateRecord(inputData.application_number); //adding case to Combined repository 2 w/o validation await crTable.createRecordAsync({

hi is anyone here using Resource Planning - Airtable Universe this one as a base? I am playing around with it. how is Planning (Globals) tab used? I am trying to see how much are certain resources available in given week - how do I do that? How can i assign resource to a project but for a partly duration? i.e. if the project is 1 months but one resource only needs to be assigned for 2 weeks? *Is there a less manual way to add individual allocations for the same project (in the allocation tab) rather than duplicating the row and changing the personnel one by one? Thank you for your help!

Hi everyone, i am trying to build a performance dashboard. I would like to count how many times the workers postpone their work’s deadline. Is it possible to do ? Can you g’ve me a hint? Thanks.

Hi, probably it’s a stupid question, but can we run the script in a different language such as Python, HTML, R, etc? I was thinking like in python, we can import a library to write codes in java language, can we do the same here? I’m new to Javascript. Thank you!

Hi Airtable Community! I wanted to know what the latest update is for images added to the Attachment field. A while ago there were big discussions about the change that Airtable has wanted to make. It was supposed to come into effect this month (November).

Hi, I’m trying to create an interface that shows only the status “To send” and not other status. As you can see in “Status 2( from Report)” there is also the status “Done”, I would like to filter the data. I tried to filter the interface in this way: But it didn’t solve my problem. This is my dataset: is someone know why “Done” is still there? and how can I solve this issue? Thank you very much!

Hello, I’m trying to find out if and how I can continue a free version of Airtable as I’m currently using only a small fraction of the app. Just this morning I got an email saying that the “free trial” is ending tomorrow. I was under the impression I was using a “Free” or “light” version. It would be helpful to find out if the limited number of features I’m using allows me to keep doing a free trial. Or… what membership tier I would qualify for. Please help as this puts me in an awkward position today with a deadline and my data in jeopardy. Thank you.

My company’s base experienced a SNAFU, and the fields in several hundred records were confused with each other. Our solution was to restore a version of the base from a point in time before the issues occurred. However, before everyone was notified to switch over to the restored base, many tens of updates were made in the corrupted base. These updates now need to be transferred to the new base. Since doing this manually would be tedious and time-consuming, I am wishing for a way to do this from a spreadsheet (using a script?). Please tell me if I am making sense and if there is a way to do this. Thanks in advance!

Hello. I am having some trouble updating a field in my record with a linked field from another table. Here is what I have so far: Lets say the creative record exist its just not linked if (creativeRecord) { return creativeRecord.id; } I put the return of this function above ^ in the variable creativeRecordID that I use below. The value of creativeRecordID is a string “RecordQueryResult.1234” table.updateRecordAsync(record, { Creative: [{ id: creativeRecordID }], }); This is returning the error: Can’t set cell values: invalid cell value for field ‘Creative’. Cell value has invalid format: .0.0.id must be an objectId. Any suggestions / solutions appreciated, Thanks!

I am relatively new to Airtable and have a specific Search/Filter issue that my colleagues and I have been attempting to solve for a while now. We are a small travel company that provides tours to our clients. Each tour has a unique route that it travels (with stops along that route). The tour itself can run on multiple days following the same route. I have set up our tables in a similar fashion to this screenshot: We need to be able to create a Search that will return which Trip Name is in a City on a specific date or range of dates. For example: we search Djibouti from 10/11/22 - 13/11/22, it would return BC, BB, BD, after which we could view individual records that BC, BB or BD are within. Is this within the realms of possibility with Airtable?

I am looking for a way to log all the emails I send to my contacts automatically to my Interactions table. I thought I could accomplish that by using the Zapier integration with Email Parser. I set the contacts involved field to equal the recipient and bcced the parser email. However the zap is pulling in the bcc field instead of the to field. I am using outlook email client. Any ideas how to fix this or is there perhaps another way to accomplish the same task?

Hi, I’m trying to think of the best way to replicate our billing schedule payment profiles where we have % of an annual fee to invoice each month. The below show how we capture this in excel: At this stage, I’m just looking for ideas on how to structure this. However, ultimately it would be nice to link opportunities to a payment profile and have each payment date shown in a calendar view. Thanks!

First ever question for the community! I have a table with a single select column that contains the names of different documents and articles used while conducting secondary research. I would like to create a new table that adds each unique document to a single row. Suggestions?

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?