User Table Editing

[BTProjects]

If I want to associate a user to say an agency, how can I do this? It looks like the user table cannot be edited to add columns.

[mikesealey]

The user table cannot be edited directly, but it can have relationships with other tables, which is likely how you should tackle this.

Create an agencies table and populate it with the relevant data, and then add a relationship column to join the Users table

Now in the agencies table, adding a user to that row will populate the agency in the App users table.

[BTProjects]

Thanks Mike. I was playing around with this concept but noted that if you do not correctly setup the relationship with the Users table (it was just user error), there was no way to remove the relationship related column without starting over with a new project, is this correct? Based on this use case, let’s say I want my NASA agency to create clients (id, name, date of birth, etc) how does one accomplish this so they only create clients for NASA and do not have an option to expose or add to other client agencies? Aaron Lind W: 531-355-1484 M: 402.676.3064 [National_Logo.png]<https://www.boystown.org/> boystown.org<https://www.boystown.org/> 14100 Crawford Street • Boys Town, NE 68010 ***@***.***<https://www.linkedin.com/company/boys-town> ***@***.*** <https://www.twitter.com/boystown> ***@***.*** <https://www.facebook.com/boystown> This message is privileged and confidential and is intended only for the use of the addressee. Unauthorized use of this message is strictly prohibited. If you received this transmission in error, please immediately contact the sender and destroy the message. Thank you. From: Mike Sealey ***@***.***> Sent: Monday, June 10, 2024 3:22 AM To: Budibase/budibase ***@***.***> Cc: Lind, Aaron J. ***@***.***>; Author ***@***.***> Subject: Re: [Budibase/budibase] User Table Editing (Discussion #13890) The user table cannot be edited directly, but it can have relationships with other tables, which is likely how you should tackle this. Create an agencies table and populate it with the relevant data, and then add a relationship column to join the Users table image.png (view on web)<https://urldefense.com/v3/__https:/github.com/Budibase/budibase/assets/39269380/cc368309-6b39-4fc5-bdb7-14b6f5a3ac33__;!!CEjAKCqGPSl6!u1Jfbo3XuhLoQhNli3ynAajVE2dYHVcmqZZBa93wP9vjntbwaCZA-qMKOhaiY0psQ6YnWjIR98cMyRzPdu8t-DJ9HTU$> Now in the agencies table, adding a user to that row will populate the agency in the App users table. image.png (view on web)<https://urldefense.com/v3/__https:/github.com/Budibase/budibase/assets/39269380/5c27e683-896a-4321-a9ed-2c9793044b82__;!!CEjAKCqGPSl6!u1Jfbo3XuhLoQhNli3ynAajVE2dYHVcmqZZBa93wP9vjntbwaCZA-qMKOhaiY0psQ6YnWjIR98cMyRzPdu8tDq5svB0$> — Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/Budibase/budibase/discussions/13890*discussioncomment-9724586__;Iw!!CEjAKCqGPSl6!u1Jfbo3XuhLoQhNli3ynAajVE2dYHVcmqZZBa93wP9vjntbwaCZA-qMKOhaiY0psQ6YnWjIR98cMyRzPdu8tFesyb3M$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ABLKFROD7MLVHYFBOVWY3DDZGVO35AVCNFSM6AAAAABI7KYGYSVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TOMRUGU4DM__;!!CEjAKCqGPSl6!u1Jfbo3XuhLoQhNli3ynAajVE2dYHVcmqZZBa93wP9vjntbwaCZA-qMKOhaiY0psQ6YnWjIR98cMyRzPdu8t_Q1NOJ0$>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>