Ask the Community

Hi everyone ! 👋I'm setting up a database with a lot of elements coming from different tables.It's a database on which sales people have to make modifications, but I'd like them not to have access to this database in Edit mode.To remedy this, I'd like to create a form with an active search.e.g.: They enter a customer's name, and all the information we've already pre-filled in the fields, to avoid duplicating questions.Have you already implemented this? Is this possible?If not, what tools or workflows would you recommend?Thank you !

I have an org chart that's looking good except for one thing: the lines that connect the name cells are in a faint blue that is all but illegible. The help bot gave me irrelevant advice, so I'm trying here. How can I configure the color of those lines? It's unusable like this.

Hello smart friends 🙂I've got a base I'm building to track companies within a community with their contact info and other demographic data listed.I'm pulling data from two different sources into the base (displayed as one primary table and 14 other segmented sublist tables) and need to incorporate the data in the following way:- The primary / working list that has the entire list of companies in it needs to have the ability to be segmented by "affinity" tags- The data to determine those tags is in each of the segmented lists, each of which has a handful of entries from the primary list but sorted by a particular affinity, i.e. "black-owned" or "women-owned"- And since some companies will have multiple affinities, i.e. being both "black-owned" and "women-owned", the tag column needs to be able to account for multiple entries coming potentially from each of the indiviual segmented sublists. I can see a way to link a reco

Need a way to have the sum of the columns be viewable in an interface like below.  

Hi All! I am hoping this is an easy problem to solve 🙂I thought this would be really simple, but I'm struggling.I have a project "Start Date" field. Every time one of my users updates that "Start Date" I would like AT to automatically retain the last start date before that change in a "Last Start Date" field.So if "Start Date" was 01/05/2024 and someone changed it to 12/05/2024, then "Start Date" would read 12/05/2024 and "Last Start Date" would read 01/05/2024. Each field would then update every time the "Start Date" field is consequently updated, which can happen numerous times.Any help / advice would be very much appreciated. I am hoping that this can be done with AT as opposed to using any external connector.......

I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteeredI want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and if I filter for the specific month, will it still work?Thank you! 

Can someone tell me if there is a way to select several tables at once to move them? For example, when creating new tables, they are automatically placed at the very end of all existing tables. We have a lot of tables in our base, and I often have to create more, usually many at a time.  If I need them to be located at the beginning, or at the top (of the table list), it can take time I don't have time to move them one by one. It seems like it would be a pretty basic function that you would be able to select more than one table at a time in the table list and drag them up to the top of the table list, or select more than one table's tab and move them over all at one time. I've done searches, but cannot find an answer. What am I missing? Thanks.

Hello!I am wondering if this might be just an Airtable "bug" or if anyone else experiences this issue.I have a notification system set up through automations. On my data table, I have a formula that will make a list of everyone who needs to be slacked/emailed from the team. Those names are then updated into a User field via an automation. This portion all works perfectly. The problem happens sporadically, some team members will receive the notifications just fine, but others on the list won't receive anything at times. The Automation has no failures and even lists the correct users as recipients. I've had everyone check their slack accounts to make sure Airtable is integrated correctly, and it definitely is because they receive other notifications just fine. Anyone out there with the same mysterious issue?

Hello Airtable CommunityI have a base with several tables (one for each department) to plan their content. So print, social media organic, PR etc.Each team has 1-3 interfaces. Now I want to synchronize the most important information from all these tables into one table in the same base. I want to have a comprehensive content calendar to see at a quick glance who is working on what. Unfortunately, synchronization only works over different bases. But then I can't display everything in one interface and the employees would always have to switch bases.Does anyone have an idea for this?Best regardsMirko

When I try to add a record in the linked record field I get an error message "You are not permitted to perform this operation". It does not happen in all ‘link a record’ field but in some, randomly. The issue is occurring on my iPad and iPhone apps. It seems working fine on Safari browser on my Mac. I am the owner of the base. It started happening about 1-2 weeks ago.Any suggestions? Thank you!

It’s slightly similar question to the previous poster actually. I have a field which has numbers in it. If I do this (grouped by field), it shows a very neat view which also contains SUM of each group. The question is. How do I get this sum to my other table? In my screenshot, that will be how do I create a record on other table which has my [400x600] text and ‘30’ integer in it? Is there a very easy solution that I miss? Thanks

We’re using Airtable as a PIM for clothing and we sometimes do modifications that creates a new style code. A lot of the information is the same (as it’s just a modification), but I don’t want to copy over any linked fields or certain notes on an item. I was wondering if it was possible to create a script that would let you select an item you want to modify and create a new item with select information from the base item. The links are in the same table FYI.

