Solved

Hello! I’m looking for a way to restrict a lookup to only the record with the max date in a date field. Context: Managing a vehicle fleet Bases: Registration VIN Desired outcome Only display the license plate that is associated with the registration record that has the max “license plate exp date” value. I’m not sure how to go about this. Seems like there may be a way to do so by creating a view in the registration base that only shows the records with the most recent restricting the lookup to that view but can’t figure out the first step there. Any help appreciated.

Hello! I am using airtable to coordinate events at a community space and I can’t figure out how to set up the front end with the survey for event booking requests that would go up on our website as the public portal to autofill into our back end. Right now I only have the back end spreadsheet aspect but want to survey portal for people to be able to request events space from the website. How do I set that up? Thank you!

Hi Everyone, I’ve been trying to script from the desktop Mac OS client. I believe it’s an electron app. Unfortunately, any time I try to open the scripting block, it just hangs there and continues showing the loading wheel. I can run scripts, but I cannot edit them, I only see the loading wheel. I saw this thread below: Scripting block does not work in Airtable Electron app Scripting app Running an example script from the Scripting block docs inside the Airtable Electron app (on Windows) generates an error. Running the same script in a browser view of Airtable (in my case: Firefox) works as expected. [Scripting Block Error] My issue is similar, but I don’t get an error at all. Any tips on how to fix this? Thank you!

Hi everyone! I am trying to create new Grids on my table but I noticed that when I input information for one city, all of what I typed pastes into every other Grid. I was looking around the FAQ and I found this article with the same question but no answers. How do I input specific information into only one grid? Thanks!

Hi, I have a rollup field (called “Lessons Included”) that won’t work in the following formula: IF(AND(FIND(“Math”, {Lessons Included}), {Submit Date}=BLANK()), “Math Pending”, IF({Submit Date} = BLANK(), “Math Not Included”, DATETIME_DIFF( {Materials Due}, {Submit Date}, ‘days’))) The FIND doesn’t work, and all fields where Submit Date is blank return Math Not Included, even if Math is part of the rollup field. Any ideas on a workaround for this? UPDATE: If I create a helper lookup column that includes ONLY “Math”, I can get the formula to work. However, with all the lesson types included, that would make my sheet much larger than it currently is.

Hi! I’m a beginner when it comes to Airtable and I want to sync or combine two of my different bases so that I have everything in one place. We have two separate brands that we promote on social media, but I’d like to have all of our content in one space. I’m currently using the free version of Airtable. I used the help article and got the information from one to the other, but when I go to the calendar view they’re still separate and I cannot see each of the posts I’ve planned for the different brands. I hope I’m explaining this well enough for someone to help. Basically, I want to see all posts in one calendar view. Let me know if anyone has a solution, I’d really appreciate it!

Hi, I have a conditional rollup where I am doing an Arrayunique of events that occurred in a specific Academic Year. If the array is empty (meaning, the event was not scheduled in said year), then I want the rollup field to say “Not Scheduled”. Is that possible? I currently am doing this by using the Rollup as a helper column, but would love it if I can do this all in one.

Hi, I have followed How to create email digests with automations – Airtable Support and all works fine except, how do I prevent the email going when no records are found i.e. the email should only go when the action in step 2 (Find records) has found records?

Hello there, I have been trying to send all records by email on the scheduled date. This automation works fine, but I want to send a nice grouped view (grouped by 1 field). Any idea how can this be done? What I want to send >> what is sends right now >> PS: I use the free version. Any help would be appreciated.

AirTable World - Need a formula that calculates or date / hr / min difference - Start date / time - end date / time

Hello, I am looking for a method/formula to calculate the total time allocated for products (for manufacturing) which have different components with pre-defined times. For instance, A product called “GS60” can be manufactured from one or mix of “RCBO+GPO”, “SA Meter”, “Modem” and so on. I have pre-defined time for each component such as “RCBO+GPO = 1h”, "SA Meter = 1:5h etc. Once I select the components from multiselect field, it should be calculated the total time for each product in “Total Time” field. Thanks

Hi all! I’m looking for a solution in a switch formula, with nested if functions. I want to calculate a percentage & addition based fee that changes based on the category input. Also with possible caveats on how that fee is calculated based on the price of the item. I’m hoping this is possible. Example: If Category=A, multiply by 12% If Category=B, multiply by 9%, then add .50 If Category=C, AND the price is <$15, ADD $2, OR if Category=C, AND the price is >$14.99, multiply by 20% Right now I have a separate table linked to include all this info, but I would love to set up a formula to calculate all of this within the main table. Thanks for the help!

