Changing the value of Created By

Need help Database
1

In the development of an app, I’ve created quite a few records in the database using the Bubble database interface. The result is that those records have an empty value for Created By. Now that I am preparing to have multiple users, and I will be filtering dropdowns, repeating groups, etc. by Created By, I want to ensure that there are no empty values in the database.

Essentially, all existing records should have my own User as Created By and I want to make that the case before adding other users.

I thought I could programmatically create a list of records with Created By is empty and then make changes to that list, replacing the empty value of Created By with my User. Unfortunately, Created By isn’t one of the fields available in the Make changes to a list action.

As I go through the process of cleaning up data to be used in a live app with multiple users, I’m sure to find other data types with empty Created By fields.

How can I clean all this up so that Created By always reflects some meaningful User?

1 Like
2

create another field called MadeBy, type user: then you can add whoever you want.

3 Likes
3

I appreciate the quick reply, Beau. Are you essentially saying that Created By is out of my control?

4

Yes. Yes it is.

2 Likes
5

Thanks, @anon65040322 and @keith. This raises the bar for what I need to do to implement user permissions. A whole new adventure lies ahead. :slight_smile:

Amended:

I may have failed to convey that adventure is a positive thing.

From Dictionary.com:

  1. an exciting or very unusual experience.
  2. participation in exciting undertakings or enterprises: the spirit of adventure.
  3. a bold, usually risky undertaking; hazardous action of uncertain outcome.
  4. a commercial or financial speculation of any kind; venture

Every new computer language and environment I’ve encountered is an adventure.

Designing and building an effective user and team permissions/security feature for a project management app will be an adventure.

A good life is an adventure.

:slightly_smiling_face:

2 Likes
8

I just ran into this as well. I don’t understand why “created by” cannot be updated. It just forces me to waste space creating another field. I’m assuming ‘Create By’ is a simple ID reference.

4 Likes
9

yup .