Ask the Community

I'm really hoping this can be accomplished without needing to create yet another formula field, so I'll give details below and see where I get. 🙂I have fields for start and end dates and then a formula that calculates the duration between them, including when the end date is blank and then it just keeps counting from the start. I want to have a chart show this data on an interface, but I don't want every single value showing uniquely on the chart if possible.Instead, I'd like to have it group them into buckets for things like 0-30 Days, 31-90 days, 90+ days, but I can't see any way to do that intelligently within the interface. My fear is that I'm going to need a formula field that gathers this at the table level and then point the pie chart to that field instead of the duration field.Anyone have a suggestion for the best way to accomplish this kind

Hi Airtable Community, I have a base that I’m using for personal lifelogging which has three tables: activities (“Dinner with friends”), location (“Sal’s Pizza”) and people, (“Nancy,” “Jonathan,” etc.). Those tables all link to each other. However, within the “people” table, I want to show relationships: parents, children, siblings, spouses, etc. Unlike when I link to another table, using a linked record here doesn’t seem to auto populate—so choosing one person as another’s spouse does not automatically fill in the other one. Any suggestions from users or mods out there on how to accomplish what I’m trying to do? Thanks!

I have a base "Inventory and Catalog" to keep track of seed received and varieties. This is the sourceI sync a catalog table to a base "Trials" where data lives about projects. I sync the variety catalog to this base so that users can link varieties into trials and say how much seed they'll use per trial.So i've added a linked record field in the synced catalog table for "trials" and then a field that rolls up how much trialing seed is used per variety. I want the seed used roll up field to then appear back in the inventory and catalog base but can't seem to figure out how to make that happenFor security reasons, I cannot put trials and varieties in the same base because varieties are entered with an external form, and our IT doesn't want that third party to access our trialing information.

Can't seem to find this on the community board, but if it has already been answered - I'd appreciate a link. I have Projects and Subprojects. The latter being the child. So there are a few Subprojects for every Project. On the other hand, I have Project managers. I want to have a "Tasks" table with all the tasks assigned to Project managers. My issue is that I want tasks to be EITHER created related to the Subproject, OR related to the main Project. The same exact relationship issue I encounter is when I have "Payments". A payment can be to a subcontractor - and therefor related to a Subproject. OR a payment can be to a Sales agent who brought the Project - and then it would be to the project. If I create two tables for these (i.e. "Project Tasks" and "Subproject Tasks" or "Project Payments" and "Subproject Payments") then it really just duplicates a lot and it also makes it im

Hi there - I keep getting hung up on lookups and links and it's driving me bananas so it's time to phone a friend! To generalize, I have a "Counterparty" table that lists all of the counterparties our organization has a contract with that includes their state and county (these are also lookups from another table which might be complicating matters). I have a second, "Local Office" table that is synced from an external base that lists every local county office by state that counterparties need to meet with as part of their contract. Each row is a different office and the columns are "state, county, office name, phone, address." Each state is naturally different, so, for example, New York has 10 rows/county offices and New Mexico 4. Super basic, right?I want to link the two tables so that we can create an automation that will automatically inform the counterparty the name and contact information for their local county office from the sync'd Local Office

Earlier today, I deleted some value options from one of my single-select fields (Team Type) in one of my tables - I did not do anything else like delete the field, change its type, or change any field permissions. Now in the Interface builder, a Grid element linked to that table is grayed out with the error message "Field "Team Type" was changed and can no longer be selected". I have hidden and unhidden Team Type from the grid Fields list, and gone into Edit it and then Saved it without making further changes, but nothing I've tried is working. I made this change a while ago, so it is impossible to go back and literally undo the actual option deletion action I did, and the change is necessary for our data so I don't want to return the data to its previous state anyway. Does anyone know what is happening here and how I can restore my grid? Thank you for anything you can offer!

