Solved

I'm a literary agent and I'm trying to create a way to track my submissions of clients work to publishers. I have a client table, a titles table and an editor table. It's tricky to do this in any of these because some editors will see multiple projects and keeping the feedback etc separate is giving me a headache. In the titles base I have an area where I add editors to a list when I've pitched to them and want to put them on my eventual submission list - at the moment this is a linked field with multiple select capability. What I'd like to do is have another table which essentially creates my submission lists and enables me to then go on an record submission dates, responses etc...I've tried to set up an automation so that a new record is created in the tracking table when I add editors to the multiple select field in the titles base so that I end up with a record that is basically TITLE X Editor A and the next field TITLE X Editor C... so that each one will be unique -

Hello everyone,I have a specific need that I can't seem to solve. Basically, my database includes training dates with multiple participants. At the end of the module, we ask the trainer to evaluate each participant on at least 5 criteria.So, for each training, there are 5 or more associated criteria. And each registration is linked to an evaluation form to which each criterion is attached, which are rated on 5 stars at three points in time: "beginning of the training," "middle of the training," and "end of the training."I need to send a form that groups all the evaluation forms of the session as a linked record. And then I need to be able to click on these evaluation forms and then on each criterion on which I can add a rating at the beginning, a rating in the middle, and a rating at the end (3 columns in the rating format). I tried using fillout, but it seems it's not possible to update a linked record, which is very restrictive. I'm coming from miniextensions, and this problem w

Hi,I'm new to AirTable and trying to work out if this is possible. I'm creating a form to collect data on various buildings and the facilities they have within them. I've got a starting list of facilities that I'm going to use a multi-select list for, with a checkbox option for other. If "Other" is checked I'll then show a single line text field for the data collector to add another item. However, there could be many items to add. Is it possible to keep adding single line fields on an ad-hoc basis.For example in my basic list I have:PrintersWifiWater fountainThe data collector finds that building A also has:Disabled accessScannersComputer labCaféThese 4 extra items also need to be added during the data collection and so would need 4 new text inputs to be added. Is it possible for the user to dynamically add text inputs to a form?

Hello, I want to send a form to users to sign up to an activity so the user can provide their contact information and their acknowledgement to have read certain conditions. I know how to configure the basic personal information, but what’s the best way to do the section for reading and acknowledging the conditions? I don’t have a place on the web to put the text to read so I can’t send the reader to an external link. Is there a way to link to a separate field in a base, with very long text ? I would have to do this for three conditions. I was thinking: One of the field has to be a long text “X” to read. The next field would be a single check box “I have read X” Any suggestions? Thank you

Hi there,I'm trying to utilize Airtable to manage Shopify Metafields (among other things), but am striking out with doing this in what I believe to be the most logical way.I've configured a field (column) as "multiple select" with preconfigured options (the array). This ensures we're dealing with legitimate values.Syncing to Shopify, through the use of AirPower, requires the metafields to be in the format:["MF1","MF2","MF3"] I've used ARRAYJOIN to convert the array to a string in a separate field, but am stumped at actually formatting the square brackets and quotes.Suggestions?TIA,Jeff

I have a form to create tasks, and it asks the user to select a 'project' to link the task to via a record picker.There are a lot of projects, and they are duplicated for different clients, meaning when they use the form, and search for the name of the project we get duplicate results with no way of knowing which record is the correct one.Is there a way to pull in more information into the 'record picker' view, eg) name of client, etc? 

Hi AllI created a form for my drive team.  The form information has start time, end time, etc.  The form information goes into my master spreadsheet.  The team members do not have a paid AT account - Only I do.Is there a way that the information on the form that goes into my spreadsheet could be automatically emailed to the user that submitted the form to me?

I am creating an automation to bring into AirTable records from a Google sheet that is being populated by Google forms. One of the fields is a Date-Timestamp field. However, even though the formatting is the same in both the spreadsheet and AirTable (namely, Date-Timestamp with the same formatting parameters), the Test Run yields an error that says, “Field ‘Date-Time’ cannot accept the provided value: Could not convert string to date.” Shouldn’t an AirTable automation designed to bring in a variety of fields from Google Sheets be able to bring in Date-Timestamp data without converting strings to dates? Is this a bug? Or am I doing something wrong? Thanks. Mike