Hi Airtable community ! I’m new to formulas, loving it but struggling a bit as well… I’m trying to automate a change in my records, from a phase of the process to the next, at a specific date using IF/AND. I created a fromnow field called “Calculation” and when it gets to 0 days, I would like to change my Phase en cours to the next phase. It looks like this : IF( AND( {Calculation} = “0 days”, {Phase en cours}= “Envol 2” ), “Accélération 3”, IF( AND( {Calculation} = “0 days”, {Phase en cours}= “Accélération 3” ), "Accélération 4”, IF( AND( {Calculation} = “0 days”, {Phase en cours}= “Accélération 4” ), “Propulsion 5”, IF( AND( {Calculation} = “0 days”, {Phase en cours}= “Propulsion 5” ), “Propulsion 6”, IF( AND( {Calculation} = “0 days”, {Phase en cours}= “Propulsion 6” ), “Coaching terminé”, ) ) ) ) ) It’s unfortunately not working and I can’t figure out why :frowning: (it says “Sorry, there was a problem creating this field. Invalid formula. Please check your formula text.”) Thanks

I’ve searched various threads for this answer and I’m still not sure if this is possible or not. I have Table 1 (let’s say) that has a formula field which constructs a url from another field and the record id. It looks like this With an automation I email this url (a form in another table - let’s sayTable 2) to potential respondents. Table 2 also has a field called “BD Link” which references Table 1. When a respondent submits the form, “BD Link” is never populated. Can someone point out what I’m doing incorrectly? Thanks!

Hi, Begginer here with formulas! I imported a lot of data into my database. In a column box, for example, I have up to 10 different data, all separated by semicolons. My goal is to multiselect them, but I was told that I had to substitute the semicolons for something else for it to work. I have tried the basic substitute formula, but clearly I am missing some information or understanding. Thank you very much for your help!

Hi. I use LinkedIn, and am interested in my SSI score (which LinkedIn automatically creates for you) - you can find it here: https://www.linkedin.com/sales/ssi. Basically, the more you use LinkedIn / engage with it, the better your SSI score. As you refresh this page every now and then, it shows you how your score has either gone up or gone down. So I wanted to create an Airtable web clipper so that I could capture my latest score whenever I visit the page, and write it to a table (so I can see a history of my SSI scores). I’ve set up a table to mimic all of the key fields on the SSI page, but am struggling to write the content (can’t find any good help online, and I’m not the most tech-savvy). I’m not sure how to set up the CSS selector to find the particular part of the page (the current SSI score - see screenshot). I’ve looked at the source behind the SSI webpage, and presume I’m trying to reference the ‘span’ entry? Can anyone help me to get this first field loaded (the curre

Objective: I want to return a number if a cell has a certain text in it and then multiply that number by another number to return a total value For example: If Content Type Column says TikTok then return number 30. However when I use the Switch function like this: SWITCH(({Select}), “UGC - TikTok”, “30”, “UGC - Review”, “25”, “UGC - How To”, “20” ) It shows a number but isn’t recognised as a number, therefore I am unable to multiply it against another column/variable to measure total cost. E.g. 30 * 5 (no of videos) = $150 [Content type cost] * [No of videos] = #ERROR! How to solve?

Hi all. I’d like an automation so when two columns show specific criteria (e.g. KNOWN CLIENT and PRODUCTS) this creates an entry in a third column with “PRODUCTS NEWSLETTER”. I’d then like a further column showing when “PRODUCTS NEWSLETTER” was added (i.e. last modified). I need this as it’ll run a Zapier automation and input the customer data into Mailchimp. I had successfully created an AND formula but this didn’t seem to link to a ‘last modified’. I’m trying automation but I don’t understand the steps. Can anyone help? Thanks so much.

Hey everyone, Is it possible to move a record from one base to another with an automation? My organization organized projects in their own bases and each task gets assigned an owner. Ideally, I would like to be able to use an automation that is triggered by a task/owner assignment and places the task in the owner’s own base in order to create a “to-do list” of tasks aggregated from different project bases. Thanks in advance for your reply!

I’m trying to update a base every 24 hours hitting a public API using remoteFetchAsync(). When I run the automation code below, I get this error: ERROR ReferenceError: remoteFetchAsync is not defined at on line 24 at main on line 9 The automation: //output.markdown ("# Updating BTC price"); let table = base.getTable ("Fetch"), records = await table.selectRecordsAsync (); //Check difficulty await Promise.all ( records.records.map (async record => { let stock = record.getCellValue ("Ticker"); if (! stock) { //output.text ("Can't update the price without Ticker"); return; } //output.text (`Updating Mining Difficulty of ${stock}...`); // make request to BTC.com var response = await remoteFetchAsync ( `https://chain.api.btc.com/v3/block/latest` ).then (r => r.json ()); // Parse by hand var data= response.data; var diff= data.difficulty;

Dear ones, I need help. I’m using a filter on another system that searches the result based on a certain date. If I inform the filter as follows. Date = “2021-06-25”, The expectation is that I would return all the rows that appear on this date, however filtering this way I have no return. If I use the Date filter >=“2021-06-25”. it works, but it brings me back not only the lines corresponding to that date but all the other dates ahead.

Hi folks I have two tables: One is called “Products” the other is called “Product Components”. As you can imagine there is a (1:N) link between them, so a Product can have multiple Components. A Component has a single Product. Here is what I am trying to do: I need to fetch all Components for a Product. I have a RecordQueryResults called “allComponents”. product.id contains the Product I’m searching for. Here is my code: let components = allComponents.records.filter(record => { (record.getCellValue(“Product”).map(x => x.id).includes(product.id)) }); After this, if I check components.length I will get zero. It is an empty array. I tried debugging using console.log inside my filter callback: let components = allComponents.records.filter(record => { console.log(record.getCellValue(“Product”).map(x => x.id).includes(product.id)); (record.getCellValue(“Product”).map(x => x.id).includes(product.id)) }); The results are: whenever a Product matches product.id I get TRUE; when it

Hi all. I have a base with 12 tables. I would like to create a table which will list links to all the other tables in the base, to ease navigation. I can get the View link but that opens up in a browser. Is there a way to create a link to a table that then goes to the referenced table within the desktop app? Thanks in advance. Shaun

so i was recently messing around with how to link records together and i accidentally clicked on Do Not Show again box. i use to be able to select the records i wanted by category. is there a way that i can restore the do not show again pop up?

I’m trying to send an reminder to email a record to a Slack channel when a Reminder Date is 14 days prior to current date. I’d like the Slack message to automatically populate the record’s name and email but I can’t see to get this to work.