Solved

Hello :slightly_smiling_face: I would like to know if this behaviour is normal and how to fix it. Thank you

Hello, I am trying to create a formula to return the category of my campaign based on the campaign name. For example, if my campaign is “Carlie Bookcase-Manual-Walmart” I want it to return “Bookcases”. I looked into nested IF formulas and FIND formulas and tried to combine them. I got it to work for 1 category using this: IF((FIND(“Desk”,{Campaign Name})),“Desk - Vanity”) But if I try to add more criteria for other categories my formula is invalid. Here is the invalid formula: IF( (FIND(“Desk”,{Campaign Name})), "Desk - Vanity”, IF( (FIND("Dining”,{Campaign Name})), "Dining Tables”, ) )

I’ve been trying to figure out if I can create a formula around two date fields… The situation: Create a field with the possible outcomes as SOLD, PENDING, FIRM, CANCELLED depending on two date fields. SOLD if Today is before Signing Date PENDING if Today is currently equal to or after Signing Date and before Firm Date. FIRM if Today is equal to or after Firm Date CANCELLED (I have no clue how to incorporate this. Basically, I still need a status for deals that have been cancelled, but I don’t know how this would tie in with dates…) Nevermind, I think I might have figured out how to do this… I added an extra checkmark column for the CANCELLED records IF({FIRM DATE FX}=BLANK(),"",IF({CANCELLED?}=1,“CANCELLED”, IF( IS_AFTER({SIGNING DATE copy},TODAY()), “SOLD”, IF( AND({SIGNING DATE copy}<=TODAY(),{FIRM DATE FX}>TODAY()), “PENDING”, IF({FIRM DATE FX}<=TODAY(),“FIRM”,"") ) ) )) Any help would be greatly appreciated. I had this formula working in Excel, but the functionalities o

