Ask the Community

Hi, I had a question about comment notifications within interfaces. I have a base with a few interfaces all centered around records in one table. Each interface is accessible to a different user group - when one user group @s someone in a different user group - will it email that user if they don't have access to the interface that the original user commented on? and similarly, if they do get an email notification, where will the link take them when they click it?  Thank you!

  One of my bases mentions "Over Limits · 30 days left" / This base has gone over the record limit. To keep adding records, upgrade your workspace.I sill can add new records... what will it happen now?Do i have 30 days to remove or to move records out of the base? 

Bonjour,Je suis en train de m’arracher tous les cheveux qui me restent sur un problème que je suis sur le point de résoudre mais je n’arrive pas à trouver le point qui blesse.Pour schématiser :J’ai un enregistrement d’une table COMMANDE, lié a de multiples enregistrements d’une table LIGNE_COMMANDE.(Le truc classique d’un entête de commande avec ses lignes de commandes).Je souhaite pourvoir “Cloner” via l’automatisation (Quand un enregistrement entre dans une vue spécifique par exemple) à la fois les informations contenus dans la table COMMANDE et à la fois le contenu des enregistrements liés de la table LIGNE_COMMANDE.Quand je parle de cloner, je veux bien sûr préciser que c’est une création d’un nouvel enregistrement de COMMANDE (presque à l’identique car il y aura affectation d’un nouveau n° de Cde) et la création de nouveaux enregistrements LIGNE_COMMANDE liés (identiques mais donc rattachés à ce nouvel enregistrement COMMANDE créé).

I have an automation that is triggered when a user clicks a button in an interface. The automation is current set to simply create a new record in the underlying table, and fill in three fields:user = should be the Name of the user who clicked the button. This is a "User" or "Collaborator" field in the underlying table. I have the user who clicks coming into the script using the input variable selector.status = should be "Assigned" which is one of the possible values in the field, which is a single-select field.string = "string is string" this is obviously a placeholder, but this is just a string.Here's my code:  // Get the input variable let inputConfig = input.config(); let userName = inputConfig.userName; // Define the target table let table = base.getTable('Table'); // Get the list of active collaborators in the base let collaborators = base.activeCollaborators; // Find the collaborator object that matches the userName let assigneeCollaborator = collaborators.find(coll

I am using API calls to read information in a Airtable Base and bring in values into Excel.I only have one person as a Collaborator in airtable but multiple people have a copy of the Excel sheet in my team that use the sheet and its associated calls but they are not registered with Airtable.I am on a free plan but I see that my Monthly API calls are over the 1000 person limit. I plan to upgrade to the Teams plan with will give me 100,000 calls but my question was if I do so do I need everyone who uses my Excel sheet added as a collaborator just because the sheet they have has the API calls?

I have a base with a large table, nearly 100k records, which contains a field that we'll call "Invoice #" which should ideally be unique. Over time records have been added which use the same invoice number, and this happens through form submissions as well, so what I'm looking for is the best way to immediately and automatically flag those records as duplicates.What I'm hoping for is a formula that can do this, populating a value of "Duplicate" or "Unique" depending on what it finds, which I can then use to trigger an automation email alert if a record ever gets updated to show "Duplicate" in that field.Unique IDInvoice #Duplicate? (Formula)112345Duplicate267890Unique312345DuplicateThe frustrating part is that I can group by the "Invoice #" field right now to try and quickly identify the duplicates, but there's no functionality within Airtable to allow me to say I only want to see groups with more than 1 record, or anything else related to the grouping. So I'd still have to scroll thro

Hi Everyone,I have base called PROJECTS with two tables:   1.  "Sync" that syncs all the values from another base called CLIENT MASTER.   2. "Projects" which is a list of projects.  Each record in "Project" can only have one client.When a new record is created in the "Project" table,  the user selects a linked client record from "Sync"  then there are lookup fields that auto-populate with fields like Account Executive, Partner, and other client information.So far that works just fine.I have created an interface with a list of records from the "Project" table.   I want to set a filter on the interface so that the only records displayed for the user are the ones where "Account Executive"= Current User.However, when I create the filter,  "Current User" is not an option.    Strangely, when I create another test field in the Projects table called "Test User" (User field type), I AM able to use that field as a filter and "Curre

