Display a message if search results are more than one

Need help Database
1

Hi everyone,

I am a noob when it comes to these things, but I’ve managed to build what I need… for the most part. What I am unable to do is build the repeating group in a way that when there is more than one result, it will display a message like “there are to many results based on your input, please input more information.”

Does anyone here know how I might be able to achieve this?

Thanks in advance,

Marten

2

This is simple!

Let’s say your RG is called “RG | Results”

Create a text element with the text “There are too many results for your query”
Make this hidden by default, and collapse when hidden checked.

Then, put a conditional on that text element:

WHEN RG | Results 's list of items count > 1
This element as visible Ticked ✅

Done!

1 Like
3

Thank you for taking the time to help me. I now have the message showing, but is is also showing if there is just one result. Besides this, I also have the issue that there is a result showing even if there are multiple search results. I have limited the amount of rows to one, but there should be no result displayed if there is more than one option. Do you know how I can do that?

4

Have you used >= instead of >?

1 Like
5

I used the wrong input for ‘result’. I now understand with RG you meant Repeating Group. Now it works flawlessly. Thank you both for taking the time to help me. I appreciate it.

1 Like
6

Great!