# CSV Upload within APP - doesn't support linked tables? Or does it?

**URL:** <https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911>\
**Category:** Database\
**Created:** [August 30, 2018, 10:03am UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911 "2018-08-30T10:03:42Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![simon](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/simon/32/8895_2.png) [@simon](https://forum.bubble.io/u/simon)\
**Post date:** [August 30, 2018, 10:03am UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/1 "2018-08-30T10:03:42Z")

</div>

So I was trying to allow a user to upload data to the app via the front-end but it turns out If your table has a relationship with another table in the database you can’t do it.

You get this error “This type of field is not supported by the upload CSV action: custom.company”

You can do it via the database as it allows you to specify a sub field of the linked table.

 ![urban%20dash%20%20%20Bubble%20Editor%20(6)](https://us1.discourse-cdn.com/bubble/original/3X/5/4/541e5265770914e1d1e92970b71fbdc6b74a7db7.png)

So my question has anyone figured a way around this?

Thanks  
Simon

---

<div class="post-metadata">

**Author:** ![dan1](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/dan1/32/23411_2.png) [@dan1](https://forum.bubble.io/u/dan1)\
**Post date:** [August 30, 2018, 7:16pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/2 "2018-08-30T19:16:19Z")

</div>

This was an issue that caused me a bit of frustration a few months back. (May have changed since then, but this solution likely still holds).

For the table that the user is uploading, I create a “reference” field which is plain text. (However, the unique ID would go here or other matching field. (In this case, call it “company\_reference”).

Once the data is uploaded, I schedule an API workflow on a list. (With the list being the CSV uploader’s items).

Within the API workflow, I now fill out the “Company” value for each record, accomplished through a "Do a search for:Companies:first item (with the constraint of Company\_Name = company\_reference). It’s a bit of a consuming workflow, but works.

It’s ideal if you can use unique identifiers (Bubble’s or self generated) instead of straight text (ex. if you have two Acme, Inc’s, you’d run into issues). Though that may not be ideal from an end-user standpoint.

---

<div class="post-metadata">

**Author:** ![simon](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/simon/32/8895_2.png) [@simon](https://forum.bubble.io/u/simon)\
**Post date:** [August 30, 2018, 7:22pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/3 "2018-08-30T19:22:37Z")

</div>

Dan,

Thanks that does sound like a good work around solution. I will give it a go. Hope Bubble improve their data upload capability because its very limited at the moment.

Cheers

Simon

---

<div class="post-metadata">

**Author:** ![dan1](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/dan1/32/23411_2.png) [@dan1](https://forum.bubble.io/u/dan1)\
**Post date:** [August 30, 2018, 8:54pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/4 "2018-08-30T20:54:57Z")

</div>

Happy to help.

My wishlist item: enable a user to upload a CSV that creates records server side instead of the user (patiently) waiting for it to process.

---

<div class="post-metadata">

**Author:** ![neerja](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/neerja/32/29814_2.png) [@neerja](https://forum.bubble.io/u/neerja)\
**Post date:** [August 13, 2019, 6:00pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/5 "2019-08-13T18:00:26Z")

</div>

@simon We now support runmode csv upload with linked data types when the field contains unique ids.

---

<div class="post-metadata">

**Author:** ![gnelson](https://avatars.discourse-cdn.com/v4/letter/g/6bbea6/32.png) [@gnelson](https://forum.bubble.io/u/gnelson)\
**Post date:** [August 13, 2019, 9:20pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/6 "2019-08-13T21:20:46Z")

</div>

Hi @neerja,

Do you have some documentation on this?

Thanks!

---

<div class="post-metadata">

**Author:** ![neerja](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/neerja/32/29814_2.png) [@neerja](https://forum.bubble.io/u/neerja)\
**Post date:** [August 13, 2019, 9:59pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/7 "2019-08-13T21:59:17Z")

</div>

@gnelson When you ‘upload as csv’ through runmode or through an API call, the csv file should contain the uniqueid of the linked data type in that linked field’s column. [Here’s](https://youtu.be/TL9iaa5nNXY) a video demo.

---

<div class="post-metadata">

**Author:** ![gnelson](https://avatars.discourse-cdn.com/v4/letter/g/6bbea6/32.png) [@gnelson](https://forum.bubble.io/u/gnelson)\
**Post date:** [August 14, 2019, 12:32am UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/8 "2019-08-14T00:32:57Z")

</div>

Thank you.

---

<div class="post-metadata">

**Author:** ![gnelson](https://avatars.discourse-cdn.com/v4/letter/g/6bbea6/32.png) [@gnelson](https://forum.bubble.io/u/gnelson)\
**Post date:** [August 14, 2019, 12:34am UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/9 "2019-08-14T00:34:10Z")

</div>

Is there a limit on number of rows uploading csv through api call?

---

<div class="post-metadata">

**Author:** ![antony](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/antony/32/19446_2.png) [@antony](https://forum.bubble.io/u/antony)\
**Post date:** [August 14, 2019, 10:12am UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/10 "2019-08-14T10:12:05Z")

</div>

@neerja, is the video meant to have a commentary?.. as I can’t hear one!

---

<div class="post-metadata">

**Author:** ![neerja](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/neerja/32/29814_2.png) [@neerja](https://forum.bubble.io/u/neerja)\
**Post date:** [August 14, 2019, 2:46pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/11 "2019-08-14T14:46:13Z")

</div>

@gnelson The same runmode limits apply with csv upload through API call.

---

<div class="post-metadata">

**Author:** ![neerja](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/neerja/32/29814_2.png) [@neerja](https://forum.bubble.io/u/neerja)\
**Post date:** [August 14, 2019, 2:46pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/12 "2019-08-14T14:46:52Z")

</div>

@antony There is no commentary for the video 🙂 as it’s meant to be a quick demo

---

<div class="post-metadata">

**Author:** ![gnelson](https://avatars.discourse-cdn.com/v4/letter/g/6bbea6/32.png) [@gnelson](https://forum.bubble.io/u/gnelson)\
**Post date:** [August 14, 2019, 9:04pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/13 "2019-08-14T21:04:10Z")

</div>

Shuxx

---

<div class="post-metadata">

**Author:** ![josh10](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/josh10/32/82900_2.png) [@josh10](https://forum.bubble.io/u/josh10)\
**Post date:** [August 15, 2019, 4:02am UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/14 "2019-08-15T04:02:00Z")

</div>

@neerja is there any type of validation for the users CSV? I’m just worried about them introducing wildcards into the database.

---

<div class="post-metadata">

**Author:** ![neerja](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/neerja/32/29814_2.png) [@neerja](https://forum.bubble.io/u/neerja)\
**Post date:** [August 15, 2019, 4:20pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/15 "2019-08-15T16:20:40Z")

</div>

@josh10 if it’s a linked data type and there is no match, the field will be left empty on upload. There is no further validation / rules supported at the moment before adding to the database when you upload as csv.

---

<div class="post-metadata">

**Author:** ![Boost](https://avatars.discourse-cdn.com/v4/letter/b/8e8cbc/32.png) [@Boost](https://forum.bubble.io/u/Boost)\
**Post date:** [January 3, 2022, 9:47pm UTC](https://forum.bubble.io/t/csv-upload-within-app-doesnt-support-linked-tables-or-does-it/36911/16 "2022-01-03T21:47:57Z")

</div>

Is there no way to do this on autopilot through API calls without having to do searches through the database? I have found that method unreliable.