Hi there,I have a button that translates my article information using deepl. So the button is connected to an automation. I would like to re-use that button in another interface, but when I duplicate the page, I need to create a new automation. Can we not connect two buttons to the same automation? Cheers,Konrad

Hey guys,I am trying to build an automation that finds a contact's record from an To recipients email address from a Outlook: When a new email is received trigger. This works when there's only 1 recipient, but when there's multiple it isn't able to find the contacts with the associated email address. This thread was helpful to pull the first email address from the string when I send the email address to a field and then parse out: https://community.airtable.com/t5/other-questions/extracting-first-email-in-a-field-with-multiple-emails/td-p/48020But my team wants to have all contacts listed on these interactions. Does anyone know how to get airtable natively (we can't use zaiper) to search for multiple email addresses from one field?Thanks!

I'm re-inventing the wheel and mine is currently square. Is there anyone here who can help on how best to map product availability?My use case is translation rights -  where a manuscript which can be sold across territories (~60), languages (~50) and formats (~5) e.g. 'BOOKTITLE' sold to North American ex Canada, English, Print or perhaps World-German-Audio. Can be re-sold on expiry.What is the best way to capture this without bloat? Currently just listing what is sold, on understanding if not listed, then not sold. Could anyone point to product sales approaches which I could take a look at and learn from?Thank you Current ideas:'Right Table' with all variations for each manuscript. Run a script: for each manuscript, loop through all territories and languages adjusting with a bit of publishing industry-specific logic and create a record for each? On sale, terms and details attached to that specific record (or even another Table?) and then linked to a record in the C

BonjourJe reçois un fichier importé automatiquement avec une colonne "Date début" au format "texte sur une seule ligne" de type01/10/2024, c'est à dire jour/mois/annéeJe voudrais dans la colonne suivante extraire le mois et le passer au format "octobre" en toutes lettres.J'ai réussi avec la fonction  DATETIME_FORMAT({Date début}, 'MMMM') à créer un lien mais le mois affiché se base sur le jour et pas sur le mois de la colonne "Date début" : Pourriez-vous m'aider svp ?merci d'avance   

I think there's a bug in the Interface Calendar page.There are 2 different settings: Label, Fields - which I think were mixed lately.The record label shows the fields names that are selected in the Fields setting instead of the Label setting.In the attached screenshot you can see that I only have 1 field selected as a Label, but the actual record label is the set of fields from the Fields setting (8 fields). Can anyone confirm?  

Hi there,I'm working on a Table where I input weekly sales figures and each Monday of every week. The columns are as follows: Sales > Shows (Linked Records to another Table) > Date.Ideally, I'd like an automation to run to create say 30 new records with the date and Shows populated. This format stays the same every week, it's just that I want to remove the need to copy and paste, creating these from scratch every Monday, so all I need to do is enter the sales figures.Any help would be greatly appreciated 🙂

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

Is there a way I can export my airtable base to firebase without having to pay a fee? I tried using Rowy, but that needs an API and airtable doesn't allow that anymore.Then I tried to set up an automation to google docs within airtable, but to create a google doc requires a paid account.I don't want to continually sync data, just a one time export so that I can use the data in another way from firebase.How do I get my data out?!! 

I have a public (password protected) interface gallery view. It contains embedded cards.  With this password, I want people to be able to open the cards within each gallery item. Currently, without an account, you can see the interface gallery and navigate within it but you can't open any of the cards. Is there a way to publicly drill into an interface in the public view? Thanks!

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!

I have a view of all the tasks assigned this week grouped by the main assignee. I have now added a another user field called support and I'm looking for a way to group by if the person is the main assignee or the support so I can see all the tasks they need to be working on, not just the ones they are the main POC on.Is there a way to do this? I figure it's with a formula but I can't figure it out. I know I could do this with individual views filtered by if assignee is X person OR support is X person, but I want to be able to see all the tasks for all the people in 1 view.

