I’ve found that it is possible in calculated field link to a child for aggregate function. It is work with number, or counting string, but is there a way to obtain a string from a child field with a join relation and put in a calculated field?
Es. [TOTAL::Articoli::Prezzo] Articoli is a child form and prezzo is a number child field it is working summing one or more child row linked
But Is it possible simply point to a string value of a child field es [Articoli::Price] and insert the string in a calculated field
Thank you in advance
Hi Simone,
Not with the Join Link Type option. This is because the Join Link Type behaves similarly to the Many to Many Link Type. That means that on both sides of the relationship there are multiple records. As opposed to a One to Many Link Type where one side of the relationship has only one record and the other side of the relationship has many records. So for a Join Link Type you can only get an aggregate calculation for the selected field.
Hope that makes sense.
Thanks,
Brendan
.
