Solved

I have an attachment field containing images. I see that the stored attachment object has a url property. In another formula field I would like to show just the attachement url. Any ideas? Thanks.

I know I am late to the game here. I have been ignoring the updates until now. I currently have uploads and the links for the uploads through a formula - which allows me to create a download button.I use these so in the public share link to my base - users can quickly select the download button instead of opening the record and downloading the actual file. The airtable documentation says the url will stop working when in formulas. This sounds like my use case scenario. Does anyone know if this will this continue to work going forward?Obviously I thought this was meant to stop working in November, so either they haven't got to my base yet or I am in the clear (because it still works)...If this function will stop working - is there an alternative way to achieve what I am doing when the change happens?

I am the Technology Manager for Companion Health. We are a medical practice currently utilizing Airtable. We recently had one of our employees accidentally remove one of our client records which resulted in me having to review a snapshot and pull the data back in.I would like some advice on what I could do to ensure this is prevented as much as possible.Also is there better backup methods for client data other than the snapshots taken in Airtable?

I have a score card with a computed percentage grade (e.g., 84) that I want to turn into an easy letter grade for my stakeholders.Rather than using a huge nested IF formula I thought I'd try to use SWITCH to compare and create some values.SWITCH( {% GRADE}, >=93, 'A', <=64, 'F')But I keep getting a generic Sorry, there was a problem creating this field. Invalid formula. Please check your formula text. error message.I can't find anything in the help documents talking about using comparison operators like =, >=, <= with SWITCH.Is what I'm trying to do even possible or am I stuck with that massive nested IF statement?Thanks in advance,Anne 

Hey guys,I spent the day trying to get my head around a moving average function. In my case I want to calculate the 7 day average of my Google Ads CPL (cost per lead) metric. I have daily data from Google Ads in my base along with all important metrics like ad spend, clicks, impressions and so on. I also track the amount of leads. For the day to day calculation a formula does quite well but when it comes to calculate things "across" rows Airtable is quite limited.My approach is to use an automation that runs a script every time I update either the amount in ad spend or leads. This way I kind of "fake" a formula field. I feel like I am almost there but it's not working still and I am having a hard time trying to debug with ChatGPT.My logic is:Values are updatedDate field value is readScript finds the last 7 days based on the original date in the updated row (not today)Script gets the ad spend and leads values of fields that match this conditionValues are added and then divided (sum of a

I am building a base for client follow up. When our clients are a couple, they are entered on the same row in our main table. I have the client name column as a look up field in our Client Birthday table, so it pulls the name from our main table. However, in the Client Birthday table we need them to be on separate rows. Is there a way to use an automation or script to split the client names into two rows?For example, if we enter John Doe and Karen Smith on one line in our main table, could we make them show up in two rows in our Client Birthday table?Thank you!

HiI have a simple script I run each night, which simply attempts to tick a box in about 100 records, which then drives an automation to fire off some reports on activity that day (1 per user). Unfortunately it never completes, it tells me it has failed. It works for many records, but not all. I have similar scripts for other reports. I'm using a script because it fires at a specific time. Any ideas how I can improve this please so that it will process all before timing out. The table in question only has 100 records or so. Thanks let table = base.getTable("Users");let view = table.getView("Users for Daily Report");let query = await view.selectRecordsAsync(); for (let record of query.records) {table.updateRecordAsync(record, {"Trigger Daily User Report": true})}

Hello,I need help with figuring out how to lookup the right price of an item for a particular customer from a table.I have an order line item table that contains "Customer Name" and "Item Name". Using this information together I want to look up the price from the price level table.This is the image of the order line item table. I have a customers table where I store all information about my customers. I have an inventory table that contains all the items. The price level table contains all the pricing information. Each item can have different prices for different customers, hence the separate price level table.  

Objective: I am trying to create an Airtable automation that triggers a script to increment a "Revision Number" field each time a button is clicked. The button is configured in an Airtable interface.Expected Behavior: When the button is pressed, the automation should trigger a script that receives the record ID as an input variable. The script should then fetch the record from the "Quotation" table, increment the "Revision Number" by 1, and update the record.Issue Encountered:Error Message: The script continually logs that no record ID is provided ("No record ID provided."), indicating that the recordId input variable is undefined.Script Setup: The script is set to fetch the record ID passed from the automation trigger (button press) and use this ID to locate and update the specific record.Automation Configuration: The automation is triggered by a button press in an interface, and it's supposed to pass the record ID to the script.Steps Taken:Verified that the automation trigger is corr

