![[Google]]( http://www.jdesource.com/wp-content/plugins/easy-adsense-lite/google-light.gif)
I’ve been pounded many a times by guys asking how to use Power forms. There have been not much tutorials on using Power forms, and its benefits. So I thought of writing up a simple Power Form usage, and a basic tutorial/guide to help all of us.
Lemme try to summarize Power Form System Functions and Event Rules. I’ll also try to make use of Saved Query Controls. I assume that you have basic JD Edwards Technical Skills and knowledge to accomplish this.
Following are the activities which I’m going to do in this example:
- Create the Power Browse Form.
- Create a Standard Subform.
- Create a Mapping Link.
- Create a Reusable Subform.
- Using Power Forms System Functions and Event Rules
- Create the Power Edit Form.
- Using Automatic Features of FDA.
- Using the Saved Query Control.
- Creating Grid Icons
- I’ve assumed that you have two tables, linked by UKID. Say the table – 1 is made up of UKID, AN8 and ALPH. The Table – 2 is of UKID, ADD1, CTY, ADDS. Something like the Address Book setup.
- Take a Power EDIT form & insert a subform (reusable or embedded anything would do, depends on your overall architecture). Note: if using resuable subform then take Reusable Edit Subform.
- Attach Header BV to Power form & detail BV to subform. (procedure is similar to any form)
- Check if subform datastructure has UKID in it (To receive subform interconnect values), if not then add (procedure is similar to any form)
- In properties of Power form, select tab “Mapping links”. Check whether proper subform is selected in “Link To” combo box. Assign the respective UKID field/variable of power form which would contain UKID values and needs to be passed to subform. Assign the proper direction i.e. From Power to Subform for this scenario.
- Use system function “Notify Child” to pass control & data to subform. Most probably you would like to use this function in “Post dialog is initialized” event of Power Form.
- Once this function is executed, an event “Notified by Parent” would be invoked in subform.
- Assign Subform interconnect values of UKID to the filter fiield on subform. This would show all the detail records on subform. (If Automatic find on entry property is set on the grid of subform). In our setup this property is somehow not working on subform grid.
- What we do is to have a “Hidden Find” button on subform which is pressed using system function in Notified by parent event.
These were the steps to show detail record(s) corresponding to header.
- Insert a Push button with default functionality of “Save” on subform & Hide it.
- On Power form’s OK button’s appropriate event use system function “Trigger Default Child Action” to press save button of subform. This would save the detail record along with header record. (there are other methods as well)
Please find the Developing Powerform-Based on JD Edwards EnterpriseOne Applications PDF from David Terborg – Please Register to View/Download
Thanks David.
Author : 
Can you give some more detailed steps on how to, including screen shots?
I’ll try to do a full featured tutorial by the end of the week.
Would like to see the same with screenshots. I’m stuck on doing Power Browse forms. Please help.
I’m sorry as time not allowing i have not got a chance to write a complete tutorial. Will be doing it soon.
Hi Deepesh,
I am new t o JDE, I have been doing some testing, i am facing this issue in forms where when I login as a specific user say Service Rep, I am not able to find the OK button in the form to create contracts. When i access the same form through the seeded JDE user I can find it there and create the contract. This is replicated across many other forms across different modules like manufacturing and CRM.
Any ideas on what might be the issue.
Currently working on a JDE 9.0 instance
Thanks
Hi Mukund,
This is due to the User/Role security feature in JD Edwards. You can set security for a particular user or a Role for Not to Save a record, or not to change the value of processing options, or say Only View the Records etc. You will have to ask your system administrator to switch off the security for “Save” or saving the records, to enable your OK button.
Good tuts. You also need to write the pre-requisites for doing such tuts.
Hi Deepesh,
I can send you some pdf’s on this toopic if you want.
Just let me know if you are interested.
kind regards,
David Terborg
David Terborg,
could you send me some PDF on Power Forms?
you can mail it to [email protected]
Thanks in advance
Hi Deepesh!
I’m new on JDE and i have to developpe an application and i’m trying to use Power forms. So if you can send me some PDF on Power Forms! You can mail it to [email protected]
thanks a lot!
Hi all,
I have pdf’s regarding creating powerforms.
If anyone is interested please let me know and I will request the administrators to upload them.
kind regards,
David
All,
You can download the PDF on Power forms Uploaded by David Terborg. Download Link given in the Article.
Thanks David.
Hi David
could you send me some PDF on Power Forms?
you can mail it to [email protected]
Thanks in advance
William,
There’s a download link for the pdf in the article
A Power Edit (in ADD mode) has 2 subforms/tab pages with required fields. Its allowing the adds withh the OK without the required fields being entered.
I would want the required fields to fire
I even put the Get Error Count into subform but that seems to fire after the OK button so the errors would pick up after the fact.
Do I have to manually validate those or can I put something in the to trigger the validation.
Also if I happen to put a function in that fails in the OK button, it then does the required field validation. But then only does like a few of the required fields v. all of them.
So that’s my question…
Hi,
Your question is not clear. I assume that you have not put a Save button on the subform, which has to be triggered on the OK button of the main power form. Is it that you are never going to the subform? I mean the control is never focused on the subform? Can you elaborate further
Actually I am doing the trigger the subform save, which typically just launches the same event for a save on the subform itself, right?
But yes a user should go into several subformes and if all okay then I would trigger the subform save within the OK button v. doing a hidden save off the subform. Rather what I’m trying to do is if they do nothing in the assoc. subforms with the required fields then the errors pop up accordingly. It just completes normally ignoring the required fields.
About it.