Solved

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.

I have a field named Echeance that has date of the deadline for each project I have a field named Statut which referres to the project status (to do, done etc…) I want if the current date > Echeance and the status is “A faire” then update the cell to “En retard”, which means late. let action = base.getTable('Action'); let tache = await action.selectRecordsAsync(); let aujourdhui = new Date(); // Date of today for (let ligne of tache.records){ let statut = ligne.getCellValue("Statut"); let echeance = ligne.getCellValue("Echéance"); let dateEcheance = new Date(echeance); if (dateEcheance < aujourdhui && statut["name"] == "A faire"){ await action.updateRecordAsync(ligne, { 'Statut': "En retard", // Here is the problem }); } }```

I’m still pretty new to Airtable, and I’ve searched for this info to no avail. I’m trying to understand the core reason(s) for using multiple workspaces. In our business, we have multiple clients with very different setups and data. I need to be sure those streams don’t cross. If we can share the bases within the workspace without granting access to everything, is there a reason why I couldn’t use one workspace and build out a base for each client?

I would like to use autofill. I am following this tutorial video. (originally post in this URL) How to create a running total or balance Apps Hey, I got the same question from my client, so I created a video tutorial: How to show a Running total on Airtable? (6:40 min) Here is the link to the base used in the tutorial. Hope it helps! Noam [Thumbnail-Running-Total] time 4:23, pop up window shows “PERFORM PASTE”, Unfortunately, in my case, there are no pop up massage. How can I use this autofill command?

Hey, can anyone tell me if features available to upgraded users (Plus, Pro, etc.) will be visible to non-upgraded users in a certain workspace? For example, If a certain base contains Gantt charts, a pro feature, will a “free” user who the base is shared with be able to see or interact with the gantt chart? Thank you in advance for your help!

Hello everyone, Tinkering with my garden automations and I have seasons on my mind. There’s a couple of items I’m working on and thinking about, and figured I may as well post my questions here to help advance my Airtable skills. Firstly, spending time with a Switch statement, is it possible to stack cases? For example; SWITCH(Month{Date} ,1,"Summer" ,2,"Autumn" ,3,'Autumn' ,4,'Autumn' ,5,'Winter' ,6,'Winter' ,7,'Winter' ,8,'Spring' ,9,'Spring' ,10,'Spring' ,11,'Summer' ,12,'Summer') SWITCH(Month{Date} ,[1,2,12],"Summer" ,[3,4,5],"Autumn" ,[6,7,8],'Winter' ,[9,10,11],'Spring') And what are peoples thoughts on having rolling seasons within a recurring calendar? Not too sure about this one though, trying to map it out still, so perhaps it’s more of a base design question. :thinking: DATETIME_PARSE(DATETIME_FORMAT({Recurring Date},'MM/DD')&"/"&YEAR(NOW()))

I am looking at to build a system which will allow me to keep track of the walkthrough I do with my teachers as a school principal. I have one tab with all the teachers, one tab with all the standards we are looking at. My goal is when I start a walkthrough would be to: Select the teacher Upload medias Add notes in 3 boxes: description fo the observation, area of strengths, suggestions Rate the selected standards (probably 5 maximum for one walkthrough), and add a note next to the rating What would be the best way to design this ? My issue is on the standard as for ONE ENTRY (one walkthrough for one teacher), I can see how to deal with the medias and the three notes, however I don’t see how I can select the standards I want to rate and rate them. If you have done think kind of design or you know a template that could inspire me, I would love to see it.