Using fields on related form

[Tim Flick]

I want to do a calculation in the main form using fields from a related form

Thanks

[Brendan]

Hi Tim,

Sure, you can do that. But only in aggregate. Just reference your related fields in your formula and Tap Forms will create the proper field tag that includes the name of the form you’re linking to.

For example:

[TOTAL::Account::Amount]

Thanks!

Brendan

[Tim Flick]

on the child form I have five time fields that I want to divide by five and show the result on the parent form. I then want to take that average to divide into distance traveled to give me a yards per second

Thanks

[Tim Flick]

I guess I could use the aggregate total and then create another calculated field to compute the average and then use that to give me a yards per second

[Tim Flick]

I tried it that works after I carry over the total from the child form. Then I can manipulate that on the parent form

[Brendan]

You can also use AVG instead of TOTAL if you want the average of a set of values from a field in the child record. Tap Forms will ignore null values in the AVG calculation.

[Tim Flick]

Ok the problem I’m having now is when I add to an existing reord or create a new one the calculated fields don’t show new values

[Tim Flick]

It only works if I go back and save each formula which causes a recaculation

[Tim Flick]

Is the only way to do this is to go to the list view and pull down from the top

[Author]

Posts