Search found 2 matches

by csultan
2020-02-12 09:53
Forum: Advanced Customizations > Others
Topic: Personal budget app - calculated fields (totals)
Replies: 4
Views: 313

Re: Personal budget app - calculated fields (totals)

Hi, this is the statement for month=1 (it seems that calculated sum(...) is for all records in sumarize table ("centralizator" in my case) [ trazactii = transactions table centralizator = sumarize table an = year categ = category ] SELECT sum(tranzactii.tr_suma) FROM tranzactii, centralizator WHERE ...
by csultan
2020-02-10 07:59
Forum: Advanced Customizations > Others
Topic: Personal budget app - calculated fields (totals)
Replies: 4
Views: 313

Personal budget app - calculated fields (totals)

Hi guys! I'm a newbie in programming and i'm trying to work with AppGini for a personal budgetting app, maybe you can help me with this issue: I have a transactions table (id, transaction date (year, month), category_id, ammount, details) but also i have a summarize table (id, year, category_id, and...