Hey there, I have a automation setup in a client database that is triggered by me changing the status and then sending a calculation to a customer with a link to a reference check interface form, because there are so many people who need their references checked with this form we need to put in the name of the candidate and the reference prefilled in the form. (due to privacy issues we cant have them searching up their name btw)I created a claculation that has the form link and then the url prefilled instructions for the names for the ref and candidate. It brings up the candidate most of the time but the reference not really, Im not sure if its because the reference is in a different table but Ive used the 'prefill_Reference%20Name=Reference Name' and ' prefill_Reference%20Name=Reference RECORD ID' (In the appropriate code ofc) and it works some of the time. I find that when I clear cookies in my browsers it works but I was wondering what the real issue is because I need

Hi there, I'm having issues with an Automation that I've set up anytime a record is updated between Airtables that are all within the same Workspace and have been granted the same permissions at a Workspace level. I'm getting a message that says the update failed due to insufficient permissions.  However, each Airtable belongs to the space workspace and has the same group permissions. Anyone know how I get support on troubleshooting this complex issue?

Probably a simple solution, but I can not figure it out. I am using the following script to try to get a list of all of the records in a specific table.let table = base.getTable("Codes");let query = await table.selectRecordsAsync();console.log (query) When I run this, I get the following error O: No field with ID fldwfud1d0wv3rdVD in table 'Codes' at main on line 2When I run this same coding using one of the other tables, it works as expected. Any ideas on how to fix t

Hi Friends! Can someone please help me with this? I manage a small team of 3 members. Let's say I have 3 tables: 1. Projects, 2.Tasks and 3.Subtasks (linked with one another).So I have an interface where each user can see everyday the projects, tasks and subtasks asigned or due for that certain day.I want a way to track productivity, or what have been done each day by each user, in someway that is simple and ideally automated.Do any of you have any idea of the structure I must follow to accomplish this?Thanks in advance

Fairly new to Airtable, so big picture question:I have a table with all records of product type (Master List)I have a second table with similar record fields, not identical (Inventory)I need to create a new record in inventory when an action is taken (button click in master list?) which will bring over relevant data but not all.Help please! 😂

I have created an interface in Airtable. I want to disable the inline edit option and enable the add/delete record inline. Are there any possibilities to do this?I must enable inline edit records when a table value field is "Yes". Otherwise, it should be disabled. But I found that is not possible. Then When expanding the record from the interface edit form appears on the right side, hiding/showing the visibility of some fields based on condition.But disabling edit inline records in interface settings Add/delete inline option is automatically disabled. Please suggest any possibilities.Need an option to enable add/delete inline option and disable edit inline records.https://www.awesomescreenshot.com/video/29750457?key=fcf1499acd92927ea57120ba17a70835                      &nbs

Hi there, This question is for the Airtable team. I see that you are using browserify to bundle the block code, would love to also be able to bundle external css files with the block, instead of loading them asynchronously using loadCSSFromURLAsync (which also makes development and deployment more complex). There are quite a few browserify transformation packages that can make that happen, but I haven’t been able to make them work so far, when trying to control browserify transformations from the package.json file. Here are the packages I tried / found so far: brfs - doesn’t work with es6 modules brfs-babel - doesn’t do the transform, for some reason, even when i add {"browserify": {"transform": ["brfs-babel"] } } to package.json

My Rollup field has (correctly) returned this array to me ARRAYJOIN(values) by looking at linked records (4 People) and their dietary requirements (dietary preferences are determined by a multiple select field):None,Allergy to Nuts (other than Peanuts),Gluten-free / No beef / Allergy to Nuts (other than Peanuts),NoneAnother formula field formats this array into an easier to read arrangement:1 x None1 x Allergy to Nuts (other than Peanuts)1 x Gluten-free / No beef / Allergy to Nuts (other than Peanuts)1 x NoneWhat I would really like is to find a way to combine any duplicated items and show the correct count for them, such as:2 x None1 x Allergy to Nuts (other than Peanuts)1 x Gluten-free / No beef / Allergy to Nuts (other than Peanuts)Any advice on how to do this please? I want any formula to work dynamically with the content of the array, as this will mak

Is this possible? I am unable to get the attachment mechanism working in an automation with send email action, or am simply misunderstanding. I just want to send all records in a view as a csv.

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

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 an

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.