Solved

Hi everyone, I am trying to get unique values from a lookup field. I have tried the solution suggested in: Solved: Exclude Duplicate/Repeating Values via Lookup or R... - Airtable Community. by  @kuovonne. Which stated: Create a rollup field that rolls up the multi-select field. Set the formula to values. Save the rollup field.Convert the rollup field to a lookup field. Notice that the lookup will be formatted as plain text instead of the usual pill format.Create a new formula field that refers to the lookup field (that used to be a rollup) and use the formula ARRAYJOIN(ARRAYUNIQUE(ARRAYFLATTEN({lookup field})), ", ")But this does not seem to work for me, as converting the rollup back to a lookup, changes the formatting back to pi lls.In the screenshot provided you can see the formula I am using, as well as both the rollup and lookup field. I have tried different combinations of using ArrayFlatten and ArrayUnique across the rollup and formula but noth

Okay, a bit of context for clarity.I have a base that I am using for tracking inventory. We send out the packages of items. Sometimes we have some of the items in stock, and sometimes we need to order more before the package is sent. I am using an interface that lets the end user select the items that they want to add to the package. Then they have the option to click a button to trigger an automation.The automation looks in the table and finds all items with a check box. Then, using a repeating group, it send the relvant infromation for each item to Make via a webhook. Make then checks to see if the qty needed is less than or equal to the qty in inventory. If it is, Make creates a new record in an Inventory Change Log table to remove that qty of items from the Inventory table. The problem I am facing is if two items with the same name are sent at the same time, the webhooks are sent to make faster than make can process through them.For instance:Say I have 1 trashcan left in stock

Hi all! First time poster, hoping someone can explain to me why I cannot figure this out based on my lurking on other threads.I have a table (below) tracking information about tours we coordinate. We track the Presenters on each tour and a count field, so I can sum the total number of presenters across all our tours. However, I want to get the number of UNIQUE presenters across all the tours. e.g. if Vivaldi's Four Seasons and Romeo & Juliet both have "Shire of Cue" as a Presenter, how can I make sure it only gets counted once?To make matter more complicated, I'm hoping to have this unique count number be on the same table as the rest of the information, because otherwise I can't access it easily when building a dashboard interface.Appreciate any and all suggestions!

Bonjour,Je souhaite créer des listes de choix dynamiques. C'est à dire que si je choisi une "Catégorie" dans un menu déroulant, ça limite le choix dans le menu déroulant du champ de la "Sous-catégorie" aux sous-catégories associées à la catégorie sélectionnée.Est-ce bien possible (j'ai trouvé aucun script, même avec chatgpt) ? auquel cas comment ?Je vous remercie pour vos retours, c'est un sujet basique mais récurrent qui me pose problème sur quasiment toutes mes bases...Damien

Hello there,I am trying to automatically delete records after 1 week. As I am in free plan, I can't run scripts (currently I don't want to upgrade). I set up a field which tags every opportunity with a delete text. Can someone tell me how to solve that with the Search Step in Make (formerly Integromat). The following delete step is not the problem, I guess. Somehow, I just don't find the right formula.Thanks in advance!

Hello,I was notified by Airtable today that I am part of a minority of users using way too much API on the free tier, costing Airtable money. The email instructed me to look at my offending workspace. Unfortunately, the workspace sums all base APIs but does not break down percentage used by individual bases, making it impossible to tell which is the offender. How do I find out which base is hammering the limit? How much API limit will I get if I upgrade to team? Why is this information so cryptic?Thank you in advance,-API Hog

Hi allI'm trying to create an interface (dashboard) that uses a report Filter on client ID (eg. so that client A can only see client A data on the dashboard) (https://support.airtable.com/docs/interface-element-filter).I have shared the interface to a test user as readonly, however the test user can simply change the value in the filter on top of the dashboard, then he can see any client's data.What I'm looking for is to grey out the dashboard filter value, so it says client = "client A" for client A, and client = "client B" for client B etc).... I know I can create a different view for each client, however this is a lot of manual work as the number of client increases...Any suggestion would be much appreciated!  

