Calculate a table Column's Total

Permalink Browser Info Environment
Can you create a field type that calculate and sum's up a column in a table that also uses Repeatable/reoccurring items?

it needs to recalculate every time a new row is added.
It also needs to be able to calculate multiple columns in the same table.

Type: Pre-Sale
Status: Resolved
shatay
View Replies:
ramonleenders replied on at Permalink Reply
ramonleenders
Hi there,

Can you give me examples of how this is used (frontend)? Do you expect to do something in the form also as a user adding a block with a field using this field type? Not sure if I understand correctly how you want this implemented, an example will give me more insight into your requirements!

Kind regards,

Ramon

concrete5 Environment Information

# concrete5 Version
Core Version - 8.2.1
Version Installed - 8.2.1
Database Version - 20170802000000

# concrete5 Packages
Block Designer (3.2.0), Block Designer Pro (3.0.0), Quick Tabs (1.0)

# concrete5 Overrides
single_pages/login.php

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
cgi-fcgi

# PHP Version
5.6.37

# PHP Extensions
bcmath, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, fileinfo, filter, ftp, gd, hash, iconv, imap, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, openssl, pcntl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, readline, Reflection, session, SimpleXML, sockets, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 512M
post_max_size - 32M
sql.safe_mode - Off
upload_max_filesize - 400M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.