Solved

I am trying to send an update email in the automation section with the sum totals of each field like they are displayed in the grid view. However, when the emails are sent the sum row is removed. Does anyone know how to maintain them within the email automation structure? 

Hello,I have a very basic automation and I can't figure out why it doesn't seem to be working.... when the amount paid is equal or greater to $300, I want to have a check box or single select text that says they are paid in full.I have a screen shot of the test I ran in the automation where it looks like the 'yes' single select text is added.  but when I go to my base, it's not there.  I've watched over an hour of help videos and tried multiple things.  I'm a newbie, I would appreciate the help! Thank you!!

Hi there community,I've been using Airtable for 6-8 months now, mainly as a way to keep track of material prices for a prefabricated home manufacturing operation.  Purchase orders and requests for quotes are entered into the system and a cascading set of tables with increasing levels of specificity allow me to view material prices by something as refined as a supplier SKU and something as broad as "dimensional lumber" - by ft2, bd ft, ln ft, or whatever other metric I want to have.  All that to say that the structure is pretty well built out and working quite well for me, but the more I build it out the more I am intimated by changes like the one I want to make (though I do know that I can duplicate a base to play around there and not risk losing key relationships in the data).We're looking at more heavily integrating this directly with the design software we use (Cadwork), and I've realized that the mechanism by which I've developed my Product IDs - a formula field that comb

Hello everyone! I'm new to airtable and I have been working on automation that when triggered, it decrements 1 from a field. I have been trying to find a solution but nothing seems to work. I appreciate any help that I can get.

Hi - Sometimes our automation email works and sometimes it does not... What could be going wrong?  

Hi All I am trying to pass Airtable data into Revit with the help of the DynaWeb dynamo package.I created a grid view and integrated this with the dynamo script.I am confused why the 3rd row is in index 02nd row is in index 5Please help me to solve this issue. I appreciate any help you can provide.

Hey folks, I can’t create an event based on dates in my table. I need to create an event based on formula born date-times, and that didn’t work; but even now testing with normal date columns (with hardcoded values) didn’t work as well. It encounters an error: Unable to parse datetime: “” But there is definitely data in those columns. Here is an illustration.

I have setup an automation to send emails on record creation. However, the automation fails with a message: An unknown error occurred.The automation succeeds if I change the send to email to a personal email I have.I suspect this is something to do with the Airtable not supporting one of my emails but I cannot figure out why.Does anyone know how I can resolve the issue?The email that fails is hosted by Ionos web hosting.The email that succeeds is hosted by Gmail.Thank you,Ali

I am needing help.I am needing to send 1 record to a group of email in different states. Ex: One email request to and email group in TX, another different request to an email group in FL and have it automated when the state or country says the group. (TX to TX group, UK to UK group, FL to FL group)  

I've got 3 tables - 1) Athlete, 2) Athlete Races and 3) Athlete Weekly Training Score. 1 is linked to 2 and 3, but 2 and 3 aren't linked. 3 is updated every week, with a new entry (score) per athlete each week.For any relevant entries in 2) (i.e. where the race date matches the date of their training score), I want to add the training score (from 3) into their race record (2)Is this possible with lookups? Or would it need to be an automation? I've tried both but can't quite get to the answer.Thanks in advance!

Hello!  I've been mulling over how to optimize an image in the body of an email for an automated gmail connection- to send an email based on airtable records.  I was able to add the image using airtable supported in-line HTML tag <img src="https://www.btsministry.org/images/logoNEW_02.png">It optimizes perfectly on mobile, but the image is massive on desktop/laptop viewing sizes. I've currently not had luck including image sizes through Style or including specific px sizes. I.e. style="width:300px;height:150px”; Any suggestions on how to optimize the image size using airtable's supported HTML/CSS (span, style, img) ? I may just have the html syntax wrong 🙂  Thank you!!

I've got records of song names.  I have a field with the dates we've played the song.  I want another field to extract the most recent date the song was played, but don't know how to get there.  How do I extract the highest number from an array?  Seems like it should be a simple MAX() command, but that doesn't work. 

I'm attempting to read the current status of a single select field, what I'd like my script to do is read the status of the button and simply return that status as a string. For example, if I manually set the button to "Doing" and run the script, my script should return "Doing" from the console. My airable is setup with a single table called "Item Status" that lists all the records in the table. Each record has a "Current Status" field, a single select field with "To Do", "Open", and "In Progress"   // read the current status of a record let table = base.getTable("Item Status"); let queryResult = await table.selectRecordsAsync({fields: ["Current Status"]}); console.log(queryResult); let record = queryResult.records[0]; console.log(record.getCellValue("Current Status"));   The problem is when I run this script it returns more data then I want.   CONSOLE.LOG {id: "selkMEZY58GC8AUfc", name: "Open", color: "blueLight2"} id: "selkMEZY58GC8

