Solved

Hey there, Fairly simple, but building a chart based on form submissions. For this use case, we want to represent the level that someone is being promoted into. The way this is represented on the chart element has the "10" before 3, 4, 5, etc. and I cannot figure out how to rearrange this. Thanks! 

Hey there,I'm new to Airtable and want to count all the checked boxes in one column. Anyone know how to do this? Please help! Thanks in advance.Dorus

Hey everyone! I need help making a formula that gives me the date of the next coming Wednesday based on another date in a date field. So for example if the date field shows 3/4/23, I want the formula to return 5/4/23. Thanks in advance!

Hello everyone, I have: a webhook sending a user RecordID. a linked record field containing multiple users How can I remove just that one user from the linked record field? So far I’ve managed to add a single user, or to replace them all with one user… I would appreciate some help! Thank you

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.