Extend Worksheet syntax to enable lookup many-to-many Custom table values

• ADMIN RESPONSE

  Feb 19, 2020

  It is now possible to reference custom table data within record worksheets. This includes the ability to reference many-to-many custom fields as well.

  To reference a many-to-many custom field on a record, use the following syntax:

  • self.custom.<many-to-many 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 identical to your example:

  

  Master-detail custom field

  You also have a many-to-many custom field connected to the table above. The API key for this many-to-many field is weight. This allows you to tag phases/months.

  

  Worksheet

  Your worksheet equation might look like this...

  

  Result

  In practice, this would work something like this.

  Note - the first row isn't needed. We just included it in this example to illustrate how the lookup works.

  

  We hope this helps. Please let us know at support@aha.io if you need any assistance setting this up.

  

  image.png

  

  image.png

  

  image.png

  

  image.png

  image.png

  Open full size

  image.png

  Open full size

  image.png

  Open full size

  image.png

  Open full size

  image.png image.png image.png image.png

• Comments 1
• Votes 2