Status Shipped
Categories Releases
Created by Guest
Created on Apr 24, 2019

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 RESPONSE
    Dec 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.

  • Attach files