I used app builder to connect various tables to generate a functional way for volunteers at a theater I manage to add shows and show data and who will be managing the event. I have everything working based on several access levels - no login can view show list, all logged in users can edit the show basic info, a role to edit/add new shows and a level to edit/add/delete shows. I have two admin levels. Both admin roles can update the list of volunteer managers, event types list and locations/theaters table. Those tables are the dropdowns for the show data. The āSuper adminā role can do all listed functions, as well as create/edit/delete the application users.
I manage website users like i do all other table data: the main page has a table showing each row. If role allows editing, then the name is linked to an edit page. Edit page makes changes, saves and returns to listing page. At the bottom of edit page, if role allows is a delete button that will delete the record. At the bottom of the table listing, is an add button, if role allows adding. That opens a page much like the edit page, just blank, allowing a new record to be created and saved. This has worked great for the shows, house managers, show types and locations. But Iām having an issue with the role assignment on the edit page for website users. I have a table with the available roles. I realized that I couldnāt use a linked table for the role field for some reason, so the role field in user table is a choice list, where the name matches exactly to the names and descriptions shown in the roles table. So on the app edit page, I have a dropdown element, which gets the list from the roles table and the value and display text are the same, the name of the role. I set the value of the field as the role of the user we are editing (ex: āSuper Adminā). When using the application builder, and I put the user id at the top of the page and select a user to view page as, then the data populates correctly. It shows the user name, email, role, active, notes, etc. (I have a method to manage the password separate). So in the app builder, all fields populate from the user table, but when I publish the app and access it, the user role dropdown is always blank when editing a user. It doesnt match the results I see in the aap builder UI. The dropdown has all the valid options, and I can select any role and it will correctly update the user, but if I donāt select the correct role each time, then it will overwrite the userās role with a null value, effectively disabling them. I just cant figure out why it will not show the current role value from the list of choices. They match exactly, ive triple checked.
Any suggestions would be appreciated. This system is not being used at all yet, Im strictly in dev mode. Therefore , I donāt mind anyone looking at it to offer suggestionsā¦. the url is
https://dgoad.baserow.site and I created a test super user to observe this problemā¦. click login, then login as super@admin.com. password is 12345678. Once logged in, click the manage menu, then website users. Once the list comes up, you can click my name āGoad, Danielā and you will see the edit form. All other fields will populate with the existing data, but the role will not have a value. You can pick a role and save it and it will update correctly. But, if you save it without selecting a role, then the role value is null. Please dont make changes to the super@admin.com user or delete the Goad, Daniel user, so others can access my example. You are welcome to create other records or logins for this or any table in the appā¦ as I said, this is just dev right nowā¦.
Thanks for any suggestionsā¦