We needed a "quick" way to see that a calendar entry was canceled (in the label, which is a text field named "Short Name") without typing it. (We use a check box to "cancel" the event) Forgive me, I'm new. This may not be the most elegant way of doing this, and I may have missed something I built an automation that when the check box is modified, AND the value of the checkbox is checked (a FIND table with that conditional and the Airtable ID as the record output) THEN run a script to update the text field (because putting the text and the field was not working in the non-script format) I added input parameters of recordID (the airtable ID from the find field) and xText which is the existing text in the field "Short Name" the script looks like this:  let table = base.getTable("Productions_calendar");let config = input.config();let recordID = config.recordID;let xText = config.xText;var c = "Canceled: ";c += xText;let query = await table.selec

Good day all. I am trying to create a formula to name my Clients based on the following: If {company} is not blank, use {company} and if {company} is blank use {last name}, {first name} - and if there is a spouse name use {last name}, {first name} & {spouse name}I can't quite get it to work - can anyone help? 

I guess I just don't understand how/why Airtable is set up this way.If I have a Pro account.And another has a Pro account.Why can't they just SHARE one of their workspaces and/or bases with me - with edit access - without my having to pay a 3rd time?! To be a Pro user on "their" account?!That makes zero sense to me. ;-/ 

I'm new here so I do not know that many formula. I imported my tables from excel and I have it generate name of the product with product name + weight. However, I want the numbers that are generated in 2 digits format. And here is my current formula :"[90.0]"&" "&{product name}&" "&{weight)}I tried using Round(), but it didn't help.  

Hi - I am trying to update a forecast in case the field hasn't been updated for over a month. The idea is that if there are no updates, the forecast would lower by 10%. It all looks great, until I have to "Update record", I pull the record ID (dynamic) and added the field "Forecasted" and also make it dynamic. I add the field "Forecasted" and multiply it by 0.9. However, this creates an error. Here are the different versions and the results: "Forecasted"*0.9 --> Error"Forecasted"(0.90) --> Error"Forecasted".9 --> If the original value was $15,000 it shows $150,001 (maybe it thinks I want to move the decimal place?)"Forecasted""Multiply by" --> I created the field "Multiply by" to all equal 0.9 in the data, but whenever I place both of them together, no changes"Forecasted"*"Multiply by" --> Error"Forecasted"10% --> ErrorThis should be simple, the formula is pretty easy, but for some reason I can't get it to work. Can someone please help me? Thanks!

Hello,I'm trying to create a mapping using IF and OR statement, in order to map a set of values for the 'Status' field to this new formula field.  This formula doesn't cause an errors, but it only partially works.  Does anyone know why this doesn't work?IF({Status} = "Complete",  "Completed",  IF(    OR(      {Status} = "Low Risk",      {Status} = "Candidate"    ),    "On track",    IF(      OR(        {Status} = "Medium Risk",        {Status} = "High Risk",      ),      "At risk",      IF(        OR(          {Status} = "New",          {Status} = "Needs Investigation",          {Status} = "Need More Info",          {Status} = "Under Review",          {Stat

