Adding

[m311ton]

On a product details page, I want a registered user to be able to click a button that says, "Add to my profile." Clicking this button would then basically add this particular item (or record) to the user's account, to be displayed on a profile page. (My goal is to allow users to basically add and list what products they own.)

Could anyone please give me some sense of direction on how to do this? Feel free to ask if my needs aren't clear, but I hope it is simple. Thank you so much for your support, I sincerely appreceiate it!

[bahar_vm]

Hi,

Here is some solution:

You need kind of one to many relational tables between products and users table, so one user could have many products added to his/her profile.

First you should make sure about the tables structure:

products table has product ID (primary key) and users-products table has user ID, product ID (foreign key),...

In the details page of the product you can create a custom button in an HTML block with onclick event to open another page URL passing the product ID and user ID (based on who has logged in) and this new page contains a Caspio Web Form DataPage againt the users-products table. This Web Form will receive those two params and user can submit the form to get the data in.

Now you can build a Search/Report against this table or you can create a view from all the three tables and just display the data in a one to many relational way.

We have an instruction how to create reports when you have one to many relational pages. Attached please the instruction.

Let me know if that does not help or if I could not address what you were looking for.

Best,

Bahar M.

[m311ton]

Thank you for your response. I will give this tutorial a try and let you know how it works out. But so far it sounds like that is what I need. I sincerely appreciate your support, and the great support that Caspio offers. It is truly what makes this a fantastic product!

[bahar_vm]

Hi,

You have got a respose through ticketing system, but here is the idea in general:

This would requires kind of one to many relational tables between products and users table, so one user could have many products added to his/her profile.

First you should make sure about the tables structure so products table has product ID (primary key) and users-products table has user ID, product ID (foreign key),...

In the details page of the product you can create a custom button in an HTML block with onclick event to open another page URL passing the product ID and user ID (based on who has logged in) and this new page contains a Caspio Web Form DataPage againt the users-products table. This Web Form will receive those two params and user can submit the form to get the data in. Then you can build a Search/Report against this table or you can create a view from all the three tables and just display the data in a one to many relational way.

Best,

Bahar M.