How to Populate The Grid Part of a Grid

[forskare]

The Grid consists of Grid section and the Detail section. The Grid section contains 2 fields, Service and Svcdescrip. Currently, the user will choose the service via a lookup. However, I would like all the services to populate the grid part rather than have the user select via lookup. The user will simply click on the service (1-5) and then complete the detail section. How can the grid part populate automatically?

[Peter.Greulich]

Re: How to Populate The Grid Part of a Grid

Grids are based upon tables (or views). You are asking the grid to display data from two different tables - one a lookup, the other a data entry table. Strictly speaking, that's not possible (although I suppose some clever person might figure out a way using a view).

If it were me, I would just use a dialog. But that would require xbasic (at least the way i would do it).

[GGandhi]

Re: How to Populate The Grid Part of a Grid

instead of using textbox then lookup, you change the field to radio button then in the choices definition you define dynamic and fill in all the detail.
all the choices will show up and the user can click one then add the description. lookup is gone. choices remain.

[GGandhi]

Re: How to Populate The Grid Part of a Grid

http://screencast.com/t/TrWwfdV1GcGE
here is the result,
you can modify to fit your need.

[forskare]

Re: How to Populate The Grid Part of a Grid

Peter, in the long run, your way is no doubt quicker to get working. Gandhi's way very easy and quick to set up, if it would only work. Currently, it shows the choices as well as the value previously entered. The toggle selected to show the detail is for the user to double click the row. Clicking on any part of a choice, including the radio button does nothing. Perhaps, as long as the previous value is showing as a separate list item, the choices are not activated. That's using only the grid by itself.

hen I use the parent grid, things are bit different. The radio button for the previous value is still there but it is unchecked and the correct choice is selected, as it should be. However, the radio button is not activated as I cannot make a different choice.

Going one step further by opening the grandparent grid, I see the same view. however, if I click on the row in focus and the double click another row, the popup message says I must first save or cancel the changes. Interesting, I never clicked in the detail part only the drid part and no changes were made.

Hopefully, this makes some sense.

[GGandhi]

Re: How to Populate The Grid Part of a Grid

Peter, in the long run, your way is no doubt quicker to get working. Gandhi's way very easy and quick to set up, if it would only work. Currently, it shows the choices as well as the value previously entered. The toggle selected to show the detail is for the user to double click the row. Clicking on any part of a choice, including the radio button does nothing. Perhaps, as long as the previous value is showing as a separate list item, the choices are not activated. That's using only the grid by itself.

hen I use the parent grid, things are bit different. The radio button for the previous value is still there but it is unchecked and the correct choice is selected, as it should be. However, the radio button is not activated as I cannot make a different choice.

Going one step further by opening the grandparent grid, I see the same view. however, if I click on the row in focus and the double click another row, the popup message says I must first save or cancel the changes. Interesting, I never clicked in the detail part only the drid part and no changes were made.

Hopefully, this makes some sense.

the whole stuff is confusing. what is grandparent grid?
would you describe what is on your mind in simple steps.
usually grid and detail parts work when grid is read only and detail is editable.
if you show what you want may be i can play around and show what can be done with grid system you seem to like.

[forskare]

Re: How to Populate The Grid Part of a Grid

gandhi,

Thanks for responding.

Parent Grid->Child Grid-> Grandchild Grid
Parent Grid = Customer
Child Grid = Work Sites
Grandchild Grid = Services This grid has only 2 parts, the grid part and the Detail part. As shown in the pic, the Service radio button is located in the grid part. Perhaps, radio buttons will not work in the grid part. Just thought of another way to use the radio button for this. Time to give it a try.

[GGandhi]

Re: How to Populate The Grid Part of a Grid

i will try to put a sample later today. but want to point out to you that
in a grid with detail view (grandchild) the grid part needs to be read only then it works.
also the radio buttons will take a lot of real estate. it is my feeling that you want to imitate the paper form the tech has with the grid.
can be done sometime later, i will post a screencast.

[GGandhi]

Re: How to Populate The Grid Part of a Grid

http://screencast.com/t/MS2XzsOvSMZ