HiI am trying to use below code (Google Apps Script) to get data from Airtable. The fetch request succeeds but the fields are returned as text [Object]. I am not able to see actual data. However the request works from other HTTP clients like Bruno.I have observed another issue. The code with small change marked below used to return data perfectly till couple of days ago but suddenly started throwing error 422. Hence I made below change and the result is missing data.Even GET method results same.Please suggest how this can be resolved as this is a show stopper.Currently the result is like below{ id: 'recrR654MViYPpGG5', createdTime: '2024-01-30T10:38:29.000Z', fields: [Object] }My code is as belowlet invoicenumin = "EI000002"const scriptProperties = PropertiesService.getScriptProperties();airdbKey = scriptProperties.getProperty('airdbkey')const fieldObj = ["quantity","unitprice","lineamount","itemdescription"]let filter = "{invoicenum} = " + '\''+invoicenumin +'\''const atdata = {//"rec

Hey Airtable Community!I have a problem that's been bugging me for some time and I can't seem to solve it, so I decided to ask for your help.I have an automation on Make.com that pulls data from my bank account, looks for transactions by [transactionId] in my Airtable base and, if not present, adds a new record. The problem though is that the filter formula I'm using in my API call sometimes works and sometimes doesn't.What I mean is when I perform tests, everything runs fine and after a few days the formula stops working - it doesn't identify correctly the records that are already in the the table and adds them again, effectively duplicating existing records. When I trigger the Airtable API call manually, using the [transactionId] field with filterByformula, it returns records correctly, but when it is executed in the workflow, it doesn't work.This is the formula in the API call I'm using: FIND("<transactionId>", {transactionId})=1Any help or guidance about what might be ca

Hi everyone, I'm a beginner at airtable automation (so excuse the novice question) - I'm trying to figure out how to set up an automation to send an email with attachment when a new record is created. Same attachment will be going to all emails. More info: 1. User fills out a form on website with email address. 2. New record is created in Airtable table "Contacts" with the email address3. I think this record then needs to be updated to include the attachment (unsure how to do this) so that it can be attached in the email automationAny help would be greatly appreciated 🙂 

My table tracks publication start and end dates for various websites, and I need to determine the time between the previous record's end date with the next record's start date.Examples:  Site A's publication will be taken down on May 31, and the new one will go up on June 1.  Site B's publication will be taken down on May 31, and the new one will go up on June 6.These require different processes ("turn this one off, wait some days, then turn the next one on" vs. "replace this one with the next one"), and I need to indicate which process should be followed.Each publication has its own record in the tableSite A / Start Date: May 1 / End Date: May 31Site A / Start Date: June 1 / End Date: June 30Site B / Start Date: May 6 / End Date: May 31Site B / Start Date: June 6 / End Date: June 30How can I check to see if the Site's records are "back-to-back" dates? In this case, Site A records are back-to-back, while Site B has a five-day gap in between.(I'm assuming this is going to have

I've read through several help topics and I am still having issues, hoping someone can help me. I have a field that is counting the days between the due date and todays date. I need to use these numbers to create a formula to provide an aging report. I'd like the 'Aging' Field to use age count to represent I need to group my table by aging, which I am trying to do by creating a formula based on the age count.if age count has a number between 1-30, aging is 1-30if age count has a number that falls between 31-60, aging is 31-60if age count has a number that falls between 61-90, aging is 61-90 Daysif age count has a number that falls between 91-119, aging is 91-119 Daysif age count has a number that falls between <120, aging is over 120 daysI’ve read through many articles and forum discussions about the nested formulas, but continue to run into errors, as a lot of the examples are not for so many options.Not only am I having trouble with the formula the age count formula

I have a list of people linked to projects in my Airtable base and I’m attempting to have the slack messages from my automation tag the user associated with the record matching the conditions when the automation runs. I’ve tried inputting the slack id as a look-up from the roster table, I’ve made a formula that concatenates it into a string, I’ve tried it both as id (with <@ and > added in message text) and <@id> in the methods above, but none of this results in a proper tag. The only tag I’ve been able to make work is when I hard-code one into the automation message, but that obviously isn’t dynamic. Has anybody had success here? FWIW; whenever I try to include the field with the Slack id into the message, it doesn’t show up in Slack at all, so I know at some point it’s getting filtered out.

Why are elements (groups) in an airtable dashboard non resizable? I added a dashboard interface in airtable with two number groups that show the count of companies and two chart groups. When I click on the expand button on the chart group, I want it to display the pie chart and the list in a descending order with details below. Though this is seen currently, I am not able to resize the charts or increase the size of the list table below. The table is seen as a thin scrollable section at the bottom and it is a very tedious experience for a user to scroll again and again when in fact the page can be otherwise utilized to show a bigger table. (see screenshot below) As a work around, I tried to create a dashboard using a blank interface. However now the number or chart element is not clickable and it is static. This makes me think airtable dashboard is not a very cohesive tool. If one feature is present, it lacks in another feature. Is there a suggestion to show better dashboards

Table 1: Companies (a list of every company that we do work for. For this example, say we have 10)Table 2: Products (a list of every product we offer. For this example, say we have 12)Table 3: Price list (a list of the price of each product for each company. If there are 10 companies, and 12 products we offer, this list will have 120 items). Each record in this list has a Company column and a Products column that links to a single record in Table 1 and Table 2.Goal: create automation that will automatically create price list records when a new company or new product is added.If a new company is added, I want the automation to automatically create 12 new records on Price List table, automatically linked to the new company and automatically linked to each product listed on the product table.If a new product is added, I want the automation to automatically create 10 new records on Price List table, all automatically linked to the new product, and also linked to every company on the Compan

Hello,As projects come to a close, I want to review how successful my team was on staying on task and completing tasks by the deadline. My base is set up to flag overdue tasks, so I know in the moment when something is overdue and needs to get done ASAP. But I'd like to take a look at the project retroactively after all tasks in the project have been marked as complete and see how many of them were finished late.I can then investigate if I have projects that need adjustments or support (unrealistic deadlines, bandwidth issues, employee struggling, etc.).Any suggestions on how to do this quickly?

I’m working with a group that has users shared at the Workspace level but now what’s to remove them from the Workspace level and share them on individual bases. I was surprised to find that users who are shared at the Workspace level can’t be shared as the Base level. Trying to do so creates an alert message that says “this user is already shared on this base.” Is it possible to shift users from Workspace to Base level access without first removing them from the Workspace and then adding them to the Base?