Filter Results from Data Store by Range (Min/Max)

[Sonia_Liskova]

What is your goal?

I want to get the data store value based on a criteria

What is the problem?

I want to get the value from the data store. I.e if the price falls within a specific bracket then return me the corresponding value. i.e if the price is 4000 then find me the bracket which it falls within, in this case 0.1725

What have you tried so far?

Tried using the search data but its not working as its not filtering through

Screenshots: scenario setup, module configuration, errors

[Stoyan_Vatov]

Hey Sonia,

Can you show a screenshot of the search module? You should be able to set a filter where it checks if something is lesser than Range Top and greater than or equal to Range Bottom and it should be returning that item.

Just make sure you are using the parseNumber() function on variables whose type is not already an int.

[Sonia_Liskova]

[samliew]

Welcome to the Make community!

Something like this perhaps?

Hope this helps! If you are still having trouble, please provide more details.

— @samliew

[samliew]

Your operations are currently swapped, so it will never be true.

Simply swap them.

RangeTop > Price > RangeBottom
RangeTop > Price
RangeBottom < Price

Hope this helps! If you are still having trouble, please provide more details.

— @samliew

[Sonia_Liskova]

I have swapped them but it is not outputing the value I need

[samliew]

Now you are using the incorrect operator.

Use a NUMERIC operator, as the value you are comparing is a number.

— @samliew

[samliew]

No problem, glad I could help with "Data store in make.com find value within range"!

1. Which was the most helpful post in this thread?

The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep this forum organised.

This marks the topic as solved, so that others can:

• save time when browsing the latest activity on the forum, and
• quickly jump to the solution in this topic

To do this, simply click the checkbox at the bottom of the post that is the most helpful in answering your question.

Here’s a magic link to a list of your other “unsolved” topics: status:unsolved

2. Have you learnt something new?

Do bookmark this topic so you can easily find and return to this topic in future.

Here’s a magic link to a list of your bookmarks /my/activity/bookmarks

3. Have a different/follow-up question? Start a new topic.

Creating a new topic for each question makes it easier for others with the same problem to search for answers. You are also more likely to receive help sooner as new topics are displayed first on the forum’s “new” page!

---

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Learn Make

• Help Centre | Tutorials – Make’s “manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth
• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

How-Tos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Aggregate an array for mapping complex fields
• Getting started with OpenAI - How to setup and use OpenAI in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy - tutorial on how to use Webhooks

If you have a follow-up question, please start a new thread. Thanks!

— @samliew