Ask the Community

Hi! I have a problem with Interface Designer for 2 days. When I'm clicking "Field summary" In Charts Settings, nothing happens. Please see the loom: https://www.loom.com/share/3ed6c002e63b47fab76500a9264801ca?sid=b3e773c1-29b7-4398-b5da-4d0e2ce4acb9. It is applicable to all my charts in many different interfaces. 

Hello, I do not know why in an invoice there is so many lines with remaining time and unused time. What it is?I have a team account with just me as editor and some other user who are just in read only. Someone car help me please? sorry for my english I am french 🙂  

What I am trying to do is change the Status of a Project once the Status of all six associated tasks (in separate tables) are set to complete. I tried doing a formula approach with calculation fields (count) using this formula below (but the formula in the field gets cut in half once I save and close so its useless). I asked support if there was a character limit but they could not even answer that simple question.I am not married to the formula approach, in fact I'd rather not do it that way and have 13 extra fields in the Project record. Is there anyone out there that knows how to do this? Formula I created: IF(AND({Design Completed Tasks}={Design Total Tasks}),AND({Email Total Tasks}={Email Total Completed Tasks}),AND({Organic Social Total Tasks}={Organic Social Total Completed Tasks}),AND({SMS Total Tasks}={SMS Total Completed Tasks}),AND({Paid Social Total Tasks}={Paid Social Completed Tasks}),AND({Content Total Tasks}={Content Completed Tasks}), "1")

Hello, community! I need to create a formula (or find some other way) to keep track of changes to individual cells in "column A" via a second column that auto-populates with first entries in column A but does not change if column A changes after that. So for example:  Column A = Project Start DateWhere a user manually enters the date they begin a project.Column B = Original Project Start DateWhere it auto-populates with all existing dates in Column A + new dates added to empty cellsBut does not update itself when a user manually changes the date in Column A after that. The goal is to be able to allow users to adjust or move out their start dates as needed but also keep a record of what the original date was without adding any other manual steps. I really hope this makes sense! TYIA for any help or ideas! 

Hi, We are looking for ways to pull data from our Linnworks.NET account (basically and order and inventory management platform) to Airtable. So far we have been using MiniExtensions to import csv files with data exported from Linnworks to Dropbox or FTP server. This has worked well, but MiniExtenions have a limit of 10 instances of their csv import app, meaning that we are limited in the type of data we can import. We have already hit this limit. I realise that the best solution for transferring data would be via api, but I am not yet very familiar yet with writing api calls. The big stumbling block to this going ahead, from what I can see, is managing Linnworks Authorization. Linnworks Developer Resources - API Home My question is a general one. Does Airtable scripting allow means to acquire auth tokens and use them in subsequent calls to Linnworks.NET for data, or would we need a 3rd party app as a go between? Thanks in advance for any help or insights here. Dominic

Hi,What are the best tools to integrate instagram with airtable?We would like that an automation reads our instagram DMs,gets the data (contact phone numbers, etc), and automatically inputs it into our airtable base of instagram-leads. 

I realized that the sync is not performed if you are not logged. I have a sync’ed table and an automation associated to this table triggered when a records enters a view. Unfortunatelly, it is not triggered unless i sing up and the sync takes place. Is that right? For sure i can solve the issue changing the automation to the source table. Hw, this source table it is so big and i d rather do the other way. Thanks!!

Hi,I have seen a few posted questions that are similar to my scenario, but I need more specific assistance. I am trying to update my Appointments grid view records when someone cancels their appointment that they've scheduled through Calendly. I have tried to create the right formulas for record look up in Zapier and Airtable Automations, but they keep coming up empty. In Zapier, it looks like it might be a multi-step search which is only available on paid plans and I really don't want to have to pay for another subscription to do what might be possible in Airtable alone. Please help! Thanks so much 🙂

