Sum items in a gallery that updates live

Like (1) Share

Report

Posted on 10 Jan 2022 02:41:22 by Lewy

Hi all,

I need to add a sum column that updates as the user enters data into the gallery. Ideally once the user add new rows and enter time I would like this to update much like an excel column cell.

For example the monday column has a text box with formula in it

Sum(galleryTimeCard.AllItems,Mon)

This sums the values in the monday column but only once the output is patched. I need feedback before any patch is happened.

Summing after a patch to collection is not ideal.

The totals summing for each day currently sit outside the gallery.

Screenshot 2022-01-10 153924.png

Categories:

General Questions

All responses (4)

Answers (1)

AJ_Z 3,711 Super User 2024 Season 1 on 10 Jan 2022 at 03:23:49

Like (0)

Report

Re: Sum items in a gallery that updates live

No worries @Lewy I am happy to help wherever I can and thanks for double checking the gallery
Lewy 34 on 10 Jan 2022 at 03:14:31

Like (1)

Report

Re: Sum items in a gallery that updates live

I have figured it out the the gallery was incorrect hence the issue. will mark as correct thanks
Lewy 34 on 10 Jan 2022 at 03:13:27

Like (1)

Report

Re: Sum items in a gallery that updates live

ThanksAJ_Z
it appears to work but the value changes to match the number I have just edited and is not the sum of all the columns.
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on 10 Jan 2022 at 03:08:04

Like (1)

Report
Re: Sum items in a gallery that updates live

what is the name of the mon text input as we can reference that?

e.g.
Sum(galleryTimeCard.AllItems,Value(MonTextInput.Text))