Hi, I want to create a new record and link it with the right assets.Creating the record goes wel, but linking the assets won't work.I get this error. I am a bit new to airtable, maybe it is a beginner mistake.Thanks in advance.Greetings,Robin   const inputData = input.config(); const { txt_name, txt_files } = inputData; // Specify the tables let postsTable = base.getTable('Social media posts'); let assetsTable = base.getTable('Assets'); // Create a new record in the 'Social media posts' table and capture the ID let newRecordId = await postsTable.createRecordAsync({ 'Naam': txt_name, }); // Update the record in 'Assets' where the ID matches txt_files, setting "Social media posts" field to the new record ID await assetsTable.updateRecordAsync(txt_files, { 'Social media posts': [{ id: newRecordId }], });   

I send emails using Airtables automation.   You can see when an email is sent from inside the automation setup.  Is there a way to put a field in a table that lists the last date an email was sent to easily see email history? 

EDIT: The issue has now fixed itself. The popup looks back to normal now. In the Interface Designer, when clicking "Share" on a Page, there is no longer an option to share the page publicly. As such, there is also no longer an option to UNSHARE a page that was already made public.What happened here? Is this a bug?This is what the Share tab looks like as of today. And this is what it's supposed to look like: https://community.airtable.com/t5/announcements/new-share-public-interface-pages-publicly/ba-p/189617 

Hi Everyone, I have a base with 3 different tabs. Fist Tab is a Project General where I'm adding new projects. The second Tab is for a specific task (Scanning) and we are creating rows by floors, and it is linked with a specific project. The third tab is for the last task (Modeling), it needs to be tracked by floor as well. I would like to have an automation when a new floor is created in the Scanning tab, create a new record in the modeling tab with the same name, and if it is possible with the same project already linked. Could someone help me with that? Thanks!!!

I am using ArrayUnique(values) as in a rollup field and then referencing this in a make.com scenario to output to a Word document. This works, but the output is a bit unfriendly.Products Acer_Vero B7_B227Q,Acer_Vero B7_B277,Acer_Vero B7_B247Y  I have tried changing the formula in the rollup field to something like ARRAYUNIQUE(values)&" - " but it has no effect.Is there a way to format the output to make it a little more readable - the ideal would be separate lines. EDIT: I have found how to add spaces etc usingARRAYJOIN(ARRAYUNIQUE(values), ', ')but is there any chance of adding a newline character (13) ?

I am trying to write a formula field that will summarize the responses of three separate single select fields (Prototype 1 Cost Status, Prototype 2 Cost Status, and Prototype 3 Costing Status) so my costing team can have an idea of what proportion of the current prototype stage is "Meeting Target" or "Not Meeting Target". I'm finding this difficult because if we move from Prototype 1 to Prototype 2, we will need the response from Prototype 2 to override the response for Prototype 1 (as shown in the attached png) and so on for Prototype 3. This is what I have been able to draft so far: IF(  AND( {P1 Cost Status} = BLANK(),    {P2 Cost Status} = BLANK(),    {P2 Cost Status} = BLANK(), BLANK()IF(  AND( {P1 Cost Status} = "Green - Meeting or Exceeding Target",    {P2 Cost Status} = "Green - Meeting or Exceeding Target",    {P2 Cost Status} = "Green - Meeting or Exceeding Target", "Meeting Target")IF(  AND(

Hi,I have a formula that currently works 90% of the time which finds the number of days between a date range for a given month. The issue is, when the end date, ends in the month I am looking for, example below Oct the formula is correct (row 1, 3 and 4 in the image below). However, when the end date includes BUT does not end in the given month (example: row 2 or 5 in the image below) I get 30 days. I want it to show as 31 days because the date range is inclusive of Oct 2024. Any suggestions? Here is the formula,IF(AND({Start Date}, {End Date}),IF(AND({Start Date} <= DATETIME_PARSE("10/31/2024"),{End Date} >= DATETIME_PARSE("10/01/2024")),DATETIME_DIFF(DATETIME_PARSE(MIN(VALUE(DATETIME_FORMAT({End Date}, "X")), VALUE(DATETIME_FORMAT(DATETIME_PARSE("10/31/2024"), "X"))), "X"),DATETIME_PARSE(MAX(VALUE(DATETIME_FORMAT({Start Date}, "X")), VALUE(DATETIME_FORMAT(DATETIME_PARSE("10/01/2024"), "X"))), "X"),"days") + (MONTH({End Date}) = 10),0)) 

