How to search for especific enties using "Search for" based on 1 field

ivan9 · 2024-11-04T20:14:13.474Z

Hello community, I need you help.

I have problems when searching/counting the number of entries that exist in the bubble AppData based on a field. The idea I had was the following, when a user creates an account, this account is stored in the AppData along with a new field with a randomly generated 8 digit code(using number and letters), in the application I am making, there is a form where the user can enter a code, if the user enters a code that exists in the bubble AppData, then a message would appear below the input field showing that his code is valid, in case the code that the user entered does not exist in the database, then a message would be displayed that the code he has entered is invalid.
Try using Search for User:count is 0 and Search for User:count > 0 using as a constraint that the Referral_Code field (which is the field containing the 8 character digit that is randomly generated when the account is created) is equal to the InputField’ value (which would be the user input) expecting it to count the number of users that have the same referral_code that the user typed, so that when Search for User: count is 0 is true, it would mean that there is no user with that referral_code and therefore it would show the message that the code you have entered is invalid, and when Search for User:count > 0 it means that there is a user with the referral_code that the user typed in, and therefore it would show the message that the code you have entered is valid, but my idea didnt work and i dont know why. I have this in a workflow that is activated whenever, the user changes his input value.

User input field and messages

image1517×698 73.2 KB

Hide/Show valid/invalid message based on serach for

image906×618 41.5 KB

image1447×685 69.3 KB

This is the User table:

image1272×482 76.9 KB

Example of how this doesnt work:

image1918×1018 125 KB

image1918×933 107 KB

Apparently it only works with the last user created.

image1918×962 113 KB

I added this alert so that you could see that when I put valid codes, it shows me that the number of users created with that same code is 0.

image1492×750 82.6 KB

Please help me :C

mghatiya · 2024-11-05T04:13:58.335Z

ivan9:

but my idea didnt work and i dont know why.

In general when you run into an issue where “I don’t know why” happens and it is something related to data, first check if you have any privacy rules that are preventing this.

Privacy rules are quite strong, but the way they silently not return data is bit weird and makes it really hard to debug.

system · 2025-01-13T20:14:21.215Z

This topic was automatically closed after 70 days. New replies are no longer allowed.