I have a blank line chart. How do I add data to it?

Hello Airtable community,Wondering if it's possible to make a pareto chart in Airtable. I'd appreciate your help!

Whatever I do, I can't pass date from our CRM or Make to an date field in Airtable with the same error as per screenshot. Please help

Hello, wondering if someone could help me correct the formula in the photo.  I am hoping for this to happen:If OLD JOB# is blank, display current 2 digit year (CREATED DATE) & "-" & 4000 + ID#. If OLD JOB# is NOT blank, display OLD JOB#For example, looking at the last 2 rows at the bottom, 42 is correct, but 43 should display "24-4183"

I am trying to set up a form that will collect requests for a dozen kinds of products from users (eg, shirts, hats, mugs...) I have a limited amount of each product available.Is there a way to omit certain questions if the limit for that product has been reached? The number is based on all submissions -- not just each individual form submission. I thought about adding a condition for each question related to the sum but I couldn't seem to make that work. Is something like this possible? Thanks!

Hi. We're using the Teams integration to send notices from AT when something happens (new email meeting a criteria, new client opened, etc.).The messages come through to Teams but are never bolded in the channels list and we don't get notifications. (Notifications work fine for all else.) We've reinstalled, re-linked, emptied the cache, everything.Is this a Teams problem?

Would be great if there was an option to select another attachment field as a fall-back for gallery view in interfaces

New Airtable user here! not quite sure If I am out of my element, but I am looking to streamline a work operation to where our intake team receives a vehicle, and records are created for them to validate all of the parts from the vehicle, efficiently as possibleI need a user to login to a "form" with 6 steps:Drop down- 6 optionsnumbertexttexttextbased on the dropdown option, this creates records in a new table based on records in an existing "template table" (6 tables for each option) and concatenates the input number with a defined field from the existing records. also auto populate fields in the new table with the number and 3 text fieldsThis notifies user 2user 2 logs in to access only the new table, that is displayed as a form view for each record- they need to validate vehicle parts Ideally, they can upload a picture as one of the fields as wellWhen they finish, t

I am looking at the template "Project Management" Template which has some good wireframes for my next project.Let's say under "Mars Explorer," / "Design 3D Model" as shown below if I change the status to "In Progress," and my start date is a bit earlier, let's say 12/25/2023. When I make that selection and change the start date, the deadline will also change because the duration is set to 2 days. So far, so good.Now, the next task in line "Develop interactive...." (the above item is its "Predecessor") will not have its start date moved by two dates (I am expecting the date to move to 12/27/2023). Is there a way to accomplish this for all Tasks whose Status is not "Done"?

I need to add a list of countries and languages as options for a few different fields. When I open the Single Select field, it forces me to add each option one by one. This would be extremely time consuming. Surely there is a way to add options in bulk? Would really appreciate it if someone could tell me how to do this efficiently. Thanks, Alex

This doesn't seem difficult in theory, but I can't figure out a way to make it happen with automations.Situation: In my Training Feedback table, I have a lookup field "Trainer (from Training Taken)" (a lookup from the Master Training List table), from which I need to copy over the field values to the linked record field "Trainer" (linked to the Trainers table), so I can associate trainer feedback data directly with the trainer(s) in other places in my base. The problem is when there are multiple trainers (i.e. multiple values in the lookup field). When attempting a simple transfer of field values to the linked record field using an Update Record automation, the automation fails for multiple trainers. I tried a repeating list automation to Update Record for each trainer in the list of "Trainer (from Training Taken)", but that results in only the final value in the list of trainers being added to the linked record "Trainer" field, since the automation overwrites the value each

I have an automation that is using a script I found on the message boards to format numeric values to currency. It works great. I pull the value from the script into the body of an email automation. However, when there is no value in the field I am using instead of showing nothing in the body of the email it shows 0.00Below is the script being used. If amount to send in USD for Email is blank how can I suppress the 0.00 from showing in the variable placeholder in the body of the email?  let inputValues = input.config();let currency = inputValues.currency;//define function to convert numbers to currencies for&nbs

Hi All! So I have set up an automation that adds a tag to my "Status" column (which is a multiple select column) when a certain checkbox is ticked as true. The automation seems to run fine, BUT, it replaces any previous tags in the "Status" column that were there beforehand. Is there a way to prevent the new tag from replacing the previous tag and just adding a new one? I did do some research and it looks like in previous versions of Airtable, one could select "Append" in the action section of the automation set up, but that doesnt seem to be an option now? Anyone got any pointers for me please? x