Ask the Community

I'm attempting to setup a Webhook from Jotform to Airtable. However, I'm never able to get past the Test portion.I have:Started the Automation in Airtable, selected When webhook received.Copied the webhook URL provided by Airtable, and pasted into the Jotform Integration Webhook.Submitting the form in JotformAirtable always says This URL has not received any requests recently.I setup a webhook API on https://webhook.site/, and updated Jotform with new webhookSubmitted form again, and immediately received webhook message on https://webhook.site/.This leads me to believe that Airtable is not functioning correctly. Is there a reason why Airtable would not properly accept my webhook? Account type? Form type?

Hello,I cannot figure out why I have a field which has multiple records linked to it even though I have not selected 'Allow linking to multiple records'.My tables are 'Materials' and 'Inventory by Location'. The top photo is 'Inventory by Location' table showing the linked field to the Materials. Preferably, if materials are linked to a storage location a new record would be created instead of linking multiple materials to one inventory record because I have not selected 'Allow linking to multiple records', or if I need to make an automation for that to happen then airtable would block linking of multiple records instead of what has happened in the photo. Also, I would like to know why, in the bottom photo, there are repeated links to the same storage locations. Thanks for any advice/clarification!  

I'm not impressed with the refund process, and would like this issue to be addressed by staff. I know the forum is mainly users, but there is no phone number by which to reach staff. I was prompted by the automatic reply I received after emailing Airtable Support to leave a post in the forum as this triggers a response time within 72 hours. Evidently, I'm not the only one forced to go this route only to be repeatedly told forum members can't do anything, but we go through the motions nonetheless in the hopes of having our issue dealt with in a timely manner. So, my useless and ridiculous post poses the following questions in the hope that someone compiling forum activity for internal reports will flag it:1- Why is there no phone number by which to reach staff for billing issues? Being re-routed many times by a bot is frustrating, and submitting a Request Form feels like we'll just end up in a big stack which will only garner a generic response.2- Why are refunds issued in credits, and

We've removed forms because me and my other users need to input info on mobile most of the time and if one makes a mistake or needs to adjust data, a form is not user friendly (submit form > realise mistake (or not) > open airtable app > find relevant table > edit). However, a spreadsheet isn't *that* user friendly on mobile either. It can be easy to miss an input column. Some columns generate information for the user as they're submitting data, so inputting data is also creating actions for the user at the same time. Therefore, not every column is an input column, and it can be easy to miss one on mobile view.This could quite easily be resolved with colour coding columns - or some way to highlight input/vital columns. It would also make certain complicated tables easier to read and interpret! I use lots of filtered views, but some tables have 15 views for interpreting data - and to be honest, I'd rather have fewer tables, with clear sections so I don't need to fl

I am using a mid formula to extract a string of text. The string appears as expected in the cell, but when Make (Integromat) runs the search it is adding an extra space before the string. " <string>" If the empty space is present, wouldn't I see it in the cell?I have checked over an over again to verify there is no extra space in the formula in Make. I have also changed my formula to +2, +2.Variations of this MID formula works with other use cases, this is the only one inserting an extra space. Is there a better way to do this? MID( {Summary}, FIND( ':', {Summary} )+1, FIND( ',', {Summary}, FIND( ':', {Summary} ) )-(FIND( ':', {Summary} )+1) )  

I'm working on a project wherein I'm trying to display the diversity characteristics of several universities (50+). I have an existing base with a list of all the universities I'm studying with various facets as fields across (location, size, focus, student life comments, admission criteria etc), but I also wanted to include information on the demographic makeup of each school. Ex: X University is 25% White, 15% Black, 10% Latino, and so on. What's the most efficient way to go about this so that this is also able to be displayed as pie chart via the Charts extension? I started by making an additional base, but as a beginner user I stumbled trying to find a usable format that allowed for readability and reporting. 

