Solved

I’m trying to figure out the difference (in percentage) between two numbers. I’d like to set up a formula that gives the percentage (positive or negative) difference between two numbers. So in the screenshot above Row 1: Percentage decrease from 100 to 50 Row 2: Percentage increase from 25 to 50 Row 3: No change between 50 to 50 My formula so far: -(({Starting #} - {End #})/{Starting #})

The piece I am really struggling with is the comma delimited split. This is the order as done in power query. Select entire tab/Table Source = Excel.CurrentWorkbook(){[Name=“Table1”]}[Content], #“Changed Type” = Table.TransformColumnTypes(Source,{{Many Columns/Fields}}), Select only the Columns/Fields #“Removed Other Columns” = Table.SelectColumns(#“Changed Type”,{“Key”, “ManyLinked”}), Remove empty cells/rows #“Filtered Rows” = Table.SelectRows(#“Removed Other Columns”, each ([ManyLinked] <> null)), Split the ManyLinked into one row for each comma delimitate value - each row gets the value from Key and a single value from ManyLinked #“Split Column by Delimiter” = Table.ExpandListColumn(Table.TransformColumns(Table.TransformColumnTypes(#“Filtered Rows”, {{“ManyLinked”, type text}}, “en-US”), {{“ManyLinked”, Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), “ManyLinked”), Thanks, Teri

Hi there, I have built an automation that will: Step 1: Trigger when a record is created in Table A Step 2: Find matching records based on a condition in Table B Step 3: Update a linked field on all matching records from Step 2 with the ID of the new record from Step 1 For Step 3 I have written a script as I understand the “update record” feature can’t handle multiple records. The script isn’t producing any errors however it isn’t working. It should update the field “Applicant Record” with the record ID from Table A - at the moment nothing is being added. Would you be able to help check if I’ve made a mistake with my code? Cheers!

I need to copy sets of data from Google sheets over to Airtable’s mulitselect field. I have successfully copied the Example A sets of data into a multiselect and it works. But for some reason Example B data copies only 1 set of data, not the entire data set. How can I achieve the same results as example A for example B. Example A contentIdComplete: 5ff7f3ea61d89c3d4f1a00f6,5ff7f40f4d6d0a37a3879004,601bdf764ac7ca3c4ae31211,601be02d58c9a36f26a0f9b8,60226b2bca657c6d5a43ccd1,60226d622a2f924017052bcc, Example B contentIdCompleteDate : 1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037, Watch the Loom video https://www.loom.com/share/825d9c899c7c4762817030d95def3ad1

For a casting agency db I need to set a personalized filter column I have a field with the age, now I need a formula column that gives me the segment :point_down:t2: AGE CALCULATED COLUMN < 15 kids => 15 & < 18. teenagers => 18 & < 31 young => 31 & < 45 mature => 45 older I’ve been trying to make an if then concatenated formula but I’m always getting errors. Any help? :pray:

Hey Guys, I’m looking for a (simple) automation that automatically deletes all empty records. My Airtable is being feeded with empty records due to a dirty API. So I need to run a script automation on schedule to clean up these blank records… I have zero experience writing scripts. I tried to use some older script from the airtable community but it does not have the most up to date syntax i guess – because it’s full of errors. Greets from Germany Pascal

Hello AirTable Community! I’ve been wracking my brain for hours now so thought I’d see if I could get some infusion of help from the group at large. Basically, I have a base with with a table called “Categories” in it that has 13 different product categories as the name field. I have a second table (in the same base) that has a full list of product names with their associated category. I would like to lookup from the “Categories” table and pull into one field all the product names that are in that category. This sounds weird ( I think? ) but it’s my current solution to an Airtable to Webflow collections sync so that I can have a category collection that still allows me to access product information, if that makes sense. I’ve been successful in linking the tables but this would require me to go through and individually select each item (like tagging?) which is cumbersome, ripe for error, and annoying because the second table will update relatively frequently with new product values

I’m attempting to use the the “Find Records” action as part of an automation designed to notify me when there are multiple records with the same description. The way I currently have it set up: Trigger: When Record field “Issue Description” is Updated Action: Find Records where “Issue Description” IS (also tried Contains) “Issue Description” from Step 1 [to identify if it’s the same description] The automation runs every time I update the field, but keeps returning result of 0 records found even though there are indeed other records with the same description. Not sure what I’m configuring wrong or need to fix to get this to work.

Is ‘loading’ a record the right concept. Up to now I’ve been using lines like: let record = await input.recordAsync("Who is Mum", view); and in my head this has then let me wokr with a chosen record. But now I want to ‘load’ a record from a ‘link to another record field’ and I suspect I’m missing a fundamental point somewhere: My code: let table = base.getTable("Characters") let deadMen = table.getView("Living Males") var deadMansRecord = await input.recordAsync("Who Died", deadMen); let theWiddow = deadMansRecord.getCellValue("Spouse") let theWiddowID = theWiddow[0].id console.log(theWiddow) console.log(theWiddowID) let widdowHome = theWiddow.getCellValueAsString("Nation of Birth") console(widdowHome) and the result when I run it for Albert. Why is my getCellValueAsString(“Nation of Birth”) not returning Germany? Reagrds Neil

Hi ! I have a calculated field that returns for me a value that looks like 2021 | Q3 or 2022 | Q1, determining the year and the quarter from a payment date. Now, in a linked table where this field (“Quarter”) is a lookup, I’m calling the RIGHT() function as follows : RIGHT(Quarter,2) in order to have as a result Q3 or Q1 as in the examples above. However, I get an ERROR! I believe it has to do with the fact that my “String” is a lookup but even if I create a field in the table, a function, that is basically “Quarter” (i.e. take the value that’s in the lookup) and call RIGHT() on that new field, I get an ERROR! too. I am deducting that RIGHT() cannot be called on a cell that’s a function ? True ? Any workaround ? Thank you !

Hello! Is there a way to sort tables and ignore articles? For example, if we are using a big list of movie or book titles with the words THE, AN, A before the title.

Hello, new to scripting, running into an issue on a single line as I hack my way through. Just trying to update script var “totes” to be 10 times the value recorded from the single select field “Pts this week”. So if “Pts this week” has a value of 7, the script var totes should be 70 after this line is what I am trying to accomplish. The line below gives me NAN so I’m doing something wrong on this particular line. If I am not mistaken, NUMBER() should do the trick as the single select value of 7 will be a string if taken as is. Anyway, here is the line. Any help is appreciated. totes = 10 * Number(record.getCellValue("Pts this week")); Thanks in advance

Dear all, i am looking for a solution for the following problem: “Column A” is a multiple select field where I have data on company presence in a variety of countries (e.g. “Poland”, “China”, “Germany”) “Column B” should have a formula that checks whether “Column A” contains an entry (among others) that belongs to a specific list (e.g. “Poland” or "Germany). In this case the formula should return “Europe” I am not sure, whether this problem should be solved with IF, nested IF, SWITCH formulas or whether I need a completely different approach Thanks for any input, Cheers

I’m trying to add a column into my financial forecast that shows whether Column A + Column B = Column C. If the value in Column C doesn’t match I’d like it to show me that it’s incorrect. The formula I have so far is below but I can’t get around the error. Can anyone tell me what I’m doing wrong? IF({Revenue Recognised in FY22}+{Year Recognised To Date}={Contract Value},“MATCH”,IF({Revenue Recognised in FY22}+{Year Recognised To Date}>{Contract Value},“INCORRECT”,IF({Revenue Recognised in FY22}+{Year Recognised To Date}<{Contract Value},"INCORRECT”))) Any advice is appreciated! Thanks

I’m really struggling on working out how to create a formula for the above. For context, I have an AirBNB type operation whereby there is a check in + check out date for guests who stay which can sometimes be as long as a few weeks. I’m trying to figure out the best way to work out if a specific day falls between 2 dates so I can group data based on events & also calculate occupancy in a given month or event based on a property (e.g. if there’s a major event in a city on the 10th of February & there’s a checkin on 8th February & checkout on the 11th February, how to have that filter in as an “event booking”). Alternatively, with the same logic, if I want to separate “weekend bookings” from “midweek booking”, I’m happy to have a separate table where I manually input every weekend/event. Would greatly appreciate any ideas anyone might have on how to solve it

I have a scripting app that will post to a Discord channel hooked up to a button field. Works fine if I use it in my logged in Airtable environment, even in a Gallery view. However, when I share that same Gallery view outside of my logged in environment, the scripting app button shows as disabled. I didn’t have this problem when it was a URL button instead. I can’t find any documentation on this or anyone else having this issue. Thanks for any ideas or insights!

I have a form for a Contacts table that collects specific data. I have another table for Leads that I need to pull this data into. I already have it linked and that works fine. The problem lies when the form is submitted. I would like a way to auto-match this data. For example, the Contacts Table contains an “email address” field. The Leads table is set up to pull the Contact info from the new record into different sort options. As it stands right now, I have to go in and manually link the contact info. I thought that by adding an email address field into the Leads table I could somehow auto-match it. Any ideas? Thank you.

I would like to achieve the following: Multiply all the quantities inside Part List Output (2x, 8x, etc) by the Quantity value. So in the first row in the example provided I want to multiply all of the integers in the comma-separated strings by 6. I’ve mocked up a demo output in Calculated Part List. One complication to note - the strings can also contain integers that I do not want to target for calculations, eg. 1x Shelf 812mm. I can easily manipulate the Part List Output if necessary. For example, wrap in special characters: _2_ Large T Side with Holes, _2_ Large A Side, _1_ Large Base, _8_ Spring Clips Perhaps @ScottWorld has managed this?

Hello community - I’m a week on form ‘Hello World’ as far as scripting (and coding in general) is concerned so apologies if this is basic - one of my issues is knowing correct terms and without them it’s hard to search for answers. I’m creating a script app that adds a record to a table called ‘Characters’. The new record will incorporate some info from other records on the same table so to feel my way I’ve done: dynastyNow = record.getCellValueAsString(“Dynasty”) motherNow = record.getCellValueAsString(“Name”) fatherNow = record.getCellValue(“Spouse”) countryNow = record.getCellValueAsString(“Country”) output.text(dynastyNow) output.text(motherNow) output.text(fatherNow) output.text(countryNow) It all works as expected except fatherNow - which returns: nothing if I use getCellValueAsString and ‘null’ if I use getCellValue. It must be because the spouse field is a linked record field (the others are either single selects or single line texts- how do I interogate the linked record to pr

Hi, I am trying to build a formula to properly calculate the cost for an order whose input is a multi-select field of products. I did my best to follow these recommendations: https://support.airtable.com/hc/en-us/articles/218734758-Airtable-s-guide-to-many-to-many-relationships Calculate Multiple Select Values - #3 by Will_Bailey1 The tables are Products, Orders, and Line Items. The Products Table (includes lookup to the Line Items Table). The Orders Table (includes lookup to a Companies Table (not pictured)) The Line Items Table (includes lookup to the Products Table) I don’t know how to create the field for Total Cost in the Line Items Table to be able to calculate total cost dependent upon which products are linked. On the front end a user would select which products they wish to include in their order. Any pointers or reference to existing community content would be appreciated. Thanks!

Hello, I have a Jotform survey flowing into my base per each response. In the survey, I have multiple “Check all the apply questions” that subsequently flow into multiple-select fields in Airtable. I am trying to connect a data visualization program to Airtable to visualize these responses, but the connect combines the row into a single string (i.e. “Option 1, Option 3”), which makes it difficult to visualize. Is there a way to have a field that puts a 1 if a selection is made, or a zero if not. I am trying to avoid making separate tables with available options, since my base already has a lot of tables (this is a big project). What I initially have: What I’m trying to achieve:

So new to this and posted some code in another thread - its’ been pointed out to me functions would save some repeats in my coding and make them easier to read and correct. But I’m missing a subtly - the let instruction within my function results in this error - yet the same instruction (commented out in the screenshot) seems to work just fine - what am I not grasping?

Hi there, I have a rollup field - Field A - which displays items in an array using a comma separator. I retrieve the items using ARRAYUNIQUE(values). When I try and call this field in another field - Field B, this formula keeps the comma separator: {Field A} Produces: 1, 2, 3 When I try and add text to the formula, the commas are lost and the values aren’t separated but bunch into one long block of text: {Field A) & " Text" Produces: 123 Text Would anyone be able to help? How can I add the commas/separators back in between these values?

Hi!. I have built an automation that sends an onboarding email (in Outlook) to new customers who have signed up for my free 30-day trial. I would like to attach our Quick Start Guide (a .pdf) to each email. I would not like to have to attach the .pdf to each record individually. I have found some pages in the help guides that talk about this but they might as well have been written in Greek.(https://support.airtable.com/hc/en-us/articles/360051028394-Send-an-email-Action ) I’m very experienced building workflows in Airtable, but can’t code worth a darn. Can someone boil the steps down for me? Thanks.

I know we can upload links to URLs but is there a way to store/play the actual video clips in Airtable? Thank you!