Other Questions

I want to build an app that can handle incoming HTTPS requests from webhooks. Would it be possible to set up an express server in the app so that any requests to my app_url.com/api get processed by my app? The use case is, a webhook sends a request to the app, the app then updates rows within my airtable base.

Our Marketing team of 10 has been using Airtable for the past year. I am the Airtable “admin” on the team but am struggling a little bit on ways to streamline the instance I have built out. We have a lot of information in our instance that was built out for all different needs of the marketing org (content, design, product, regional, MOPS). It just feels a little over saturated and I welcome any help or suggestions to streamline. You view our read only base here: https://airtable.com/invite/l?inviteId=invvgV9ZF8wl5BMVq&inviteToken=76b50a841995a7916afca4962cfd225d462c1a22018887f27d6192b8f8511e34

Hello Guys, I’m trying to building a web app form my company. We need a Sales Order App for our agents, I’ve create: Products table Customer table Orders table But I have a problem we sell fashion stuff and every product has multiple sizes, how can I make it work like a you select a product and for each size you choose the quantity? something like this image: Can you help me???

Hi There, I have a date field (name = Contract Start) with a simple dd/mm/yy. In a new field (name= Order Date), I would like a formula to create a date that is six weeks prior to the date in the ‘Contract Start’ field. I have tried this: DATEADD(Contract Start,-6,‘week’), but not working. When building the formula, the system offers the {Contract Start}, which I have also tried, and also did not work. I’m hoping that someone is able to correct my error. Many Thanks Rob

