Solved

How can I customize the Airtable interface to dynamically adjust bar colors based on the values stored within specific cells?Specifically, I'm interested in understanding the process of implementing such a feature within Airtable's interface to visually represent data more effectively.Are there any specific settings, configurations, or formulas that need to be applied to achieve this level of customization within Airtable's platform?Additionally, what are some best practices or considerations to keep in mind when setting up this feature to ensure clarity and coherence in data visualization?

I am NOT a coder... but this process is slowly making me one (sometimes to my regret).I am trying to put together a script triggered by a change in a field titled "Invoicing?" on a table named "ALL INVOICES 2024" that will update a different table titled "Client Overview" by adding "Offboard/Last Inv" to a field named "Active/Inactive." These two tables are NOT linked to each other and I don't want them to be, but they do have one field that is identical between the two of them: "Client ID."After banging my head against a wall for about two days, I decided to just backtrack to the most basic tutorial to see how I might put this together. My first task to "learn" is how to make Airtable identify the record that triggered the script to run. I stripped down to the easiest of tasks: Output the Record ID of the table that caused the trigger. I used a bit of code from this article: https://www.airscript.dev/2021/01/31/airtable-automations-scripts let inputConfig = input.c

Hello, let me first give a little backstory on the process I have leading up to where I need help...I have two tables (Table1 and Table2). There is a button on Table1 that triggers a script. The script copies a few fields from Table1 over to Table2, one of which is an alphanumeric code. While copying this alphanumeric code over to Table2, it also performs a check to see how many times this code already exists in Table2, and populates that number into a field. Table2 contains a complex formula that uses the existing alphanumeric code and the number of times that code has been seen before, to generate a new unique alphanumeric code. All of this works flawlessly, I'm just struggling to figure out how to execute the last step... copying this new unique alphanumeric code back to a field on Table1.First attempt at a solve, I setup a new automation that watches for new records entering a view on Table2. From there I know I'll be able to reference my new unique alphanumeric code, but I can't f

I’m trying to create an automation to take data from one cell in a record and paste it into another, linked, cell in that record. I set it up to trigger if “PART NAME” is not empty and “PARTS” is empty. Then it is supposed to take the value from “PART NAME” and update “PARTS”. When I run a test it does find a record to update but when I turn the automation on nothing happens. Any idea where I’m going wrong?

Hi,I'm not sure if this is the right place for this, but here goes. I have a table containing the following 'data'Project, Person, Start, FinishI want to plot on a Vega-Lite Heatmap style Histogram the 'heat' of these people over time. So the more 'Projects' then the higher the 'heat'. I could see that Joe is cold in Jan, but hot in July.This is the style of heat map: https://vega.github.io/vega-lite/examples/rect_binned_heatmap.htmlI guess I need to transform the 'hits' per say, month. But I have no idea how to do that!Thanks in advance.

Hello everyone, I have a base in which I have defined tasks with a start date and a deadline. Both dates are calculated from the start date of an event and a number X days before the event starts.In three cases the tasks have to start after the start date of the event which is why I used a negative number. The date is calculated without any problems, but these data records are not displayed in the timeline.Can anyone help me with this?Formula for calculating the deadline:Columns:Timeline: 

I'm having trouble with using the DATEADD function (and yes totally new at this). I'm trying to add 3 months to a date in another column. I've technically gotten the formula to work but it's not quite getting the desired date. So for example if my date is 4/1/2024 and the formula is adding 3 months it's calculating 6/30/2024. I need it to actually calculate 7/1/2024. I've tried to add a day to the formula but keep getting an error. Any help would be great. Thanks in advance.

Hi guys. I made a connection with Make, so I can transfer every incoming email from certain accounts to a new data row in Airtable.The problems are the attachments. I am showing you in the pictures below how I would like them to appear and how they actually appears. We need every attachment to be shown in a preview as a separate file.. The Make-support thinks it is Airtable-problem, so I am grateful for any suggestion.Regards, Imelda

Since the rude depreciation of APIs from Jotform, I have rebuilt my integration using their new system. However, it fails every time a form is submitted reporting:Unknown Field Name "fldqb0p2A79uDENvw". I have no field of that name in either Jotform or Airtable, mine are all user friendly names. So what's going on? I have raised the issue with Jotform support who say they need more detailed logs. Any ideas?

