Solved

I want to provide a workaround solution given that Airtable natively cannot do much with the change log, and I want to create a column that would update another column (within the same table) every 1 or 2 days. For example, something like the below: Column B = IF( Last Modified Date < Today - 1, = Column A, IF FALSE DO NOTHING). Through this I am hoping that even though Column A is continually changed, I can see the previous value of Column A via Column B. Thank you in advance, and please let me know if I should explain further.

Hi! I’m going crazy trying to come up with an NPS formula. I am planning to have a formula return -100, 0, or 100 depending on the value so I can then average that column on dashboards. I can get my NPS just fine, but I can’t figure out how to exclude blank cells in an IF statement. In words, I want the following: If {Program NPS Value} is between 0 (inclusive) and 6 (inclusive), -100 If {Program NPS Value} is 7 or 8, 0 If {Program NPS Value} is 9 or 10, 100 If {Program NPS Value} is BLANK, “” There’s gotta be a way to factor out these blank cells. I’m getting -100s for all my blank cells with this formula: IF({NPS Value} < 7, -100, IF({NPS Value} > 8,100,0)) I appreciate your help!!

Airtable Not Working by anyone?

Hi there, Im looking for a bit of help with a formula. I’ll try and explain it as best I can… I have six fields as follows: 1st Payment Date (date type) (e.g 1st Jan 2020) 1st Payment Amount (Currency) (e.g £500) 2nd Payment Date (date type) (e.g 3rd Jan 2020) 2nd Payment Amount (Currency) (e.g £500) 3rd Payment Date (date type) (e.g 5th Jan 2020) 3rd Payment Amount (Currency) (e.g £500) What I would like to do is create another field with a formula that would basically sum all the payment dates which fit within a specific date range (an example date range relating to the fields above would be the 1st to the 31st Jan 2020) Would anyone be able to help with this? Thanks in advance!

Under “collaborators”, I am shown as the owner along with the message “This workspace also has 1 base collaborator not represented above”. No other collaborators are shown. How do I find out who is this other (hidden) base collaborator?

I have a bunch of different strings of text and want to remove different phrases, but I’m unsure of the formula. Here is an example of what it may contain: 123.jpg 234.eps 345.ai 546%20(1).eps I want to remove every instance of “.jpg”, “.eps”, “.ai” and “%20(1)” Is there a way to do so?

I am trying to use an IF statement and I can’t get it to work either with an AND or an OR formula (or both)… Essentially I have a calculated price for my products and I want to create a formula field for a selection of the products IF ‘Sub-Category = X OR Y’ then take ‘Calculated Price +0.1’ to add 10p to the calculated price. I have tried this which returns a result for all products and not just those where the Sub-Category is “Coffee Retail Beans” or “Coffee Retail Ground”. IF(OR({Sub-Category}=“Coffee Retail Beans”, “Coffee Retail Ground”), {Calc Price}+0.1) Any other combos I try using AND statements where I have followed other similar examples on different threads, but they always come back with a formula error. Basically I have a list of wholesale and retail products each with a calculated price and for customers who only buy retail I want to add 10p to their price, but I want this to only apply to products with a retail ‘sub-category’. If the ‘sub-category’ isn’t a retail one th

Hi. I’m currently wondering if there is a way to extract a section of text from a URL. http://...Drink%2FSeafood%20%2D%20shutterstock_524277715%2Ejpg&...Images%2FFood%20%26%20Drink I want to Airtable to automate searching the link for “shutterstock_” and then display the following characters up to “%2E” The link will always have a different amount of characters before “shutterstock_” and after “%2E” and may contain a different length of characters between the two. Is there a formula for something like this?

I need Airtable to send me an email if the record was last updated 3 days ago and the status is high. Can I create this automation ?

So I was recommended airtable to manage my office staff task. So seems promising. I get the demo, got busy and never used it. Today i jump to pro all because i can color code things and mostly will be used for simple task management and minor project collaboration. So i delete the workspace that was originally their and create and label new ones that now say free. So now I am assuming you pay by workspace and not to just use the program. So the one i deleted is the pro on and is now gone. Airtable has no phone support and i am assuming they rely on their community of paying users to provide their support. How do I get my money back, remove my credit card info and delete my account?