Hello! I am new to creating formulas in Airtable, and therefore need help creating a total count field based on multiple selections. What I want to have is the top items ordered (maybe top 15 items) and show which employees have ordered that item. I've created an Interface but it currently shows ALL the items and I haven't figured out a way to display only the highest totals of items. Also, I need to have a filter where when the item has the majority of the same words, it combines those two items together as one item (we did a "sale" so some items have a "25% off" in front of the item name).    Please help! 

I have a base with a table: Scores that has 2 fields in it. Field 1: TeamName, Field 2: QuizScoreWhat I would like to accomplish is to generate a leaderboard where the Average QuizScore per TeamName is displayed. There may be several TeamName records with differing QuizScores.  I do not want to show the detail records in the Interface. Just the summary records. I'm not sure the best way to do this. I managed to link to table: AvgScores, where I calculate the average. But, I cannot figure out how to do an animation, where when a new record is added to Scores, how to I update AvgScores. The TeamName is created in another application, so, I can control how it is spelled/formatted. So, I can match a field in AvgScores. But, I can't figure out how to do that either. I'm an old SQL hack...

I am designing with softr portals for my teachers. They don't access airtable but interact with data through softr. For assessments I would like then to be able to edit all records more like a spreadsheet way,vseeing 20 records for 20 students for example and being able to grade them all without having to edit record one by one as they could do with an airtable access m is there any way, platform, existing I did this ?I’m designing teacher portals using Softr, where teachers interact with data through Softr rather than accessing Airtable directly.For assessments, I’d like teachers to have a spreadsheet-style view, allowing them to see multiple records at once (for example, 20 students' records) and enter grades efficiently across all records without needing to edit each one individually. Essentially, a way to edit data in bulk, similar to what’s possible within Airtable. Does anyone know of a platform or integration that supports this functionality?I’m designing teacher portals us

Hi AllI am trying to connect to airtables through power bi and have the API setup with the key, base id and table id. however when i enter the details into Power Bi i get an "We couldn't authenticate with the credentials provided. Please try again." error. now sure why as i do have access to the airtable with the same power bi credentials.Thanks 

Hi all,I am trying to update a select field options, as mentioned in the documentation.It would seem that I can not update the options of a selectField within my automation 'Run a script' module.Documentation :Errors :Code:    // Create new entries if necessary const uniqueUpdateOptions = sortedRecords.map(record => record.fields['Price Wave Number'].name); const newOptions = getNewOptions(uniqueUpdateOptions); const selectField = priceWavesTable.getField('Price Wave Number'); await selectField.updateOptionsAsync({ choices: newOptions }) // typescript is not sure this will be of type singleSelectfunction getNewOptions(updateOptions) { // Get the existing options for the "Price Wave Number" field const selectField = priceWavesTable.fields .filter(field => field.name === "Price Wave Number" && field.type === "singleSelect")[0]; if (!selectField) return; const selectFieldOptions = selectField.options?.choices || []; if (!selectFieldOptions)

I’ve built a client meeting interface for my team with the following elements: Client record dropdown element Meeting record dropdown element Client Goal filter element (to filter for only the goals linked to the meeting) Client Action Item filter element (to filter for only the action items linked to the meeting) My objective is to generate an automated URL to view the interface with all 4 elements prefilled. I’ve been able to prefil the client record and meeting record, since these only use record IDs. However I can’t seem to identify what data type the filters utilise in their url code. Here are some examples of one of the filter’s URL code: 0Klo0=b%3AeyJBYk5NTyI6W1swLFsicmVjWEtBdGMzQmJaY0JlaUYiXV1dfQ 0Klo0=b%3AeyJBYk5NTyI6W1swLFsicmVjR1pWRzc1OU50Q2JORDkiXV1dfQ The bold part appears to be the value of the filtered meeting, but is clearly not a record ID. If I can identify this value type and source the value, I can then build my desired prefilled URL formula for the interface. Any