Ask the Community

Hi,I am trying to register my localhost rest API endpoint as a notification URL for the Airtable webhook. I am hitting a roadblock with the server sending the following response: [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."}}[raw] => HTTP/1.1 403 ForbiddenNow my questions are:1) Can we register our localhost endpoint as a notification URL?2) I am using the pated below php code. Is it a problem with the code?$headers = array('Content-Type' => 'application/json','Authorization' => 'Bearer ' . $airtable_api_key,);$body = wp_json_encode(array('notificationUrl' => $webhook_url,'specification' => array('options' => array('filters' => array('d

Hi Airtable community! New user here,I am working with three tables in Airtable: 'Families,' 'Codes,' and 'Vases.' Each family in the 'Families' table can have multiple codes in the 'Codes' table, and each code in the codes table can have multiple vases in the third table. The objective is, for each new record, to automatically generate and assign unique codes for each family in the 'Codes' table and each code in the 'Vases' table. When assigning a new code, Airtable should automatically tell me the last code used for that family and assign the next one (for example if xxx-1 exists already, then assign xxx-2) The code format should include the family number followed by a numeric increasing value (e.g., 1, 2, 3). The count should reset for each family, ensuring that each family has its sequence of code numbers. The goal is to implement script in the Airtable Scripting Block that triggers whenever a new record is created on the codes and vases table, ensuring

Hello to all, I would like to be able to copy every day at a precise time the data contained in a column and paste it in another column. This is to compare the progress each day with the day before. Would you have an idea? I was going to use an automation but I can’t find the solution. Thanks a lot, A.

Hello Community,I'm currently working on an exciting project using Airtable and Softr and need some guidance to bring my vision to life. I appreciate any insights or advice you can offer!Project Overview: I am building a web page that is accessible only after users log in. This page is designed to be unique for each user's account.What I Want to Achieve:Personalized User Pages: Each user should see a page that is specifically tailored to them upon logging in.Card Views with Details: I intend to include card views on these pages. Each card should display:ImagesDescriptionsNamesOther relevant detailsDisplay of User-Submitted Applications: Users should also be able to view applications they have submitted.The Challenge: My main challenge is configuring the system so that users c

Hello,I'd like to create a Digital Planner like this one. It seems the Interface Designer lack of feature or may be I don't know how to do it.TopLeft component should be a Record Picker but it seems AirTable only allow Select Box UI not Calendar UI (month) ?Middle component should be Calendar UI (week). It can be  filter on current Record but the date can't be position to current record's date ... the visible range is 00h to 23h30 it can be narrow...Left CheckList can be done with List filter on current record but can't resize title, only add a prefix field.OK : Other fields, description, ... OK : Media field in CarouselAny suggestion to improve the UI ?Thanks ! 

Hi there!I am trying to create a formula that will pull the Last Modified date and combine it with my initials and my Pending Items column. The formula I'm using right now works, but the Last Modified date is pulling tomorrow's date. I'm assuming this has something to do with time zones because it doesn't switch the date until 6pm CST, but I'm not sure how to fix it! Please help 😊Table:Formula:CONCATENATE(DATETIME_FORMAT({Last Modified},'M/D/YY')," ","RE: ",{Pending Items}) 

Hello, Does anyone know how to format buttons in an interface record detail?For example, I would like to move the buttons around and have all 3 be the same size and display at the same time instead of having the weird drop down menu. Also I would like to reorder the position of the buttons.Thanks in advance for any suggestions!  

I'm working on my graduation project, using Airtable as an API. In the API documentation, specifically in the "create records" section, I'm having an issue. When I try to copy the 'YOUR_SECRET_API_TOKEN' for authentication, it stays as plain text and doesn't convert into the expected key format.Has anyone else run into this problem? Any ideas on how to fix it?Thanks for your help!

Thanks in advance for the help - unsure if this is an automation, lookup or sync question.I have two tables in my base that I need to somehow link.Table #1: Content calendar, where posts are to be planned and marked as "ready for approval" Table #2: Task Management, where ideally, once a post in the content calendar table is ready for approval, would automatically be populated into this table with the same info. I would ideally like to be able to switch the status to approved here too and it would be reflected in content calendar. I would also need to add tasks manually in this table that aren't related to posts. I've played around with automations and lookup fields but am at a loss for this one and may not be expert enou

Hi folks,I'm looking for ideas on base design(s) for chemical formulations. I've taken one stab at this where I hardcoded some columns, but that fell apart pretty fast. I'm hoping some Airtable creatives have ideas. Here's the general problem:An ingredient inventory has some number of ingredients A, B, C, D, E, F... etc and can have an arbitrarily large number of entriesA formulation has some number of ingredients (an arbitrary subset of the ingredient inventory, so maybe B, C, F as a random example) and a defined amount of each included ingredient (xB, xC, xF). That amount could be a fraction or a mass in most casesSimple case: how do I deal with a formulation having arbitrary composition of ingredients?More complex case: How do I deal with the above, but ingredient inventory can also include formulations (so it's getting recursive)?Any ideas are most appreciated!Regards,Scott

I've to create interfaces to access to our base, but users that logged in have to see only its own data (user is linked with each row in the database).So they can read, modify data linked with their accountHow can I do this in Airtable? or have I to use only the base and automation and develop interfaces via 3rd parties like Softr, Glide or others?Thanks  

I am trying to put a formula I pulled together in the primary field, but get the following error "Sorry, there was a problem saving this field. Can’t save field because it causes a circular reference".  Back story, I am using one tab to house all the event details. I am using the nesting feature to pull through things I need for all the sperate views (agenda, session intake, speaker details, ect.), where I would usually use separate tabs for each of these things. Here is the formula that I have pulled together. Depending on what Is selected in the Content Track field it will pull a particular reference field. I want to use this formula in the primary field, but even if I remove the "for column 1" field I still get the circular reference error.  Any one have any suggestions? 

I've gone through all the new plans and understand that when our plan renews (we are on Annual Pro Starter Pack currently) we will be changed to the Team plan.But I am still uncertain as to the pricing - we currently pay $348 annually for up to 5 seats.  I have read that the discount remains that we were getting on the Pro Plan - but what does that mean actually. We currently have 2 users.Has anyone been moved from Pro Starter Pack - annual to the new team plan annual. Can you tell me what the renewal price was? Thanks! -The only post I could find I think was for someone who was moved off the starter pack before renewal and lost the discount. 

HiMy card has expired and I need to go to a physical mailbox to replace the card, but that will take me a few days. An attempt was made by airtable to charge the card, but it has failed. How long do I have until my account is affected?

I’m working on an app to keep records for a children’s club. We try to get their birthdays, but sometimes they don’t know the year they were born. Is there a way to enter only the month and day? Ultimately I want to use the date to calculate the age, but I can have a check box to test if the date isn’t complete. Alternately, maybe I can use the age if we know it to calculate the year. I would like ideas for the best way to handle this. Thank you.

Does anyone have an example they can share of a “Now, Next, Later” style roadmap they’ve set up with Airtable? Would be interested in learning how you went about setting it up, since the Airtable timeline view is tied to dates. Thanks!

At work I have an Airtable base as in the attached screen share.I need to create one like this for my daughter soccer team. Is this a timeline view? meaning I would have to pay to create one?Thanks M

Hi, I am total new for airatable. So sorry in advance if it was asked before. But I was not able to find it. I am trying to figure out if Airtable could be use as kind of an ERP. Basically create orders by our sales and than “do automate stuff around it”. Basically I am starting to create table with Form that they would fill up/use with new order. Now to question. Is it possible to create Unique ID that would have specific set of numbers and logic around it for each order? For example: Every order would have unique number Every order number is exactly 10 lenght First two numbers are fixed (11-----) Third and fourth nubmer are last two digits of year (1122…) Fifth number office number (Karen is from Europe office so it would be fixed “5” but Bob is from America so he would have fixed “6”, etc… last five numbers are always unique number always increased by 1 from 00000 to 00001, 00002, etc…

Hi Airtable Community,I am having an issue with a formula that I was hoping to get some help on. Here is the issue:We do our invoicing on Airtable. We have a few different types / categories of invoices - they are as follows:Quotes: This is what we use when we have to submit a price 1st before any approvals to begin have been granted.Suppleental: This is like a change order - we use this when the job has changed and or scope was added.Estimate: This is used  when we have submitted a price but it has not been approved - what we call "settled"Invoice: This is what we use when we have submitted an estimate and it has been approved. We have the primary field be a concatenation field that takes the name  of the customer, the type of work it is, and then looks to the "(MIT) Settled Date" field and if it is empty, uses the word "ESTIMATE" as the last word of the primary name. The thinking here is that when there is no date in

I've got a table that has a single select field. I'd like to parse all records in that status by airtable user, and send that user all records in 1 email once a month.I've got this worked out kind of, but it emails each per matching record - I'd like to make it send 1 email and include all records. Screenshot is what I'm doing that emails each record to that airtable user.  

I got a table with DOB in date format dd/mm/yyyBest way to filter those records whose anniversaries (mm/dd) are within 5 days ahead?

Good morningat the interface level when adding a new customer, is it possible to find a solution for duplicate customers (who have the same telephone number)??The objective is to distinguish duplicate clients or, if possible, block the addition of a duplicate client.for example color duplicate records or add a new field that counts if the same number repeats or use a script in the interface

Hi there! I am looking for a solution how to export my Airtables to Excel (or csv) and change the number format at the same time. Example: I have a column with prices and they’re displayed in the format $1,000.00 but I need them in the format $1.000,00 as I am in Europe where this format is more common. Is there any chance to get Airtable and or Zapier to do that? Cheers, Tobi

Hello Airtable Community,I hope this message finds you well. I'm currently working on a project where I've implemented a referral code system in Airtable, and I could use some guidance on handling potential duplicates.Here's a brief overview of the situation: I generate referral codes in the format "Four letters of firstname, -D, and last 2 digits of the phone number." For instance, if I have a user named Johnathan with the phone number ending in 19, the referral code would be JOHN-D19. If i have another user named John with the phone number ending in 19, the referral code would also be JOHN-D19. Now, the challenge I'm facing is that I want to avoid assigning the same referral code to different individuals. To achieve this, I'm looking for a solution to identify and handle duplicates. Here's the logic I'm aiming for:Identify Duplicate Referral Codes:If the referral code is duplicated, proceed to the next step.

Hi All,im trying to create a button in an interface, of which the interface has a project record picker, that will trigger an automation, to find records in another table.the project picker is set to a particular table called PROJECTS.the button is set to find records in a table called PAYMENTSwhen creating the button and setting up the automation, the conditions of the FIND RECORDS option can set up all the requirements but won’t limit to the particular project that the Record Picker has selected. In fact it won’t let me have any condition relating to the PROJECT. When I test, it picks all records not limited to the PROJECT. Is there any way to let the RECORD PICKER limit the button automation selection… eg.Record Picker: set to PROJECT number ‘100’. So all records assigned with project number 100.Button set to find all records in PAYMENTS tab with other conditions, but can’t set it to only also find re