Ask the Community

I have a multiple select field with four options: 2020, 2021, 2022, 2023. I want a formula field that prints how many of these options were selected. I played a bit with Count and If statements, but couldn't get anything to function quite right. Any help appreciated! 

Hi there,On this interface page, I have 2 progress bars: one visualizing the percentage of people who said 'yes' on a topic and the other one for 'no'.But instead, I'd like to get a stacked bar chart that combines the two figures into one single visualization object (like in the example below).I don't think that's possible as of now on Airtable, at least not on a List-type page. Do you guys confirm?Thanks for your help.

Hi there,We're building a decision-making helper tool on Airtable to reduce the number of meetings at work. For each topic that requires discussion, we intend to have people use a dedicated Airtable interface. On it, someone creates the topic to be discussed and then assigns the relevant participants to it. Later on, the assigned participants weigh in on the topic.The screenshot below displays a list of the decisions to be discussed and of the positions taken by people. Hierarchy on this page is turned on, with topics being on Level 2 and positions on Level 1.As of now, new topics can be created with a short form that opens up when clicking a button, while positions can be created inline. But for the interface to be as simple to use as possible, we would like to make it possible for both decisions and positions to be added inline. We couldn't figure out how to do that, though.Do you know if that's possible?Thanks for your help.

Looks like all of my interfaces that have timeline views have pulled in all 'preview' fields into the record label ... Seems at the moment there's a bug where they can't be seperate and it looks super messy Thanks!Ross

I saw the functionality below on a youtube video from earlier this year, and I'm wondering if there's anyway to implement it, without using the Project Management template? It looks like, from an assignee field dropdown, it gives you a before and after of that user's capacity if assigned to them.  Amazing!Sadly, we're rolling our capacity up to Team level, as we have too many people to use it at the User level, but would love to see if this functionality is accessible outside of the template.Also if anyone has an thoughts / ideas / implemented solutions for forecasting using the utilisation tool, I'm all ears!  At the moment, it seems there's no way to see how a project will affect overall business capacity without adding a full project loaded up with all tasks, etc.  I'd love a similar setup to the above where you'd be able to see the impact before committing it to the schedule ...Cheers!R 

We have a load of addresses in a database. They are individually pasted into a Long Text field.The issue:Some addresses are in this format - 51A Wigton RoadCarlisleCA2 7AYAnd some addresses are in this format- 51A Wigton RoadCARLISLECA2 7AY So the difference is that the Post Town is uppercase - which is what we want.But a lot of submissions have come through in lower case on that second to last line, which is incorrect. I need a formula to find and replace the all text before the last break and after the second to last break, ie. all text on the second to last line. And replace it with the same text but in UPPERcase.  The addresses are not always on 4 lines, sometimes they are on 5 lines, so we would need to work backwords from the last break. A formula to do this would be much appreciated.  Thank you in advance.

Hello,I work for a growing nonprofit that needs *help* in the area of Email Marketing.  We use Airtable to manage our various lists of people and their contact information, but I need a good Email Marketing App that will integrate well with Airtable. We're using MailChimp right now, but it's a mess because it's not integrated with our Airtable contact lists. Can anyone recommend a setup for using Airtable as the CRM, integrated with another Email Marketing App that can:Automatically sync contact lists "two ways" with Airtable.Meaning, if someone updates the Airtable list then the Email App's List will be updated, or if someone Subscribes using an Email App SignUp Form then Airtable's Lists will be updated. (FYI, MailChimp doesn't do this natively, neither does Outfunnel which integrates Airtable and MailChimp.)Manage the Contact Lists, tags, groups, etc. in Airtable, andDesign & send no-code marketing emails using the Mail App, pulling from my Airtable lists.I was looking

Hey! We build our company automation and centralized system with Airtable's API & Automation systems.We use 1 Workspace with many many different Bases. Could the Dashboard (in the main view) have folders inside the Workspace that can be used to divide the different bases, which would make it easier to organize and find the right Base. The view looks really messed up right now. 

Hello everyone,I'd like to have an informative main field in one of my tables but im blocked because of circular references. To be brief, I have a table Programme, that is referenced in Sessions, that is referenced in Half-days, that have begin & end dates.In Sessions, i have a cumulative field that defines which is the earliest half-day of the Session in the field {from} and the latest in the field {to}.Id Like for Sessions to have in their main field this formula:{from} {Code name of Programme (from Programme)}and I can't because it is causing a circular reference.Is there a workaround any of you can think of?or How can I get more information about the error to try and solve it?

I live in Lagos, Nigeria, one of the biggest commercial hubs in Africa and I think it's a shame that Airtable is hardly known here. People are still using decade old desktop versions of popular office software that they learned to use when they were in university. I would like to officially partner with Airtable to showcase the product to businesses in Nigeria and Africa as a whole. I sent an email through the Airtable contact form about this but I received a generic response that sounded as if the person didn't even understand my request. I'm hoping that an Airtable community manager or sales representative will respond to this post.