Currently I can only synch one table into the output table. How can i make it work for multiple data tables into one table ? I’m following this article : https://support.airtable.com/hc/en-us/articles/360052521254-Airtable-Sync-Basic-setup#:~:text=Using%20Airtable%20Sync%2C%20you%20can,you%20have%20creator%20permissions%20to.

hi everyone, is there a formula that can compare 2 dates (a due date and the completion date of a project) and fill in if it was finished on time, early or late?

When inserting an image to attachment field, is there a way to link a url reference? I am creating a base that features mythological creatures. One field has images. I need to be able to credit an artist or website for the images used. I considered adding a record to the table, but many of the attachment fields will have more than 1 image. Creating 3 or 4 fields to add a reference to each of the images in the record seems daunting. I had poor luck searching for this answer as the word “reference” in my meaning (to credit the original location item was found) is different then the common airtable usages. I hope I used correct terminology with records/fields ect. I’m not confident in speaking this subject.

I need to add an additional carriage return within this formula where the red maple leaf is in the below formula. I’ve tried multiple different ways but I’m unable to find success. If anyone has any solutions would be most appreciative!!! CONCATENATE(Patient, “\n”, DATETIME_FORMAT(SET_TIMEZONE({Start Date}, ‘America/New_York’), ‘LT - dddd :maple_leaf: MMM DD/YYYY’))

Hello I’m new to AT, so I’m just feeling my way. I have a base recording bookings we get from schools who want to visit us. I send a school who wants to come to us a link to a booking form view that they fill in themselves to create a new booking record initially. Once they have done that we add bits and pieces of data behind the scenes. One of the things we need to do is book staff against the school booking, but that is something someone else takes care of. Previously I would have manually completed a form in Word and mailed it to my colleague as a prompt to book staff, but I am hoping Airtable can make this process unnecessary. I would like to be able to have myself and my colleague automatically emailed when we get a new booking added by a school via the form, to prompt her to look at the staffing requirements. She is the owner of the workspace the base is in, but can I add her as a collaborator to every record in this base automatically and have AT ping us both an email to say ‘a

Hello everyone, I would like to have a formula column in a table where I have a code name as the first column today. This formula should check the code and give me a determinated result. Today my codes are SFPAPXXXXRI004, or SFPAPXXXXBA005. I would like a column that says “Ring” if there is an “RI” on the code or “Bracelet” when there is a “BA” and so on. Is this possible. Many thanks for your help!

Hi all, I’ve been using Airtable as an employee for the last few months but only recently have started building some tables on my own, and I’m running into a hurdle that I think either has an incredibly simple answer or just requires a different approach. After going through forums for hours, I figured posting might be the quickest way to find a solution. This will be a musician related database, and I have two tables - ‘Owners/Writers’ to keep records of artists: And ‘Songs’ to house the information for each song they might be a part of: As you can see, each song may have multiple writers. I want to create a column in the ‘Owners/Writers’ table that shows every song that each writer may be a part of; for instance, Ben Allen is a writer on both of the example songs, Song 1 and Song 2, and I’d like those records to be displayed in the ‘Owners/Writers’ table. The problem is when I create a linked record in the ‘Owners/Writers’ table to the ‘Songs’ table, it doesn’t automatically popula

Hello everybody! Sorry if the question is too basic, I’m new to airtable… I’m trying to keep the wine inventory of my restaurant in airtable, and use a shared grid view to show the wine menu. During Covid situation we cannot use paper menus and we have a QR code so client use its own phone to read it. I have all items sorted by wine type using groups, then price… it works great. The question is: can I add the group name in top of the item list? The list is quite long and non-expert clients will get lost (they are using a smartphone to read). It would be great to have something like: White wines: xxxx xxxx xxxx Red wines: xxx xxx “White wines” and “Red wines” are coming from a single select field which I use to group them. Any comments or recommendations will be very much appreciated. Thank you very much and keep safe!! Angel

