Solved

I have a base for my Dispatching business and i deal with brokerages that have different reps. I got a Brokerage Table and Contacts table for each individual rep and i link them to their particular Brokerage. I have another table where i keep Trips table but i want to know is their a way to bring in a field where i can search inside the linked records of the individual Brokerage?

Hi,I am trying to pre-fill two records in an Airtable form from the following column "Client Commercial Controls":If I pull up the pre-filled form, currently I can only pre-fill the one value ("Police check to be performed"), but I also want to pre-fill the second value ("Data security policy to be added").This is the formula I am using to pre-fill the form and have no issues when only pulling in one value, but can't work out how to pull in multiple values. Please advise.Many thanks,Nik

Hello,I sat up an email automation with Airtable. It works well and sends the emails, but I can't find a way to customize the sender name. I'd like to have the company's name as sender name instead of "Airtable Automations". Do you know how I can solve this? I have the Airtable Pro account.  Thanks very much in advance and have a nice day. Kind regards,Alex

Hi all,II'll try and better explain.Imagining you have a base with multiple tables, and on one table there are 2 fields... One, is a linked to field that allows for multiple selected records... Let's say it links to a table listing people's names; members of a team. One record has 3 names: Jason JonesAmy AbnerSteve SullivanAgain, these are individual records from another base, not text.  Is there a way I can pull just the first record, automatically, into the 2nd field? Similar to if I was using the right or left functions with numbers.  I want to have a second field that pulls out just Jason Jones in this field, and does the same for all the other records along that same field; ie pulling out just the first record.  🙏  

Hi all! I am building out something to help with vaccine planning (yay!) and need something that can essentially help me do the following: I have a single select field called “Vaccine” with Moderna (First Dose), Pfizer (First Dose), Moderna (Second Dose), Pfizer (Second Dose), and J&J as options I also have a date field (“Clinic Date”) indicating when the vaccine clinic takes place for each of them, and how many doses were administered. What I am looking to do is to automatically calculate a field for the second dose clinic (i.e. it would need to identify the type of vaccine and calculate the next date based on that. For example, First Dose Pfizer - calculate for me the next date as 3 weeks out. For Moderna, the next clinic needs to be 4 weeks out. I should add that I did try creating the following formula, but Airtable does not seem to like it: SWITCH( {Vaccine}, ‘Pfizer (First Dose)’, DATEADD (3, ‘week’), ‘Moderna (First Dose)’, DATEADD(4, ‘week’)) I know that this should be s

Hello!Our project managers often add personalized information to an automated email before sending to a client.  Is there a way to drop the email into the Office 365 drafts folder rather than actually sending it out?I see an option with Zapier but was curious if there is means to do it within Airtable's internal automation as there is with purely sending an email. 

Hello, I am trying to find a way to add an attachment from a new record to a field that already has one. The automation deletes the existing file and add the new one. I tried adding the URL from the search step in the automation as well as of the URL of the new attachment but it does not work. Also tried to separate them with ", " Or “;” but it does not work either. Did anyone manage to do that ? Best Paul

I don't understand from the documentation how to use the following filters properly:filterIsAnyOf_filterIsNoneOf_filterHasAnyOf_filterHasAllOf_Can you help me?Documentation: https://support.airtable.com/docs/shared-view-url-filters

Hey Community,  Thanks for reading my post.  I am trying to update records in Table A (sales estimates) with a number from Table B (sales invoices) when a new record comes into Table B.  I could also do this on a regular interval instead of having a new record entry in Table B kick the automation.  Whatever is easiest. Essentially, I'm trying to get around the autolinking problem.  Sales estimate numbers are unique and when they convert to an invoice the invoice has the same number.  However, I'd still have to go in every day and link all the new invoices generated to their estimates to make the reporting work correctly.  I REALLY don't want to do that.  Any suggestions?  I imagine there are several ways to get around this, but I'm really hitting a wall.

Hello,These presented properties will have a chance to have a different property address linked on this column which is not having any issues.My main question here is there any way how could I set up,  the "current property" will be replaced with the latest property address from the presented properties?For example.The first property from the presented properties was 15 Kaye Drive, after a few minutes there will be another property added to the "presented property which is 36 Erronmago Drive.How can I replace the "current property" with the latest address which is 36 Erronmago Drive?The main purpose of the "current property" should only have 1 latest property address only.Hope it is clear and someone could help 🙂Thank you 

I have customers purchase information. in Make.com I'm able to store all of the customer's purchase information into a Long Text Field that looks like such:37466774995108, 37466777616548, 43650268266737, 37466778697892, 37466778632356, 43650344222961, 43650236907761, 37466778173604All of these values are linked to another record that has the Product information. How do I convert the numbers into Linked records. I can do this manually, but I want to automate this. I know you may be asking, but I have over 122 different products, so I would rather not manually add them. Also I'm using Make.com, and the only way to automate this is to upload as a comma array. So I need some sort of formula to convert a comma array into a linked field. 

Hello!Pulled up a list of three dates from a linked table.  In this table, there is a separate date on each record.  Looking for a way to find the latest of the three dates, that is not later than the separate date in the record.  I can find the last date using MAX, but am struggling to integrate the IF statement of not surpassing the stand alone date on the record.  

This is a relatively new issue - when I copy and paste from anywhere into Airtable lately, it automatically adds two new lines before pasting my text and another line after. Can you please look into this? It's frustrating to have to go back and delete it when I'm trying to paste in place. Is there a setting I can change to stop it from happening?Pic #1 - Screenshot of image where text should be pasted. (Source is one 'word' of text - no returns.)Pic #2 - Screenshot of image after pasting text. New lines added both before and after pasted text.Thanks,Terry 

I have a task that requires itertools. but I am having no luck. is it possible to import from itertools? or any other library for that matter? thanks

We currently publish an Airtable calendar of training events on a company intranet page. We use the Zoom event registration feature and I have a button on each event that takes the users to the Zoom registration form. But I'd like to find a way to track these event registrations in Airtable rather than in Zoom, so we can utilize automations, etc. Is there some way that I could build a button that so that when a user selects an event on the calendar and clicks "Register", they would go to an Airtable form which would automatically associate that registration with the selected event? I don't want them to have to pick the event from a list within the form (for a few reasons). I just want them to fill in their name and contact info and answer a couple of questions. Thanks for the help!

I have an interface for Contacts with a linked record to Interactions. The linked record is customized to display the required details.When creating a new interaction, only two of the details are displayed. If I then click on that record after it's been created, I can then edit the additional details.

I'm struggling to figure out a solution for scaling views.  I currently have a view for each of our districts (which gives me approximately 90 views). They all have identical data/fields with a filter to only see the pieces tagged in that district.  I set these up as views specifically because I need the shareable URL for users viewing that don't have an account. I am using that URL in some email automations - use case, district updates. So each month, an automated email to that manager saying "here's your highlights" (all dynamic fields) with a link to "view your detailed breakdown here" (dynamic field to insert the URL of their view).    Hopefully this makes sense so far.  My problem is how poorly this scales. I just improved the view with a few other columns/groupings etc. But now I have to make that manual change across each of the 90 views and hope I don't miss any ..... is there any way at all to scale this?  The views are all ide

Hello,I'm wanting to move from Trello to Airtable Kanban, but I have a few questions as I'm setting it up:1) I wanted to make the Primary Key Field to be my Task Name, however, if I do that then I am unable to *EDIT* the Task Name within the Kanban Interface. That's a bummer because I don't want to have to go back to the Table/Data view just to edit a card's title. Since that didn't work I tried #2 below:2) Just using "Autonumber" for my Primary Key Field, with the hope of hiding my Primary Key Field on the Card View and making the Task Name column the header on my Kanban Cards... but, when I'm customizing the way my "cards" display in the Interface Designer, it appears that I cannot remove the Primary Key Field from displaying... so I either have to have a meaningless number as the header, or an Task Name that's uneditable from the interface.How can I:Keep Autonumber from displaying on my Kanban Cards, Use Task Name as the header for cards, and Be able to edit the Task Name within the

