Ask the Community

Hi !     I created a column to identify if the "End Date" of a task belongs to one of the weeks below, based on the ISO numbers for each week of the year (1~52 or 53).      But I am facing an error due to the year, that I cannot overpass.      It is considering the pure number of a week in 2023 (e.g.: #49) as a week in future, because the actual week number in 2024 is less than that.     Please, can someone help me with it?PAST: "End Date" week number < actual week numberTHIS WEEK: "End Date" week number = actual week numberNEXT WEEK: "End Date" week number = actual week number +1FUTURE: End "Date" week number = actual week number +2Here is the actual formula I have that is running, depite the error from year:"IF({End Date},IF(AND(YEAR({End Date}) = YEAR(TODAY()),DATETIME_DIFF({End Date}, TODAY(), 'days') < 0),"PAST",IF(AND(YEAR({End Date}) = YEAR(TODAY()),VALUE(DATETIME_FORMAT({End Date}, 'W')) = VALUE(DA

Hi Everyone, Is there an automated way to combine 3 lines into one? The context is that, we will have 3 different persons filling in 3 different forms to feed into the same table, but want to combine them into a single line. Dedupe is OK but we will need to do this 1800 times :frowning: And of course, there are a lot more columns than shown above. Thanks.

I have GMail > Send Email automation setup. While the automation shows as the email as being sent, the receiver doesn't receive it for a few hours. How to ensure that the email is received immediately? In some cases the email is not received at all. The Gmail account is a Google workspace account. 

Hi,i have a database and with group and filter actions I came up with a list of items to print.How could I reach the goal of having the count of the items instead the count of the lines?Tnx in advice

Hi there, i just subscribed to the Team plan using 96$ of credit that i had stored from the last few years.My question is, when my plan will be automatically renewed next year, will Airtable consider the credit that i will have by that time?Example:i subscribed today (09th February 2024) to teams, my credits are now 0$.If i will have 50$ in credit on the 09th February 2025, will Airtable use the credit to renew the plan, or i will pay the full amount?If i will pay the full amount, what if a unsubscribe and the subscribe again (as in the subscription phase i have been asked to use my credit as part of the payment)? Thank you for enlightening me

Hello,Yesterday I realized that I don't have a backup of my many bases.Quite worried, I then looked for a solution. And found out: Almost all of them are quite expensive, and some of them seemed awkward to handle.Now I would like to know how important it is to have a local data backup?Is it really possible for my data to suddenly disappear one morning? Perhaps due to some error on the part of Airtable, San Francisco?Or is all data backed up redundantly several times, as some providers claim? So secure that you don't have to be afraid?Marceting

Can I download my csv on a MacBook ? I don’t see the download popping up.

So my challenge may be in my how I have my dates setup. Essentially what I'm trying to do is to utilize a date to create text based on the current month. I think an example could better explain this, e.g., I have a date that is 4/1/2024 and I'd like another column to display the text "Summaries" when it is within that month. So then if it's the following month, 5/1/2024, I want that column to display "Graphs" for that entire month. Is this something that's even possible? Is there a way in the dates to select an entire month? I think that may make the formula more straightforward. Any insights would be amazing. Thank you in advance. 

I'm new to formulas but have learned quite a bit from these forums. I have arrays of Hardiness Zones for plants, which are written like this: 4a, 4b, 5a, 5b, 6a, 6b and so on. I need to put them into ranges like this "Zone 4-8". So far I have it this way:I used this formula to get it:IF(NOT(Zones=''), 'Zone' & ' ' & LEFT(ARRAYJOIN({Number value (from Zone test)}), 2) & '-' & RIGHT(ARRAYJOIN({Number value (from Zone test)}), 2), "")There is another column named Zones, and in the linked table, I had to put a space after 9 so that it would still register as having 2 characters in the field instead of just one.There are two problems with my outcome.Problem 1: Some of them only have a single number in the Number Value field. So that return looks like "Zone 10-10" and I want it just to say "Zone 10". I'm trying to use a nested IF(LEN) function in there but it's not coming

What is the best ways right now?The API Keys are not working anymore. 

I have a huge database of contacts. I would like to group and categorize these into households/families.My initial thoughts were to group by last name. However many contacts share the same last name yet aren't in the same household. Similarly, some households have different last names.I've currently got a separate "single select" field called "household/family". THis does a good job at seperating the records; I'm not able to count how many options are being used though. Is there a better way to do this?Much appreciated on any ideas! Thaaanks

Help!  I am trying to create a field that combines first and last name.  I am using the formula below but getting the error message as shown.  Confused what I am doing wrong? 

OverviewAllow users to assign different detail pages based on conditions.When a user expands a record from an interface, allow users to change which details page opens based on conditions of the expanded record.Setting the conditions could work using a UI similar to the one conditional coloring uses.Problem:There are many instances where I have records that share 90% of the same info, but based on some differences - such as Type or Status, need to be interacted with differently.For example, for my business we track furnishings and fixtures we refer to as "Items" for architectural projects. We need to ensure that certain pieces of information are recorded for each Item, but what pieces of information we need varies based on the Type of Item. There are so many different kinds of information that we need to record that we have as many as 120 different fields in our Items Table. ideally, we could show only those fields that apply based on a condition, in this case, the "Type" Field.I.E. If

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:IF({non-cog16}="I might take it personally and feel discouraged.",1,IF({non-cog16}="I'd feel a bit upset but would try t

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?

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>; } initializeBlock(() => <HelloWorldTypescriptApp />); source code: https://github.com/jacobwilson41/airtable_web_worker_example/tree/main/frontend