Automations | Airtable Community

Total in colums and send email

hi !! can someone help me? i need to send a email dayli, a greed whit total sales in determinate date, how i can get a total for each colums, and send in the email ? .

Automation to convert IN to CM or CM to IN, depending on where is updated?

I have about 30 measurement fields, 15 in Imperial, and 15 in metric.I am trying to make it so that individuals can enter EITHER imperial OR metric, and an automation would magically convert and update other field.Is there a way to do this in a singl...

Resolved! Restore Rich Text Format from Markdown

Hi all,Hoping you can help me. Check spoiler tag for completely detailed explanation of my situation, just in case you can spy a base design issue that could easily be fixed: SpoilerI have a table called "Products" and a table called "Definitions". I...

Resolved! Dynamically Pull Data From Two Rows?

Hi all, I'd appreciate a bit of help.I am trying to make a two product comparison page. I have all product specifications in one table like this: And I want to pull the specs data on this other "compare pages" table depending on which two products ar...

Resolved! Automation failing because "Could not convert string to date."

I have a task table with start date, due date, and completion date. Each task is marked open, attempted, or done via a single select. Working to create an automation that creates a copy of a task marked as "Attempted." here's the flow of my automa...

Automation - Update Records: Updating more than just 1 record to a synced field

Hi, I have an organizations table and a contacts table.Every time a contact gets updated with different organization name under the contacts table - I need the organizations table to update its synced field with the contacts name, but i need the auto...

Resolved! Copy a value to another attachment column from a roll up value.

the roll-up value consists of the image filename[image. jpg] and lmagelink[domain. com/image.jpg] now I want to create copy value that has an attachment-type column.@ScottWorld and @kuovonne I'm a fan of you guys! or maybe someone knows the answer. T...

Sum of status

Hi! Does anyone know if there is a way to do a sum of each status?For instance I have 5 statusStatus 1 - 14Status 2 - 29I am trying to get a view or a script to be able to automate an email that shows how many items are in each status. thank you!!!

Resolved! Assigning Client based on Last Name

Does anyone know how to simply program an automation that would allow for clients to be assigned to employees based on first letter of last name.So if clients with last names starting with:A - G --> Employee 1H - M --> Employee 2N - S --> Employee 3...

How to add the new value to the existing value using Airtable automation

Hi, My Airtable use case is to maintain Farmer’s finances. We have developed a WhatsApp bot, and by using webhook triggers the information gets stored in Airtable.I am using webhooks to populate the Expense Amount field. For eg: The bot asks the ques...

Auto link records if it's the same week and create new record in table

Hello, I want to link 2 records if they are scheduled in the same week, and then create a new record in a table that stores those linked records. I also want the original 2 records to have the newly created records ID. My goal is to do the following:...

Resolved! Conditional Automation Button Based on time it was Last Clicked

Hello,I have an automation based on a button click that creates a number of records in a separate base based on what is selected in a multi select field. The automation itself works well, but I am having an issue with people accidently clicking the b...