Calculation Feature: Figure from Subform

[q]

Hi Brendan,

after using tapforms on a daily basis now and loving it, there’s a feature I miss.

I use quite a lot of subforms to record more detailed data for my more general daily accessed main forms.

I’d love to have a calculation field, that could access the calculations that are available for the respective subforms.

I.e. in my subform “travel”, I can adjust calculation settings for that subform, which changes what will be shown there (average of field x, total of field y, …).

It would be great to have a calculated field in the parent form, for which one could chose the target subform and the kind of calculation.

How do you feel about that feature?

Thanks and enjoy!

[Brendan]

Hello Q,

I’ve been contemplating adding in the same calculation to the parent field that you would see at the bottom of the list of child records for that field. The reason being is that the field selection and calculation type is already stored on the form object itself, not on the field.

Thanks,

Brendan

[q]

Hi Brendan,

that would be great, any chance we’ll get that feature soon?

Best,

q

[Brendan]

Hi Q,

I added this for the next update. Don’t have an exact ETA on it, but hopefully in a month. I’m working on iCloud sync too so I want to get that working first and release it all at the same time.

Thanks,

Brendan

[Brendan]

Just want to qualify it though… it’ll display exactly the same value from the child list view, but on the parent’s field (the one you tap on to see the child records).

Thanks,

Brendan

[Marisette]

Hi, this is just what I’m looking for, except I need to be able to use it in a calculation, not just display it (though that would be a good start).

Here’s a simple example:

Vacation Available for Year

— Year

— Available hours

— Vacation Time — linked, one to many, consisting of

—- Date

—- Hours (calculating total)

—- Note

When I click on the Vacation Time, I see the calculated value of “Total (Hours): 40”

I want to add a field to the parent “Vacation Available for Year” record that calculates the hours left, which would be the “Available hours” – “Total (Hours)” from the linked “Vacation Time” records.

If you could provide that soon, I would be delighted!

[q]

Hey Brendan,

just wanted to say thanks for adding the feature!
It is great :)

Best,
q

[Author]

Posts