Hey folks, looking for a little guidance on how to implement the following:
There are a set of categories and under each category there are some skills.
This hierarchy should live in the database.
Each user can select a certain number of skills that apply to them.
So, I’d like to have:
A user page that is dynamically created from the categories + skills in the DB, with checkboxes next to each and separation between categories.
The page should auto-fill each checkbox based on what the user (may have) previously selected and was stored in the DB.
A user can make changes and save them, updating all fields in the DB.
Would really appreciate some guidance or examples on how to best implement something like this. Feel free to point me at topics if I’ve missed them searching…
Hey folks, can someone move this to “Need help” instead of “Database”? I think it’s best suited to live there. I can’t seem to edit the forum any longer.
Ex: Category : Name field.
Ex: Skills : Category , Name field.
Link Skills to the User table. Add new field called skills (enable multi input on field creation on database)
Create RG group with category and inside create another RG with list of skills.
and add checkbox in skills. Check the status if user’s skills field have this current skills then checked, otherwise not checked.
Once you checked then add this skill to user skills field, otherwise remove from user’s skills field.
For your reference :
