Solved

We have a table called Documents and I want to use a formula that pulls the name of the file in the {Attachment} field in order to provide the Name of the record. I've been using the LEFT({Attachments},FIND("(",{Attachments})-1) for this purpose and it works great, but I've now found that if the name of the attached file contains a comma, then the formula name adds a quotation mark at the beginning of the name. So now I'm trying to combine the SUBSTITUTE and FIND formulas to:1. Look at the name of the attached file, and if it contains a comma then replace it with a hyphen (eg. 'Ocala, FL' becomes 'Ocala-FL' )  2. Then use the name of the attached file as the name of the record without the URL at the end (using the FIND formula). Another acceptable option would be to just remove the comma from any file name in the {Attachments} field and then allow the original LEFT formula to do its work, but I think that might require an additional field. It's less elegant, but I'm

Is there any way to be notified when a base has no new records in a period of time.I'm creating a base where managers need to leave a new record at least once every 30 days.  I want to be alerted when they have NOT left a new record since the last one was posted.Anyone know of a way to do this?

Hi there,In the last few months we been happy with getting an email on each new lead being created in one of our tables. The email contains all the needed data relevant for our sales team. BUT i'd really want that email to contain an attachment which is a .eml file (email) which is populated specifically with the records data. How can i accomplish this?Goal is to minimize errors when our sales rep copy/paste the data from the email. 

I signed up for beta a long time ago, but seems I'm still on the waitlist. Has anybody one else been let in to beta?Notion's AI tools are cool and I'm using them already.  Wondering if I should be shifting my workflows over, or keep waiting.  It's almost 2024!  

Hello, I'm trying to merge a CSV but the field that I need to map to is not available to select. I can't select the field I need as the merge field. It is not one of the options in the "choose a field" drop down.

Hey all I've created an automation where when a form is submitted - a record is updated. However! Sometimes there isn't a record to update, so it needs to be created first. So I need to create a process like this:WHEN a form is submitted AND record exists UPDATE it. IF record doesn't exist CREATE itBut the automation is getting stuck on the first part and fails to run into the second. I've taken a screen shot to show what I mean. How can I fix this?Thanks!

Structure is as follows:Project tab has all of our project records with around 50 fields of project-specific details.Some project records are categorized as "Original Project" and some are categorized as "Revision""Revisions" are linked to their "Original Project"I want to do the following:1. Create a new "revision record"2. Fill out ONLY the fields that will be changing 3. Link the "original project" in the "Original associated project field"4. When that field is updated, I want an automation to run that will copy and paste fields from the original project record to the revision project record, but ONLY for fields of the revision record that are empty.Example:"Original project record" fields/Project info:Unique Project Number: #557 (Autonumber)Customer name: John DoeSolar module: Mission Solar 400WQuantity: 25Inverter: Solaredge 7600kWProject type: Original ProjectAssociated Original project: None"Revision project record" fields/Project infoUnique Project Number: #558 (Autonumber

We have a list of questions in a base that we want to email out to gather answers, or ratings on a scale of 1-5. Is this possible to automate?

Hi,I'm using a form so users can enter their data into a table. In that table one field always has to have the value "SUM" I want that every new record to be receiving default “SUM” Thank you

