Solved

Hello Airtable community! I am struggling with a formula and thought I would put it here since you all never let me down :slightly_smiling_face: I want the formula to produce the result overdue IF the contact’s sum of (“level of connection” and “Level of importance”) is greater than 5 and “Last Contact” is more than 180 Days The contact’s sum of (“level of connection” and “Level of importance”) is greater than 7 and “Last Contact” is more than 90 Days -The contact’s sum of (“level of connection” and “Level of importance”) is greater than 8.9 and “Last Contact” is more than 30 Days For reference here is what I currently have (Very far off) IF(DATETIME_DIFF(TODAY(),{Last contact},‘days’)>90,“Overdue”) THANK YOU !!!

Phew! Lets’s see if I can explain this clearly. Almost daily I go running. I keep a log of distance and time and get a kick out of recording and graphing the results. In Airtable, I’m using the chart app to chart several bits of data (DIstance, Time, s per km, s per mile, speed, etc.) For the straight forward data (duration, time) Airtable has no problem making charts for me, they look great! But, Airtable won’t let me make a chart with duration. No problem: the current workaround is as follows (example to calculate km/h): Insert Distance as Decimal in “Distance” field Formula -> convert to m (divide by 1000) (new field) Insert Duration as Duration in “Time” field Formula -> convert to s (divide by 60) (new field) In “km/h” field, formula {distance}/{time}*3.6 This then gives speed and so far has been carefully charted every day without fail But when I try to do something else (e.g. duration for fixed distance - mins per km) the fomula works for all previous entries but never t

hi. im trying to change the view with filter by api as i said. (outside airtable) i read the api document. and tried to “filter by formula” by airtable encoder. BUT as i understand it only support “GET records” which is not i want (to ADD filter in the view) is there a way?

I’ve successfully applied both those conditions distinctly: filterByFormula: {customerOwnerRef} = '' filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}') But I don’t understand how to make a logical OR between both conditions, I tried the following but it fails with INVALID_FILTER_BY_FORMULA error: filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}' OR({customerOwnerRef} = '')

