Adding data for users in Production šŸ˜±

Need help Database
1

Letā€™s say Iā€™m doing a change in my DB structure and in order for everything to work right for existing users I want to add things ā€œfor themā€ in the data base through a backend workflow operated through ā€œBulkā€ action in the DB view in the editor.

  • If Iā€™m adding fields to existing things/change values of fields this way everything works great.

*If Iā€™m trying to add things, these things are created by a ā€œdeleted userā€ and wonā€™t be shown to the user because of privacy rules.

Solutions I thought of:

  1. Create a one-time work flow that will initiate the backend work flow when a user logs in.

  2. Create a hidden button that initiates this backend workflow, then log in as a user and click on this button, the backend workflow will create these things with this user as a creator and everything will work except that I donā€™t want to log in as my users (doesnā€™t feel right + much workā€¦)

  3. Create a field for this ā€œthingsā€ which will read ā€œforUserā€, add the user to this field and change the privacy rules.

Is there anything Iā€™m missing? Canā€™t I create things directly from the DB?

Thanks!

2

If you are creating things through Bulk action in your database, the field Created By will be always empty.

3

I was afraid this will be the answer but thanks!

4

Do you want this new thing to have a specific creator!? Canā€™t be an admin?

5

It canā€™t be an admin because I have privacy rules which says that users can find this thing only if they are the creator.
If I set a privacy rule which say that they can see this also if an admin created it, all users will be able to see all other usersā€™ these types of things.
Also Iā€™m not sure ā€œdeleted-thingā€ = ā€œapp adminā€.

So I guess Iā€™ll have to use one of the solutions Iā€™ve mentioned above.

6

@baum.mori Did you find a solution to this? Iā€™m in the exact same situation and have also thought of some of the solutions you mention, but none of them are really ideal for me.

There must be some way of bulk adding things to existing usersā€™ databases.