Hello! I'm new to Airtable formulas & could use some much needed guidance! I need to calculate the total with an option of a discount if a multi-select answer is chosen. For context, this is in reference to grades of elementary curriculum books purchased. I am trying to create a formula that will show me:If Rural Discount multi-select = 'Small school (one classroom per grade level)' answer, then total # of grades licensed x $250 + additional invoice amount= total invoice costIf Rural Discount multi-select does NOT equal 'Small school (one classroom per grade level)' answer, then total # of grades licensed x $500 + additional invoice amount= total invoice costHere was what my closest effort was: Additional info:I'm not sure if this will make a difference/make things more difficult but the column I need to multiple from (total # of grades licensed) also has a formula. Not sure how Airtable is with multi-formula mingling so just wanted to throw that out there! (side note: If ther

I have a team that wants to send a weekly digest that shows updates only from the previous week. I found a formula that can show if a date is this week or not but can't figure out a way to show just dates from the previous week 

Hi, I am trying to automate an email message with invoice details for the finance department to create an invoice. For each record (invoice) I have one or multiple sales, invoice lines, so each record will have fields with multiple linked data. In the body of my email I would like to split out these fields by the invoice line (sold item), but they lump together by the fields on one line.Message body build up: Below you can see Sale #1 and Sale #2 with their corresponding fields are clustered on the same line. I need them to be on separate lines with their corresponding fields:Thank you.Best regardsChristopher

Hi all, i need help form you 🙂i have 2 tables : - VariantTable -CostTableThe key is the SKU, this field is in the 2 Tables.I would like to add colunn in VarianTable with the CostPrice.How to create field with Automaticaly put the CostPrice when SKU is same.  Thanks for you help

Hello everyone!Im trying to automate a LinkedIn Image Post using Make. But i have some problems:Even tho my scenario runs successfully, the post dosnt get posted to LinkedIn, the problem is the image.I dont know how to get the image from Google Sheet/Airtable to the LinkedIn module, even tho i use a HTTPmodule, which is weird.Here is the scenario:This is in the output from the LinkedIn module:The image URL is public, so Make can find it.Do you guys have any tips?

Using the insert Grid/List of Records into Automation email how can I include more than the Name field of the record,? Similar to what you can do with a Grid in the Page Layout designer? So the result in the email would look like:Name 1 Date StatusName 2 Date StatusName 3 Date Status Again this is a field in the main record that looks up related records that I want a Grid of, but with more details.

Hi Community,I have a team annual plan. I have a base with 8 editors. How do I read this bill?Thanks!

I have an automation attached to a button, and I want to insert the user who is logged in to a field. I can’t seem to figure this out. Is there a current_user() formula?

I have several single select columns with "yes/no" selection answers. I want to make a sort of if/than formula to combine the information from those yes/no columns. For example, in the photo below, there are columns a, b, c ,d, e. We will call those each "foods" for the purpose of the example. If someone says "Yes" to foods a, d, e but they say No to foods b and c, can I make a column that combines the yes data? I would like a formula field to show that the person has chosen foods a, d, e, just like how a multi select field looks. I have thought about using If statements, but I'm not sure if that will allow multiple answers into 1 column. I'm not even 100% sure a formula can give me the information I need. Does anyone have any input on this? 

When I use to copy a base via public share link, automations copied over as well. They were just turned off.Now when I do it, automations aren't copied. They're all gone.Am I doing something wrong? Was this removed?

hi fellow community members, I'm scheduling a series of posts on Instagram.I have created post and assets tables on the same base. However, the image previews formatted as PDFs never show through Lookup. In the attached screenshots you'll see that only one is coming through. That's a PNG screenshot. I understand that this was a major issue in 2020. Does anyone have a solution?Thank you so much!Rafael

Hello Airtable community,I've been working on a project where users input data through a form, and the results are recorded in the base. I have set up a rollup field for each question to calculate the average of the results per field. Now, I want to create a graph in Interface Designer that displays all the columns along with their averages in a single graph and sorts them from highest to lowest average.I'm currently having a hard time achieving this, and I'm wondering if I'm approaching it the wrong way. Could anyone provide guidance or suggest a more effective approach to visualize this data in the Interface Designer?Thank you in advance for your assistance!https://airtable.com/appbYmoC5vgmEZJPx/shrZ7wAcVoE0AcfIA

Hello,how can I calculate the weighted average? Example:[-4, 0, 2, 0] -> I get this values via a roolupI want the result to be -2 i.g.. Correct me please if I am wrong.I'm open to use multiple formulas. Best regardsJohannes 

Greetings,In an Airtable, In a single column, I want to be able to edit a single select drop-down menu for all the fields in that column at once. Or to select and edit several at once.Any suggestions, ideas, or information would be greatly appreciated.Thank you.

We have a Start Date (Date field) and a Start Time (Duration Field).  I want to combine them together.The first formula I have does combine them, but not in the way that airtable calendar view recognizes it as a date/time field.Can you help me create a formula that will format it  properly (more like the "copy" field below, but showing the correct time. Currently I am using:DATETIME_FORMAT({Start Date},'M/D/YYYY')&' '&CONCATENATE(FLOOR({Start Time} / 3600) & '',':',IF(MOD({Start Time}, 3600) / 60 < 10,'0' & ROUND(MOD({Start Time}, 3600) / 60, 0),ROUND(MOD({Start Time}, 3600) / 60, 0) & ''))

Hi Airtable friends,I'm new to Airtable and really loving it. But currently stuck on something that seems simple. I'm looking for a way to automate my sales summary by country without having to predefine the countries in my Airtable base.I have a sales order table with detailed information, including the quantity of products sold and the country they were shipped to. I need to create a separate table that dynamically summarizes the total sales by country.Challenge:The "Total Sales by Country" table should update automatically as new sales data comes in.I cannot predetermine the countries since new orders may come from previously unlisted countries.Current Setup:My orders table includes fields for order number, customer name, quantity purchased, shipping city, shipping country, and product.I have created an example of what the summary table should look like with hardcoded data, but I need this to be generated automatically.Request:How can I set up a rollup or a summary table that automa