Solved

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

Without using forms, but within AirTable itself, is there any option to build anything like a flow chart, where selecting different options would show different fields to input data?For example let's assume I have an employees table. Each employee can either be employed directly or via a subcontractor - for each option I need to fill out different fields, and then for each one of them they can be in different departments, and for each department I want different fields filled out once again and so on.Is there any way to do that?

Hi all,Just asking for a kick in the right direction for a formula, extension/script and/or automation that'll put the PriceInput value from my Price List table into the Database1 table (whether it's displayed in the Lookup or thrown into the PriceOutput field) when the "Agency, Board Type, Size, Type" match.I can see the option's available to select the suitable record via manually selecting it in the linked cell (as pictured in attachment) but this is obviously the part I need automated when a new record gets put in or updated.Database1 : https://airtable.com/apprcSs2FuTW9JKPJ/shrX6iv9CyKfOFLN3Price List : https://airtable.com/apprcSs2FuTW9JKPJ/shrMo95QtDPC7n3HqGreatly appreciated in advance 🙏

Do you know how manufacturing facilities have a "days since last accident/injury/whatever" sign? I need to create something like that on a dashboard. I was hoping to be able to use the simple "summary" extension but I can't seem to figure out how to do it.I have a table that tracks events and their corresponding dates. Events happen almost every day. Every once in a while, there is a day that has 0 events. Each event also has a time duration (minutes). On days with no events at all, a record is still created (via automation) for charting purposes, and the field that shows the duration of the event will show 0. I'd like to be able to display the number of days since the date when there were no events. Example:DATEEVENT DURATION (MINUTES)5 days ago15 days ago44 days ago03 days ago33 days ago83 days ago102 days ago3Yesterday1Yesterday6Today6Today4So if you view this summary extension block "today", it would show "4" because we've gone 4 days without seeing a 0.How can I do

Hello-I have created a field with single select options. Is it possible to create a link such that when an option is selected it will link to a new field with new sub categories? Example: Field= Clothing with  Single Select Options: Skirt, pants, suit., etc.  When "Skirt" is selected, I'd like a new subcategory further defining skirt to become available either to populate the same field or a new field ex:  mini, knee, maxi, long. Thank you.

I created PAT as followed in documentation and copied it's token but I can't use it.I do get an "Error 403" in Make when I use my PAT there and I also get "Invalid Personal Access Token" in Xano.I checked the documentation regarding it and it seems I don't understand how to use it since I only wanted to use the template as base here in airtable and use it's table in Xano as a test data.

Is it possible to exclude records that have a zero value from an average rollup?

I use Airtable to track and schedule vaccinations for the animals in my calf barn. Using the birthdate of the calf, I have formulas in the due date fields to calculate the appropriate date to give each vaccine to each animal. Then I have a field with a checkbox to indicate when that vaccination has been completed. I use the calendar view with this table to show me what I need to complete on any given day. This works well, but what I want to create is an automation that removes the item from the calendar view after I check it off as being completed in the grid view. I would even settle for the date of that item being changed to a date 6 months in the past or something, just as long as it doesn’t keep showing up and cluttering my current calendar. But most automations I have tried can’t alter a “calculated date”, which most of my fields are because they are all based on the birth date of the calf. I have been puzzling over this for a week now and am hoping someone out there has a potenti

Hi,I'm having trouble with Airtable displaying options off the visible screen. So far I have experienced this with automation menus (first image) and creating dropdown fields (second image). Is there a way to force these menus to only appear on the visible sections of the screen or a way to scroll these back into view?Thanks for the help.