# User updating tables
**URL:** https://community.glideapps.com/t/user-updating-tables/70625
**Category:** Ask for Help
**Created:** [February 8, 2024, 11:38am UTC](https://community.glideapps.com/t/user-updating-tables/70625 "2024-02-08T11:38:01Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 8, 2024, 11:38am UTC](https://community.glideapps.com/t/user-updating-tables/70625/1 "2024-02-08T11:38:02Z")
I am trying to make an app that allows students to enter in data on the plants that they are growing.
There are 10 different plants growing in the garden.
20 students will be accessing the app to record data. Ph levels, temperature etc. After a month of observations and logging data we want to export the data as a growth chart.
Is an editable table the best way to do this?
Kind regards,
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 9, 2024, 12:47am UTC](https://community.glideapps.com/t/user-updating-tables/70625/2 "2024-02-09T00:47:54Z")
I would do it like this:
- Users table: RowID, User email, name, image
- Plants table: RowID, Plant name, description, image
- Plants x Users table: RowID, Plant ID, User ID, Added at timestamp
- Growth table: Plants x Users ID, Added at timestamp, Ph levels, temperature
After a month, you can export data from the Growth table.
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 10, 2024, 10:22pm UTC](https://community.glideapps.com/t/user-updating-tables/70625/3 "2024-02-10T22:22:50Z")
Thank you ThinhDinh. I will give it a go. Just checking that when you say ‘x’ you mean a link them together make a ‘relation’, is that correct?
Ta
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 10, 2024, 11:38pm UTC](https://community.glideapps.com/t/user-updating-tables/70625/4 "2024-02-10T23:38:49Z")
It’s just a table name, I mean it’s a table where you store a combination of one plant and one user on each row.
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 11, 2024, 12:06am UTC](https://community.glideapps.com/t/user-updating-tables/70625/5 "2024-02-11T00:06:27Z")
Ok I have given it a try. 4 tables linked by ID
Thank you
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 13, 2024, 12:18am UTC](https://community.glideapps.com/t/user-updating-tables/70625/6 "2024-02-13T00:18:46Z")
Hi there ThinhDinh
I am actually thinking I am over complicating things. I might just need a form for each plant and the students update the forms. Would this work?
ta
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 13, 2024, 2:23am UTC](https://community.glideapps.com/t/user-updating-tables/70625/7 "2024-02-13T02:23:09Z")
That sounds like a lot of work.
Wouldn’t you be better with a single form where the Students select the Plant from a list?
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 13, 2024, 2:53am UTC](https://community.glideapps.com/t/user-updating-tables/70625/8 "2024-02-13T02:53:38Z")
Yes, selecting the plant from a list would be perfect, I am just having trouble with the new height data etc pushing into the row in the existing ‘plant’ form.
I have been trying to make the column ‘Height’ in ‘Plant’ table relational so that when submission happens a new row is made. However data keeps being propagated in new columns not under row that belongs to that plant.
Humm
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 13, 2024, 3:00am UTC](https://community.glideapps.com/t/user-updating-tables/70625/9 "2024-02-13T03:00:02Z")
Are you able to share a couple of screen shots?
That will make it easier to visualise and perhaps provide some guidance.
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 13, 2024, 3:06am UTC](https://community.glideapps.com/t/user-updating-tables/70625/10 "2024-02-13T03:06:49Z")
Yep on it now.
Thank you so much
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 13, 2024, 3:38am UTC](https://community.glideapps.com/t/user-updating-tables/70625/11 "2024-02-13T03:38:08Z")
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 13, 2024, 3:48am UTC](https://community.glideapps.com/t/user-updating-tables/70625/12 "2024-02-13T03:48:01Z")
I think you need a separate table to record your growth logs.
This table should have the following:
- PlantID
- Date/time
- Height
- Soil Moisture
- PH
Then instead of adding rows to your Plants table, the form should add rows to your Logs table.
Once you have it setup that way, you can create a multiple relation column in your Plants table that matches the PlantID in your Logs table, then use that relation as the source of a collection on you Plant details screen. This will give you a log for each plant. You could also quite easily create that line chart in Glide.
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 13, 2024, 3:49am UTC](https://community.glideapps.com/t/user-updating-tables/70625/13 "2024-02-13T03:49:53Z")
Ok this is great. I will give it a go now.
Talk soon,
Thanks again
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 13, 2024, 4:06am UTC](https://community.glideapps.com/t/user-updating-tables/70625/14 "2024-02-13T04:06:20Z")
Should I be using Form Elements to allow users to update logs table?
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 13, 2024, 4:12am UTC](https://community.glideapps.com/t/user-updating-tables/70625/15 "2024-02-13T04:12:35Z")
Thinking ‘submission’ might be the way to go as new data when entered into Logs over writes old data. Now trying to set up the relations.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 13, 2024, 4:22am UTC](https://community.glideapps.com/t/user-updating-tables/70625/16 "2024-02-13T04:22:16Z")
Rather than adding input components directly to the details screen, you should add a Button, and set the action on the Button to “Show Form Screen”. Then set the Logs table as the target of the Form screen. This will have the effect of adding new rows to your logs table, which is what you need.
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 13, 2024, 10:27am UTC](https://community.glideapps.com/t/user-updating-tables/70625/17 "2024-02-13T10:27:15Z")
Ok great, thank you so much for this idea. I am getting there. The button is working, action is creating new rows and data is arriving into the Log table, however the log table is capturing new data for all the plants, not individual plants.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 13, 2024, 10:38am UTC](https://community.glideapps.com/t/user-updating-tables/70625/18 "2024-02-13T10:38:03Z")
In your Data Logs table, you need a column for PlantID. This column should be populated when the form is submitted. The way to do this is by using a [Column Value](https://www.glideapps.com/docs/reference/values/column-values#column-values-in-submission-screens).
Once you have that, you can modify that relation column so that it matches the PlantID with the RowID in your Plants table. Make sure it is a _single_ relation. Then you can fetch the Plant name for each row by adding a Lookup column that targets the relation column.
---
### Author:  [@Richard\_H](https://community.glideapps.com/u/Richard_H)
#### Post date: [February 13, 2024, 6:59pm UTC](https://community.glideapps.com/t/user-updating-tables/70625/19 "2024-02-13T18:59:26Z")
Ah, so close. Thank you so much Darren. I am so so close. It keeps adding an extra row so that the new entries are not lining up. There is a gap between each of them, I think it might be that one of the relations is ‘match many’, thoughts?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 13, 2024, 7:04pm UTC](https://community.glideapps.com/t/user-updating-tables/70625/20 "2024-02-13T19:04:51Z")
Don’t use the forms On Submit action to add a row. The form already adds a row. Adding a secondary Add Row action On Submit is redundant. You should be able to add the appropriate components to pass values through the form. You do not need to use On Submit.
[Next page](https://community.glideapps.com/t/user-updating-tables/70625.md?page=2)