Solved

Hello the community ! I have a table with a date field. I have a formula which is : IF(IS_AFTER(TODAY(),{Date}), ‘Published :rocket: ’, ‘To publish :hourglass_flowing_sand: ’) And it’s working fine. Now, I have 3 différent dates for 1 record. So I have a 3 date fields : ‘Date1’, ‘Date2’ and ‘Date3’ What are the formula for “If Date1 or Date2 or Date3 are not empty, then ‘Published :rocket: ’, ‘To publish :hourglass_flowing_sand: ’” ? Sorry for my english… Thank you very much !

Hello Airtable community… I currently have two columns User Name User Fact Item 1, User Fact Item 2, User Detail User Detail Item 1, User Detail Item 2 I need a formula that creates an array with rich text formatting that merges the two columns to create this At the moment I’m using {UserFacts} & “\n” & {Facts Detail} Which is doing this User Fact Item 1, User Fact Item 2, User Detail Item 1, User Detail Item 2 But I want this User Fact Item 1 Item 1 User Fact Item 2 Item 2 Would you be able to help or give me a pointer? Thank you

Hi there, I’m using tags in a table to create groups for records e.g. ‘homepage’ , ‘landingpage’ ‘checkout’ . In a one to many relationships. So, for instance, I have a table that has Observations | Tags record 1 | Homepage record 2 | Homepage record 3 | Landing page Then in another table I’m seeing Insight | Observations | tags Name | record1, record, 2 | Homepage, Homepage What I want is it to do Insight | Observations | tags Name | record1, record, 2 | Homepage When I do a lookup on the tags on a separate table. What I see is a record with the same tag repeated several times as it is linked to several other records. How can I make it only display an associated tag once rather than for every instance?

I’ve been having tons of fun learning how to handle DATETIME and IF() and SWITCH(), but I can’t figure this one out. I am measuring the difference in weeks between two calculated dates, and that bit is OK, but I want to replace all of the weeks in the past with an emoji. Picture added for the 1000 words I could otherwise use…! I’ve tried using an IF statement but can’t quite figure out which part of the existing statement is IF-able! Any pointers on that or should I be looking at another function for the formula? Cheers and thanks

How can link a column to a new table?

I can’t find the way to format properly to date a rollup field. The formatting tab return that it’s not a date field. I have that : 2020-10-05T00:00:00.000Z and I want just that : 2020-10-05 Yet, the field rolled up is a date and the aggragation formula is ARRAYUNIQUE(values) Thanks in advance

