The User column type allows you to select a Budibase user from a dropdown list as determined by the Application access. This list will include all admins of the tenant, and any members of the app.
Allow multiple users on to make the list a multi-select.
With the user column added, you can now click the
+ within your data grid view to select a user as identified by their searchable email address.
The user column is available for both the Budibase DB and external SQL databases.
In the case of SQL, when a user column is added within Budibase, it will create a varchar column in your table to hold the user id:
A common usage of user columns in your tables is to indicate ownership or assignment.
For example, I can add an 'Assignee' user column to a 'Jobs' table to indicate who is responsible for completing that job.
If your user column has Allow multiple users enabled, then the filter will be a contains like so:
As of v2.11.0 you will no longer be able to create a relationship between the Users table and a Budibase DB.
To accommodate this change, apps that were created before v2.11.0 can migrate existing user table relationship fields to the new user column, as outlined below.
- Open your existing app and navigate to the Budibase table that contains a user relationship
- Click the hamburger menu, and select the last option:
Migrate to user column
Continueto create the new user column. As warned, you may need to update some existing bindings
This will remove the link from the App users table and can improve the performance of your apps.
It should also be noted that if you were displaying user data through a migrated relationship link, this would also need to be updated as shown in the 'Usage' section above.
Updated 27 days ago