Is there a way to get aggregated data from an axillary association table?

Ask the community Automations and Integrations
#1

@wmchristensen has asked:

Is there a way to get aggregated data from an axillary association table?

#2

Hey there @wmchristensen

It’s not possible right now, but you can submit it as a suggestion in the Ask for a feature category(Ask for a Feature - Jestor Community). We have a very similar trick (aggregates values from connected records and sums/averages them), and having a similar one for texts by concatenating may be useful for other users as well!

EDIT: I should note that I’m talking about no-code. In low-code this would be fairly easy with loadData().

#3

Is there a place I can find docs on how to do it with low code?

#4

Here’s our doc @wmchristensen Native Methods

#5

Is the best way to do this then to run a low code function use loadData and Update?

#6

@Fernando is the best way to do this to run a low code function in a trick? Use loadData to pull in the data then and Update to push it into a text field?

#7

Hey @wmchristensen

If you’re already using low-code by functions, I feel like the best way to do this would be through low-code triggers in the table itself, unless you want to use this information in following actions in a trick.

#8

Is there a quickstart guide for Lowcode I can follow? I’d love to learn this.

#9

Hey @wmchristensen

For Jestor’s own methods and low-code features, you could use these docs:

Development Area: Accessing the Developer Area
Things to be aware before starting: A simple guide for your first automation
This one teaches Jestor.loadData(), which you’d be using: Native Methods

The code itself, though, would be more of a PHP thing than Jestor.