How to use fields from linked form in calculation field

[Vit Vit]

Hello,

i have two forms.
Form_A fields:
– product_id (N)
– name (T)
– count (N)
– calc (calc)
– link (link to form) – join – product_id AND product_id

Form_B fields:
– product_id (N)
– color (T)
– price (N)
– type (T)

I try use fields from Form B in calc field of Form_A
But I can not insert fields. TapForms insert only functions Count or Total.
Any of corrections in formula – I loose blue box under function.

How to use formula in calc field ???
For example: [Form_A.count] * [Form_B.price]
Or “result is: “+[Form_A.name] + ” ” + [Form_B.color]

Thanks for help

[Sam Moffatt]

You can’t use a calculation field on Link to Form fields when the field could have multiple records contained within it. This is why you’re seeing the aggregation functions being used. If you are on the other side of a 1:M, then you can include values because there is only one ancestor however every other type and direction could have multiple values that need to be aggregated.

A script field has a more control over what you can do at the cost of more coding, it should do what you need to achieve.

[Author]

Posts