Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Calculation between two linked forms
Tagged: Calculations, crash, field, linked
- This topic has 33 replies, 14 voices, and was last updated 7 years, 6 months ago by Brendan.
-
AuthorPosts
-
July 22, 2014 at 8:53 AM #10542
Antoine FlapParticipantHi Brendan,
Great work!
I’ve been trying to make some calculations in a child form with values fetched and totaled from a parent form, to no avail…
What I’m trying to do :I have a parent form witch lists all the housings I have on sale. Each of them has a different price.
My child form needs to calculate ratios from the total of all these prices…Don’t know if that is really clear.
thanks in advance for your answer!
Cheers
Antoine
July 22, 2014 at 5:30 PM #10544
BrendanKeymasterHi Antoine,
Child forms don’t have access to the fields from their parent, so you won’t be able to create a formula in a Calculation field which references fields in the parent. Nor can parent forms reference the fields from child forms. A form can only reference the fields of itself. I’m very sorry for that.
Thanks
Brendan
January 23, 2015 at 5:21 AM #12778
Grey DraneParticipantIs this something that may be possible in the future?
I ask because I’m trying to build a project tracking and billing database. I have a client form, a project form (one-to-many child of Clients), and a task form (one-to-many child of Projects). I’d ideally like to send “multi-project” invoices to my clients at the end of each month (directly from Tap Forms), but maybe this isn’t going to be possible without the ability to total the task values into the Projects form (and then calculate the sum of the project totals)?
Or is there some other solution/workaround?
Cheers,
GreyJanuary 23, 2015 at 5:45 PM #12781
BrendanKeymasterHi Grey,
There’s no workaround other than to do it manually by adding a separate field to your parent form. Then you could just copy the total from the bottom of the Link to Form field.
But it’s definitely something I want to do to enhance the Calculation engine. Something like [Child Form:Total(Amount)]. Don’t try this though. It’s just a though and hasn’t been implemented.
Thanks,
Brendan
January 24, 2015 at 12:19 AM #12783
Grey DraneParticipantOK, thanks. I’ll play around with it a bit and see what solution I can come up with. I may end up exporting the data for invoicing, though.
Cheers,
GreyJanuary 29, 2015 at 7:30 AM #12841
Vladimir GlazunovParticipantHi, Brendan,
Impossibility of exchanging data between forms is a real trouble in building database with a few financial calculations ((( I have finished the structure of my base in 30 minutes (it’s really very easy!!!), all movement of clients, contracts, linked payments and rewards are working, but I can’t calculate accepted or estimated payments for selected contract or seller ( May be you have seen such structure before and have idea how can I solve this problem?Sincerely, Vladimir
January 29, 2015 at 12:24 PM #12842
BrendanKeymasterHi Vladimir,
The best you can get is to display a calculation at the bottom of the list of records (including linked records). You do that by setting the Calculation Type field property for all the fields that you want to show that calculation for.
So if you were displaying a seller and you saw their list of contracts, then you could have Tap Forms display a total of all the contracts just for that seller.
Thanks,
Brendan
March 9, 2015 at 10:31 AM #13126
Dominique PIERREParticipantBrendan,
you mentioned
“Child forms don’t have access to the fields from their parent, so you won’t be able to create a formula in a Calculation field which references fields in the parent. Nor can parent forms reference the fields from child forms. A form can only reference the fields of itself. I’m very sorry for that.
But it’s definitely something I want to do to enhance the Calculation engine. Something like [Child Form:Total(Amount)]. Don’t try this though. It’s just a though and hasn’t been implemented.”I just decided to start switching from Bento to Tap Forms, which I find interesting. But the ability to access to the content of any field in a linked form is really needed. It s very very convenient for proceeding with calculation taking into account values that are located in the liked form, or to automatically assign content to fields, using information from the linked form.
You mentioned that this is something you definitely want to do. Would you have any idea about when this could be available.
Thanks for your answer.
March 9, 2015 at 6:31 PM #13128
BrendanKeymasterHi Dominique,
I do not. Sorry. I’m currently very busy working on Dropbox sync at the moment and haven’t been able to look into this yet.
Thanks,
Brendan
March 15, 2015 at 1:12 PM #13155
Dominique DelcomminetteParticipantHi,
I will second this feature request. Would be wonderful for invoicing, and a lot of reports.
August 20, 2015 at 2:36 PM #14481
Fabien EspicParticipantHi Brendan,
I would be very interested by this feature. Do you have time to make any progress?
Regards,
FabienAugust 20, 2015 at 3:23 PM #14483
BrendanKeymasterHi Fabien,
No, I haven’t had time to work on this. After my big work on adding the Dropbox Sync API to Tap Forms, Dropbox decided to deprecate the Dropbox Sync API, so I’ve been working on a big migration to Couchbase. It has touched every part of Tap Forms and is a very big job for me. But I’m making great progress on that at the moment. I just haven’t had the time to enhance the Calculation engine with this ability yet.
Thanks,
Brendan
August 24, 2015 at 6:40 PM #14515
RonlangaraParticipantHi Brendan
Just another vote for the need to add calculated field capability between parent:child forms as soon as possible.Regards,
RonOctober 26, 2015 at 6:05 AM #15082
guardajoiasParticipantOne more vote! This, and global variables,are key features! Thanks in advance!
Regards,
February 29, 2016 at 9:41 AM #16027
rafvalParticipantHi Brendan
Just another vote for the need to add calculated field capability between parent:child forms as soon as possible.Regards,
September 18, 2016 at 4:26 AM #19610
Zsolt SzékelyParticipantHi,
I have bought the 5th version of Tap Forms and I was very unhappy because the calculation between two forms is not solved. Dear Brandon please try to find free time to implement this function to the version of iOS. The Tap forms is a really great app but without more complete calculations it looses so much from its charm.
Could you tell more about when can you solve this issue?
Many thanks,
Zsolt
September 18, 2016 at 12:21 PM #19613
BrendanKeymasterHi Zsolt,
I understand the need and demand for it, but I have no specific timeline for when I can write this function. Sorry.
Brendan
September 30, 2016 at 12:57 PM #19865
RonlangaraParticipantBrendan
As there is no timeline for adding calculations based on child data is there a timeline on fixing the bug in TF5 for IOS that does not display the total from a child field in the left hand column summary of a form? I had emailed you about this before and you were going to look into it. Hope that at least this can be fixed soon as without it I can’t use TF5 and have to stay with the previous version on mac and iPad. I just did a new install of the IOS version and migrate of the data with latest version and it still did not work.
Regards,
RonSeptember 30, 2016 at 4:05 PM #19870
BrendanKeymasterHi Ron,
I’m very sorry for this. Can you please email me a screenshot of the previous version of Tap Forms so I can see what it is that you need in Tap Forms 5? My apologies if you sent one already before.
October 2, 2016 at 7:40 AM #19879
scneophyteParticipantJust in case Brendan is not sick yet of votes for this feature request:
+1 from me!
October 2, 2016 at 8:05 AM #19880
umberto tParticipantAlso for me, Brendan!
December 11, 2016 at 5:09 AM #20595
Ivan HermanParticipantI saw this thread and, actually, there is something I do not understand. I tried to do what others on the thread (I believe) tried to do: on form A I have entries with numerical values; on form B I use the ‘link to form’ field to get specific records and I would like to take, say, the sum of values in a column. The strange thing is that there is something called ‘calculation row’ (there is a small sigma sign underneath the table to switch that off and on) and, furthermore, on the online manual it shows an example where that entry would actually contain the sum as I wanted. However… I have absolutely no idea how to set the formulae for that calculation row. Did I miss something in the manuals or is it something that is not (yet) implemented in the first place?
December 11, 2016 at 11:17 AM #20601
BrendanKeymasterHi Ivan,
Go to the Linked Form and click on the Form button in the toolbar. Then the Fields tab. Then select your Number field. Then click on the Summary Calculation popup button to choose how you want the calculation. You can choose Total, Min, Max, and Avg.
December 12, 2016 at 1:10 AM #20610
Ivan HermanParticipantBrendan,
thank you, it works indeed.
May I suggest that you add this information somewhere in the manual? It is not very intuitive, at least for me, that this is an information you have to set in the linked form and not in the form that links from.
thanks again
December 20, 2016 at 4:00 PM #20654
RonlangaraParticipantBrendan
Have you had a chance to see why the linked form Total does not show up in the Parent Form list on IOS 5.0.7 as per the files I emailed you quite some time ago?Are you getting closer to being able to access child form data for calculations in the parent form?
Regards,
RonDecember 20, 2016 at 10:05 PM #20661
BrendanKeymasterI’m sorry Ron but I haven’t resolved this issue yet. It shows on the details view, but not the list view. Unfortunately with the new database engine I’m using this is a complicated problem to solve. I just need to dig into it and work out a solution.
January 23, 2017 at 5:55 PM #20871
RonlangaraParticipantHi Brendan
Just wanting to check if you will be addressing this issue soon?
I am still using TF 4 due to this bug.
Best regards for the New Year.
RonJanuary 24, 2017 at 11:40 AM #20876
BrendanKeymasterHi Ron,
Yes, the next update will show the calculations from a Link to Form field on the records list view.
January 24, 2017 at 12:42 PM #20878
RonlangaraParticipantGreat to hear from you and hope it comes soon.
How about adding the ability to access the the data in a child form from the parent form?
Regards
RonJanuary 24, 2017 at 12:56 PM #20879
BrendanKeymasterWell now that’s a much bigger request :)
March 9, 2017 at 6:15 PM #21408
RonlangaraParticipantBrendan
Any update on the timing of this next update for the IOS version of TF 5?
RonApril 29, 2017 at 5:39 PM #22807
RonlangaraParticipantBrendan
Great to see 5.1 adds accessing child fields from the parent! Thanks.The switch to 5.1 was not as slick as I’d expected but after a couple of false starts, I got it working.
However in TF 5.1 if I do a backup from the “File” menu it crashes the app on OSX. If I do the backup from “Preferences” it works. I thought you would want to know.
Ron
April 29, 2017 at 8:46 PM #22809
BrendanKeymasterHi Ron,
Hmm… Can you please email me the crash report?
Also, can you update to Tap Forms 5.1.1 for Mac?
April 29, 2017 at 8:48 PM #22810
BrendanKeymasterAlso, in Tap Forms 5.1, when you do a backup, it closes the document after the backup and re-opens it. So maybe that seems like a crash, but it’s not. It’s just closing the database file before it makes a backup and then closes the document and re-opens it in order to re-open the database file.
-
AuthorPosts
You must be logged in to reply to this topic.