How to create users specific tables

[JSC]

Hi,

I am trying to create a customer portal but each customer needs to view completely separate data. I believe the best way to do this is having separate tables instead of having one table with several thousands rows.

How can I go about automatically creating and connecting a table for each new user when they sign up?

Is there a better way to approach this?

[Robert_Petitto]

This might help

Row Owners vs. User Specific Columns

Row Owners and User Specific Columns in Glide both provide a way to secure, privatize, and personalize user data, but which one should you use in your no code app? Join me as I walk you through a few different scenarios as to when you’d use each (and when you WOULDN’T use either!). [Glide: Row Owners vs. User Specific Columns]

User Table vs Profile Table

<a href="https://www.youtube.com/watch?v=JPgZeDSPQMw">https://www.youtube.com/watch?v=JPgZeDSPQMw</a>

Demyst…

[Darren_Murphy]

@JSC

I believe the best way to do this is having separate tables instead of having one table with several thousands rows.

On the contrary, that’s the absolute worst approach.
Use Row Owners. Watch Bob’s video.