Ask the Community

Can I change the display of options in a single select column according to responses from another column?example:IF {COL2} = "OPTION1", "COL3" & "COL4" return options variable x

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?

We had students respond to a number of self-reflection questions, and their answers are in table 1.  Table 2 uses lookup fields to pull in those answers, and then a formula field to attempt to score them.Each question has 5 answer choices, and each answer choice is worth between 1 and 5 points.  Here's an example with the number of points each answer is worth in parentheses:  How would you react to constructive criticism from professors in your host country?a) I might take it personally and feel discouraged. (1)b) I'd feel a bit upset but would try to learn from it. (2)c) I'd take it as it is, without much emotion. (3)d) I'd see it as valuable feedback for improvement. (4)e) I'd welcome it and actively seek out feedback for growth. (5)We're using a version of the same nested IF statement to score each question, though obviously changing the answer text:

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: 

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 co

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?

Bonjour,Je souhaite que mon collaborateur ne voit que les entrée de ma vue auxquelles il est assigné.Lorsqu'il clique sur le lien qui lui ai envoyé par notification il a accès à l'ensemble de la base même aux entrées qui ne le concerne pas.Merci pour votre aideEmilie

Anyone have experience removing someone from a workspace, then adding them back to a base? Will that erase timestamp, commenting, etc? I basically have everyone in a workspace and 75% of them are editors of that workspace. However, I need no one but myself to control entire workspace and all its members have access to only the bases they are assigned to. Thanks

Hello Airtable community! Our team has recently transitioned our CRM system to Airtable and configured a dashboard for straightforward reporting to our leadership.In our setup, we have a "Status" column that includes several choices. I've arranged a status view on the dashboard for a quick glance at the figures. However, I'm also looking to calculate a conversion percentage to demonstrate, for instance, the percentage of leads progressing from "interested" to "won" among other transitions.Can anyone guide me on how to establish a view for this purpose?

Sync is not working!!!

Hello Everyone,  Basically I have got a table with documents sign date and expiry date, and created a formula when it shows that the document is "Active" or "Expired" if the date is in the past. The question is how to create an automation so whenever formula changes to expired it will send an email telling a person that the document is now expired.  Hope that makes sense.  Thanks

I'm getting a CORS error when instantiating a Worker.  What do I need to do to avoid this CORS error when instantiating a Worker?  "Failed to construct 'Worker': Script at 'https://localhost:9000/worker.ts' cannot be accessed from origin 'https://devblock---t-vjm-s-v7-g-mvh-c-b-r--55q8cmv.alt.airtableblocks.com'."  import { initializeBlock } from "@airtable/blocks/ui"; import React from "react"; function HelloWorldTypescriptApp() { const useWebWorker = () => { const worker = new Worker("worker.ts"); // <-- throws error mentioned above worker.postMessage("foo"); }; return <button onClick={useWebWorker}>Click me</button>; } initialize

i have a automation that builds out new records, and depending on the project being created in Table A it connects to different linked records on other tables, for ex Table B and Table C. Table B uses a text field as primary field, so anytime i am connecting to this table with Update Record, it easily links to existing or creates new.however Table C uses a a formula as a primary field. When i use the update record it is not connecting due to computed field. i dont want to create new records, i just want to connect to existing. I have a formula on my recoird creation that determines the correct linked record, and it does exist, but it still fails.

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.

I have a form that I am editing using the "new form designer" - aka Interface Designer.I am adding some new questions that should be in a group - and all of my old questions seem to be in another group.Can I put the new group INSIDE the old group? Or do I have to figure out how to drag everything OUTSIDE of the old group before I can create conditional groups?Thanks!

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.

Hello, I am using a form to register event attendees. This form sits within a table called "Event". However, the registrants are records in different tables. I want the completed form to trigger a contact on a different table (within the same base), to update a field marking "registered to attend event". Is this possible?Attached is the automation I have set up, and when I tested the automation with test data it worked. The field in the other table was updated. However, over night, I received lots of error messages. I wonder if it is because I used the record " When a record matches condition", and therefore it is continuously running? The error was occurring at "update record" and was saying "Received invalid inputs". Sometimes it was working. Sometimes it was not. Would anyone be able to help please?

Hello all,we use interfaces in airtable so that we can only show the desired data to the users who need it at that moment. For example, we show records where the "current user" is indicated as the assignee.We also have a "Team" field where multiple users can be indicated. Here I would like to indicate a group as a team because a team changes every now and then. We created the group in the admin environment. Does interfaces then recognize the current user in the group?Does anyone know if this is possible?Greetings, Martijn

Hey everyone , I am slightly struggling to find the best formula for expiry data. Basically, I have signing date and expiry date and I need to create a formula that will indicate that if the paper is now after expiry date it will change to 'expired' and if it is within time frame then it is "active" And maybe it will be possible somehow to connect it to "Status" in single select feature? Thanks in advance !!

Here is what I have managed so far:• In the first table, when I confirm that the record is eligible through a single-select option, I have been able to:1. Copy it to a second table dedicated to Marketing.2. Copy it to a third table dedicated to the Backend.What I am unable to do is:1. When I activate a trigger in the Marketing table, I would like the record to update in the Backend table as well.I have tried both reproducing the tables manually and individually copying the columns and using the "link to another record" function with tables in lookup.The error I encounter is that sometimes it doesn't find the record, and other times it indicates that the input entered is not feasible.In the end, it just needs to update a single-select field, nothing complicated. 🥹

Hello friendsI have a script, that makes queries and record update,  after that I have Google Calendar Sync, Calendar Dates are dependent on Script results. I tried await keyword in front of record update statement and the timeout end of the script, but Calendar Sync executes before the script ends, how i can solve this problem, any ideas?

I have a base with Costs and I want to set up a form where our staff can select multiple records data from one base that will then create a new record in a different base. I want these new records to only show the data selected in the form. This base has unique 'cost code' fields and a corresponding 'Nett Rate' field. I want them to be able to select multiple 'cost codes' that will then create a new record with all of those selected cost codes and Nett Rate fields I then want to set up an automation that sends that record as a CSV file to an email address

Hello :slightly_smiling_face: Well, the title says it all I guess … I’d like to set an automation when a defined view reaches a number of records I define. Is it possible, please ? it seems I can’t find a way for now. Thanks in advance for your help. Regards. Nicolas Caplat

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