I would like to remove the following special characters on the “project name” ~ ` ! @ # $ % & * ; : ? . , ’ " UPPER(CONCATENATE(Language, “-”, Team, “-”, SUBSTITUTE({Project Name}, " ", “”), “-”, {Date Added to Airtable})) Can someone help me :pray: Thanks

I’m trying to create a template for a source bibliography that would include punctuation in the formula. I have multiple fields that will eventually be combined. Can someone tell me why I’m getting an X in Column 1, Row 3, when Column 3, Row 3 is blank? I would have expected that field to be blank. Here’s my records Here’s my formula Thank you, Stacey

Hi all. Sure this is super simple and I’m no doubt being super simple myself in not getting the solution… I have a sheet where I am keeping track on recurring charges. I’m dealing with 3 specific columns in this sheet Col 1 [$ Charge] Col 2 [currency selection…eg AUD, USD, GBP etc) Col 3 [$AUD Charge] Ultimately for each line item I add, I want all charges to be converted to AUD (this would be COL3) and from there I can run further calculation based on this number. So I’m assuming the formulas for column 3 would be: If “Currency” is “AUD” then display the value already entered in “$ Charge”. And… If “Currency” is “USD” then multiply by “<FX rate that I’ll input>” then display the calculation as a “$ value” I’m just not sure how I would write those formulas in Airtable? Possible? Thanks so much Ian

I’ve built a news publishing Airtable and I want to be able to link to my articles table when clicking on a cell, and only have articles that do not have a status of “Slotted” to be available.

Hello there! I was trying to create an filter that acts like this SQL: SELECT * FROM table t WHERE t.Status = “Pending” AND t.Name == “Robert” AND … (and so on…). How can I translate that to Airtable Filter By Formula in the API? I just want to return the records that match those conditions. Using airtable.js to do it.

I’m using the API to update an Airtable table on a daily basis. Everyday I’d get around 100 records to be updates or created on the table. What’s the best way to tell Airtable to either update the record if a specific field matches a record which already exists otherwise create a new one? Do I need to perform a search for each one of the records manually or is there a better way to do that? Thanks!

I have started using views more to fully customize how I view my tasks in Airtable. Is there a way to change the default view from the Main View to one of the other views I have created?

I’ve got a datetime field called Start time (UTC) I want to take the time component and reformat the minutes into a fraction. For example: Source Desired output 14:00 14 14:15 14.25 14:30 14.5 14:55 14.92 I have tried taking the minute component and conditionally dividing it by 60 to at least get started (before I sort out rounding etc), but I just get #ERROR. Here’s my formula: IF(DATETIME_FORMAT({Start time (UTC)},'m')=0,"",(DATETIME_FORMAT({Start time (UTC)},'m')/60))

I need a field to add 10% to the previous totals column and then another field that adds 20% to the previous, my experience in formulas is basic +,-,x & divide, and I cannot find the simple solution yet, please help

Is there a way to change the Field that is displayed in the Calendar View? I would prefer to select another Field/s, not the default ID Field only. Also, how can I change the order of the Fields in the Calendar View? Also, how do I select which Fields are hidden or not?

I upgraded my account to Pro, but my forms aren’t giving me access to Pro features. Help!

Can I format the date to DDMMYY using CREATED_TIME() The default format is 2015-11-11T22:18:17, how can I change it to DDMMYY (no spacing between dates) Thanks

I’m seeing this error today in my custom block, but don’t think that I’ve changed anything dramatically in my code. Can someone tell me the fix? Thanks.

is it possible to remove spacing between words using formula

Hello, forgive my English, I’m Brazilian and I’m having difficulties with the use of the IF command. First, I have 5 different dates, which I will use as a review in the studies, and I needed to compare all these dates at once with the current day, so if date 1 is less than today, date 1 would return to me, if it were bigger i would return date 2, however, if date 2 was smaller, i would return date 3, and so on. Does anyone have any idea how to do this? !

Hello, I’m trying to make a formula that automatically copies the first/top option of a multi-select field to the primary field of that record. Is this possible? Any help is much appreciated, Frank

Hello, I would like to embed a gallery view of images on my website but only want the viewer to see/have access to the thumbnails on the cards and not the original images. Presently, the viewer can click on the card and then click on the image (which is listed under “1 hidden field”). Is there a way to to remove the hidden field or modify the iframe to keep the viewer from clicking on/opening up the records all together? I would like to keep card filtering/sorting activated. Any help is much appreciated, Frank

How can I hide the personal information shown to others completing our form? All the personal fields are hidden from the grid view. As you can see when using the linked field in the form it has these details visible. We obviously do not want to share salary, personal phone numbers, etc to all using the form. Is there another way to have the person filling out the form only see the names, which we are trying to link? This is an example to our base - there is a daily growing field, currently at 600, to search through.

Hello, I’m new to Airtable and I seem not be able to understand how to play with it, that’s why I’m asking for some help. I built an app for scavenger hunt where the user needs to find some QR Codes around the area. Once found the QR code, they scan it with the app and get some points according to the difficulty. The app sends and stores immediately the points from a specific user as in one columns I have all users which scans the codes and the other with the points they collected. Something like: Admin - 30 Admin - 10 User1 - 30 User2 - 10 Admin - 30 User2 - 10 User2 - 10 User1 - 10 What I would like to know is: -How can I sum up the points done from each user so that I can have some kind of result list? My idea is to have something like: Admin 70 points User1 40 points User2 30 points Any help is really appreciated. :slightly_smiling_face: