Hi there, @viquarahmed07… to the best of my knowledge, the options you have are to put a privacy rule in place that limits the results of the search to the desired fields (which could be tricky, depending on your setup) or separate the Product data type into multiple data types (which would be linked to each other, of course), and have one of those data types contain only the image, name, and price.
I am in quite same situation
I am following this…
I am trying to do this but the problem is when i click on any product i am navigating to product details page which needs to display more information (other than name, price, image)
Then i am getting stuck i don’t know how to link them…
Hi there, @anthony.viel… you could have a Product Detail data type, and that data type would have fields for all of the additional information you want to store for a product. Then, you would create a field in the Product data type (we’ll assume that is the data type that stores the product’s name, price, and image) that has a field type of Product Detail.
When a product is added, you would create a thing in the Product data type, and you would also create a thing in the Product Detail data type. After the latter is created, you would make changes to the thing that was created in the Product data type, and you would update the thing’s Product Detail field with the thing that was created in that data type. With that link in place, you would have access to all of a product’s info in the Product Detail data type by referencing the thing in the Product's Product Details field.
@mikeloc Thanks a lot for brief explanation
Also just 1 more question (Not related to this topic)
I have around 800+ products in my database
Do you think adding pagination will improve my RG loading performance ?
Once Bubble starts returning only fields used, life will be great for many of us. In the mean time the suggestion above is one option or start storing copies of the same data in different tables depending on use. It sucks to maintain but it works.