Hey guys,I am trying to calculate out hours for our personnel worked on projects each day. We only have the start and end dates of projects, we were not tracking hours individually so this'll be a rough estimate at the end of the day. Here what I'm working with:Project Tracker table: This is the hub for all the project information including the start date and end date for each project. It links to the personnel table through a crew linked field.Personnel table: Contains all the information about a person.What I'm looking for:I need to calculate from a persons allotted 8 hours how many hours were worked on each project for each day. These hours will be split evenly to total 8 hours. The final numbers would show us:- Person total hours per project- Project Total hours from all personnelHere's a visual of what I'm thinking (not how it would look in airtable) Hopefully this makes sense. Please let me know if anyone has any idea on how to accomplish this.Thanks!

Hello community,I'm building some kind of table where it has repeated content in the rows that I would love to have them combined, similar to a merge cell in Excel or Google Spreadsheets.Is it there a formula or a scripting that can help me have some structure like in the attached image?Thanks!Leandro

Hi,I am new to Airtable.I am trying to create a simple form. In which, I have a multiple-select field.I want to pop up a text input box, when "Others" is selected from among the choices. How do I achieve that condition?

Hello, we have had 422 errors in our integrations suddenly, when trying in post man everything works correctly but from the VB.NET application the same record gives error 422, this is happening in several integrations from different databasesEdit: for now all api integrations are working fine, check yours

Is there a way to customize / change the favicon and / or the AIRTABLE URL! Screen Shot 2020-05-18 at 3.01.49 PM|690x236

Hi I am trying to figure out how to remove the NaN value when the formula is 0/0I need it to reflect 0.  I have tried IF() and IF(And( formula's but I cant seem to get it to work current formula is {Surveys Recieved-MGR}/{# of Managers} Does anyone have any solutions?Thanks !

Hi Airtable Community!Problem: I'm having trouble adding a linked record to multiple records without erasing the data that is already in the cell.ContextI've got one table of studies, and another table of people. Each person can be linked to any number of studies in a "Contacted" field. Sometimes that field is empty, if that person hasn't been contacted yet, and sometimes it has a few linked records (studies) in there already.If I contact 50 people, I want to add the study I contacted them for to their record. If I copy/paste the study to the cell, this overwrites the existing data , so if there were 3 studies in there to start, I'll erase them if I paste in the new study. What I triedI made a field that concatenates the study name I'm adding with the study names already in the "contacted" field, and it comes out as text. If I then paste the text into the "contacted" field, voila, I have all of the records, or so I thought! Turns out this just makes NEW duplicate records of all of

I’m new to airtable, it’s great! I’m trying to use it for a sign-off / authority database for leave requests, expenses claims etc. Is it possible to give a collaborator access to some columns but not others on the database? For instance they could create new requests but only people with sign-off authority could tick the “approved” column for requests. I know you could achieve this effect with a form for new entries but I’d prefer permission controls. Please let me know, thanks Thanks Lyndon

Goal: importing JSON from an open API into my airtable base.How: Using a script extension in the base (at the bottom of this message), with proper error logging.Result: No return after “let response;” The script just seems to stop without any error triggering. The last log is “console.log("⏳ Start fetching domeinen data...")”Test that does work: A curl request to the API does yield the complete JSON, just as a request through postman. So the API is reachable.The code to request and import the data:  // API credentials let apiKey = "(API key censored, but it's working)"; let apiUrl = "https://opendata.slo.nl/curriculum/api/v1/domein/"; // Function to fetch the domeinen data async function fetchDomeinen() { console.log("⏳ Start fetching domeinen data..."); let response; try { response = await fetch(apiUrl, { method: "GET", headers: { "Accept": "application/json", "Authorization": "Basic "

I am trying to create an order form for the company I work for. Right now we get orders through email, where the customer just writes what they want on a paper, takes a picture of it, and emails it to us. I need the madness to stop. So I've been looking to create either a form or an interface of sorts that will allow my customers to be able to input their name, and company info including shipping address, and then they are allowed to input their own part numbers and quantity.I do not want to create an inventory table for them to be able to choose, as there are thousands of constantly changing parts and numbers. The customers know the numbers they need to use and how many they need.I am new to Airtable but I do have a decent understanding of how databases are structured and linked relationships. I am having trouble creating the form and allowing the customer to input a number and quantity on their own. If this is too vague, I can explain further on whatever area needs more detail.M

I am looking to Run a script in an Action. basically whenever the Category “Done” or “Postpone” is set to the record by single select field. I like to run a script that deletes those records. The trigger is pretty much easy to do by the automation configuration. The script is the one I didn’t figure out how to do.