Longtime Airtable user, but limited experience with Interfaces.My regular workflow has three browser windows open at once:Window 1: Shows the fields of one record from Table AWindow 2: Shows a filtered view of the records in Table BWindow 3: Shows a filtered view of the records in Table CIs there a way to create a single interface to show these things?

I am building a web application for my students using Node.js/Express that displays information from an Airtable base.  Instead of embedding a table of news stories, I want to pull several fields from the table and insert them into the DOM so I can design the display of information. I've been able to send 3, 5, 10 stories to the console, but when I try to send a second story to display on a web page, I keep running into this error:  TypeError: Cannot read properties of undefined (reading 'offset') which points to part of airtable.js that compares result.offset with params.offset. I've tried to find an offset in the json but I don't see the key or values beginning with itr.I tried to call record.offset but it is undefined.Several community posts about offset explain how to find more than the maximum 100 records, but I'm getting stuck on the second record.I found Offset property missing in API response as an open issue on Github from 2021, so maybe

I have a linked table called "Voucher Codes" and as you can see from the attached screenshot, I can click the + and select a voucher code from this linked table and assign it to a record in the Order Fulfillment table. This is great, it works, however it shows everything in the view "Available" in the "Voucher Codes" table.  Is there a way I can have it ONLY show voucher codes in the "Available" view if it matches the "Course" field in the "Order Fulfillment" table as the attached screenshot shows? For example, if the Course says ITIL 4 Foundation w/TAKE2, it should only show voucher codes that are titled ITIL 4 Foundation w/TAKE2.  And if it the Course says ITIL 4 Foundation, it should only show voucher codes that are titled ITIL 4 Foundation, and so on. Is this possible?

I would really like the ability to group related tabs within a base - it would make our database so much tidier and easier to navigate. Thus far I can see no such function. Does it exist, and if not, how can I suggest such a function to them? 

I have an extensions that use useCursor, useLoadable, and useWacthable. I am able to run an extension application and get the correct entry id to generate what I need to. After I have run the extension and click on a different cell I get tons off errors in the console that looks something like this.   ~Uncaught (in promise) Error: comment count out of sync at RecordStore. _ loadCellValuesInFieldIdsAsync$ (bundle. js 1: 180883) at tryCatch (bundle js:1:1444931) at Generator. invoke las invoke] (bundle.js: 1: 1444536) at Generator.next (bundle.js: 1:1445835) at tryCatch (bundle js:1:1444931) at invoke (bundle. js:1:1446108) at bundle.js: 1:1446340 loadCellValuesInFieldIdsAsync$ @ bundle.js: 1 tryCatch @ bundle.js:1 invoke @ bundle.js:1 (anonymous ) @ bundle.js:1 tryCatch @ bundle.js:1 invoke @ bundle.js: 1 (anonymous ) @ bundle.js:1 8 Error: comment count out of sync at RecordStore.. _loadCellValuesInFieldIdsAsync$ (bundle.js: 1:180883) at tryCatch (bundle.js: 1:1444931) a

I’ve seen the many posts advertising a shortcut product, but it is rather expensive (and due to the nature of the product, I can’t test it first). I really don’t want to leave Airtable, but the inability to save websites from Safari to a table has become a deal breaker for me (use case: student research project). I don’t need it to be super fancy, simply saving the URL and page title is enough... does anyone have a working solution?Alternatively, if someone can point me in the direction of an easy to understand tutorial on how to create a shortcut for this, I would be grateful.Thanks 🙂  

I think this is a fairly straightforward process, but I am unable to figure out how to do this. I have 2 excel sheets imported. One is Product Master List, one is Inbound Shipment. The Product Master List contains Code, Product Name, UOM, while Inbound Shipment contains Delivery Number, Code, and shipping date. I just need to add a lookup field in the Inbound Shipment, to look into the Product Master List for the Product Name. Just want to make sure I'm not crazy, because it sure seems like extra work for what could be available . 