Hello,I need help setting up an automation that links records in a "dependencies" field to a predecessor/successor record (determined by order number). The goal is to automate tasks to hit contributors dashboard when its their turn to work on the project. We have a Projects, Tasks, Content Type and Templated Steps boards that ive set an extension to generate a specific task list based on the type of content. I can edit the extension code to include the dependencies field and set those are part of the template, but the problem is that many project managers use this as a starting point and edit the task list manually, adding or subtracting tasks for their specific need. If a project manager edits the task list, they have to manually manipulate the dependencies field using the gantt view, which is cumbersome and manual. id like to set a way for the field to automatically update based on the task order. So the trigger I have in place is "when record is updated"- on the task board, so

I need a formula that calculates the number of days we have owned a house.Possession date to sold date and in the case there is no sold date I want it to calculate using today. TIA

Hello!I'm trying to create a formula that will create First Name (Goes By Name) Last Name (Business Name).  I've gotten my formula so that I can get all those pieces together, however if either Goes By or Business Name exists and the other doesn't, I'm getting () included still. For exampleKatelyn () Grant (Airtable) or Katelyn (Kate) Grant () How do I get it to not include the () if the field is empty?Here's the formula: IF(OR({Goes By Name}, {Business Name}),{First Name} & " " & "(" & {Goes By Name} & ")" & " " & {Last Name} & " " & "(" & {Business Name} & ")",{First Name} & " " & {Last Name}) 

