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

It would make the Worksheet field even more useful.

For example, a custom table with two fields, a key and a value:

Phase / Month	Weight
1-01	99.99
1-02	99.88
2-01	77.77
3-02	66.66

The Custom table has a many-to-many relationship field in the Feature card layout.

Extend the formula syntax in a Feature-level worksheet field to pass a Phase / Month value and return the matching Weight?

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

Attach files

Enter a subject

Guest

Reply
| Feb 19, 2020

Thank you for the great response!

0 reply Hide replies