I have a list of schools and I'm trying to track demographics I have about the schools:raceincome levelsgendersI have reports with the aggregate data, not the individual student records. Therefore I'm not able to do rollups but tracking each demographic for an individual students in a linked table.What would be the best way to store the aggregate values, so that I can generate charts per school or across all schools? These categories have different amounts of choices too.

I want to check Checking HTTP Status Code everyday in automation, how can I do that?

Hi - I’m running into a problem when I try to group a list of events. The dates are from Dec. 21 up to Dec. 22 and I’ve one column witha formula that extracts the month from the date column. I can sort my table by the date field and it’s all fine, but when I then group by month, the order gets messed up. How can I create a grid view that is sorted by month and shows the month in the right order? And in addition with a two times December (21,22) entry?? Thanks for any help!

I'm writing a script that will update my airtable dynamically with new tags that will sit in a multi-select field. I know that I can use { typecast: true } in my call to airtable, but I'm still getting an issue when updating it. I'm pretty sure the issue is either in how I've set up my object for Airtable or the placement of the { typecast: true } option. Here is the partial method that creates a record in my airtable await this.table.create( batch, // batch of records to be updated, see below for structure { typecast: true }, function (err, record) { if (err) { console.error(err); return; } console.log(record.getId()); } ); Here is the object (batch) that I'm sending through fields: { name: 'a new record', categories: [ { name: 'Item 1' }, { name: 'Item 2' }, { name: 'Item 3' }, { name: 'Item 4' },

Hello! I'm having trouble allowing our AirTable users to add a new option to a single-select field. Also, any changes that happen to that field break an interface where that field is included both in a grid and also as a filter option. The field is only letting me add new options -- I am the one who created the field/changed up the format of how it was. Not sure why that's happening, please let me know if you have any ideas on how fix it. 

Hi there!I want to automatically export data from Airtable and create online files separated by managers. The data in those files should refresh daily. These files could be in the form of a Google Sheets or Excel online file.Does anyone know of any tools or solutions for this task? We have over 50 managers, and doing this task manually consumes a lot of time.Am I the only one who needs this kind of workflow? 🙂

I am supposed to create an app in Power App. My data source is Airtable. Therefore I want to export the csv file from AIrtable to SharePoint or Excel Online automatically on daily basis. Kindly let me know whether this is possible and documentation related to this

I've prepared a snappy demo video which shows how to do this:https://youtu.be/ns0CjtM7fGoThe solution uses csvgetter.com, here is a link to the corresponding guide

I am new to Airtable and would like to know the best way to build the architecture around data and tables from you people who are more experienced Airtable users.More specifically I am building a Supplier database of approx. 100 suppliers. Each supplier have a unique ID as identifier. I would like to share this ID across tables, so that the records are linked to each other based on the ID.When creating a new record (supplier) in the main table, then I would like this record to be auto-created/displayed in the other tables (or than one can only add data for records that exists in the main table)My idea is that the main table is for the key supplier information and other tables are for grouping of data.Like tables for:Main tableContact informationPrice informationIntegration informationlogistics informationetc.What data architecture do you recommend or do you have a better proposal for how to build an internal supplier information database?

Dear Team!Can you please check the below error ?Error while submitting AirTable entry{:ok, %HTTPoison.Response{status_code: 403, body: "{\\"error\\":{\\"type\\":\\"INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND\\",\\"message\\":\\"Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct.\\"}}", headers: [{"Date", "Tue, 19 Sep 2023 09:31:26 GMT"}, {"Content-Type", "application/json; charset=utf-8"}, {"Content-Length", "251"}, {"Connection", "keep-alive"}, {"Set-Cookie", "AWSALB=f+uz31NlfZTNrWX1gThigET2URThzvJkGvNuDsHJ5Y5CRhVAdfRVj6cmGOMqzTceIj8RkgHwIv1RUwpUGlwK6i9sm2JlZ+Iea5Roi9YqIWmLTiM4nfDEeFA1fORD; Expires=Tue, 26 Sep 2023 09:31:26 GMT; Path=/"}, {"Set-Cookie", "AWSALBCORS=f+uz31NlfZTNrWX1gThigET2URThzvJkGvNuDsHJ5Y5CRhVAdfRVj6cmGOMqzTceIj8RkgHwIv1RUwpUGlwK6i9sm2JlZ+Iea5Roi9YqIWmLTiM4nfDEeFA1fORD; Expires=Tue, 26 Sep 2023 09:31:26 GMT; Path=/; SameSite=None; Secure"}, {"Se

Hi there. Does any know how to prevent my csv data from breaking when I transfer it from a csv export to my spreadsheet?Problem (CSV Export Bug): When I export the data, a piece of the notes column rolls over into a new row, resulting in additional rows that are unrelated to any record.Thank you in advance! 

Hi, I need to allow interface users to export table data to excel, without giving direct access to the table itself. Is it possible  using a script, triggered by a button?

I need to create a fields + network field based on the below image, How can I achieve that in the airtable table?

Hello Airtable communityLooking to you for help / direction with a problem a client of mine has. They are auctioneers, and use Airtable to manage their business, specifially to load properties and other assets onto Airtable, which displays on their public facing site via an <iframe>.The challenges he faces is that every time someone registers to bid on a property, they have to go through the registration process from A to Z. My clients wants a solution where their client registers an account on either Airtable or the Wordpress instance, so that they remain registered for all auctions. Secondly, they'd like to take payments on the site as a deposit for the auction. This is easily done with a simple Woocommerce install, but was wondering if something exists within Airtable to facilitate this payment.Thanks in advance for your kind assistance.Regards,Willi

Greetings All,I have recently created a base paired with an interface that I believe could serve as a beneficial template for users seeking similar functionalities. It's important to emphasize that the key functionalities and features of this proposed template are primarily housed within the interface designers, relegating the base to a backend role.I am keen on making this template publicly accessible, and I wish to accentuate its interface-centric features prominently. Although I am considering the Airtable Universe as a potential platform to share this template since it seem the only spot for sharing "base" templates, I am uncertain if it is the ideal place given the significant interface-related features of my template.Could anyone suggest the optimal method to share this base and interface as a cohesive unit?Appreciate your insights!

this is the record for "test" in our Airtable - #1 = VD Formula (Formula field for date)#2 = Main Verse#3 = Teaching theme/topic This is the email template in the automation - This is the Generated test email - #1 shows up exactly like it's suppose to but, even though there are values in the Airtable record for #2 & #3 nothing is showing up in the test email. I have refreshed, I closed everything and reopened. I'm not sure what I'm missing.  

In my automation I have a trigger when a synced table from another base updates a {risk} field. Automation is currently like this: When a record is update (synced table - {risk} fieldFind record in project list table which matches the trigger record  Update record (airtable id from Find Record step) {Risk Type} (field in the project list table) with {Risk} value in the Synced table {risk} field. But I want to concatenate the values in {Risk Type} field.  Another words I want keep a previous value and add the new updated value.  {Risk} field in the synced table is a single select{Risk type} field in the project list is a multiple selectBoth have the same select valuesScenario: week 1: {Risk} field is set to PTO, result {Risk Type} is set to PTOWeek 2: {Risk} field is set to Scope, result {Risk Type} is set to PTO, Scope 

I have a 'Learn more' URL link on each card, but when I click on it, it opens up to an expanded intermediary page showing the same link information.  I have to click another time to go to the destined URL. Is there anyway I can bypass the intermediary page?  Please advise.  Thank you.

Hi everybody! I’m new here and learning everyday some new incredible capabilities of Airtable. I work for a not-for-profit organization and we often use Kobotools to collect data from our beneficiaries. Kobotools is an ODK based survey platform (kobotoolbox.org). In Kobotools there is a built in REST service and I was trying to connect a an airtable table to Kobo, in order to create a new record with the results of the surveys. But I’ve no expirence with API and I’m really struggling to understand if it is possible to do that and if yes, how I can realize that. Any help is greatly appreciated :slightly_smiling_face: Many thanks, Claudio