Using Custom Equations to sum number field from a Custom Table

• 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.

  

  image.png

  

  image.png

  image.png

  Open full size

  image.png

  Open full size

  image.png image.png

• Comments 0
• Votes 13