PerfectForms Forums: Forum: Parent-Child Forms

PerfectForms Forums: Forum: Parent-Child Forms - Recent Topics http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 08:23:42 +0000 srogers on "How do multiple instances of a child form work?" http://www.perfectforms.com/forums/topic/how-do-multiple-instances-of-a-child-form-work#post-2477 Mon, 07 Nov 2011 18:25:39 +0000 srogers 2477@http://www.perfectforms.com/forums/ Hello, I have a parent form with two child forms. Can I have multiple instances of one of the child forms on the same parent instance? I am getting some wonky results with it - When more than one instance of the child form is created in the same session (The parent is not saved/submitted between instances), the original child instance is opened instead of a new blank instance. I'm also getting form notifications going to the wrong people (Notifications directed to an email address taken from a field, which is set via a Custom Parameter or Connection, depending on a drop-down fiel selection). Since my form design looks like it should work, I conclude that the problem lies in how the parent-child relationship works. Any thoughts? Hugo Solano on "Using SQL: Master-Child" http://www.perfectforms.com/forums/topic/using-sql-master-child#post-2216 Tue, 14 Jun 2011 22:38:19 +0000 Hugo Solano 2216@http://www.perfectforms.com/forums/ We are trying to setup a form that updates all of its data to SQL tables. Here is the setup: Master Table: Primary Key Several fields Secondary Table 1: Primary Key Specific field Secondary Table 2: Primary Key Specific field The issue here is that all data must be stored in SQL tables. We are using the connection agent and everything is fine. The question is what is the best practice inserting/displaying/maintaining multi-value seconday records. We tried form table objects, but the whole SQL insert/update/delete doesn't work well there. We think a parent-child form relationship may do it. What is the best type of control to use to display/insert/delete records? Any help is surely appreciated. Hugo 889 on "Update a parent form" http://www.perfectforms.com/forums/topic/update-a-parent-form#post-1762 Fri, 05 Nov 2010 09:57:13 +0000 889 1762@http://www.perfectforms.com/forums/ How do I update a parent form with fields from the child form without submitting the parent form. I have this table for invoice as my child form.What I actually want is when I close this invoice(child form), some fields from there will be shown to my parent form. Jackie H on "Get Custom Parameter" http://www.perfectforms.com/forums/topic/get-custom-parameter#post-1683 Thu, 23 Sep 2010 13:07:24 +0000 Jackie H 1683@http://www.perfectforms.com/forums/ I have a very simple parent form containing a table in which one column contains email addresses (at the moment only one email address). My Show Form behaviour opens up a child form and I want to get the email address into the child form so that I can use it to send a notification. In the Show Form behaviour in the parent form I have set the table column to be a Custom Parameter, and in the child form I am trying to do a set field formula when the page opens to pick up the email address from the parent. The formula I'm choosing here is Get Custom Parameter. But I am not sure how I "get" the parameter in question.... Nothing I try has worked so far. Any ideas? I am probably doing something very simple incorrectly!! Ah... I think the trouble is with my table. I managed to do it from a field outside the table. Peanuts890 on "Parent data to first and subsequent child forms" http://www.perfectforms.com/forums/topic/parent-data-to-first-and-subsequent-child-forms#post-1674 Wed, 08 Sep 2010 11:02:37 +0000 Peanuts890 1674@http://www.perfectforms.com/forums/ I have a fairly simple parent/child application. the parent form acts as a portal and holds the "Company Name" and link to a survey (child form). When the child form opens I get the "Company Name" from the parent using the "Get Customer Paramater" and this is working okay. When the child form survey is completed I have a "Submit" button and a "Submit and Open a New Form" button" (for the same company). I am unable to get the "Company Name" data from the parent form for these new forms. This may have been answered in one of the other topics, but I don't fully understand the solution. Incidently my "Get Custom Paramater" call is when the form opens. simond on "Passing values between two forms" http://www.perfectforms.com/forums/topic/passing-values-between-two-forms#post-1072 Fri, 15 Jan 2010 15:57:15 +0000 simond 1072@http://www.perfectforms.com/forums/ I have a simple form which allows you to add an email address and a name. Work flow closes the instance. I have a second form where I would like to enter an email address and then retrieve data from the 1st form where the email is = to that entered in the 2nd form. I've tried different methods which all fail. help please mcroft66 on "Writing Back to Parent Form" http://www.perfectforms.com/forums/topic/writing-back-to-parent-form#post-1048 Wed, 06 Jan 2010 10:21:22 +0000 mcroft66 1048@http://www.perfectforms.com/forums/ I have an Equipment Request form that allows you to raise a Purchase Request form if the equipment is unavailable from stock. The Child Purchase Request form is opened via a child form button in a table in the Equipement Request form. It is in a table as each Equipment Request form could possibly have many pieces of equipment requested and therefore many PRs associated with it. I want to be able to write the Form ID Number, not instance ID, back into this table once the form PR form has been submitted to allow us a view of which piece of equipment has which PR. Problem I'm having is that the form ID is 0 at the stage I'm trying to retrieve it. Does anyone have an idea if this can be done? Thanks, Michael. MABrown on "Update child without opening" http://www.perfectforms.com/forums/topic/update-child-without-opening#post-441 Fri, 29 May 2009 21:33:21 +0000 MABrown 441@http://www.perfectforms.com/forums/ Is it possible to update a child form without actually opening it? I am trying to setup a form with a table where every entry in the table represents a child form. I would like to allow the user to update the fields in the table directly, and have those changes committed to the child form without having the child form open, submit, and then close. ccapra on "Pulling Custom Parameter Date Format From Parent Form" http://www.perfectforms.com/forums/topic/pulling-custom-parameter-date-format-from-parent-form#post-380 Wed, 13 May 2009 17:17:49 +0000 ccapra 380@http://www.perfectforms.com/forums/ I'm setting notices off of dates in a child form. I want the dates to be determined in the parent form, and then get pulled into the child form. I first set up the date fields in the parent form as date input fields, and set up the fields for pulling the dates into the child form as simple text fields. When I did that, the fields pulled into the form fine, but then the notices did not go out on the dates. I concluded that the fields in the child form needed to be date fields as well, so that the notice would recognise the content of the field as a date. So I changed the fields in the child form that I wanted the dates to pull into from the parent field as date input fields also. Now my notices will get sent on those dates, but the actual dates will not pull into the child form fields from the parent form fields. The behaviors & parameter names SEEM correct - where did I go wrong? ccapra on "Custom Parameters not saving in child form" http://www.perfectforms.com/forums/topic/custom-parameters-not-saving-in-child-form#post-307 Mon, 20 Apr 2009 21:55:39 +0000 ccapra 307@http://www.perfectforms.com/forums/ I have a parent/child form set-up. I want certain fields from the parent form to feed into the child form, so I have set up custom parameters. When I create a child instance, I can see that the fields have come into the child form. However, if I submit the data, the data in the fields that were pulled in disappears. Why is that? Laura Debello on "Orphan child records" http://www.perfectforms.com/forums/topic/orphan-child-records#post-254 Mon, 30 Mar 2009 23:58:09 +0000 Laura Debello 254@http://www.perfectforms.com/forums/ I have created a form similar to the sample meeting application where there is a main (parent) form and a child form button in a table. However, I have found that I can create a child record without having saved the parent record, thereby ending up with an orphan child record. Apart from putting a behaviour that checks if the parent has been saved before allowing the user to create a child record, is there another way to stop orphan child records? ijobling on "I have a process that is slightly different for different departments" http://www.perfectforms.com/forums/topic/i-have-a-process-that-is-slightly-different-for-different-departments#post-114 Thu, 18 Dec 2008 16:14:30 +0000 ijobling 114@http://www.perfectforms.com/forums/ Where you have a lot of common requirements , but a few differences, Parent/Child can be of use. Perhaps look to set up your parent form that contains your common requirements, and then individual child forms for the departmental differences, and if you are able to identify your users departments, form behaviours can be used to show/hide a button for them to launch the appropriate Child form