RELATED IDEAS
Using Custom Equations to sum number field from a Custom Table
A custom table is used to track individual savings / cost elements attached to a feature.
The request is to be able to create a feature custom field whose equation sums the cost elements in the related custom table records.
| Release time frame | 3 months |
-
ADMIN RESPONSEDec 19, 2019
It is now possible to reference custom table data within record worksheets. This includes the ability to reference master-detail custom fields as well.
To reference a master-detail custom field on a record, use the following syntax:
self.custom.<master-detail custom field API key>[].custom.<api key for field on custom table>
Let's say you have the following configuration for a feature custom field layout:
Custom table
You have a custom table capturing the savings and cost.
Field
Type
API key
Type
Text field
type
Savings
Number field
savings
Cost
Number field
cost
Master-detail custom field
You also have a master-detail's custom field connected to the custom table above. The master-detail's custom field API key is
budget.Worksheet
Feature
The worksheet is now configured to calculate values added to the master-detail custom field.
Please reach out to us at support@aha.io if you have any questions.
