# How do I have a column displaying total numbers?

**URL:** <https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214>\
**Category:** Ask for Help\
**Created:** [August 19, 2022, 9:13am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214 "2022-08-19T09:13:04Z")\
**Posts on this page:** 13\
**Page:** 2

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 20, 2022, 10:57am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/21 "2022-08-20T10:57:53Z")

</div>

Okay, I think I see what is going on.  
Which button adds the new row - is that the Start button?  
It looks like you are adding a new row, but your screen is still attached to the first row, so when you do a set column values it’s going to change the values in the first row of the table, instead of the row you just added.

Anyway, I think we maybe should take a step back, because I think you might be making this more complicated than it needs to be.

Can you tell me a bit more about the purpose of this screen?  
What is it that you are timing, and do you need to keep a permanent record of the time each time you start and stop?

Also, have you looked at the [Stopwatch](https://www.glideapps.com/docs/reference/app-components/stopwatch-component) component?

---

<div class="post-metadata">

**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\
**Post date:** [August 20, 2022, 11:15am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/22 "2022-08-20T11:15:20Z")

</div>

What I wanted to do is this

1-List tab will show all the students profile when clicked on a particular student name \> student profile will be shown ( this is done via list). This screen will have a button that will take the user to a new tab **Timer**. Clicking this tab will mean that the student is ready to start their lesson. Once the button is pressed, the record of student name will be written in **timer** table and user will be brought to **timer** tab

2- In this **Timer** tab. There are 3 buttons starttime/stoptime/reset buttons. Starttime is to start the timer, stop will stop the timer, and reset will clear the screen. Start and stop will input timestamp in the **timer** row. (here I select add row)

The row of num 1 and the row of num 2 are not in the same row. I need it to be in the same row. Trying to record that this time record is for which student. If the row is empty I won’t be able to tell whose time is recorded in the table. (here I selected set column values) ☹

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 20, 2022, 11:19am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/23 "2022-08-20T11:19:33Z")

</div>

> [@prizal](#):
>
> 1-List tab will show all the students profile when clicked on a particular student name \> student profile will be shown ( this is done via list). This screen will have a button that will take the user to a new tab **Timer**. Clicking this tab will mean that the student is ready to start their lesson. Once the button is pressed, the record of student name will be written in **timer** table and user will be brought to **timer** tab

What if that student already has a record in that Timer table? Would you want to use the one that is already there, or create a new one?

Should it be possible to “Go Back” and start the timer for a 2nd student before the first one finishes, or would you only ever time one at a time?

---

<div class="post-metadata">

**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\
**Post date:** [August 20, 2022, 11:33am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/24 "2022-08-20T11:33:39Z")

</div>

![timeraman](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f3745c2e3e9c10d96fd71b193c8fbce8ca90520b.png)

for example here. If you see the row 4 is when i press the button on num 1  
row 123 is what ill get when i press the start in timer tab

answering to the question  
every time we start and stop a timer it should display timestamp of start , stop and duration. also the name of the student it is ment for. everytime we start again it will start a new line.

the record will be completed once the stop button is pressed, or every time the start button is pressed new line will be recorded

recording the start time and stop time also with new row is not a problem in my case. the problem is how do i get the name of student recorded along with the record

pls ignore the blue sketches

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 20, 2022, 12:38pm UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/25 "2022-08-20T12:38:33Z")

</div>

Please have a look at this, and let me know if it does what you are trying to do.

> **[Student Timing](https://student-timing-g87i.glideapp.io)**

It can be copied, so you can make your own copy and study it to see how it works.

---

<div class="post-metadata">

**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\
**Post date:** [August 21, 2022, 4:28am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/26 "2022-08-21T04:28:28Z")

</div>

Thank you so much. looks like just what I want. let me explore a little bit and will surely update.

---

<div class="post-metadata">

**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\
**Post date:** [August 21, 2022, 4:43am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/27 "2022-08-21T04:43:31Z")

</div>

Its almost there but its not there yet.

In this scenario  
If Tamsin login and start timer for Alan, the record will show Alan as subject  
IF Tamsin login and start timer for Tamsin , the record will show Tamsin subject

needed scenario

if Tamsin login and start timer for Alan, a record with info of Tamsin as recorder and Alan as the subject will be shown  
In this case Tamsin is the teacher and Alan is the student

I will have hidden the Tamsin in the list, but in record still won’t have the info such as Tamsin as recorder and Alan as subject

![student](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/f/9f89cd9de7ba93356b4333bea182e9a26d3764b8.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 21, 2022, 8:41am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/28 "2022-08-21T08:41:06Z")

</div>

Okay, I understand.

I made some changes to it, please try now.

> **[Student Timing](https://student-timing-g87i.glideapp.io)**

Note that the Teacher name is only saved if the Teacher is signed-in, otherwise it will appear as “Unknown Teacher”

---

<div class="post-metadata">

**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\
**Post date:** [August 21, 2022, 9:17am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/29 "2022-08-21T09:17:37Z")

</div>

![bravo](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cbda78be1fd66907ef56ab37025e6079ba8dc31a.png)

looks like now i have got a lot of new local students 🤩

Terima Kasih banyak

What does it mean sv \> \*helper  
what does helper table do and how does it work ?

👏 👏 👏

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 21, 2022, 9:42am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/30 "2022-08-21T09:42:40Z")

</div>

The Helper table is (as the name suggests) a “Helper”, or “Working” table. This is something that many of us use in these types of situations. Strictly speaking it isn’t required, but it does help to keep some of the app logic separated from the app data. It will only ever contain a single row, and you will notice that both the “Student” and “Start” columns are [User Specific.](https://www.glideapps.com/docs/reference/basic-columns/user-specific-columns) This will allow multiple teachers to use it at the same time for different students without getting in each others way.

`sv/helper` is a special type of [Single Value](https://www.glideapps.com/docs/reference/computed-columns/single-value-column) column. If you look at the configuration you will see that it looks in the first row of the Helper table, and takes the whole row.

 ![Screen Shot 2022-08-21 at 5.30.20 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c857e31e6b72ec87b601b628548f0824df540224.png)

The purpose of this one is to allow us to set the StudentID in the Helper table when we select a Student from the list. You can see that if you look at the custom action that’s assigned to the Students list:

 ![Screen Shot 2022-08-21 at 5.30.51 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/21febf8ec28d8553147aa2e44d58bff16c4ec4f0.png)

Notice that it does a Set Column Values using the sv/helper column, which means that we are setting values in the first row of the Helper table. We set the values of the two user specific columns. Student is set to the StudentID of the student we just selected, and the value in the Start column is cleared, so that it’s ready to start timing for this student.

---

<div class="post-metadata">

**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\
**Post date:** [August 21, 2022, 10:23am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/31 "2022-08-21T10:23:50Z")

</div>

so much I need to learn and understand

how did u get the student id and row id?  
why is the lock appears next to row id

where can I read much about this? not sure where to start

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 21, 2022, 10:56am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/32 "2022-08-21T10:56:11Z")

</div>

> [@prizal](#):
>
> how did u get the student id and row id?  
> why is the lock appears next to row id

That’s a special kind of column, it gives a unique value in each row. The lock is there to indicate that the values are automatically assigned and cannot be edited.

> **[Row ID Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/row-id-column)**
>
> Generate unique IDs for your rows.

> [@prizal](#):
>
> where can I read much about this? not sure where to start

The Glide Library is a good place to start…

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

---

<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:** [August 22, 2022, 10:57am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/33 "2022-08-22T10:57:04Z")

</div>

Closed on August 22, 2022, 10:57am UTC

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

[Previous page](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214.md?page=1)