Pretty new here so forgive me if this is an obvious question! In Excel, I have the option to filter a column to show a certain subset of entries - e.g. I can click on the filter button on the column header, and view checkboxes for every single type of entry in that column. (e.g. if the column is full of Apple, Orange, Kiwi, etc., I could select to see only the records with Apple OR Orange in that column). In Airtable, this seems much less intuitive - I can manually type in filters, but a) typing each entry is slower than simply going down the dropdown / checkbox list and selecting which values I want to display, and b) forces me to manually remember or find I might want to filter for, instead of having a list presented to me. Additionally, if I want to filter multiple columns this way, the whole AND/OR filter list becomes confusing to work with. (e.g. am I filtering for: (Column A is Apple OR Column A is Orange) AND Column B is Aeroplane or Column A is Apple OR (Column A is Orange AND

I have a Google Form that is pulling records into a table using automation. Once we’ve reached out to those people, we archive them with a checkbox. However, it’s gotten to the point where it’s hard to sort through the archived and ones we still need to contact. I’m using a script to create an automation where once the archived checkbox is checked, the record will be deleted off the existing table and moved to an “archive” table. My problem is that it’s throwing an error code for any field that has preset answers (multiple select or dropdown). I am still new to Airtable scripting so I’m struggling! ERROR CODE: Error: Field “Who are you interested in booking an appointment with?” cannot accept the provided value. at main on line 6 CODE: let table1 = base.getTable(“Referral Calls copy”); let table2 = base.getTable(“Archive”); let result = await table1.selectRecordsAsync(); for (let record of result.records) { if (record.getCellValue(“Archived”)) { await table2.createRecordsAsync([ { fiel

I manage a dataset with each row representing dates and several columns with times. In this dataset, I really don’t need ‘dates’ in the field but have to use ‘date’ format. Is there a format or formula or anything else that I don’t need to enter date every time?

Hi guys! I looked through several threads that were also trying to find COUNTIF workarounds, but none really matched the use case I have, so I’m hoping to find some help. We use Airtable to manage a large editorial team and content calendar. We have our main editorial table with our content roadmap and weekly assignments. My colleague who manages our freelance writer network has created a separate table with information about all of our freelancers including their names, contact info, assignment capacity, area of expertise, etc. She is wanting to find a way to count all active assignments assigned to a particular freelancer and pull that number from our main editorial table into her freelancer table. Is this possible? I can easily find the assignment count of each freelancer within our main editorial board, but can’t figure out a way to get that count to show up on the other table. Right now she is manually counting and putting that number in there as plain text. I’m attaching screensh

I have seen how to hide fields and create personal views and locked views but I did not understand how to make some attributes (columns) of a table visible only to one user. These attributes are not to be seen by other users. For example, with the maintenance table I would like to hide the “expected cost” field from the operators and see it only I who am the owner. Can you help me please Thank you very much

I’m trying to see if there is an ability to lock a task/table for individuals. Basically, we are providing courses and the next levels (with the content) need to be locked until they’ve completed courses/tasks…

Hello, I have text that I would like to paste text into a table. I’d like each line of text to get split across two columns. I know that I could probably get to this to work with a CSV import but I’m wondering if there’s a way to get the result I want with copy/paste. Here’s an example of the text I would be pasting: Line 1, Another boring day in the ocean. Line 3, Another boring day in the ocean, SIR! Here’s how I would like it to appear in a table: Here’s how it actually appears in a table when I paste it: I would either like the paste function to recognize the , and split the text into two cells at the comma (like a CSV import would do). Or I would like to paste the text then highlight column A and split the text at the comma into two columns. Are either of these things possible?

Hello everybody. I’m getting the Max value from a field which links to some records, then I’m adding to the link to increment it for the next time I need the MAX. Is there a limit on how many records I can link from 1 field? Thanks.

I created a test account to explore airtable functionality. We might need to publish our own application on airtable marketplace. But I cannot install any application from the marketplace. I click “Install” button on an app (e.g. - this one https://airtable.com/marketplace/blkt8D4LiDFZ1SCop/sendgrid) and nothing happens why is this?

Hi! I have table: integer - text - date I want view with group by text+date and average(integer) In grid view I see count(records) In Martix app and Pivot app - summarization by one field only. In excel/spreadsheet I can do it easily in pivot report. Could you advise way to create such view here?

Hey guys. I have an integration between Typeform and Airtable, I’m using Zapier to do that. BUT whenever a new record is created in Airtable, this record appears duplicated but without the field that I named as “Interaction ID” and with a different Record ID. PS: If I run a test in Zapier, the record appears with no duplication. Any ideas?

Hello everyone, I was wondeing if there was anything like a heatmap app where i can see what time of the day/week is the most popular order times, please see my screenshot for extra clarification (this was taken from google analytics). Many thanks! Matt

Hi Airtable Community! I have a problem I’m sure some of you have already solved. I’m collecting monthly data for specific metrics (example: Revenue) I’m capturing three data elements in one record - Actual, Budget, and Previous Year. When I try to create visualizations for this in the Chart app, because of the way I’m capturing the data I can’t get the visualization I’m looking for. I would like to see three vertical (or horizontal bars) for for each of the data points in the record (Actual, Budget, Previous Year). I’m thinking Veg-Lite might be the answer but have never used it. Really appreciate any feedback and ideas. I’m also open to other ideas on how to better capture this data from end users, there may be a better way to capture these elements that would lend to better visualizations. I added all three data fields to one record to make it easier for the end users to submit updates. Thank you all. Travis

Hi—I’m new to Airtable, and have a free account for now. I’m working with a cowriter on a detailed outline for a musical. My cowriter has a Pro Plan. If I also get a Pro Plan, can we collaborate on the same base without either of us being charged a collaboration fee beyond the $20/month standard fee? If not, is there any plan that would allow us to both make changes to the same base without being charged a base-specific collaboration fee? Thanks—Peter

Hi all, So today I wanted to get a “Mark Duplicate” script up and running on a base. Turns out its one of the featured examples. So I copied the code, adjusted it for my base and hit test and it didn’t work. The error reporting is rubbish - so I have no idea what went wrong and logging variables doesn’t work. This is the second time in 3 months I have tried to use the scripts block. I can’t say I am enjoying it, its slow and has no failure message (primitive stack trace) So my question is - how are others working with this productively. Because at the moment this absolutely sucks and I’d be better off using zaps.

Hello everybody. As the title says, I’m generating receipts with Airtable and I’m looking for a solution to generate a unique number for each one. I was looking at automation to maybe grab the last record and on the receipts # field do a +1, but I think this could be simpler with autonumber. Greatly appreciate your input.

User AISYAH_AMBOK asked the same thing some months ago, and even provided a great example. The third field in this table, with the issue pointed out with the ‘CROSS MONTH’: Can anyone here figure out how to make this work? And if possible make it work so it will list every month (and not just the first two) included in the range. e.g. if the range started 9 workdays before the end of January, and five workdays into april.: jan 2020, 9 - feb 2020, 21 - mar 2020, 22 - april 2020, 5 Obviously all the holidays of the year would have to be added to the formula to have a correct tally. This would make or break my use of Airtable on one project, so I really hope someone can figure this out.

Please assist me in Managing users with rights.

Hin Guys ! I’m using the Batch Update to sort the linked records but the are not sorting by date … any idea what could be the problem ? Thanks !!

Dear sirs, In our company we are considering to use Airtable pro. But a question emerged. We can have non payed users accessing via forms or kanban modes and giving inputs. Or will they be considered payed users? The use case is the following, we are onboarding partners and organisations and we will establish a simple CRM to schedule our work. Some users will engage with the forms to get assignments and progress the leads. But the cost will not scale if they are payed users. thanks in advance, Paulo

Hello! Im an airtable newbie with very light coding experience. Having several challenges setting up the bases for my team, but there’s one in particular that I cant seem to figure out. I’ve created an automation that triggers record B to be created on table B whenever a new record (record A) enters the view on table A. Table B’s purpose is to aggregate information from table A and table C and provide a top level view of many different scheduled communications. The problem that I have now, however, is that whenever there are updates to record A or C—like a date change, for example—the updates arent passed along to record B. I tried to create an automation triggered when record A is updated, but am unable to link it to record B. Are any of the below possible through a script or automation? 1- when record A is updated, the now outdated, record B is deleted and a new, updated, record B is created 2- when record A is updated a new record B is created, script runs to remove older record by