Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jun 04, 2019 12:19 PM
Hi, I have a database set up with multiple tables.
Set up like this
Person1 (Information in one table) gets 5 Linked Entries in another table
How can I get these linked records to sum in the table with the first table
Jun 04, 2019 04:24 PM
Hi there!
Not sure what you’re trying to sum up, but…
If you only want to count how many linked records there are for a particular person, you can use the Count field type. Otherwise, you’ll likely want to use a Rollup field.
Add a field on the first table, point it at the field on the second table that you want to sum up, then use the formula:
SUM(values)
Hope that helps!