I am trying to use the API request to retrieve comments from a record using the following URL: v0/{baseId}/{tableIdOrName}/{recordId}/comments. However, I encounter a '[404] NOT_FOUND' error. I am using an OAuth connection in Make, which works when I use any other request, such as a simple 'Get a record': v0/{baseId}/{tableIdOrName}/{recordId}.

Hello! I am currently using the below formula to pull together a list of cities that correspond to a record. I have City 1, City 2, City 3, City 4, City 5, Cities 6 fields. Formula looks like this: CONCATENATE({BP City 1}, ", ",{BP City 2}, ", ",{BP City 3}, ", ",{BP City 4}, ", ",{BP City 5}, ", ",{BP Cities 6}) My formula works if all 6 fields contain cities although it doesn’t look great if only one city is listed. It ends up looking like this: Philadelphia, , , , , Anyone know how to fix the formula so that the appropriate number of commas appear so there will not be a string of messy commas at the end? Thank you!

I'm attempting to assign an Award Name to an Award Picked field if an applicant says 'Yes" they want to apply for that award.So, if someone says 'yes' to the First Award, I would like the Award Picked column to read "First Award Name".  Same for Second, Third, etc. (I have 21 awards). If they don't say yes, then it should be 'blank'.I tried the AI formula (which came up with the same thing I tried myself) but the Award Name does not appear, only 'blank'.Any help would be much appreciated!! 

Hello,I have a schedule table with multiple records that are linked as work to be repeated. When a checkbox is set I want each of these records to be recreated using a repeat group automation. When the automation is complete I would like to send a single email with a summary of all the records created. Currently, it appears that Airtable severely lacks this as a native function to add further automation steps after a repeat group.Thanks!

