Solved

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:

Hi all,Are there any other London-based Airtable fanatics that would be interested in a meetup organised in London? I’m thinking something around a Show & Tell format where people can grab 10 minutes to run through a base they’re proud of.Let me know if there’s any interest! UpdateJoin the Airtable London Meetup Group on Meetup

My base is for keeping track of genealogy research projects. The Main Table is a list of projects that links to a People Table and a Timeline Table People Table: Has columns for First, Last and Middle name. Has a column that concatenates to list the Full Name and the Primary record field Timeline Table Each record is linked to a project from the Main table and a person. The same person can be linked to multiple timeline records Has a lookup column to display the Full Name field from the People Table Main Table Lookup pulls the Full Name from the Timeline Table and repeats it since a person can be linked to multiple records in the Time Line I want to create a new column in the Main Table that lists the Full Name only once. Something like this: List the first name in the list, if the second one is identical, then don’t list it, etc. through the list of names in the lookup column. I’ve really had good luck finding formulas for what I want to do by searching the forum, but not having lu

I love Airtable, and was using it at work and home, basically co-mingling the two sets of data. Some are owned by me (work) and some by me (home). The work bases are shared with personal me. Unfortunately, I was laid off and now I’m wondering if, when the license needs to be renewed, the collaborators will be eliminated (since that base won’t get paid for). I hope this question makes sense.

Hi everybody, I’m struggling to find the right code for my formula. I’m making a content calender in airtable. I made a text field “text input” and I made an attachement field “image”. My goal is to have a field that tells me the status of the content. What I’m looking for is a formula that kinda goes like this: IF {text input} is empty then: “ :bell: write text” IF {image} is empty then: “ :bell: upload image” IF {text input} and {image} are empty then: " :bell: :bell: write text, upload image" IF {text input} and {image} are not empty then: " :white_check_mark: Ready to go" Can anybody help me how to get the right formula? Also… (to make things interesting) I was wondering if there’s a way to add a “deadline” feature to the same formula. My question is: is it be possible to add something like this too: IF {text input} or {image} is empty, and {deadline} is within 2 days, then “ :rotating_light: HURRY” Hopefully someone can help me out with this. Thank you guys so much for yo

I would like to pull the value from a single select to use in a formula. For example, i have an opportunity that has a set value as well as a set of percentage of realization. I would like to multiply these two values to get a weighted value. See below for full example: Project X has a $100,000 opportunity value, with a 70% chance of winning. The weighted value would be $70,000 ($100,000 x 0.70).

Still learning about Airtable, so I may be missing a built-in solution, but in case I’m not here’s my problem I hope someone can help me with: I’m helping a small business that’s switched to making sewn masks (originally a sewing school), so I’ve built a base that tracks {Orders}, {Inventory}, {Customers}, and {Mask Styles}. A common question from customers is when their mask will be done and ready for pickup. It takes about 1 hour to make each mask and the work days are minimum 8 hours every day (even weekends). Based on the number of unfinished masks currently in the queue, I want the number of days and/or the date everything currently in the queue would be finished to be calculated & displayed automatically. The {Inventory} table is Kanban-like, so among others has a Single select field showing what {Stage} of completion the mask is at: ‘Planning’, ‘Fabric Chosen/Cut’, ‘Sewing’, and ‘Done!’. I just want to count masks that are not ‘Done!’ - let’s call it “totalWIP” - divide by 8

Hi, I’m using a lookup field which aggregates a list of single selects (containing values like : “Yes”, “No”). Within the lookup fields, I’m using the formula : ARRAYJOIN(values) It works great. Then I have a formula field with a FIND() : FIND("Yes", {my lookup colomn}) The result I get with this formula is way below the amount I am supposed to get. About 3 times lower. Even stranger, if I change the lookup formula to ARRAYJOIN(values, ', '), I get yet a different number. What gives? Thanks for your help!

Hello Airtablers! For my CRM I’m trying to automate the ranking of my prospects from “ :fire: Flaming hot” to " :skull: Dead". I tried using a SWITCH formula but got in difficulties, so I reverted to IF and DATETIME_DIFF. I want to switch between the 6 values below and though I managed an IF statement with just 2 values, when I try 6 (and DATETIME_DIFF) I get no-where (I even checked for curly brackets, straight quote marks and the number or parentheses)! Can you help? I tried the following: IF({Last Contact}=TODAY(),"🔥 Hot!", IF((DATETIME_DIFF{Last Contact},TODAY(),'days')>3,"🌡 Warm", IF((DATETIME_DIFF{Last Contact},TODAY(),'days')>7,"😎 Chilled", IF((DATETIME_DIFF{Last Contact},TODAY(),'days')>21,"🚰 Tepid", IF((DATETIME_DIFF{Last Contact},TODAY(),'days')<90,"🥶 Cold", "💀 Dead!") ) ) ) ) Thanks in advance!

Hi! I have a formula that works awesomly to calculate international age (see below). IF( {🆔 Birthday}=BLANK(), ' (N/A)', IF( {🆔 Death}=BLANK(), IF({🆔 Birthday},' ('&DATETIME_DIFF(TODAY(), {🆔 Birthday}, 'years')&')'), IF({🆔 Birthday},' (✟ '&DATETIME_DIFF({🆔 Death}, {🆔 Birthday}, 'years')&')') ) ) { :id: Birthday} is a date field. I’ve been trying to adapt this formula to calculate Korean age. I would need it to do something like IF({🆔 Birthday},IS_BEFORE(TODAY(),DATETIME_FORMAT({🆔 Birthday}, 'MMDD'),+2 'years',+1 'Years')) …if that makes sense? I’ve been banging my head for too long that even the above might have an error. So in plain English: if today is before a persons birthday (but after January 1) I want it to add 2 years to their age. If it’s after their birthday I want it to add 1 year. I just can’t get it to actually work and I wouldn’t be at all suprised if it’s all down to my nesting, which I’m horribly at. I would

I’m sure this is a simple solution but I am just learning the formula lingo. All in the same table, in field a, I multiplied field b by .14 and it automatically rounds the number up. As this is a dollar amount and field b is also a formula multiplying other fields, how do i get them to give me two decimal places instead of rounding all numbers up to the nearest integer. I’d love to take the extra cents but don’t think my customers would appreciate. Thanks.