Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Airtable formula error in 'search records' module in Make.com

Hi. I am trying to construct a formula in a Make.com search records module. The module is the trigger and I've been trying:AND({Ind Doc}!=BLANK(),(DATETIME_DIFF(NOW(),{Record Created}(),"days")=14))('Ind Doc' is an attachment field)Any help would be ...

hauwi by 6 - Interface Innovator
Solved
  • 82 Views
  • 2 replies
  • 2 kudos

Resolved! Calculation Percent yes/no in one field

I am looking for a way to calculate some percentages in my base. There are a few things I need to do first:1. I want to only include records listed as "Budgeted" or "Not Budgeted", not any "N/A" records. (this removes TEST 1 and TEST 4 from my calcul...

KevinTC91_0-1707511298379.png
KevinTC91 by 4 - Data Explorer
Solved
  • 349 Views
  • 4 replies
  • 4 kudos

Allocate information based on post number

Hello, I just started with Airtable, and to be able to use it, I need solve this problem. I am having a database of volunteers on a national level. I would like to make them write their post number when they apply, and in the base allocate a decided ...

LauraF by 4 - Data Explorer
  • 192 Views
  • 0 replies
  • 0 kudos

Multi likes help me

I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a l...

Sarahhh1 by 4 - Data Explorer
  • 224 Views
  • 0 replies
  • 0 kudos

Ingredient stock rollup

Hello,We are a vitamin supplement company and we buy ingredients from all over the world. We have 178 different ingredients which are used to create 17 products.  Sometime the same ingredients will be used for five different products.We want to creat...

MoniK by 4 - Data Explorer
  • 466 Views
  • 3 replies
  • 0 kudos

Dynamic mentions when setting up airtable slack automation

Hi There -Im having trouble with adding dynamic mentions with my slack message automation in airtable. Currently my airtable is connected to salesforce where it pulls a managers name into the airtable record. I'd like to set up an airtable automation...

How to Insert a Line Break in a Long-Text Column

I'm working with a long-text column in Airtable and need to insert line breaks into my text to help improve readability. Could anyone guide me on how to add a break (\n) in my text within a long-text field in Airtable? Any help or guidance would be m...

serdar by 4 - Data Explorer
  • 513 Views
  • 1 replies
  • 1 kudos

Resolved! Empty Space in search formula

I am using a mid formula to extract a string of text. The string appears as expected in the cell, but when Make (Integromat) runs the search it is adding an extra space before the string. " <string>" If the empty space is present, wouldn't I see it i...

Screen Shot 2023-09-13 at 11.25.55 AM.png Screen Shot 2023-09-13 at 11.26.45 AM.png Screen Shot 2023-09-13 at 11.27.24 AM.png Screen Shot 2023-09-13 at 11.28.14 AM.png
Jaxtraw by 4 - Data Explorer
Solved
  • 444 Views
  • 2 replies
  • 1 kudos

Difference in Date for For Different Records w/ Same Serial Number

I am importing customer support tickets from another database (Hubspot) in an attempt to calculate the following:1) What is the duration between each ticket date (single field) for the same product serial number? The goal is to understand the average...

blankman by 4 - Data Explorer
  • 364 Views
  • 0 replies
  • 0 kudos

How to automated functions

Hello community I have been trying to solve an issue. I am looking for the correct formula to automatically fill the columns, (CCC Loads, variable expenses, fixed expenses) in the cost per mile calculator listed below. Those entries will be pull from...

screenshoteasy (3).png screenshoteasy (2).png screenshoteasy (1).png screenshoteasy.png
Jghost1800 by 4 - Data Explorer
  • 759 Views
  • 7 replies
  • 1 kudos

Resolved! Today/Tomorrow formula

Hey everyone, have a question about a formula I can't get working correctly.I only have a date field (Date) and a formula field, with the formula Date=TODAY()The formula returns a 1 for today and 0 if it's another date. So far so good.What I want is ...

Bring the sales price with two conditions Customer and Route

I need to get the price from another table and bring it to my booking table. The conditions must be based on the company and the route to bring the correct sale price registered in the Routes Price table,My airtable system is already working and I us...

Resolved! Add new text from one cell to an ongoing list in another

Hi everyone,I'm trying to solve a workflow/formula problem I've run into.Goal: I am building a task tracker, and it's important we have a history of steps already completed for each task. I have built a table that lists the tasks, and one of the colu...

Jade_Payne by 4 - Data Explorer
Solved
  • 432 Views
  • 1 replies
  • 1 kudos

Unable to create JSON friendly output - Strange Text Behavior.

I'm having a hard time cleaning a long text value so that it can be passed to an API as a JSON value via a Post Request.  After running lots of different cleaning formulas, which all yield 'bad character' errors, I think I've narrowed the problem dow...

Screenshot 2023-06-25 at 6.33.09 PM.png Screenshot 2023-06-25 at 6.38.45 PM.png

Resolved! Formula in primary field - create record via API (Make) - NaN value

Hello,I am experimenting with Airtable and Make, but I have a table with a Primary key which is a Formula field.I am trying to create a record in Airtable with this primary key as a formula, but the primary key is populated with NaN value.Isn't suppo...

Screenshot 2023-05-26 at 12.19.08.png Screenshot 2023-05-26 at 12.19.00.png
cam by 5 - Automation Enthusiast
Solved
  • 1026 Views
  • 6 replies
  • 1 kudos

compare URLs

HITrying to compare URLs in a Search records module in MAKE.Want to find the 1 record where the URL in the table equals a URL passed from a previous module in MAKE.Can't get it to work.... the formula in AT directly does work, but within MAKE, it sim...

arruga by 6 - Interface Innovator
  • 585 Views
  • 1 replies
  • 0 kudos

Resolved! Convert a Comma Array into Linked Records

I have customers purchase information. in Make.com I'm able to store all of the customer's purchase information into a Long Text Field that looks like such:37466774995108, 37466777616548, 43650268266737, 37466778697892, 37466778632356, 43650344222961...

Link Record Example.gif

Advanced Formula Help: Compare text from 2 lists

Goal: Create a list of email addresses that Accepted a Google Calendar Invite, a list of people that Declined, and a list of people that NeedAction.My Data: I have 2 text fields with my data, called "All Emails" and "Attendee Status" (grabbed via Zap...

emintzer by 4 - Data Explorer
  • 884 Views
  • 2 replies
  • 2 kudos