Javascript - What, Where and How 2 Part Question

[forskare]

I have two grids, grid1 is linked to grid2. Grid1 has bill address fields and Grid2 has service address fields. Most customers will have the same address for billing and service. When a new record is entered in grid2, I need to check a checkbox or click a button to copy the billing address info from grid1 to the service address fields in grid2. If the service address is different than the shipping address, then the user can simply add the service address.

What is the best way to do this, checkbox or button? Would I use javascript or serverside Xbasic? I presume the code will be the same, either way.

Thanks for the insight.

Solution:

I createdd a small grid composed of the customer_id and address fields. The I did a lookup for the Svc_address field in grid2. It looks up the bill address field in the lookup grid. It's really cool the way the genie laid it out. I mapped the fields and then used the linking field (customer_id as the dynamic filter. Do the lookup and a small grid pops up with a select button, press the button, the lookup grid closes and the values are in the service address fields. The only thing better would be it it was done automatically. Sort of like if I created a function and the the function ran only when a new record in grid 2 was created.

[frankbicknell]

Re: Javascript - What, Where and How 2 Part Question

Have you thought of the look-up and fill in fields action javascript? You can use any control that has events.

[forskare]

Re: Javascript - What, Where and How 2 Part Question

Have you thought of the look-up and fill in fields action javascript? You can use any control that has events.

Hi Frank,

Are you referring to "lookup" as I did above or are you referring to another lookup?

[frankbicknell]

Re: Javascript - What, Where and How 2 Part Question

Ken,

An example using an action button. Click the button and the fields on grid a are filled in with data from table b. I think this is what you are looking to do.

In the onclick event of a button or image or whatever, open action javascript, in the actions panel select Lookup and fill in fields. Follow the dialogs. I would post an image but I still can't post images to the Alpha forum.

[forskare]

Re: Javascript - What, Where and How 2 Part Question

Ken,

An example using an action button. Click the button and the fields on grid a are filled in with data from table b. I think this is what you are looking to do.

In the onclick event of a button or image or whatever, open action javascript, in the actions panel select Lookup and fill in fields. Follow the dialogs. I would post an image but I still can't post images to the Alpha forum.

Thanks Frank, I try that later this evening. Post an image to the mesage board? I thought I was the only one. LOL

Frank, This is way cool. Exactly what I needed and so flexible, beyond my expectations.

Thanks

[Rich Hartnett]

Re: Javascript - What, Where and How 2 Part Question

An example using an action button. Click the button and the fields on grid a are filled in with data from table b. I think this is what you are looking to do.

In the onclick event of a button or image or whatever, open action javascript, in the actions panel select Lookup and fill in fields. Follow the dialogs.

The Lookup & Fill option is great if the user has already submitted the data in table b to the server, but I am looking for something a bit different.

When a user fills in his/her address in the "home address" fields, I want to be able to copy that data to the "shipping address" fields before the submit button has been clicked. That way all the data from both the home address and shipping address fields are submitted at once.

Any idea how to do that?

[forskare]

Re: Javascript - What, Where and How 2 Part Question

Seems to me I did see an example in a video, but that was quite awhile ago. Check the dialog vids.

[Rich Hartnett]

Re: Javascript - What, Where and How 2 Part Question

Yeah I thought so too, but I checked the videos before posting this message and didn't see anything.

I'll go through them again to make double sure I didn't miss it.

[forskare]

Re: Javascript - What, Where and How 2 Part Question

What you want to do is a fairly common task. Since there is documentation for the DT to do this, I would think there would be documentation to do in in a grid or in the detail section of a grid.

[GGandhi]

Re: Javascript - What, Where and How 2 Part Question

hello

you should be able to do with getvalue and setvalue of the detail view inline javascript using on change event for the address fields.