take a look at this screencast, it is done to satisfy two of your needs,(1) grid->child->grandchild grids, (2) tech to just select a service type and enter detail in the description.
for me I would like a dialog. much better control, pleasing layout.
you choose what is best for you.
if you like I will fashion a dialog to do what is done in the grid.

making of the grids:
http://screencast.com/t/tsj9HmOQl4A

[forskare]

Re: How to Populate The Grid Part of a Grid

Hello gandhi,

Thank you for the videos. You put the radio button list in the detail section. What I need is a to use the radio button list in the grid part. AS to why, this whole thing came about because the customer uses pre-printed contract which lists the services. The customer wants the contract to show the amount of the sale/service, sales tax and the and the total. Most of my customer's customers, do not use all services. Thus it should show $0 for the services not used. Using the report shows ONLY the services used. So, if a customer purchases service 3, it would actually print on the Service 1 row. In order to get it to print on the correct row, I need to either, enter a record for each service showing the amount as $0 if the service wasn't purchased.

If I set it up to print each service (rather than pre-printed) it will only show the services used. What my customer desires, is that all the services are listed whether purchased or not because often, their customer decides to add a service. If the service is not listed, the opportunity to remind the customer of other services is lost.

As I think about this, ideally, the best way to accomplish this is that when a new customer is added, the 5 services are added, and the amount of $0 is entered into the sale field. Any service amount and the accompanying info can be changed at any time. What's not changed will show on the contract as $0 for the sale amount. The attached might be of help.

[GGandhi]

Re: How to Populate The Grid Part of a Grid

can you fax the blank pre printed contract form to
347 725 4571
you can remove any sensitive part.

[forskare]

Re: How to Populate The Grid Part of a Grid

I emailed it to you.

[forskare]

Re: How to Populate The Grid Part of a Grid

Progress. I created a form based on my Sales table, putting several fields on it along with a button with the following code which I generated from action scripting. The code won't work in a grid but I should be able to do the same thing with javascript. This is the xBasic code which works great:

'Enter new record in current form.
topparent.new_record()
'Set 'Value' property of multiple objects in Form 'testing' .
parentform:Sale.value = 0
parentform:Svcdescrip.value = "Spring"
parentform:Service.value = "1"
'Save record in current form.
topparent.commit()
'Enter new record in current form.
topparent.new_record()
'Set 'Value' property of multiple objects in Form 'testing' .
parentform:Sale.value = 0
parentform:Svcdescrip.value = "Early Summer"
parentform:Service.value = "2"
'Save record in current form.
topparent.commit()
'Enter new record in current form.
topparent.new_record()
'Set 'Value' property of multiple objects in Form 'testing' .
parentform:Sale.value = 0
parentform:Svcdescrip.value = "Summer"
parentform:Service.value = "3"
'Save record in current form.
topparent.commit()
'Enter new record in current form.
topparent.new_record()
'Set 'Value' property of multiple objects in Form 'testing' .
parentform:Sale.value = 0
parentform:Svcdescrip.value = "Fall"
parentform:Service.value = "4"
'Save record in current form.
topparent.commit()
'Enter new record in current form.
topparent.new_record()
'Set 'Value' property of multiple objects in Form 'testing' .
parentform:Sale.value = 0
parentform:Svcdescrip.value = "Late Fall"
parentform:Service.value = "5"
'Save record in current form.
topparent.commit()

[forskare]

Re: How to Populate The Grid Part of a Grid

Well, almost. I changed the code to the javascript version and while it does insert a new record, it only adds the first one. I broke the code down to 5 buttons and tried it one at a time. If this is a new customer (no existing services) it will add the first service. However, the other buttons only change the service number. The do not enter a new record even though the first line of code is {grid.Object}.detailViewNewRecord();. The code on each button is the same except the service number is different as is the Svcdescrip.

{grid.Object}.detailViewNewRecord()
{grid.object}.setValue('D','SERVICE','2')
{grid.object}.setValue('D','SVCDESCRIP','Early Summer')
{grid.object}.setValue('D','SALE','0')
{grid.Object}.submitDetailView();

Is there other or different code which must be added/used?