Website membership question to review private data per username

Hi Jesus,

Sounds like a real privacy issue.

Would it be possible to add the financial data to fields in the accounts database itself? Then you could easily restrict access more easily.

Don't forget to back up at least your accounts table before mucking around, or better yet set up a test CMSB installation and work with that one.

Best,

Jerry Kornbluth

Thank you Jerry.

Well, basically I can probably make a where statement.

Something like display all records just for this username/member and then do the math I need from those records. The thing here will be to create that where statement using the dynamic username/member as obviously that will change for each specific username.

Is that possible? Is there any example doing something like this using this plugin?

Thank you!

Jesus

Hi Jesus,

Take a look at the edit profile code in the code generator Website membership plugin.

The current user logs in and the form on the page shows information from the user account record for only that member.

I've added fields to the accounts database and easily massaged that form to do exactly what I think you wanted to accomplish, which is to show data belonging to a particular member to him or her once they logged in.

The plugin does all the heavy lifting for you. The owner can update certain fields in their account record.

I don't remember if I've ever done it, but I think you could use what you suggested or similar to work on other tables.

Also take a look at Deborah's current post https://www.interactivetools.com/forum/forum-posts.php?81150

It may give you some ideas.

Jerry

Thank you again Jerry,

Will try to start making some tests and see how it goes. Will keep you posted.

Thanks again!

Jesus

Great! I look forward to finding out how you accomplished the task, and will include it in the CMSB Cookbook (crediting you of course...).

Best,

Jerry Kornbluth