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

Forum Posts

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
  • 946 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
  • 2273 Views
  • 6 replies
  • 2 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
  • 1074 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
  • 3152 Views
  • 2 replies
  • 2 kudos

Updating Airtable IF something new exists in Podio

Hi everyone, Thank you in advance for any suggestions you may have I'm working on creating an always up-to-date Airtable that consists of records being updated in Podio. So within Podio, I have an app with a sheet consisting of people; my colleagues...

Dhiresh by 6 - Interface Innovator
  • 1750 Views
  • 2 replies
  • 0 kudos