We have a field called Products which is a link to our “Product” table We have a field called Cost which is a lookup field. (looks up the cost from the Product table) In our “ORDER” table, we have a field called Total Cost In that Total Cost field we would like to multiply the Cost by the Qty (quantity) but if there is a value in the Misc Cost field then we would like to multiply that field by the Qty to calculate the Total Cost Here’s the kicker… Basically, we want to use the Misc Cost to override the Cost x Qty total, if there if something is entered in that field. Usually a product is full price for us. Sometimes we get a massive discount on a certain quantity or we get some of a product for free. I still want to link to the existing product from our database, but I want to have this Override field and have my “Total Cost” field use the Misc Cost field, if it’s exists. Sorry if I didn’t explain this very well. Any help here would be great!! :pray:

Hello! From the documentation for the Airtable API, it clearly indicates that there is a rate limit of 5 transactions per second. With the current implementation of our updateRecordAsync for Airtable, we are seeing no (noticible) rate limits. Are Custom Apps not currently subjected to such limits? If not, will it be? Thanks! Sharon

I am trying to create a priority score for a team travel destination based on a series of checkboxes. This is what I tried: SUM(IF({1 Must Do}5,0),(IF({2 high on list}4,0),(IF({3 would like to do}3,0),(IF({4 maybe if in the area}2,0)) This isn’t being accepted. Any help appreciated.

Hello guys, I have an Airtable managing my bills in multiple currencies. I’ve been trying to customize the [Airtable Currency Converter] (Airtable Scripting) to convert each record with the conversation rate of its date. I want it to be automated given that I have 5,000 records of bills. I suspect my syntax is wrong, but maybe the logic of my code is completely wrong too. My code is the following : // load table and records let table = base.getTable("Table 1"); let result = await table.selectRecordsAsync(); // launch a 'for' loop to fetch conversation rate then update each record depending on value of "Date" field for (let record of result.records) { await // fetching exchange rate let apiResponse = await fetch(`https://api.exchangeratesapi.io/${record.getCellValue("Date")}?base=EUR`); let data = await apiResponse.json(); let conversionRate = data.rates.GBP; // updating the record table.updateRecordAsync(record, { 'Exchange rate': convers

Hello- I have a formula field that multiples values from two other rows. It functions properly when multiplying values without decimal points, e.g., 1, 2, 3, 4, etc. But fails to account for values with decimal points, e.g., 1.5, 2.5, 3.5. The odd thing is that for those values (the ones with decimal points), it actually accounts for the numeric portion of the values without the decimal value. Specifically, for 1.5 or 2.5, it will multiply based on 1 or 2, respectively. It ignores that there is a .5 tacked on as well… Here is the formula: IF({Mins}=15,".5",IF({Mins}=30,“1”,IF({Mins}=45,“1.5”,IF({Mins}=60,“2”,IF({Mins}=75,“2.5”,IF({Mins}=90,“3”,IF({Mins}=105,“3.5”,IF({Mins}=120,“4”," ")))))))) Not sure if this is helpful, but when I click on the “formatting” tab within the field, here is the response: “Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.” Thanks in advance!

I have a base in Airtable already set up that has several tables. One of the tables is my “Contacts” table. I have some additional contacts in some other places and I wanted to import them into this ‘Contacts’ table. So I imported a spreadsheet from a CSV file. The problem is that when I imported the spreadsheet it showed up in my base as ANOTHER table called ‘Imported Table’. Now, I can’t figure out how to add the contacts from my ‘Imported Table’ table into my contacts table. What I am missing here?? #AirtableLoser

Hey, I’m trying to add an attachment to my action email in response to a trigger. The attachment is PDF or PNG and is in an Attachment field. But every time I run a test, it gives me test error: Step failed. Failed to construct the value for “Attachments”. How do I get it to read the value? Your help is appreciated.