I have various contracts and various contractor invoices that I need to review, and I want two formula fields to confirm whether the billing periods covered by each invoice - and the invoiced amount - are "valid". My table is pulling in the contract start and end dates, as well as the budget balance and total invoiced, from another table. Right now, I have 3 manual entry fields: 1 for Billing Period Start date, 1 for Billing Period End date, and 1 for Invoiced Amount. I created a formula field to confirm whether the billing period falls between the contract start and end date, but it currently shows billing periods that start or end on one of those dates as invalid. IF({Billing Period End}<{PoP End},IF({Billing Period Start}>{PoP Start},"Valid","Outside PoP"),"Outside PoP")I thought I could adjust the < to <=  and so forth, but figured there must be a more elegant way to do this. I also want a field that will confi

Hi allI have created an automation so that when I Trigger 'Create Dispatch' button this will automate a dispatch quantity.I want to have this trigger reset back to being a blank field as below.  Below is the automation with error populated on the 'Update Record' Thank you in advanceGeorge   

I have an attachment field that I am manually uploading items to, but the original files live in my Google Drive. I'd love to have these connected somehow so that if there are updates to the files, my attachment field will automatically update. If I delete files in my Google Drive and then upload new ones with the same name(s), is there a way to make this automation happen?

Hi there! So I have a few bases (Newsletter Tracker, Task Manager, Content Creation Schedule, Signings & Events) and each of them have due dates in them and their individual calendars. Is there a way to have a master calendar or to have all of the calendars in different bases within a workspace to sync or sync to one calendar? I have a Teams Subscription if that helps!  Thank you so much for your time and any input! 

I'm a new owner to my company's workspace and I'm trying to understand the billing.We get charged annually in May for all the users, and then we get subsequent monthly invoices that say:Remaining time on 10 × Team Annual after 02 Jul 2024 (a positive $ amount)Unused time on 9 × Team Annual after 02 Jul 2024 (a negative $ amount)What does this mean and how is the dollar amount calculated? I would think we should just have to pay the yearly amount unless there are hidden add-ons I'm not aware of.

Hi,My client has some rather long items (meeting objectives) they would like to show in a pivot table. Is there a away to extent the first column on the left to view all the text?  Thanks,Rachel

Is there a way to switch back to the old home screen dashboard UI? Maybe it's just me but I found it far better organized and a superior UX overall

Hi there! This may be more of a Zapier question but posting here anyways. I am wanting to add or find and update an existing field airtable when a purchase is made from kajabi. Having trouble figuring this out on Zapier: https://www.loom.com/share/bdf00a2d8d8248449acf795d692cf4d0?sid=0dcc78b6-8953-4e77-b369-ffca126fd2c1

Hi! I need help. I am attempting to connect a Jotform to my Airtable. Here is the problem: on the Jotform, users can submit multiple students to nominate on one form (ex: student 1, student 2, etc). From there, I want the data to populate on my airtable base as separate students. Right now, it only gives me the option to link one student to airtable base. does this make sense?Basically, I just need to figure out a way to configure my Airtable to accept multiple submissions of students. We have used Airtable to collect event participants info, etc. Now, when a jotform collects multiple participants info on one form, I am unsure how to populate that onto airtable as seperate  people.

I'm building a base to help track my company's product lineup and I've built an Interface for each one of us 3 founders have our own To-Do interface, populated from a To-Do table. This To-Do table gathers information from other tables such as customer's name, product selection and other items. I want a column "Extended Task" to populate with a short checklist automatically, based on a selection of a "Task Group" field (which I've made a Single Select drop-down field in an effort to keep the names consistent). I thought of using an IF formula, where IF "Task Group" is "Quality Check", then the "Extended Task" field would get populated with "Verify Unit Powers On. Verify IR Remote Works. Visual Examination. Inputs Tested.  Doors Open Smoothly. Lights Operational." in checklist form. But not only can I not figure out how to do this complicated IFTTT formula, but I am also not sure if this is the best way to go about it.Here's an example:In this example, I've copy and pasted