# Data/Table Structure - comment like entries

**URL:** https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788
**Category:** Ask for Help
**Created:** [October 28, 2022, 12:50pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788 "2022-10-28T12:50:04Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Hannes\_1234](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hannes_1234/32/49610_2.png) [@Hannes\_1234](https://community.glideapps.com/u/Hannes_1234)
#### Post date: [October 28, 2022, 12:50pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788/1 "2022-10-28T12:50:04Z")

</div>

Hey Commuity! I have the following case to solve concerning data  
structure for my app project:  
I have:  
1 ) Map/List with entries that are entered through a form by users (a  
surf spot). —\> every entry gets one row in the main data table named  
‚spots‘. That is all set.

I want:  
2 ) Users are on the detail view of entry (surf sport) and can add  
foto/text to that detail page afterwards (fotos of their surf session -  
if it was only text, I could use the comment function. But I want to  
enable foto/video upload).  
Therefor I need a new form button & form.

The question I have:  
a) Does that form write into a new table? If yes, how do I link all  
entries in the new table to a specific row in the main data source ’spots’?

b) Or can I write those entries directly in the main table in the row of  
the specific entry?

c) Frontend Display: would you use an inline list to display those  
entries on the detail page?  
How do I structure such a behavior?

thanks for your help.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 28, 2022, 1:03pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788/2 "2022-10-28T13:03:44Z")

</div>

I would create a separate images folder. Especially if you have an open ended number of images that could be added to a spot.

- First create a RowID column in your spots table.
- Add a form on your spots detail screen to add a photo and have it write to an images table. Add a column value component to the form to retrieve that spot ID and pass it through the the form. Now when you add images, it should include the row id of the spot.
- In your spots table, create a multiple relation linking it’s RowID to the spot ID stored in the images table.
- This relation can be the source of an inline list that will display the images.

---

<div class="post-metadata">

### Author: ![Hannes\_1234](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hannes_1234/32/49610_2.png) [@Hannes\_1234](https://community.glideapps.com/u/Hannes_1234)
#### Post date: [October 28, 2022, 7:42pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788/3 "2022-10-28T19:42:30Z")

</div>

**Thanks a lot for your answer.**

- I created a rowID in the spots table ☑

- added a form to the spots detail screen and added the rowID picker ☑—\> is that the correct one?  

- Do I have to add another column for the spot ID in the images table? if yes, as a text column?  

- in the properties of the rowID picker component it shows a column selection dropdown. The columns there are only the columns from the spots table. which one is to choose? Any?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 28, 2022, 7:48pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788/4 "2022-10-28T19:48:30Z")

</div>

> [@Hannes\_1234](#):
>
> added a form to the spots detail screen and added the rowID picker ☑—\> is that the correct one?

Yes, that looks correct.

> [@Hannes\_1234](#):
>
> Do I have to add another column for the spot ID in the images table? if yes, as a text column?

Yes, you need somewhere to put the Spot ID in the images table. What you have looks good, just make sure that “Value from Screen” Row ID is writing to that Spot ID column. A type of ‘text’ is fine.

> [@Hannes\_1234](#):
>
> in the properties of the rowID picker component it shows a column selection dropdown. The columns there are only the columns from the spots table. which one is to choose? Any?

When you configure your form, make sure that it’s pointing to the images table. That’s the table it will write to. Looks like you currently have your form writing to the spots table.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/84d3f85847eae0e81d5f39f3872e6db36a5aaa6c.png)

---

<div class="post-metadata">

### Author: ![Hannes\_1234](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hannes_1234/32/49610_2.png) [@Hannes\_1234](https://community.glideapps.com/u/Hannes_1234)
#### Post date: [October 28, 2022, 8:00pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788/5 "2022-10-28T20:00:15Z")

</div>

I seem to be unable to find where you can set where the form will write to. Where do I find that setting?

I clicked on the form button and then find the menu but without the option to choose the destination sheet (see below).

 ![Bildschirmfoto 2022-10-28 um 21.57.06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc39f6492e4c723ad8d196bbbd585bddf8d5930a.jpeg)

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 28, 2022, 8:02pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788/6 "2022-10-28T20:02:36Z")

</div>

Click on the form button to go into the form. When the form opens, don’t click on any components. What you see on the right hand side should be the settings for the form.

---

<div class="post-metadata">

### Author: ![Hannes\_1234](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hannes_1234/32/49610_2.png) [@Hannes\_1234](https://community.glideapps.com/u/Hannes_1234)
#### Post date: [October 28, 2022, 8:05pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788/7 "2022-10-28T20:05:57Z")

</div>

🤦🏽‍♂️ got it. thanks

---

<div class="post-metadata">

### Author: ![Hannes\_1234](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hannes_1234/32/49610_2.png) [@Hannes\_1234](https://community.glideapps.com/u/Hannes_1234)
#### Post date: [November 2, 2022, 6:29pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788/8 "2022-11-02T18:29:36Z")

</div>

quick update: I followed your instructions and it works just fine. thanks a lot for your support!

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [November 3, 2022, 6:30pm UTC](https://community.glideapps.com/t/data-table-structure-comment-like-entries/52788/9 "2022-11-03T18:30:33Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
