I can’t tell if I’m just stupid or what, but I need some help.
I have multiple stores which are each their own data type.
Example:
Data Type: Store A
Data Type: Store B
Data Type: Store C
I also have a landing page, with a search bar. How do I set up the search bar so I can search each store name (a, b, c, etc.) from each Data Type, and then send over the information for that specific Data Type to the page?
Hi there, @stewart… is there a reason why you have a custom data type for each store? I would almost certainly have a Store data type, and that data type would have a text field for a store’s name, and you could search the Store data type and the name field via a searchbox element to get the desired result, assuming I have understood your post at all.
Best…
Mike
Hi Mike, thanks for the reply!
I suppose it’s possible to do that. There are thousands of stores with likely over a few hundred distinct things each. So it’s possible to get into 1 million+ things. Will Bubble handle that?
Yes, Bubble can handle that… and even if it couldn’t (which, again, it can), are you saying you would have thousands of custom data types, one for each store? If so, you absolutely don’t want to do that.
Oh okay, I wasn’t sure which was preferred, a large amount of data types with a short data list vs. one data type with a huge amount of data.
Well, the number of data types isn’t necessarily the question here because you are talking about having a data type for each store, and you simply don’t want to go that route.
Yep this is fine
Interesting. Okay but this creates a problem for me.
I created a single Data Type for all stores, along with records for each store.
I have a search setup and I can see each store name from the Data Type. I click on it and it sends the ENTIRE Data Type to the next page (which has repeating groups to display relevant information). But I only want to display relevant information for the store that was clicked on, rather than the entire Data Type. How would I go about this?
Just for your own sake:
Database - your app’s entire data
Data Type - table of a specific data type
Data / Thing - a row of your data that contains this Thing’s fields
Field - an attribute of a data type
Corrections made! Thank you for that!
Your next page should have the data type Store, then when you select a Store from a repeating group you to do “Go to page” action, pick your page, and the data to send would be “Current cell’s Store”
The way Bubble works is you send over the actual Store (or Thing, the row in your database). So on the page you can display whatever information you want like Current page Store’s Name, or address, etc.
Well my problem, I think, is I have about about 200 things for each actual store. I have products, product descriptions for each product, categories, etc. Should I have all of these as one “thing” for each store?
Update: I’m able to search with constraints to only display what I need. Works good now!
No, you have 200 fields
See here for a sample database structure:
200 fields you probably mean.
But that’s not right either because Product needs to be its own datatype, where a Product would contain its description, pictures, and a field Store (type Store)
