Today I began building the onboarding - a much bigger feat than expected!
I used the Trello clone tutorial, https://bubble.io/blog/build-trello-clone-no-code/ as a reference but noticed there was some poor database design i.e. storing long arrays.
I added states to each category meaning they would change colour when selected. I thought these states would allow me to submit selected categories when the user clicks 'submit' but it turned out this was a lot more involved.
I played around with this for about an hour and realised it would be impossible in bubble so i started exploring other options. One way of doing this would be following the to-do list tutorial i'd done a while back, i.e. implementing a 'yes/no' boolean field, but this isnt ideal because the category would still be added to the user field in the user-role table
Finally I stumbled across this article - despite a couple field name mixups and the fact that it is from 2016, i was able to use it as a reference and finally created the desired output using it in combination with checkboxes. This meant I had to give up the original designs, but I figured this layout is more accessible as the title takes precedence over the illustration
Here is the workflow:
This is the onboarding screen, where the user can add and remove categories they're interested in. The selected categories are added to the box on the right. When the submit button is clicked, all the categories are added along with the user id to a new database called user-role
This is the user-role database