Hey guys, Which field type should I use to enter page numbers for each of my table listings? I want to be able to do some calculations on them later e.g. average page number for 10 rows of book listings. I tried using the number (#) field type but it adds an unnecessary decimal place. So for example a page number entered as 350 changes to 350.0. I was going to use the single line text field but wondered if that would prevent me running calculations later on. Thanks in advance if anyone can help.

Hello! My setup is : two tables fisrt is made with my participants second is made of my categories (event A, event B,…) I am looking for updating the number of participants recorded in my first table in each event that are in my second table. So far, I could compute the total number of participant by event in table 2, but I cannot find out how to update this calculation while a new record is occuring. Because automation Update record replace the value : it seems impossible to append a record, nor to use a variable like “ALL RECORDS” (for example). How can I manage this issue ? Thank you !

Hi folks I’m having an issue with the Charts app. I’m setting up a simple scatter chart with x and y axes drawing from formula fields in my base outputting a percentage and a decimal, respectively. After initially setting the axes, the plot works nicely, and when I rollover the data points on the chart it shows me the points measurements alongside the primary field data for that entry, identifying the point. My issue is, when I then go to group the points by a third field (using the “group by” toggle in the chart’s Y-axis settings), while the grouping displays on the chart correctly, when I rollover any particular point the primary field data that appears on the chart is for a completely different point. Though, when I click on the point, it does bring up the base entry for the correct field it is supposed to represent. Am I doing something wrong here? It seems like a bug to me, and it reduces the usefulness of the charts app quite a bit for me. Would appreciate any and all feedback! C

Hi, is this possible? Thanks for your help.

I have a table with a lot of webshop orders in it. how can I make a view with all orders made to-date a year ago? So I can compare Christmas sale from last year with the sale this year to date. is there a function that checks for order date one year ago and back for example

hello, i want to copy my first field to second field using automation as shown in image below. any help please? my automation’s trigger is “when a record is created” and action is “Update record” i want to update my second field with my first field’s value

I’m trying to work out how I can have different members of a team view a spreadsheet of ideas (each row is an idea) and have them each vote on whether they like the ideas. I want to then show an updated tally of the number of votes each row gets. I was thinking maybe I have a multi-select column with the names of each team member. If you like an idea you add your own name to this selection. I’d then want another column which is a number, which I was thinking I could have a formula to count the number of items selected in the multi-select field. So I’m not sure what formula would work there. Or if perhaps there’s a better way of approaching this? Thanks.

I’m trying to further customize a formula (that’s already working) with additional functionality to detect when text is missing a certain element and, in such cases, to then add that element to the text in a different column, but can’t seem to get anything to work. Specifically, I have a formula that, among other things, takes a URL from, say, Column A, and then customizes/edits that URL in Column B based on criteria from data in other columns. In this instance, Column A is a URL field and Column B is the formula field, and Column B displays updated versions of URLs from Column A. So far the formula is working fine except I also need it to detect when a URL in Column A is missing its trailing slash ("/") and to subsequently add in that slash where it would otherwise go when the URL appears in Column B. I also don’t think it will be as simple as merely finding/replacing instances of <.com> with <.com/>, <.org> with <.org/>, <.co> with <.co/>, etc., si

SOLVED: SEE POST FROM KAMILLE I have a database of students in Uganda and I am building a separate table to help the administration track student temperatures (government requirement for school re-opening). The table is simple and the nurse will use a basic form (Select student name, enter date/time, enter temp). In the Student table, I’d like to add a field that shows the most recent temperature taken and the date. The Rollup field works well for the date using the MAX(values) aggregation formula, but I can’t figure out how to show the most recent temperature (as opposed to the max or min). Any suggestions on how to show the most recent number added within a set of values? I’ve seen a few other posts on this, but I couldn’t find a clarification. I realize the “Most Recent Temp” field in my screenshot is a text field. I’ve placed that there for illustrative purposes only until I can figure this out. Thanks, Dave

Building a payroll system and need formula help with splitting up total hours between Daily Hrs, time and a half pay, and doubletime. Here’s my setup: My “Total Hrs/day” is the actual total of all hours worked, calculated with: (OUT-IN)-BREAK Then, I want to limit the amount of hours from the “Total Hrs/Day” that can go into “Daily Hrs” to 8 hours of regular pay. I do this with: IF((OUT-IN)-BREAK<=8, (OUT-IN)-BREAK, 8) This means that if 10 hours were worked, “Daily Hrs” is capped at 8. I want the remaining two hours to populate into the “time and a half” to be multiplied by that 1.5x rate. The caveat is that I need this to be capped at 4 hours of overtime, before spilling any remaining hours from the “Total Hrs/day” into “doubletime”. IF( (OUT-IN)-BREAK>8, ((OUT-IN)-BREAK)-8, BLANK() ) I can then spill the remaining hours into the “time and a half” with this formula above, but I can’t figure out how to also cap it at 4 hours before sending the remainder to doubletime. I tried

I have 3 tables: Units - a list of all our technology units whether classified as inventory or leased to a customer Customers - linked to the Units table Unit Setup - this is a form to be used by the shipping department to go through shipping checklists AND assign a Unit to a Customer. I cannot figure out how to get the Unit Setup Form to update the Unit assigned to the Customer. I can get it to add a new linked record column… but I want it to update the main associated Customer record to the Unit.

While I’ve seen plenty of posts on formulas based on whether a checkbox is checked or not in another field, I’m curious as to whether it is possible in the inverse? I want to create a formula that will say, “If condition exists in some field, mark checkbox in another field.” Can this be done?

Hi! I am trying to set up an automation so that when we update the record, an email is sent out to a client with the updated notes. However, when I use the date link in the Automation, the email test comes back with “2020-10-30T18:04:00.000Z” as opposed to the US format (10/30/2020 at 6 pm). Am I missing something that is causing this to come out this way?

Hi All, I’m looking for some help in building out a formula field (Transfer Tax) that is formatted as currency. I’m new to Airtable but have a lot of Salesforce.com experience. The Transfer Tax field provides the dollar amount that will be charged when the dollar amount in another field (Purchase Price) falls in a certain range. The rule is: the transfer tax is $3.30 for every $1,000 of the purchase price. Essentially, a Purchase Price anywhere from $0-$999.99, the Transfer Tax field should be showing $3.30. If the Purchase Price is anywhere between $1,000-1,999.99, the Transfer Tax field should be showing $6.60. If the Purchase Price field is anywhere between $2,000-$2,999.99, then the Transfer Tax field should show $9.90. This continues for infinity. Ideally, I only need it for a purchase price going to about $100,000. In Salesforce.com, I would likely do this using something like the IF and QUANTITY logical and numeric functions. That said, I don’t think Airtable has the QUANTITY n

Hey everyone. I’m using this formula to calculate how many days it took for a response. DATETIME_DIFF({Response date},({Submission date}), ‘days’) & " days" I’d like to add a part to the logic that says if {Response date} is blank, calculate days between Submission date and today’s date. Any ideas?

Hi, all! I’m facing a challenge to do the following: Column A with multiple choices (All, Sheep, Goats… up to 12 more) Column B with multiple choices (Universal, Black, White) Column C with single choice (F, SE) Column D with multiple choices (3 months, 6 months, 9 months) Because I have more than 500 records I need a formula to do the same as filtering manually. May be the topic should be divided in two parts: I want to have a formula that can tell me if a certain combination for a record is “true”. If it is true, we can name it (All-Sheep-Black-F-3-months), then the formula displays the name of the combination (All-Sheep-Black-F-3-months). I found that in excel this could be done with ISNUMBER and FIND but Airtable doesn’t support ISNUMBER. The problem for me here is that I cannot use AND and OR in columns with multiple choices because it doesn’t work or I just can’t make it work. For combination All-Sheep-Universal-Black-F-3-months this is what I use: IF( AND( OR({Column A}=“All”,

Hello - I’m having trouble with IF and CONCATENATION formulas Here is what I’m trying to achieve: Concatenate “SUB SKU” - “PRODUCT NAME” If “SUB SKU” = Blank, concatenate “Parent SKU” - “PRODUCT NAME” I tried it this way but it’s not working. IF({SUB SKU}, CONCATENATE({Sub Sku},” – “,{Product Name}),IF({SUB SKU}=BLANK(),{Parent SKU},” – “,{Product Name}) Appreciate any help. Thanks!

Hi All: This is incredibly simple I think but want to verify. In my view, I’m just filtering out the entries that older. I’m using Created Time and when I choose any of the preset options (one day ago, one week ago, etc.), it all works fine. When I enter in a specific number of days though, nothing will appear in the view (but should). When using a specific number of days ago for a filter based on created time, do I need to have a separate calculation for day count and base the filter off of that?

Hello guys, I have this string : DECO > OBJET DECO > AUTRE OBJET DECO and I would like only : AUTRE OBJET DECO so only what is after the second >. I tried with : RIGHT( {Catégorie}, FIND( “>”, {Catégorie} ) -1 ) RESULT was " DECO" (The last 5 characters) I really don’t understand why only the last 5 characters.

once an Action is selected, it can’t be deleted. The only way to fix it is to delete everything and start over (keeping the Trigger alone is not much use). Hoping this is on the roadmap for urgently needed fixes.

Hello Community, When checking the API Doc, I can see Airtable is providing size and thumbnails dimensions for an Attachment Is it possible with a formula (not script) to pull properties from the first attachment? I tried several things like: Attachment[0].thumbnails.full.width … but didn’t succeed :confused: Regards.