Website membership question to review private data per username
6 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: November 7, 2017 (RSS)
By Jesus - November 2, 2017
Hello,
I'm planning a website and I have a few questions for the Website Membership Plugin.
I'll be importing some data from a text file into a CMS table, this data will have financial information. I'll like to get my Website Membership plugin to display the information for each username privately. Example:
Section name: Balance card
Inside this section, each username will be able to see and check their OWN balance and their movements up to date (I'll get this info from the imported data).
Is this possible? Can someone point me in the right direction on how can I do something like this while using the Website Membership plugin?
Thanks in advance!
Jesus
By gkornbluth - November 6, 2017 - edited: November 6, 2017
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
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
By Jesus - November 6, 2017
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
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
By Jesus - November 7, 2017
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
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php