# Photo Uploader (Multiple Inputs to One Column Creating New Rows)

**URL:** <https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241>\
**Category:** Ask for Help\
**Created:** [August 19, 2022, 3:21pm UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241 "2022-08-19T15:21:49Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![patrick.roomlift](https://avatars.discourse-cdn.com/v4/letter/p/65b543/32.png) [@patrick.roomlift](https://community.glideapps.com/u/patrick.roomlift)\
**Post date:** [August 19, 2022, 3:21pm UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/1 "2022-08-19T15:21:50Z")

</div>

Hi all.

So, we’ve created a photo uploader page that maps to seven “customer photo” columns next to the Shopify order of our customers in an Airtable.

 ![Screen Shot 2022-08-19 at 11.19.24 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e482edf28bdb9ec8f38985b4f3c3caa870e7a9b4.png)

I want to create a photo uploader that can write several images to the same column as new values each time, in a one-to-many relationship. But Glide puts this as an issue saying you cannot write images to the same column — it’s assuming I want all the photos to be in the same row, not to create new ones. Any way to do this?

 ![Screen Shot 2022-08-19 at 11.20.07 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bbf0730f7a3414fe66c5d802430f79ef1fca8fc2.png)

It would also be necessary to have the photo write to multiple Airtable columns (order number, ID) that are associated with the order they’re uploading photos to.

 ![Screen Shot 2022-08-19 at 11.20.51 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/136ad82e3ebf6de982c559aa079f42e170756d9d.jpeg)

Let me know if you need any more explanation – happy to give context. Thanks!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 20, 2022, 12:19am UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/2 "2022-08-20T00:19:52Z")

</div>

Firstly, gotta emphasize the fact that we can’t upload multiple photos at once, so you have to upload 1 by 1.

If you want images on another table, you can use a form to write them one by one to that table.

If you want 7 images on the same row, you can use 7 image pickers in a single form.

I know it’s not great, but that’s the limit for now.

---

<div class="post-metadata">

**Author:** ![patrick.roomlift](https://avatars.discourse-cdn.com/v4/letter/p/65b543/32.png) [@patrick.roomlift](https://community.glideapps.com/u/patrick.roomlift)\
**Post date:** [August 20, 2022, 12:36am UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/3 "2022-08-20T00:36:33Z")

</div>

Thanks. When I’ve tried to put 7 image pickers in a single form, it won’t let me write them all to the same column as unique values. That’s what we’re looking for – all images to write to one column as new values, and pull the customer ID with it, as opposed to making 7 columns for 7 image pickers.

Can you do that one-to-many relationship in Glide?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 20, 2022, 12:40am UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/4 "2022-08-20T00:40:49Z")

</div>

There’s no way to write 7 images to one column. I imagine the best way for you is to create a new table, but then you would have to upload images one-by-one, and do it 7 times.

Sort of like this:

Orders table: RowID - Customer ID - Order Info  
Images table: Order ID - Image Link

Then you can relate the rowID from Orders to Order ID in Images. Does it work for you?

---

<div class="post-metadata">

**Author:** ![patrick.roomlift](https://avatars.discourse-cdn.com/v4/letter/p/65b543/32.png) [@patrick.roomlift](https://community.glideapps.com/u/patrick.roomlift)\
**Post date:** [August 20, 2022, 1:06am UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/5 "2022-08-20T01:06:55Z")

</div>

Hi,

Thanks for continuing to work with me here. How do I relate the row ID of one table to a column in another table?

---

<div class="post-metadata">

**Author:** ![DillanMartinez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dillanmartinez/32/46254_2.png) [@DillanMartinez](https://community.glideapps.com/u/DillanMartinez)\
**Post date:** [August 20, 2022, 1:13am UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/6 "2022-08-20T01:13:29Z")

</div>

Hello, I would like to know if the solution you are looking for is something similar to this?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e29db44bd609aa53a67efe695cbdba5758e8194.png)  
the list column has a collection of all uploaded images in a single row.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 20, 2022, 2:36am UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/7 "2022-08-20T02:36:31Z")

</div>

You submit the rowID alongside the image when you submit the form.

> **[Forms](https://www.glideapps.com/docs/guides/other/forms)**
>
> Control how you allow users to contribute to your app's data

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0d4c4107753c9d4e1c9a96953e3a6be037d26b6b.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/33e8a0e37e80b8c631ea3d159cb7d11c3f233749.jpeg)

Add that as a special value in the form.

---

<div class="post-metadata">

**Author:** ![patrick.roomlift](https://avatars.discourse-cdn.com/v4/letter/p/65b543/32.png) [@patrick.roomlift](https://community.glideapps.com/u/patrick.roomlift)\
**Post date:** [August 20, 2022, 11:24pm UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/9 "2022-08-20T23:24:34Z")

</div>

That could be one workaround, but ideally, we’d like each image to create a new row in the same table, not a batch of multiple photos in one row.

---

<div class="post-metadata">

**Author:** ![patrick.roomlift](https://avatars.discourse-cdn.com/v4/letter/p/65b543/32.png) [@patrick.roomlift](https://community.glideapps.com/u/patrick.roomlift)\
**Post date:** [August 20, 2022, 11:25pm UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/10 "2022-08-20T23:25:02Z")

</div>

Thanks, @ThinhDinh. One additional question. How can the user upload more than one image to an image picker? I.e. How can the row automatically create a new row for each image, allowing the image picker to refresh and let them upload the next image?

It seems like that’s how they set it up [here,](https://www.glideapps.com/blog/photo-uploader-with-airtable-and-glide) as in their example table, different users have submitted several photos each to the same uploader, but I don’t see an explanation.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 21, 2022, 12:40am UTC](https://community.glideapps.com/t/photo-uploader-multiple-inputs-to-one-column-creating-new-rows/47241/11 "2022-08-21T00:40:38Z")

</div>

> [@patrick.roomlift](#):
>
> How can the user upload more than one image to an image picker?

No, not possible.

> [@patrick.roomlift](#):
>
> How can the row automatically create a new row for each image, allowing the image picker to refresh and let them upload the next image?

I think you can have a custom form for that.

> [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

Have an image picker pointing to a user-specific column. Have a button to add a new row in the “Images” table, then clear the image picker user-specific column to prepare for the next entry. That way you can stay on the same screen.

> [@patrick.roomlift](#):
>
> It seems like that’s how they set it up [here,](https://www.glideapps.com/blog/photo-uploader-with-airtable-and-glide) as in their example table, different users have submitted several photos each to the same uploader, but I don’t see an explanation.

Pretty sure it’s just the form here, they just submit it multiple times.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fb3c287d2c387239c53e032f1d2bde446148c09c.jpeg)