I have this table set up where I have a running balance of what being added and taken from a cash register. I am running this script for it: // change these names to pick a view:let table = base.getTable('TIN');let view = table.getView('ALL');let result = await view.selectRecordsAsync({fields: ['Gross Added or Subtracted']});let runningTotal = 0;for (let record of result.records) {// change the field names here to adapt this script to your baserunningTotal += record.getCellValue('Gross Added or Subtracted');await table.updateRecordAsync(record, {'Running Balance': runningTotal,});} BUT, when someone counts the actual amount in the register, I want the running balance field to become equal to the actual count. How to I do this? 

I have two tables:Table one shows a list of tasks done on different computers and when the task has been marked as finished:TaskId, FinishDateTime, Computername.In table two I have information who was logged in when on on which computer:DateTimeStart, DateTimeStop, EmloyeeName, Computer. I want to have in table one an extra column, showing the name of the EmployeeName that was working on that computer while the task was finished. So we need to use the FinishDateTime and Computername to query the other table to find a match with exactly this computer and FinishDateTime in range between DateTimeStart and DateTimeStop. The result of the formular should show just the Name of the Employee. I hope this is clear. How to create the formular? I am familiar with excel, where i would do some kind of nested vlookups, but have no idea how to achieve this in airtable.

Hi there!  I'm hoping someone can guide me to a tutorial or has some great design ideas:  I have a base that calendarizes a huge list of events across multiple departments.  I have an interface page set-up with a record picker that displays relevant events.  I would love for each department to be able to review the list periodically and either suggest edits to existing records, or request new ones be added.My reason for not having them directly edit the records is because I want to (a) be sure that I know about changes, (b) can resolve conflicts if different team members varied info (that happens!) and (c) am concerned about data integrity when many of our users aren't regular airtable users! Is the best solution here to just allow users to make edits directly & just create some level of automation/notification when edits are made?  Or; I had thought to just request users to make edit suggestions by adding a comment to the record, and I'll get a n

Hi all, I'm very curious if this can be replicated on Airtable interfaces. From my experimentation, the filename of the image keeps coming up and I can't remove it. How do I develop this? Or is this just "non in-application screens"?