Hello! I am trying to sync prices and stocks for several products between Google Sheets (source) and Airtable (destination). Thanks to other posts’ answers in this community I could make a script that updates products one by one. But I would like to reduce the number of requests by adding 10 products at a time on a single request. I tried several things but I cannot make it work. I guess it’s related to the way the script parses the data. Here is a simplified version of the script covering only 10 products: function bulkSendData() { const url = "https://api.airtable.com/v0/XXX/"; const dataSheet = SpreadsheetApp.getActive().getSheetByName("XXXSheetName"); var productsData = []; //Step 1 get the data on Google Sheets for (r=2; r<11; r++) { var singleRecord = { "id": dataSheet.getRange(r,1).getValue(), "fields": { "Cost": parseInt(dataSheet.getRange(r,2).getValue()), "Stock": parseInt(dataSheet.getRange(r,3).getValue()) } } pro

I have not started anything, I got an invite from a friend & I signed up, but when I open my account, it has my friends base (shared with me) and I have no place to start a new base from scratch. have looked all over, but can’t even get started, thanks for any help.

Does anyone know what determines the order of records structured as milestones in the GANTT view? Right now, if two milestones have the same due date, one seems to arbitrarily stack on top of the other in the GANTT view. Does anyone know what dictates this order? Is it not possible to sort records in the GANTT view? Also - does critical path not highlight when GANTT views are organized with grouping? I can’t seem to get it to work when I group by project category and then by project.

Hello community! I am using an automation that triggers when an Airtable field is updated. The action is to update attendees field in an Outlook calendar but testing returns an error of ‘Cannot read property “timeZone” of undefined’. See image for what this looks like. Am I about to fall down the rabbit hole that is time zones in Airtable? Or am I just missing something obvious? Thanks in advance :slightly_smiling_face:

Hi guys! I’m quite new to airtable and have no experience in writing strings. I have read the syntax page, but could not find out what i should do to get the desired outcome. I have a column with the name “Referral URL” In this column, urls will be entered trough zapier when a user submits his/her credentials. Something like this: “www.test123.nl/test-ebook-landingspage/?ref=xd3r4n” I have another column next to the “Referral URL” column which is called “Referral Code”. What i would like to do is, eliminate everything before “=” and place only the “xd3r4n” in the cells of the “Referral Code” > This should be automated en run everytime someones signs up Is there someone who has experience with this? Looking forward hearing from you guys!

My company helps provide aid to individuals in very life-threatening situations in other countries. Their personal identities and whereabouts are closely guarded for their safety. Each person is a record in our base. We would like to map out individuals by city in the Map App in order to help with basic logistical planning. My only question is: Does using the Map App (Google Geocoding API) enable Google access to any information in the Base/Table/View outside of the 2 columns (location-text column and Geocoding Cache column) required to set the Map App up??? Thanks for any insight into possible security issues implementing the Map App!

I’m creating a community-facing form where folks can click a button to open a client’s webpage - IF the client has a webpage. However, if they DON’T have a webpage, I’d love the button to not appear. As it is, it’s disabled, but is there a way to make the button disappear if conditions aren’t met? From the screenshot: The first entry lacks a checkbox or website. As such, I’d like that button to be invisible, as opposed to merely greyed out. The second entry has a true checkbox and a website, and the appearance of the button is fine. Any ideas?

I’m using Airtable to schedule event times and am trying to tie a few fields together with a formula but am having trouble getting the date to play along. Right now I have a project name field and then multiple events within a project over a few dates/times. So for example, I’d like to have: Project 1 - 4/10 2:00pm Project 1 - 4/10 4:30pm Project 1 - 4/10 7:00pm I have a relevant date/time field, but then when I use a formula to include that field in a name, it formats it in a way I do not want. When I use datetime_format, it’s in the wrong time zone (I think) and I can’t change it in the formula formatting. This is what I’m using: {Project}&" - "&DATETIME_FORMAT({Start Date Time},‘M-DD-YY h-mm’)

Hello! I’m looking for a few hours to get the duration of a video file in an attachment field. Is it possible? Thank you! Quentin

Hi! There is probably a very simple solution to this, but I’m trying to create a field that shows information from EITHER of two other fields - whichever one happens to be populated. My issue is that they are both calculated number fields, so I’m getting zeros instead of blanks. Example: of Jars (SOUP A) = 3 of Jars (SOUP B) = 0 Ideally Field C should just be “3” but instead I end up getting “30” because I don’t know the proper “IF” formula to wrap into it. Here is my current formula: CONCATENATE({# of Jars (A)},{# of Jars (B)}) Any assistance would be much appreciated! Thanks!

I want to be able to send HTML emails to my contacts in Airtable. I’ve used the SendGrid app, but it only sends text emails. I’ve tried Zapier to integrate Airtable with Mailjet. The problem is it needs a “trigger,” and I want to sent out general emails (newsletters) without a trigger, just whenever I need to send them. Any suggestions? Is this something that a knowledgeable API person would be able to configure? I’m willing to pay someone to do it. Thank you.

I am using DATETIME_PARSE, but it has problems with some months in spanish, as you can see in the screenshot. I am trying to convert those months, but I cant get the way. Any ideas ??

Hello, I have a very basic filter: Randomizer ≤ 3 The view only contains the record where the Randomizer = 1 even though there are records that contain 1 and 3. Thanks!

Hi, I’ve been using the “Find Records” aspect of automations and super helpful. It doesn’t seem to be well documented anywhere though, and where I am very confused is that often there will a value from a previous step that I want to use (dynamic), but it is not available, only <>length. Unhelpfully rather than being greyed out, or not visible, I always end up clicking through to find it’s not available! From what I can tell, you can not use any of the following as a dynamic variable in the Find Records automation: Formula value Linked record Roll-up Considering those make up a large percentage of my tables, it’s a little frustrating! Indeed it seems that the only values you can actually use dynamically, are ones that have been manually populated. But that means either having to actually populate those fields manually, or using an automation to print the value int he field (so it looks like it has been created manually). But that seems an awful waste of a precious automation giv

Hi, So I have a field called {First Name} and {Last Name}. I have a formula field called {Full Name}, which is simply the result of {First Name}&" "&{Last Name}. Pretty simple. However, there may be cases when the {Full Name} results in blank. For e.g. when I create a new row in the grid, but no First and Last Name have been entered yet. I assumed that the {Full Name} is equal to BLANK() in this case. I have a primary field {ID}, which I’m using as an ID with the intent that if the {Full Name} is not blank, then evaluate to Autonumber&" "&{Full Name}, so something like “101 John Smith”, “102 Rebecca Jones”, etc. However, I want ID to be a formula such that if the {Full Name} is blank, it evaluates to something like “103 No Name”, instead of just “103”, i.e. I want to see the ID that has no full name explicitly, so I thought a simple IF() formula for the ID field would work. I tried to write an IF() formula such that if {Full Name} is BLANK(), then formula result should

Hello all, I have an automation that is looking for a record with specific values. Sometimes it does not find the matching and it is normal (it is a use case.) I would like to know if there is a way to catch the error of the find function ? If not I was thinking of doing it with a script but I found it strange that in automatisation it is not possible to catch error or even do conditional branch. thanks for your help Alex

Hi All! First time in the community. I’ll have a bunch of questions but wanted to know if there’s an easy way to do a formula to convert a duration field from hh:mm (hours and minutes) to hh.hh (hours with a decimal)

Hello! I have two linked tables, let’s say Users and Events, and the Events table contains an Attendees column that links to Users. I want to add a new value to this column using the API. The code is quite simple: await eventTable.update(eventId, { Attendees: [userId] }); But this overwrites the previous attendees. Can I just add one new value to the cell without overwriting the previous ones? I know I can read the previous values manually, add the new one and write the whole array back – but that’s a race condition waiting to happen, isn’t it? Is it possible that someone changes the value after I read the previous contents and before I write the new, augmented value?

Hi. I’m trying to figure out how to use your API. What I need to do using the API endpoints is the following: Send a request to create a user (record/row) in a table Then create a Gallery view named as the user’s name Generate a “share view” link/embed code with an active filter. Is this something that is possible to do via the API? Thanks, Andriy

Just started with Airtable, using the free version at the moment on Firefox / Ubuntu. When I log on, Airtable seems to open to a random base in my workspace. Is it possible to set it to open to the workspace screen so I can choose the base I want to use? Thanks! Dianne R

I have an automated email set up, using Gmail, for informing someone when their video is scheduled to be published. This is trigged once the publish date date field is set. I have changed the publish date date format from ISO to friendly format, but it still publishes the scheduled date as ISO format in the automated email. Does anyone know how I generate an automatic email with the friendly date format? Thank you!

How would you go about configuring a field so that you can create a dropdown list of years inside of a form? Is it possible for it to dynamically update with the {current year} + {10 subsequent years}? For example, the form field might read something like: 2021 2022 2023 2024 2025 etc…