I run a workshop / class business.When a customer books a class I need to manually link the customer to their class looking for the correct class title and date (there are multiple dates to choose from for each class).HOWEVER ... after having airtable for a year now (created for me so I'm still a relatively new user) I have accumulated 100s and 100s of classes and although I can type in the search bar the name of the class to narrow down the number of classes to search through (to find the correct date) there are still far too many and its never in date order either. Annoyingly classes dating back to 2023 will still appear in my search which I would love to omit from my search. Can anyone help? I can't delete the classes from my bases because I need the data. So how do I make it so that when I need to link the class (record) all I see are the dates "from today" or at least just from 2024?It's getting easier and easier to make an error as there are just too many to search through and th

What should be do for Customer relationship management (CRM)?

Hello,I am attempting to use Airtable's Kanban board in Interface Designer to replace Trello. It's been going really well overall, however, I just realized that Airtable is not letting me change the order of cards in each column. Whenever I drag-and-drop cards up-or-down in the column, they just go right back to the exact same place and order that they were in before without any change. Does anybody know how I can update my Kanban Interface so that I can change the order of my cards within each column? This wasn't an issue until my lists of cards required a scroll bar.There's not a clear logic to the order the cards are in, however, it appears they might be displayed in the order that the record was created. If so, it would be surprising to me because Record Creation Date isn't a column I'm keeping track of, so I don't know why Airtable would sort by that.I added a screenshot from the Interface Designer settings showing that the data is set to "Sort" by "None"... so I think I "turned o

Hi Community, i have a single select field with the following options. I want to add up the results from different columns in a formula. To do this, I need to extract the score from the rest. For example, only “2” should be extracted from “2 More then 20%” in the formula.What is the best way to do this?   Thanks & bestMirko 

I have a conditional automation. One of the conditions is that the actions only run if Formula = 1. However, airtable returns an error when this condition is included. The field is formatted as a number field. How do I get airtable to evaluate whether formula = 1? And why won't it do so in this set up. It seems fairly straightforward, so i'm surprise this is causing a problem. It's able to evaluate whether a formula = string.

Hello!Is it possible to enable the revision history to show exact dates (instead of "1w ago, 3y ago," etc.?I continue to run into this--where I am trying to find out when a change was made and I get these approximations. Hoping there is a fix for this or maybe it can be requested on future updates.

Hi Airtable ninjas, So I'm trying to build out an application form for new workshops that my customers can submit to apply. When I get their application, I approve their application and register them for the workshop. This triggers my automation, where I want to APPEND the new workshop data to the existing workshops that the customer attended (this happens on my Customers table).I've set up my automation to trigger with the Application status being marked as "accepted", then I used the Find Records action to find the related record in my Customers table. Lastly, I used Update Record action to update my Customers table, specifically the Workshop Registrations field, where I want all historic workshop registrations of a particular customer. As you can see below, I first selected the field from Find records that contained the existing workshops of a record, then, I added another field that brought in the new workshop selected by the customer in the form:The problem is, the LAST entry

Hello everyone,I am trying to get my formula to recognize numbers >= $0.00 in all of the columns listed:  My formula: IF({August FY25 Projections},{August FY25 Projections},IF({FY Start Split Formula},{FY Start Split Formula},{Original FY25 Revenue Projections})) For reference:The August FY25 Projections column is a currency fieldThe other 2 fields are formulated fields with a currency format.Attached you can see the "Updated FY25 Revenue Projections" column is skipping over the $0.00 amount that is listed in the August field. This is incorrect and should have picked up the $0.00 amount as per the order of the IF statement. Any help would be appreciated! 

I'm trying to create 4 automations that update Field B when Field A matches the conditions [both are multi-select fields].For example, if Field A has any of Clothing/Fashion, E-Commerce/Retail/Wholesale, Entertainment & Sports, Field B should be updated to Traditional Industries. If Field A has any of DEI, Education, Government/Regulation, Field B should be updated to Service-Oriented. And so on.However, most records in my base fall into multiple categories, and Airtable is defaulting to the first automation listed. How can I adjust my automations to allow Field B to be updated with multiple options?

I have an automation that sends an email. Now to my question, when sending a message, there is always the sender's email address at the top and then the following (see attachment). Is it possible to remove the text highlighted in red?

I have a table that syncs from emailed data from CSV attachments. I need to be able to delete some individual records. (The data is not valid, and it's messing with roll-up calculations.) When I try to delete a record in the main record UI it's grayed out and says "To delete this new record, update this table's sync configuration so that records are deleted when deleted or hidden in the source." But I don't know how to get to the source since it's an emailed CSV? Can anyone advise on how I can get some records deleted from the synced table? Either through accessing the source data (how?) or through a script or API override of sorts? Open to any suggestions. TIA!

Hi All,I'm struggling with finding the right way to deal with multiple links between two tables.I have a Base with a People table, and a Milestone table, as well as a Teams table. Milestones have an Owner (link to People), and several teams (link to Teams table). Each team has a link (multiple entries allowed) to the People table. This works great for assigning people to different roles on each milestone and have a singular Owner who is leading/responsible for the milestone.However, I want to be able to go to the People table and have a list of all milestones a person is assigned to, no matter whether the person is the Owner or in a team. I have found a way to use a lookup to get all the milestones a person is assigned as a team member, but I need to add the Owner to this list. I don't want to do a simple formula doing a concatenate, because then I can't filter by People in the interface to show everything a person is working on in the calendar/timeline/lists.So; How do I combine

Brand new to Airtable, so forgive me if this is a dumb question.  I've shamelessly stolen a formula to calculate start and end dates based off a T- or T+ from a specific event. DATETIME_FORMAT(DATEADD({Calculated End date},{Days Needed to Complete},'days'),'MM/DD/YY') The dates are calculating just fine, but when I try to add a Gantt view, it doesn't allow me to choose these fields to determine the dates for the Gantt.  What do I need to do to have Airtable recognize the output of this formula as a date?