Hi everyone, first of all I'm really sorry for the noob question, I'm an English teacher who is not good at math and I cannot figure this out after days of trying.I have an excel document where tasks are given scores based on prioritization questions.Most of the questions follow a simple "If answer = YES add a numerical value of 3 to the overall score" format.But I have a few segments that use COUNTIF logic.In one of the sections where there are 5 prioritization questions the COUNTIF logic looks like this(COUNTIF(I7:M7,"Yes")>3,12,IF(COUNTIF(I7:M7,"Yes")>2,9,IF(COUNTIF(I7:M7,"Yes")>1,6,3))So the yellow section of questions follows:If 1 question in the yellow segment is answered "yes"  - add 3 points to the overall scoreIf 2 questions in the yellow segmentare answered "yes" - add 6 points to the overall scoreIf 3 questions in the yellow segment are answered "yes" - add 9 points to the overall scoreIf 4 or 5 questions in the yellow segment are answered "yes" -&nbs

I want to automate an email that goes to staff two weeks before their leave year renews on the anniversary of their start date each year.Is it possible to create a formula which will automatically show the next anniversary in a date format? For example: If my start date is 28/02/2019 and today is 07/02/2024 then the next anniversary date should read 28/02/2024Or if my start date is 28/02/2019 and today is 01/03/2024 then the next anniversary date would read 28/02/2025I'm UK based so using DD-MM-YYYY formatting. I'm struggling to generate anything that works - any help appreciated.

Hi everyone, I have a collaborator with Creator permission who is unable to add attachments to an Attachment field. Is there a solution?Thanks in advance.

If I use AirTables to host my pictures before I post their links to social media and then I cancel AirTables, will all of my pictures on social media go blank?thanks, mark

Hi everyone. I have a table "receipts" that collects receipts linked to different projects. Every receipt can only be linked to one project. The Receipts table has a Number Field "Amount in Euro". Now I the Project table, I want to have a Rollup field with the sum of all Amount field. But only those who are linked with the Project im currently in. What I want to do is add the condition "Where Project is exactly current project". So for Project 1 it filters by that, for Project 2 by that one. But I can only choose one particular project. Am I missing something or is there another way to do this? Basically what im trying to do is see the Sum of all incoming and outgoing receipts for every project right within the Project. Any helps would be greatly appreciated 🙂 

Hello - full disclosure, I've only just started to get into scripting in Airtable, so bare with me as I'm still learning!My actual goal with this script is actually quite complex, I'm probably only about half way through. But instead of trying to summarize the entire thing, I'm just going to hone in on where I'm stuck specifically... which is how to properly utilize the Filter function with arrays.So I have a button trigger in a table "TV Finishing" that I want to execute a script. The script copies a name and an alphanumeric code (ISCI code) from the record, and pastes it as a new record in the table "AutoHelper". This I have working just fine.But then I want the script to count how many existing records in "AutoHelper" already have the same ISCI Code, and to paste the number (plus 1) into a number field of the newly created record... and this is where I'm stuck.I've added my existing script below with the error code I'm getting when I try to use query.records.filter. I've tried to em

Hey everyone! How do I create the statement to leave cell blank if a value is missing instead of #ERROR? I’ve read you should not use the BLANK() code? Code for Days Left: WORKDAY_DIFF(TODAY(),Starts) Code for Urgency: IF( {Days Left} < 0, "🔥OVERDUE", IF( {Days Left} <= 20, "🔴 ASAP", IF({Days Left} < 40, "🟡 Medium", IF({Days Left} < 100, "🟢 Low" ) ) ) ) Thank you in advance!

I'm using a Google Drive Sync integration with the intention of avoiding going over the storage limit in my base. On the FAQ's for this integration I found this information:Will the attachments in a synced table count toward the destination base’s attachment limits?Yes. Similar to record limits, attachments in a synced table will count against the attachment limit in that synced table's base.If I were to simply not sync the attachments field, will that avoid taking up storage space in my base? With this solution, I could simply rely on the urls provided by the Google Drive Sync integration to interact with my files.Thanks in advance,

Good morning all! I'm hoping someone can help me with turning a pretty straightforward concat formula into something with more if/then logic to help when empty fields are encountered.Right now I have a primary field on my sheet that uses a formula to build a unique ID for logged payments. That formula is below:  CONCATENATE({Vendor Name}, " - ", IF( {Remit to AP}, DATETIME_FORMAT({Remit to AP}, 'MM-DD-YYYY')) )  The trouble is that with a lot of records there may not be a "Remit to AP" date for a number of reasons. I'm hoping there's a way I can use alternative fields as backups so the primary field doesn't just show something along the lines of "Vendor - " which isn't helpful.There's another field called "Invoice Date" that is much more frequently populated, and a "Year" field (which is a single select, not open text) as the last resort. Would it be possible to have a formula that builds the concat as above and says if the "Remit to AP" field isn't blank to use

Hi @dashler78 experts,I have an interface which has a dropdown and a button. When a user chooses a value from the dropdown and clicks on the button, an automation script runs doing the following1. It saves the value chosen in the dropdown.2. Updates 'Created By' as 'Automations'.I want the script to even update another field say 'User' with the user object (of the person who actually clicked the button).Is there a way to input the actual user object using automation script?I saw that I am able to get 'email id' , 'id' - which is usrXXXXXXXXXX and name. However what I actually want in the field is the complete user object which is similar to how 'Created By' and 'Modified By' fields look. Kindly let me know how this can be made possible?I am using an automation script because that is the only way I can save the value from a dropdown in an interface.Currently when I try adding the id in the User (field is of type: User) field, it gives me the following errorError: Field "fldyaWWxTRvpc9bS

Hi, I am trying to get some more sophisticated user interfaces and calculations into a form view or interface but am getting stuck. I am trying to have some pre-set instructions with calculated values in a form that employees would be able to fill out from a single link. are there any integrations/ extensions/ suggestions on how I might be able to do this?Thanks for the help!

Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.DATETIME_DIFF({Sell}, {Buy Date} 'days')Well, there may be a problem, but I can't see it... can anyone help with the formula to display the number of days between two dates 🤔 🤔? Thank you.Here's what I'm getting for these 3 fields:Buy Date, Sell, #Days1/12/2020, (No End Date), NaN7/10/2023, 1/31/2024, 177120001/1/2020, (No End Date), NaN9/19/2023, 1/31/2024, 11577600

Hello, I have a 'Client' table linking to another table that holds information about Event Labor. From the Event Labor table, I am trying to send an automated email to the client (email address linked from its own table.) When creating the action, the 'Email (from Client table)' is an option, and then I have the choice Linked Record ID or Value. I assumed to use Value but neither choice is working. Any solutions? Video to show my work https://www.loom.com/share/38183324bec943ca8c58bffa9ac91162