"Do a search for" returning inconsistent values

karishma.babu · 2025-02-20T13:34:01.254Z

Hi,

I have a table of email addresses and login count. If the user logs in for the first time I create a new record and set the count to 1. On subsequent logins, I increment the count.

Before inserting or updating, I “Do a search for” records based on email address. If the first item is empty, I insert a new record, else I update the existing record. I use the “only when” property for this.

What I’ve noticed is that if the user logged in on different days, the search returns empty, so I incorrectly create a new record for the user. However, if the user logged in multiple times in the same day, the search correctly returns not empty and I update the record instead. For e.g.:

On Monday, user logged in for the first time. A new record gets created with count 1.
The user logs in again multiple times on Monday. The existing record count gets updated.
On Tuesday, user logs in, another record gets created. Now there is a duplicate record in the table for the same email.

Any thoughts / ideas on why this might be happening ?

Thanks!

fede.bubble · 2025-02-20T21:27:57.295Z

you might want to drop a ticket with the support team. If they can reproduce the steps they can escalate and fix the bug. If there’s something missing they can walk you through the issue as well

saloon-esquiver0t · 2025-02-20T21:52:38.569Z

Try to send some screenshots

georgecollier · 2025-02-20T22:06:05.336Z

Privacy rules

saloon-esquiver0t:

Try to send some screenshots

or this ^^^

karishma.babu · 2025-02-21T13:27:47.890Z

Attaching a screenshot of the two conditions. Thanks!

Screenshot 2025-02-21 at 8.27.04 AM382×472 24.4 KB

Screenshot 2025-02-21 at 8.27.17 AM367×369 18.9 KB

saloon-esquiver0t · 2025-02-21T22:05:24.637Z

What is step 3 ?
Had you run in debug to see this result ?

karishma.babu · 2025-02-25T14:51:16.714Z

Step 3 is an API call to a rest api that returns profile info. The profile info is parsed to extract the email address. The email address is always correctly fetched. The issue only happens with the “only when” condition.

I’ve reached out to the support team at Bubble as well. Waiting for them to finish taking a look.

saloon-esquiver0t · 2025-03-01T22:44:25.767Z

Did you log the api response to be sure it always respond ?

karishma.babu · 2025-03-04T18:47:15.431Z

It appears to be related to the privacy rules. I was not storing users correctly and the “Only when” condition checks against current user. The records were being stored against a temporary user. So the condition was false if a new temporary user was created on next lookup.