Assign Data created by admin to a user

kylie · 2021-02-08T06:46:19.004Z

Hi I have uploaded some user data “workshops details” in a CSV file. It is now showing as created by app admin (me). IS there a way to manually override the creator and have it assigned to a user.
Thanks
Kylie

johnny · 2021-02-08T06:47:06.140Z

Hey @kylie ,

I don’t believe so. Perhaps try the upload CSV workflow on the front-end?

chris.williamson1996 · 2021-02-08T07:06:03.788Z

Yes, you should be able to click “edit” on the dB entry and switch the search field to name or email and easily change the creator.

You may have to do individually or via “modify” with an api flow.

kylie · 2021-02-08T09:02:03.615Z

chris.williamson1996:

easily change the creator.

Thanks for this. Are you able to share a screen shot as I can’t work it out?? I have clicked edit and I cant see what you mean ?

boston85719 · 2021-02-08T10:24:40.989Z

You are not able to modify the ‘creator’ of a data type…this is a field that is set by Bubble and you do not have access to modify it via the editor or via workflow actions.

Built-in fields

By design, Bubble adds a few fields to each type. These fields are the ‘Created Date’ and the ‘Modified Date’ of type date. For things that aren’t users, a third field is ‘Creator’, which is of field type User. For each thing that isn’t a User, this field will link it to the user that was logged in when the thing was created (see below the few actions that let you create things). Every thing also has a ‘slug’, which is a shorthand, unique way to refer to a thing that can be used, for example, in URLs (see this article).

Each thing in Bubble also gets a unique ID assigned when it gets created - this has the format of a long string of seemingly random numbers with an “x” in the middle. Using this field isn’t common, but in some cases, if you need a way to uniquely identify a thing, you can use the ‘unique id’ field.

Instead of these fields yourself, you can rely on Bubble’s data engine to create these fields, assign the right data when a thing is created, and use that data where you need it.

There is not anyway that I am aware of that you can modify these built in fields.

Instead what you can do is add another field to your data type…that field would be of type User…then you can modify that as you would please…of course you won’t be able to use the operator ‘things creator’ but instead would just reference ‘things user’ (if you name the user field type to be field)

Screen Shot 2021-02-08 at 5.23.48 PM771×770 49.9 KB

boston85719 · 2021-02-08T10:29:08.137Z

kylie:

Hi I have uploaded some user data “workshops details” in a CSV file. It is now showing as created by app admin (me). IS there a way to manually override the creator and have it assigned to a user.

To do this, follow my previous reply about not being able to modify the built in ‘creator’ field and add the field for type User.

Then you can use the 1T CSV upload plugin

Bubble

1T - CSV Uploader Plugin for Bubble, by Eli

1T - CSV Uploader Plugin page on Bubble, by Eli. Add 1T - CSV Uploader in one click to your app. Bubble lets you build web apps without any code.

Then access in the plugin element the custom headers and use dynamic data to add the User you want to

Screen Shot 2021-02-08 at 5.27.50 PM

My example shows for the User field I did the current user, but you could do a search like I did for survey and constrain to get the correct user, since I believe your app admin will be uploading the CSV file

kylie · 2021-02-09T21:24:25.193Z

Thanks Legend !

ezhang · 2021-03-11T03:05:30.105Z

Hi @boston85719 ,

Thanks for the explanation here. I downloaded the 1T CSV Uploader and also want users to use it to update other data types, but not sure how to do it. I checked the plugin page but the demo link is now asking for a username and password. Would you please show me how to set up the FIELD LABELS and the FIELD NAME? Thanks in advance!

boston85719 · 2021-03-11T17:23:46.129Z

ezhang:

Would you please show me how to set up the FIELD LABELS and the FIELD NAME?

Watch the video by the developer…it is how I learned.

1T - CSV Creator 3.0 Showcase

@boston85719 Here’s a walkthrough on setting up the CSV Creator action:

ezhang · 2021-03-11T17:26:16.289Z

Thank you for your time finding and sending this! @boston85719 I should have searched more carefully.

bilgi1 · 2023-09-28T08:23:20.621Z

hi,
im trying to have a find by name and replace with unique id solution before uploading csv. can you open this example a little bit more how does search work you cant refer to a column in csv you can parse from json but what is the best way to do it?

boston85719 · 2023-09-28T08:50:18.817Z

bilgi1:

im trying to have a find by name and replace with unique id solution before uploading csv

I don’t really understand what you are trying.

Normally you would first upload a CSV, and then after the CSV has been uploaded, would run a function to replace the name in the data uploaded by the CSV with the unique ID

bilgi1 · 2023-09-28T11:04:48.054Z

so what is the way of doing it?

imagine i hava “brand” data type for “car” thing
i will create another data type in car thing call il “import brand name” and create a backend worfklow database event when an “import brand name” created do a search for this “brand name” from “brand” thing then assosiacate it with current car ? is it the best way of doing this ?
thanks for your answer