I am building a website for a fitness center. They need to have their members fill out health information form which they can retrieve in case of emergency. Now I’ve built a database for health information and created the form, but I cannot figure out how to make an “admin” or staff of the fitness center search for and look at a specific member’s health information? I need to be able to search by name/mobile number/email (and view the related health information) but these all are not designed to be in my database to make it more convenient for customers as they have already registered with the website!
Any thoughts are appreciated.
It’s not that difficult to make admin page, the simplest way probably is to add a page that is hidden from site menu and set password requirement to access it. So for example in order to access the page you will need to know exact link (for example: mywebsite.com is available for purchase - Sedo.com) to the page and it will require password to access the page itself. There are more sophisticated solutions that can be made here depending on how much time and effort you’re willing to put into it.
And admin page can use table of users with search for example there’s a good solution described in Tips&Tricks section of the Forum
You can also use repeaters for more interface control, but overall solution stays pretty much the same.
As for additional data this depends a lot on the collection data you already have, the way you store it and data you want to add. Probably the best way is to implement your members area with code that will allow users to handle their own data, you’ll just add new fields and users will be able to add them whenever they want. You can add members area to your site but it’s limited to name, last, email, phone and address, you can use this part but you’ll have to add you additional data separately and it can be difficult to manage.
As you have mentioned it is exactly the issue, I have the members pages set up as they need to book and pay for their sessions with the trainers which makes the health information added not easily connected to the customer.
From reading across many discussions, it seems I cannot use the member ID and login info with my database. So I did it the stupid way (ask the customer to enter their data again which will not be in sync with their actual account ! ) But still given that, it’s been a headache trying to make customers able to
1- fill the form
2-update it when they need to and
3- an admin to look through this data and filter
I also have the hidden admin page but I need it to be password protected as this is private health and other info that no one should be able to see easily. I am trying to access the link you shared about having password protected pages? It doesn’t seem to work.
The password protected link is just an example, the link wasn’t intended to be working.
It’s pretty easy to set up, you can just go to
Mange Pages → Settings (of the page you want to protect) → Permissions
Just don’t forget to toggle Hide from menu in Page Info and set a strong password.
After having such a page it can be configured so admin can go through data, filter, sort maybe something else, it’s up to you.
As for members area thing it can be tricky, we’re working on improving it.
There’s wix-users API that may be of help here. You can have your custom form and use user API to autofill user forms your users have to fill, much like members area, so they won’t have to fill in everything but only new data you don’t have yet.
Thanks again,
one last question please.
So I created the health informaiton form which they are able to update any time they need to.
The only issue is, if there are no previous records for this member (ie new member still didn’t fill the form) the form is greyed and they cannot add new information. Is that something I can fix?
This brings me to three other questions plus original:
1- Why can’t I write immediately on the same read-write form and if it can be fixed
2- When you update health records, although I’ve added a link when successfully updated, it only updates without going to link.
3- Is there a way to prompt customers to fill this form when they first create account?
4- Can I add the (My Health) page in the login menu on top right?
Your form is connected by a dataset that is set as ‘read & write’. As such, the dataset tries to find an existing submission by the logged-in user (read => write) and once he cant do so he automatically disables the form.
Your solution in this case will be to make a duplicate to the page which will be set as ‘write only’ and first-time users will be directed to it. Then, when a user wants to update the info he should be navigated to the page you currently have.
I tried to find a solution to this issue but it seems like something is wrong on our side working with members pages. I’ll update this thread as soon as I have a solution but in the meanwhile the alternative is by code. Note that if you use code to solve it you’ll need to make some changes in the page due to the fact that components cant have both dataset functionality and code in the same time.
Yes, that will be by code, as well. You’ll need to check in some point (you need to choose why and when) if the form exists for the current user and if not to redirect the user to the form asking him to fill it.
As I mentioned in section 2, we’re checking if the issue of redirecting to ‘members pages’ might be on our side so as soon as I’ll have a solution it will be possible and I’ll update this thread.
