# Connecting Different data types through uploads

**URL:** <https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884>\
**Category:** Database\
**Created:** [January 3, 2025, 4:54am UTC](https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884 "2025-01-03T04:54:03Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ejack728](https://avatars.discourse-cdn.com/v4/letter/e/977dab/32.png) [@ejack728](https://forum.bubble.io/u/ejack728)\
**Post date:** [January 3, 2025, 4:54am UTC](https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884/1 "2025-01-03T04:54:03Z")

</div>

I have CSVs for users and organizations and they need to link. I’ve uploaded the Users and now uploading the Organizations. I want to update the created by from app admin to the user email, but changing created by isn’t an option when doing an upload.

Is there another way to do this? Potential other solution is I upload the organization data then pull the unique id’s. Reupload the users with organization ID then figure out a way to do a search and update created by to the email that gets return when a search is done for users that have that organization unique id…

---

<div class="post-metadata">

**Author:** ![iwakinomotoye](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/iwakinomotoye/32/86919_2.png) [@iwakinomotoye](https://forum.bubble.io/u/iwakinomotoye)\
**Post date:** [January 3, 2025, 8:54am UTC](https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884/2 "2025-01-03T08:54:09Z")

</div>

Hi @ejack728 You mean “created by” on the organization field, right? If yes, instead of using “created by”, why not create an editable field like “Owner” or “Author” or “Creator Editable” (type=user) and let it be filled with the unique id of the user. This will mean you will upload the users first before the organisations.  
Does this solve your problem or will you still like to reference the organisation on the user data type after already referencing the user as an “Owner” on the organisation data type?

---

<div class="post-metadata">

**Author:** ![ejack728](https://avatars.discourse-cdn.com/v4/letter/e/977dab/32.png) [@ejack728](https://forum.bubble.io/u/ejack728)\
**Post date:** [January 3, 2025, 1:26pm UTC](https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884/3 "2025-01-03T13:26:58Z")

</div>

It solved it. I’ll have to go update many workflows that use creator to owner, but that’s fine

---

<div class="post-metadata">

**Author:** ![iwakinomotoye](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/iwakinomotoye/32/86919_2.png) [@iwakinomotoye](https://forum.bubble.io/u/iwakinomotoye)\
**Post date:** [January 3, 2025, 1:42pm UTC](https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884/4 "2025-01-03T13:42:37Z")

</div>

That’s great @ejack728 I am happy to hear that. You can mark this thread as solved.

---

<div class="post-metadata">

**Author:** ![ejack728](https://avatars.discourse-cdn.com/v4/letter/e/977dab/32.png) [@ejack728](https://forum.bubble.io/u/ejack728)\
**Post date:** [January 3, 2025, 2:04pm UTC](https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884/5 "2025-01-03T14:04:44Z")

</div>

quick question.I then bump up against the same issue (a little different). I’d like to add my org id to my users which have already been uploaded. It doesnt look like I an overwrite. Is there a backend workflow where I can add org id to users once they’re in the database?

---

<div class="post-metadata">

**Author:** ![iwakinomotoye](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/iwakinomotoye/32/86919_2.png) [@iwakinomotoye](https://forum.bubble.io/u/iwakinomotoye)\
**Post date:** [January 3, 2025, 2:17pm UTC](https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884/6 "2025-01-03T14:17:01Z")

</div>

> [@ejack728](#):
>
> uick question.I then bump up against the same issue (a little different). I’d like to add my org id to my users which have already been uploaded. It doesnt look like I an overwrite. Is there a backend workflow where I can add org id to users once they’r

yes,

1. Create a backend api, say, “update\_user\_organisation”.
2. Let this backend api have a parameter user.
3. Then add an action to make changes to the user. (Your user data type should have organisation field.) update the user’s organisation field = do a search for organisation (constraint: owner = this user): first item
4. a. you can run a bulk action action directly from the “bulk” button on your user database and select the api you created in step 1, or  
b. implement a click button that triggers schedule api on a list - the api would be the one created in step 1 and the users would be ‘do a search for users’ (that is all the users in your database).

Let me know if this is clear enough.

---

<div class="post-metadata">

**Author:** ![davidb](https://avatars.discourse-cdn.com/v4/letter/d/76d3ee/32.png) [@davidb](https://forum.bubble.io/u/davidb)\
**Post date:** [January 3, 2025, 2:32pm UTC](https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884/7 "2025-01-03T14:32:39Z")

</div>

@iwakinomotoye’s manual solution is great for one-time or infrequent maintenance. Alternatively, if you’ll be regularly importing new organizations and need an automated solution, create a workflow using a database trigger event that runs every time a new organization is created.

---

<div class="post-metadata">

**Author:** ![ejack728](https://avatars.discourse-cdn.com/v4/letter/e/977dab/32.png) [@ejack728](https://forum.bubble.io/u/ejack728)\
**Post date:** [January 3, 2025, 9:14pm UTC](https://forum.bubble.io/t/connecting-different-data-types-through-uploads/353884/8 "2025-01-03T21:14:47Z")

</div>

Thank you this is perfect!
