Quick Data Question

jackedwards664 · 2025-02-15T15:16:53.888Z

I have one nagging issue I can’t seem to figure out, that effect’s many pages and would appreciate any New ideas, as I’m out.

I have a user “client name” drop down menu, that when clicked, creates a “new item” then goes to a form,… for them to fill out the rest of the info.

The client email shows in the products database. great,

That all works.

What I can’t seem to figure out is how to add that newly created “Products” unique ID to the Client’s database.

I want to be able to exclude clients with no “products of that type” on look up.

So how when I create a new product, on the next step also add that unique id into the clients database?

Btw, list of clients, client, nothing seems to work.

I think I have tried every way but the way it works. Probably something simple. Thanks for any thoughts.

Bubble 10349×322 9.25 KB

Bubble 11358×325 9.58 KB

dianabologabv · 2025-02-15T18:56:03.961Z

You are trying to make changes to a list of Clients, while the “List to change” is referencing one single thing/client.
Step 2 should be Make changes to Client and the field to change: Product(of data type Bid Product) = Result of step 1

mitchbaylis · 2025-02-16T03:01:24.372Z

probably the better way to do this is with the database structure

if there are not that many clients per product then yes you can keep a list of clients on the product - but if there are many then that’s an inefficient way to do it

if there are limited products you could store it on the client, but again if there are many it’s very inefficient to store a long list this way

better option is a separate data type
client_purchase - client, product, status

your search could function several ways depending on the data structure

search for clients minus list (search for products where product is product) products clients
search for clients where product list doesn’t contain product
search for clients minus search for client_purchases where purchase is product

essentially 1 and 3 minus off a second search from the first search
2 does 1 search with constraints

#3 would be the most flexible and scalable

if you wanted to filter by products type (not the product itself) then I’d also store the type on the client_products data - saves doing a nested search which can be slow and WU high