I try the formula that IF({Date due}!=0,CREATED_TIME({Date due}),BLANK()), but the result is the created time of the row, not the date the {Date due} cell changes. What should I do?

I’m struggling to get my head around how to draw a line chart in Vega-lite that displays multiple fields. I can get one field working, but am hoping someone can post an example of syntax required to do something like this (example from random values in Google Sheets); Appreciate any help on this. Reading through the Vega-lite documentation is leaving me cross-eyed. :frowning: Extra points to show how a line can change colour as its value gets highter or lower. :grinning_face_with_big_eyes: EDIT: Ok, making progress… point data in 3 different graphs. Now to see if I can layer them. { "title": "Data", "repeat": ["Value A", "Value B", "Value C"], "columns": 1, "spec": { "mark": "line", "point": true, "encoding": { "x": {"field": {"repeat": "repeat"}, "bin": true}, "y": {"aggregate": "count", "type": "quantitative" } } } }

Hi there, I have a table called "activities" that links to a "users" table and a "products" table.Each time a user upvotes a product, a new entry is created. (Picture 1)I am trying to set up an automation that updates one field in the linked product, with the user who upvoted that product. (Picture 2)It seems like the linked fields appear to be empty for Airtable. Only when I untoggle the fields the actual user or product appears. (Photo 3)I keep getting an error message, for an automation that should really be simple. (Picture 4)How can I fix this? Does Airtable not support Linked Fields? How can I get the linked field info to show up in the field values?I spent 5 hours trying to fix this. Any help or pointer is greatly appreciated. Many thanks!

Hello,I'm really new to Airtable and completely inexperienced with formula options.I'm looking to set up a formula so I can easily create a list of dates for the calendar year. Right now I used # option but I think a formula is more in line with what I need...Here is an example 

I’m setting an automation to copy a value from a lookup field (formatted as currency) to a currency field. The tests run fine, but the automation doesn’t get the value from this lookup field when it goes live. It works if I set a manual value in the automation, so it seems something wrong with getting the value, the field type or something like that. Has anyone hit the same issue or has something to add to help?

HiThis is Elias. I work with Airtable Api. I need to know is airtable personal token has any expiration date?I did not get any mention about the token expiration date over the api documentation.Please reply the posts.

Hi there! I've been trying to replace  "," by "&" in a lookup field using Substitute and IF statements but I still receive an error or the result is not giving me what I want. So the result I want is IF First name contains  "," then replace by &..  

I’m in the process of creating a form the interested clients can fill out and submit. One of the fields is a Number (Integer) and I wanted to know if there was a way to give a maximum value. We don’t want to accept the entry if the value in this field is over 100. As far as I know, there is no way to pop up a message or to prevent the entry from being submitted. We would not want the client to proceed with all of the actions driven by the form if their numeric value is greater than 100. I know I can use a formula to determine if the value is greater than 100, but I don’t know how I could use that formula in a form. Thanks in advance.

Hi,I'm trying to patch call an empty cell which is always be in the last/current row. Is there a way to do this with a parameter?

Hello,I'm completely new to Air Table and very unfamiliar with the available formulas.I want to have rows display dates for the whole of 2023. Yes, a long list of every day of the year. I'm including a picture as an example.I'm sure I can achieve this with a formula? Instead of manually...  

Hello. Looking for a formula that allows me to both convert to central time & round to nearest hour. What I have 2022-11-11 4:01pm 2022-11-11 2:01pm 2022-11-11 12:02pm 2022-11-11 10:15am Want 2022-11-11 4:00pm 2022-11-11 2:00pm 2022-11-11 12:00pm 2022-11-11 10:00am

This has probably been answered before, but I'm not sure how formulas work or how to maniuplate them to fit my use case.My base has multiple tables, one of which is a Members table. This includes the person's name as the primary field and other info, including their birthdate, in other fields.On another table, I have a list named Releases. Each Release record links to the Members table, and includes every Member who participated in a Release. Also, each Release has a release date field.As an example (Note that I'm only interested in linking to the H!P Members field, not the Non-H!P Members field):Let's use the record named Morning Coffee to hopefully explain things well enough.Morning Coffee was released 1998-01-28, and five H!P Members participated in the release: Nakazawa Yuuko, Ishiguro Aya, Iida Kaori, Abe Natsumi, Fukuda Asuka. I would like to have a field running a formula that displays each individual member's age in years on that date, preferably in a list. As I