I want to map specific job roles to job categories. "Open Roles" in Table 1 has the specific roles, and Table 2 has the mapping between the categories and the roles. If "Open Roles" has a matching option in "Old Role", then I want to add the "New Role" value to the "Open Role Categories" field in Table 1.Worth noting that "Open Roles" can have multiple options and may need multiple mappings.

Hi everyone,I'm learning airtable scripting and what i want to do is this :-When a check a checkbox in my table, it run a script which will fetch a webhook. The webhook's url is concatenate with the webhook's url and the recordID.My script is running well but it concatenate only the recordID from the row 01. Whenever i checked another box from another row...My question is : is there a solution to concatenate with, my webhook's url, the recordID from the row that i checked the box ?Here's my script : (a mix of everything I found on the internet) let url="https://hook.eu1.make.com/XXXXXXXXXXXXXXXXXXXXX"let table = base.getTable("Ligne - Matériel");let queryResult = await table.selectRecordsAsync({fields: ["recordID"]});let record = queryResult.records[];let request= url.concat('?ref=', record.getCellValueAsString("recordID"))await fetch(request); Thanks a lot !

I’ve read several posts similar to this already, I but haven’t figured it out. I’m trying to count how many times the word “Retouch” appears in this Rollup record.

Hello  Is there a way to copy data into airtable by copy and paste. My airtable table has a link field that points to another table. In google sheets I have the current data where I need to copy some missing records maybe a handful. Is there any way to copy in that link Field. I can copy to any of the other data fields that are not link. But it seems that I have to select the plus and manually enter the location is the link field. Is that correctSorry for w newbie question

Hi there,I'm quite the novice at Airtable at the moment and would love some help with from anyone whom is knowledgable with the SendGrid integration and/or can figure out a solution for this problem. I understand how it works, surface level, by adding {field}s to the HTML however, it is not as dynamic as I want it to be. My goal is to send an email from the SendGrid integration with information from multiple rows - a dynamic list in the email that will shrink of grow depending on how many rows there are.Is there a way to add a repeating group in the HTML-code of a SendGrid email that is pulled from Airtable?Is this possible? If so, how? 😭

Hi there,i have an automation question that I can't get around. Using Airtable as a CRM system, I have a table DEALS, a a table CLIENTS and a table BRANDS. I would like to build an automation that checks on a new DEAL if a CLIENT has placed a DEAL with that BRAND before. The DEAL name contains the name of the brand and all DEALS of the CLIENT are referenced in the CLIENTS table.It needs to be something like:Trigger: New DealIf CLIENT(from DEAL) has already a DEAL that name contains the name of the BRAND (from DEALS) then set „NEW CLIENT“ field to TRUEanyone that might be able to help me out here?thx!!

I’m trying to create a home page for my Confluence space with some headline data from a table I’ve got in AirTable. I’m ultimately trying to create Power BI type cards on the page, showing a count / total of records in a view in AirTable. I’m not even sure how to get that headline data out of AirTable, let alone import it into Confluence. I’ve asked the question on the Confluence forum as well, to see if it’s better to approach it from that direction.