Solved

Hello everyone,In short, I am trying to use an automation to combine multiple single select linked fields into a single multi select linked record.I have two bases: projects and team. Depending on the complexity and size of the project, there may be 5-15 resources assigned. We assign these resources through their own single select linked field so that we can utilize the timeline/utilization function. This makes doing things for the entire team complicated - such as creating a distribution list for the team members -  as we have to create a lookup field for each resource's email, another field to combine them, and another field to format it. I thought a simple automation could address this issue. It is pretty simple: when one of the 15 single select linked records is updated, it updates the multi select "team" field with all the assigned resources. I am running into two issues: 1)If I don't put a separator, then the multi select merges them all together (Instead of the field h

Is there any way to control the image sizes I get served from an Airtable Attachment field via API? My API docs tell me I can access “thumbnails” in sizes “small” (width 72 on one image), “large” (width 1024 on one image) and “full” (3000 on one image)… But… “full” is not a thumbnail at all, it’s the source image. “large” is too large. “small” is just too small. It feels like there’s a missing middle size here. But it’s not supplied. Is there any way to constrain the size of an output image?

I have an automation that 1st Finds Records from a table then Inserts the Found Grid into an Email. I have static Emails and also want to Use Emails from the Found Records.  If all the Found Records Emails match is there a way to just add 1 instead of it putting in multiple identical Emails in the To:I imagine maybe a script but do not know how to write those. Bull

buongiorno a tutti, ho bisogno di aiuto perchè non riesco a concludere quest’operazione:mi occupo di vendita di merce, ho creato una griglia con varie informazioni, tra le quali esiste la colonna nella quale viene visualizzata la data della merce in uscita.mi piacerebbe che quando questo cliente risulta “uscito” venga spostato in un’altra grigliacosì da avere un elenco di clienti da consegnare, e nell’altra griglia merce uscitagrazie 

Hi all!I've created an automated email and am trying to include our company logo as a footer.The code I've used in the input is: <img width="200" height="50" src="https://www.the-page.co.uk/psoostoo/2022/05/The-Page-LOGO-2048x486.png">In the preview, this works perfectly (see image), but when I ran a test to my own email address, the image didn't render and I just saw a grey box (see other image).Any idea on what I'm doing wrong or what the issue may be?Thanks!

I'm trying to set up an automated email to email our clients with a feedback form (not an Airtable form, we use a different platform). The feedback form needs to be tailored to each individual, so I've added a field for the link for each record. In the automated email, I'm using the "choose data from" tool to insert the form url from the record. However, when I generate the preview, there is nothing left. I've attached screen shots of the draft email vs the preview. How do I make the link appear in the email??

I have an automation that reminds me to complete a task once every month, however, I realized what I actually need is a reminder specifically on the second Wednesday of every month. I’ve been having a lot of trouble figuring out an automation for this new reminder requirement and would love some assistance if anyone has any tips or advice.

Hello the community,I want to write a script which will read the data from a csv file which is in the attachment field "doc"  in the table "fileImport"The csv has 4 columns:Nom,Ligne,Jour,Valeurhere is an example of the data:Nom,Ligne,Jour,Valeur Bornet Marc,AL / ASD,2024-04-01,2Doe John 85%,AL / ASD,2024-04-01,17I want to parse all data and to create/update/delete records in the table "Planning" and writing the data in the appropriate field:Nom,Ligne,Jour,SV how can I do such a script 

I have the following use case: I have images saved as attachments within a table. I need to automatically upload any newly created images via API (not Make or Zapier due to volume) to an 'Input' bucket on S3. From here the images are manipulated by another API and saved to an output folder. When a file is uploaded to the output folder we would send this back to airtable.Can someone give me some general direction in writing a script to enable this? I understand I will need a presigned URL from AWS which is well documented, but I'm struggling on how I might do this using Airtables API. Any help very much appreciated!Many thanksEdward

👋 Hi all - wanted to share something I thought you might enjoy!We just launched Whalesync 1.0 - the easy way to 2-way sync Airtable with your CRM, DB, spreadsheets, and other tools.https://whalesync.com/Hundreds of fast growing companies, like Webflow, Descript, and Clay, use us to bring the power of Airtable to their other apps with true 2-way sync.Popular use casesWhen you can two-way sync Airtable with your other apps, you basically unlock super powers. A few pretty awesome use cases include:Creating programmatic SEO pages in WebflowUpdating leads in HubSpotConnecting project teams in Notion/Google Sheetshttps://www.whalesync.com/connector/airtableTools you can 2-way sync with AirtableWe support >15 connectors you can two-way sync with Airtable includingGoogle SheetsNotionSalesforceHubSpotZoho CRMSupabaseMS DynamicsWebflowTry it outWe have 2-week free on all our plans which you can try out here -> https://app.whalesync.com/If ever have any questions, also fee

I create a Make.com automation that sends out a transactional email to the customer when a new record is created in my enrollments table.  The last step in the automation is to update the Enrollment record so show that the Confirmation Email was sent out by updating the record with today’s date.It’s a rather basic setup, but every time I test it out I am getting a “404 Not Found” error when Make tries to update the record.I have checked the Input / Output in the error, but I’m not finding anything useful.  The OAuth connection is working fine to pull the records, and the Base / Table / Field names are all pulled from the dropdowns.  I also checked the Base ID, Table ID, and Field ID from the output bundle, and they are correct.Airtable Update node 404 Error  Input Bundle  Output Bundle  Airtable Field 

I have two separate bases. When a form is submitted in base1, a record is created. When a specific record matches a condition, i want to use an automation to create a record in base2.Ive tried using the sync feature in the data layer, which appears to pull base2 data layer into base1 data layer but when i go to the automation, the table I want to create a new record in is there, but is greyed out and cant be selected. I went through permissions with someone from airtable, but we still can’t figure out what the issue is. This is from the automationIn the table field i can see the table i want to create a new record in, but it is not selectable. IN the data layer, it is listed as grid view   

I want to update a record when a field condition is met, and currently the “Update Record” automation only seems to use any value/change to the field. What I am trying to do when the “Status” field is updated, and ONLY when it’s Value is changed to “Used” do I want to execute the update. Right now when the value is changed from Used to Unused, it runs the automation. Any guide on what combination of actions I can use to do this?

If I use an automation to update fields, does it update the fields in the order listed in the automation? So can I copy data from the existing fields first then update the fields with new data all in the same automation? If they update in order why can't I rearrange the order? just have to delete and reorder them all manually...

I have a Single Select field field that I want to allow users to be able to add new options too when they are in Create Form interface. Since this is not possible, are there any workarounds/alternative designs that anyone has used?My thoughts:1. Using Linked Record is also not possible, since it doesn't allow new record creation from the Create Form interface. 2. Using a text field and then automating creation of the option in Single select also is not possible since I believe it doesn't allow update of the Single Select options through "Run Script" in automation?

I have an email table with field agent that extract information from an email. I want to use data from another “events” table to match the result from the field agent and get the best possible match. Any suggestions on how to achieve this?Regards

Hello,Please I need help with resolving this blocker I’m encountering with the system adding multiple records of each unique client email to the email sent. I have tried replicating the issue in the loom recording 👇🏼;  Looking forward to positive responses and best/ideal recommendations 🙏🏼 

As I create Interfaces for my database, I noticed that my record selector box for my source table, always defaults to the earliest record.  I need it to appear blank, when I first open the table's Interface.   Is there a setting that I need to change, or is an "unwanted" feature of the Airtable Interface?

This is kind of complicated and I’m not sure if it will be possible, but here goes. I’m trying to automate data entry for each record I create in my Project table. What I have set up now is a Long Text field called “Paste” where I paste the contents of an email, and several field agents that comb through the text of that email to fill out fields like Project Name, Project Type, Notes, etc. Each email contains the name of several people associated with the project’s production team: directors, writers, and producers. I have a separate table that is a Master Contact List of all the names that have ever been entered, and in my main Project table, I have a linked field called Production Team that links to the Master Contact List. Multiple linked records are allowed so that multiple people can be logged in that field in the Project table. Right now, I have to manually enter all the names. I would love for a field agent to be able to do this for me, but it would require several steps. First,

This one is a little convoluted and I can’t figure out where I’ve gone wrong. I have three tables - course list, participant list, and course completion status. I set up an automation so that when a participant is added to the linked field in course list, or a course is added to the linked field in the participants table, it creates a record in course completion with that information.What is happening is that the new record will do one of three things: it will link to the correct record in the course list, it will link to a different record in the course list, or it will create a new record in the course list. I actually need to make some changes to accommodate users who get future enrollments, but I want to get this working first.Here is the automation setup:When record enters a view in Participants table, create record in Course Completion Status table. The view is set to show only records in the Participants table where the Courses field is not empty.And the action settings:Course C

I’m trying to convert an Access database we use to track event and participant data to Airtable so that we can get away from Access and all of its downsides. What we have has always seemed pretty simple and straightforward, but I’m really struggling to create a similar situation in Airtable that isn’t so time consuming. What I have is two tables connected by a join table: Events is where I create records for each new event we host, with a unique number as the identifier, as it’s possible to have multiple events on the same day. Participants is where I create records for each new attendee who participates, and the unique identifier is their username. We have new events about every week, and new attendees is unpredictable. Participants may attend one event or many events, and the goal of the database is to track who comes to which events, to be able to pull data about the types of people who come to our events, and to offer transcripts of the events attended by attendees who may ask for

Hi everyone,I’m trying to create a line chart in Interface Designer that shows interest rates over time. My table structure is simple: Date (date field) Rate (percentage field) Type (single select) In the chart settings: I use Date for the X-axis, Rate for the Y-axis, And I apply a filter so that only records with a certain value in the Type field appear. However, I noticed that Airtable automatically applies an aggregation (e.g., average, sum, etc.) to the Y-axis values, and I can’t find a way to set it to “none.”Since each date in my table corresponds to exactly one record (no duplicates), I’d like the chart to simply plot the rate as-is, without aggregation.Is there a way to disable aggregation or make the chart use raw values for each record instead of aggregating them?Thanks in advance!

I understand there is an Admin panel available on the Business and Enterprise plans that looks like a one-stop-shop for organizing user settings/permissions, but that this is not available on the Teams plan. Isn’t there a way on the Teams plan to see all users in one place to see what they have permission to and at what level with the ability to edit the settings right there? Currently it seems like a disorganized mess as I have to go to each element to see who has what and frankly that’s not very clear. An Admin panel seems like database 101 and should be available to all paid plans. Am I missing the boat here? (I feel like I’m missing something obvious.) A specific question: In our workspace, under the Collaborators tab, it shows three users:Me - Workspace OwnerMy boss - Workspace EditorEmployee - Interface Editor Would this setting allow the employee to interact with the base itself, or do can they only see the interface (which is the goal)?

Hello Community,First post here. I am attempting to connect my Airtable to Power BI.I am receiving the following error message in Power BIExpression.Error: We cannot convert the value null to type Record.Details:Value=Type=[Type]I am following this guidance and using a Personal Access Token. I setup Power BI Parameters successfully but received the error code in the Query. I suspected that it may be the M Code so I followed a link to a GitHub resource for alternate code."If the above script seems to be causing an error, then please refer to this GitHub resource, as the code may have changed.I have tried both versions of the M code.I don't know enough about tracking down this error code. Any ideas of what it might be?All assistance is greatly appreciated.

So I’m looking to employ a formula to provide a word count for my SEO keyphrases, which range from 2 to 8 words. Below is the formula that I thought would work, but I’ve had no such luck…does anyone have any thoughts as to what’s going on here? Thank you in advance! IF(({Keyphrase}=BLANK()),0,(LEN({Keyphrase}) - LEN(SUBSTITUTE({Keyphrase},’ ', ‘ ’))+1))