Ask the Community

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

 I want to calculate the average income per hour correctly by dividing sum of total price by sum of total hours. In the left number the average is calculated incorrectly by dividing the sum of income per hour with the number of projects. Is this possible? I would need calculations in the interface I guess.

Hello!I have a table that has multiple tabs. If on Tab A, I have a column of costs, am I able to link the sum of that column to a cell on Tab B?I know that I cannot use Airtable like I do Excel, but I am trying to do it anyway because I really love working on Airtable.!!thank you for your help!  

I’m working with two tables in Airtable: "Application Data" and "Personal Info". Here’s the setup:Application Data Table:Contains records for each application a student submits.Students can submit multiple applications, so they may have multiple records in this table.Has a column called "Full Name" (used as a unique identifier to match records in the Personal Info table).Has a checkbox field "Reviewed" to indicate when an application has been reviewed.Has a linked record field called "Personal Info Link" which should connect each application to the corresponding personal info record.Personal Info Table:Contains one unique record per student.Has a "Full Name" column (used as a unique identifier to match records in Application Data).Has a linked record field called "Application Data Link" to link back to all applications a student has submitted.Goal:I want an automation that, when the "Reviewed" box is checked in a record in the Application Data table, automatically links that record to

I've had a simple "LInk to Another Record" field working flawlessly for years.  All of a sudden it stopped working correctly., sometime between 9/27/24 and 10/31/24 . I give you the dates because I'm almost certain that there was a note from Airtable that popped up in the last week or two about new AI features, and I see that on the Link to Another Record field there is a new option that wasn't there before--to use AI (see attached screenshot).AI addition or not, here's the behavior:- On existing records, it's still working, sort of. Although if I change the field (Field 1) it is using to select a field from the target table, it doesn't grab the new record.- On a new record, The Link to Another Record does not bring in the record field. So on new records, I now have to out my cursor in the Link to Another Record field, and manually select the record I need.Any ideas?   

Hello, I am trying to collect two types of survey responses through Fillout parent & child form that are linked to two separate Airtable tables.1) I am using the record picker option on Fillout to let respondents create new records. Currently, only child form responses are updated on Airtable and the parent form responses do not get updated on Airtable even though they are integrated correctly. What could be the issue with this problem?2) Is there a way to set titles to the new records created by respondents? Currently the new selected record appears as a blank. 3) Even though I have integrated the respondent identifiers for both parent and child form, the unique link to log or identifier (name) columns do not get updated on Airtable. Is there a solution for this? Any help will be appreciated. Thank you in advance! 

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

In the new forms section there is no way to sort your form title in the left forms list.Allow sorting of these forms both by drag and drop AND alphabetize like we do all the time with fields like single selects. Thank you!mpollock@olamilaunch.org

I turned off an automation as I wasn't ready for it to run. The automation was set to go off at a certain date. When this date was reached the automation ran even though it was turned OFF. Should automations run if they are turned OFF? 

Hi there,I am building a base with 2 tabs: the first one is for data entry and to be linked to the second tab which contains standardized data.  About 5-10% of the data in the second tab updates frequently and the data in tab 1 must reflect the data in tab 2 on the date of entry, meaning the data in tab 1 should maintain the old data and if new data is entered, it will show the most current data from tab 2.How do you counter this problem?  Any insights or help will be appreciated.  Thank you very much! 

To create a base through API you  need to provide a workspace_id -> https://airtable.com/developers/web/api/create-baseBut I can't find a way to list the workspaces a token/user has access to. How do I get the different workspaces for a token (in non-enterprise accounts) ?

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 there,I've created a base where I track all of the marketing activity for a number of shows, and now wish to track the weekly sales and present them in a line graph, similar to how you would in Excel.At the moment, I have a column in a table called 'Revenue To-Date' where I update the figure. However, this is replacing the data each time rather than tracking it in order to show trends. I'm open to using an app or building out another table but would love a simple way to update this via the interface I have built out.The data itself comes through via an email each day as an Excel spreadsheet, so if there was a way for this to be automated, too, I'd love to learn the best way to configure.Thanks in advance!

Hi all,Having a really rough time trying to update a (User) record through Script.I am trying to update multiple fields, names and types below:Leads: Linked Field"Source": Multi-Select"Marketing Consent": Multi-Select"Landlord of Properties": Linked Field"UTM Source": Multi-Select"UTM Medium": Multi-Select"UTM Campaign": Multi-SelectI have checked my personal reference, and the scripting docs, and I can't for the life of me figure out what's going on... I have double-checked that the multi-select field options are present before trying to update the record, but my issue highlighted in the issue below:Example Log of Values: Example Multi-Select // uniqueLandlordProperties (2) [Object, Object] 0: Object name: "0001271" 1: Object name: "0001262" Example Linked Field* // "uniqueLandlordLeads" (3) [Object, Object, Object] 0: Object name: "rec3WbJ2Xb3rTpj2q" 1: Object name: "rec9VnDniSERZkyIo" 2: Object name: "recjbDvZZtGh3YCih" *please note that (stupidly), the record Name/

Hi, I have some columns in my table where I want to use a formula but also link the data from that column to another record. Is that possible? Thanks. Tom

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? 

Bonjour à tous,c'est mon premier post ici, j'espère être au bon endroit. J'ai déjà cherché les sujets en ligne mais je n'ai pas trouvé de réponses.Je suis débutant sur airtable, je souhaiterais faire des connexions entre deux tables d'une même base de données. Je m'explique, je souhaite créer mon CRM immobilier ou mes produits à vendre qui ont des caractéristiques spécifiques : ville, prix, nombre de pièces, jardin etc... pour être "confronté" aux recherches de mes prospects qui ont les mêmes caractéristiques de recherche.Par exemple, si j'enregistre un nouveau bien avec la caractéristique ville + prix + jardin + nombre de pièces, proposez-moi tous les prospects qui ont cette même recherche (idéalement avec un pourcentage d'erreur sur le prix) et inversement si j'enregistre un nouveau prospect.Je cherche depuis plusieurs jours une solution, notamment avec les fonctions "lien vers une entrée" et "recherche", mais je n'y arrive pas. Une bonne âme pourrait-elle me mettre sur la voie s'il

In my base i have made an automation that sends mail ( gmail) but whatever i tried it keeps giving messag " the To" is empty, there are nog blank fields in the row ( email) i ve made a roll up with the fix ( found on another thread ) .. after days of testing i didnt solve the problem.. can anyone help me please??A link to the loomvid https://www.loom.com/share/d497132a3ddb47c9a6ce93030e103e4b?sid=131789ac-7d4b-4f19-b43c-871452ce6fda  

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 

Hello all, I have a single base to use as my CRM. A tab for Leads and one for Opportunities. They each have their own statuses. Lead status has 8 steps. Opportunity status has 6 steps. What I am trying to achieve A formula counting how many records are at a certain status (i.e Demos) in that month, to output that into an interface. A formula that tracks how many days it takes to go from status 1,2,3 to 4. It may be 1 to 4, or 2 to 4. A formula that counts, in days total time from status 3 (in Leads tab) to status 16 (in Opportunities tab) What i Have so far Following this airtable article, I have the automations to output when a status has been modified and outputs into a column for each step. When attempting to create a formula, I get an error. (no ,its not the emojis, I tried without, same error). But this formula would only count from step one step to the other, and not from any to a specific step. Thanks in advance :upside_down_face:

Struggling to figure this out.  Is there a way to filter the results from a Linked Table so that it only shows items that match a term in another field? In this case, for eLearning Access Code, when you press the + to add a code from this linked table, it should only show values that match what is in the Course field of the table.  Is this possible?