Calculated fields

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
pasbonte
Veteran Member
Posts: 162
Joined: 2013-02-06 09:49

Calculated fields

Post by pasbonte » 2018-06-04 12:26

Hello
I have a table with a field "number of people", can we in a table do the total?
How to put it in my table?
thank you

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Calculated fields

Post by pbottcher » 2018-06-04 13:48

Hi,

can you be a little bit more specific on how you want to do this. You have a table with field "number of people". So do you want to have the sum of this field in another table?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

pasbonte
Veteran Member
Posts: 162
Joined: 2013-02-06 09:49

Re: Calculated fields

Post by pasbonte » 2018-06-04 14:40

Yes I have a field with the number of people, and I want to have the total in the same table (the same table).
MERCI !

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Calculated fields

Post by pbottcher » 2018-06-04 16:51

Hi,

sorry, I still do not get it.

You have a TABLE:

| ID | TEXT | Number of people | Total |
---------------------------------------------------------
| 1 | aaa | 10 | 10 |
| 2 | bbb | 5 | 15 |
| 3 | ccc | 15 | 30 |
| 4 | ddd | 20 | 50 |
| 5 | eee | 30 | 80 |

or do you have a row with the total?


| ID | TEXT | Number of people |
----------------------------------------------
| 1 | aaa | 10 |
| 2 | bbb | 5 |
| 3 | ccc | 15 |
| 4 | ddd | 20 |
| 5 | eee | 30 |
| 6 | total | 80 |
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

pasbonte
Veteran Member
Posts: 162
Joined: 2013-02-06 09:49

Re: Calculated fields

Post by pasbonte » 2018-06-05 06:52

Hello
I want to "just" the total of a column.

| 1 | aaa | 10 |
| 2 | bbb | 5 |
| 3 | ccc | 15 |
| 4 | ddd | 20 |
| 5 | eee | 30 |
| 6 | total | 80 |

|TOTAL: | 160 |

pasbonte
Veteran Member
Posts: 162
Joined: 2013-02-06 09:49

Re: Calculated fields

Post by pasbonte » 2018-06-05 07:16

0506.PNG
0506.PNG (38.92 KiB) Viewed 3752 times
Under the column Number of students

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Calculated fields

Post by pbottcher » 2018-06-05 07:31

Hi,

this can be set in the field definition.
sum.JPG
sum.JPG (36.93 KiB) Viewed 3749 times
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

pasbonte
Veteran Member
Posts: 162
Joined: 2013-02-06 09:49

Re: Calculated fields

Post by pasbonte » 2018-06-05 08:15

I am really a head in the air ..
Thank you

Post Reply