I am trying to achieve the following:A "Points" table that stores usernames and points associated with themA "Leaderboard" table that aggregates all points for the users, i.e. sums up the points for each userI set up the Leaderboard table first where I defined a "Username" field as the primary key and a "Total" field as a number field. Worked fine.Now I wanted to setup the Points table so a Username field points back to the primary key "Username" of the Leaderboard table, like this: { "name": "Points", "description": "Points table to track points per user", "fields": [ { "name": "Id", "type": "singleLineText" }, { "name": "Username", "type": "multipleRecordLinks", "options": { "linkedTableId": "tbl..." } }, { "name": "Points", "type": "number", "options": { "precision": 0 }

So my goal is to automate image enhancing via form submission.When my table receives the form submission, most of the time, it will receive multiple images ("rawFiles").Once it receives the data, it will send a webhook to Make.com where it all goes through the automation.My issue is "rawFiles" only receives data as a string and not as an array. I would like to pass this data as an array so that my webhook in Make can process it properly.Here's my current script: let inputConfig = input.config(); let webhook = 'https://hook.us1.make.com/s3i0oapoqp08n8wxigxpv7jl826k24lw'; let queryParams = `/?Record ID=${inputConfig.recordID} &Raw Files=${inputConfig.rawFiles}` const returnedPayload = await fetch(`${webhook}${queryParams}`); And attached is a screenshot of my test in Airtable.I'm not good at coding/scripting, so any help or direction will really be appreciated.

Hi - the iframe code that is generated when you want to share a view makes it look like the background can be changed, but it is always grey regardless of what I do with the iframe code. Has anyone been able to change the background color? Thanks. <iframe class="airtable-embed" src="https://airtable.com/embed/shdfgsfgs0I?**backgroundColor=blue**" frameborder="0" onmousewheel="" width="100%" height="533" style="border: 1px solid #ccc;"></iframe>

I am trying to fix a formula for hours, but I can't find the error. For some reason, the last argument in an OR Formula is ignored.The base has 2 tables (Table 1 and Table 2)Table 1 has one record with the following values:Field 1 (single line text) = AField 2 (single line text) = BField 3 (single line text) = C Table 2 also has one record with a multi-select field. The values areField 1 = C, D, E, F My OR formula should check if any of the 3 values from the record (Table 1) is included in the multi-select field (array) of the record in Table 2.  OR( FIND(Field 1 (Table 1), Field 1 (Table 2)), FIND(Field 2 (Table 1), Field 1 (Table 2)), FIND(Field 3 (Table 1), Field 1 (Table 2)) )  When I add "C" to Field 2 (Table 1), then it's correctly counted.If I add C in Field 3 (Table 1) I don't get an error, and the formula just goes through. It just ignores the last argument, "FIND(Field 3 (Table 1), Field 1 (Table 2))". Does anyone have an idea

I have an Airtable automation that uses the AI module to summarize text fields for each record in a view. A repeating group iterates through that list. In Make, those newly updated records are processed through a Word template to output a report. I'd like to figure out a way to trigger them with one button press.There are three ways I'm aware of for triggering Make, but I can't figure out how to make any of them to work.Webhook doesn't work (I think) because I need it to happen sequentially, with the Airtable automation running first.Record update: my original plan was to update the status of a report record that Make was watching after the Airtable automation looped through the whole list, but it doesn't look like you can add another action after a repeating group. So I also tried a script within the group that would count the loop iterations and compare to the list length, and at the end of the last iteration, would update the record. But I don't think it's possible to save the itera

Hi guys, I built a CRM on Airtable. Each contact's details sidesheet features a 'LinkedIn Links' block. This block contains a 'Chat' button that redirects to the LinkedIn's conversation with the person. I'm trying to set the conditional visibility of that button: have it shown only when the `LinkedIn Chat URL` on my base is not empty.Problem: I can't find the field among the displayed fields. And yet:1. the page is linked to the right table, 'Contacts'2. the 'Contacts' table does have the `LinkedIn Chat URL` field (formula type)3. filters can display formula-type fields. E.g. the field `Full Name` in my case. Any idea of what's causing this and of how to fix it? Thanks!

I know this issue has been discussed before, but there doesn’t seem to have ever been a solution discovered, so I’m bringing it up again in case anyone’s found an answer in the last 1.5 years. The problem: occasionally/often, when an attachment is uploaded to Airtable via a Make.com automation, Airtable will immediately delete the file after upload. In the record history, it will say that the user who created the record also deleted it, but that’s not the case. Here’s a Loom video illustrating. Important notes: I’m using the Share Link Google Drive module to get the share link. The automation itself doesn’t seem to be the issue. Airtable will occasionally keep the attachments, but less often than it seems to delete them. The files being uploaded are all “accepted” file formats, like jpg, pdf, etc. Anyone have any ideas?

Hello, i'm calling an API but i'm getting different results if i'm using Android or iOShere is my call:https://api.airtable.com/v0/appOwBv51ih******/teamtim****/?filterByFormula=FIND("Maurizio Polverini",{Nome})=1&sort%5B0%5D%5Bfield%5D=ID&sort%5B0%5D%5Bdirection%5D=ascAndroid response (it works well as everything is sorted "asc" by the column "ID") - as you can see everything is well sorted starting from fields{ "ID":36:--------------------------------------{"records":[{"id":"recHkGRBjaYe3ohuO","createdTime":"2024-11-09T08:19:32.000Z","fields":{"Nome":"Maurizio Polverini","Created":"2024-11-09","Device":"Android","Entrata":"9:19","Uscita":"9:20","GPS":"Estensione GPS non attiva","Ore Lavorate":0.016666666666666666,"Mese Nome":"novembre","Anno":"2024","ID":36,"Giorni":"09","GPS Uscita":"Funzione GPS non disponibile per l'utente"}},{"id":"reczyPzSXGnyMGXey","createdTime":"2024-11-09T08:20:46.000Z","fields":{"Nome":"Maurizio Polverini","Created":"2024-11-09","Device":"Android","E

  Hi folksI am fairly new to automations so plz excuse my lack of expertise.I am working on an automation that requires copying some data from 1 table into another table in certain circimstances.One of the columns (DISCONNECT_PROMPT) is of single select type - both in the source table as well as destination table.I am using the below code to insert the data but the it fails when the single select column is empty/blank in the source table.Can you please help me identify a way to insert a nothing if the source field is empty?Thanks in advance await tabChangeHistoryLog.createRecordAsync({ 'ROUTING_PROFILE': airTableKey, 'PRIMARY_Q (Mandatory)': strPRIMARY_Q, 'PREFERRED_ROUTING_ELLIGIBLE (Mandatory)': {name: airTableRecord?.getCellValueAsString("PREFERRED_ROUTING_ELLIGIBLE (Mandatory)") || "TRUE"}, 'PREFERED_AGENT_SCORE (Optional)': intPREFERRED_AGENT_SCORE, 'LC_EXPIRATION_THRESHOLD (Optional)': intLC_EXPIRATION_THRESHOLD, 'IN_Q_REFRESH_RATE_IN_SECONDS (Mandatory)': intIN_Q_

Hi Everyone,I am trying to create a forecasting table that will tell me how many months of cover I have based on current stock on hand. In the image you can see the fields Sock Holdings and Outbounds Forecast. What I need is to create a field where I can see for example March 2024, how many future months I have in cover based on current SOH and the figures in the outbound forecasts.Thanks! 

I want to create a chart that shows record counts of a table over time.  In our case, we have a table of clients and want to show how the total number of clients has changed over time.  I have a "Created time" column and I can use the COUNT formula to get the current number of clients, but I'm not sure how to get that COUNT over time.Any ideas?