Simple - Copy field value to another in a grid

[CharlesParker]

I did this before but cannot seem to make it work and I am driving myself crazy.

This is a Grid (Detail View) V12

I have a field called
Called From (its a phone number)

I have another one called
Call Back (its also a phone number)

Since sometimes these numbers are different BUT sometimes the same, I want the Call Back number to be the same as the Called From number by way of clicking a button, otherwise I would just enter the differing call back number.

So can someone please direct me?
I have a button and I am trying to use the onClick event in the Javascript field properties.
I have tried so many things that if I had a loaded revolver I would have shot the monitor 5 times, and then turned the gun on my app giving it one last chance...lol

Help!

[GGandhi]

Re: Simple - Copy field value to another in a grid

Hello

You should be able to do without the button Ajax callback. Probably not necessary to have the button.
Use the onChange event of the called from field harvest the e.dataSubmittedNew.calledFrom then e.set.callBack.value= that value you harvested.
This way you can change it when you arrive at that field or leave it alone.
If you still did not get this to work by tomorrow evening I will send you a screencast, I am away in Florida till tomorrow night.

[CharlesParker]

Re: Simple - Copy field value to another in a grid

Many Thanks!

[Davidk]

Re: Simple - Copy field value to another in a grid

I would probably stay on the client side and do this with the Alpha Javascript methods. No real need to make a round trip to the server.

Create your button, and in it's Javascript onClick event do this...

var calledFrom = {grid.Object}.getValue('D','Called_From');
{grid.Object}.setValue('D','Call_Back', calledFrom);

You don't have spaces in your field names... do you?

[CharlesParker]

Re: Simple - Copy field value to another in a grid

David, no I do not have spaces and that snippet is perfect AND at least I know I had the right idea, in fact I wrote code so close to that! I get it - I left out some important aspects of it, like apostrophes.
I also tried 35 varieties of {grid.object}.setValue(D,Called_From,Call_Back,' '); etc. which all I got was 1 parentheses or nothing, lol
Thank you - my button is working exactly as I wanted and I hope this helps out someone else as well!

Can I write 3 varieties of similar code on the same button? Like creating 3 vars and have them all fire on the same button click?
SO I can just "Copy" values like from ship to/bill to?

Lastly Ghandi - I would still like to see your idea on how to accomplish this because I learn so much from you - I think many have.

Thanks Again guys!

[GGandhi]

Re: Simple - Copy field value to another in a grid

hello

Can I write 3 varieties of similar code on the same button? Like creating 3 vars and have them all fire on the same button click?
SO I can just "Copy" values like from ship to/bill to?

this is one of my old videos
http://www.screencast.com/t/b4uqKldt
where it updates the shipping address as you type in the billing address ( without round trip to server) of course you can put a button and copy to i have to look for that video i will post back when i locate it.
if you want to do all you have to do is combine all the separate codes to one and call with inline javascript of the button onClick event

[CharlesParker]

Re: Simple - Copy field value to another in a grid

Thanks Gandi - all good information...

[kstans]

Re: Simple - Copy field value to another in a grid

I am trying to do this same thing. Using a button on a new record in a dialog. The record has not been saved yet, but I need a button to copy address info.

[CharlesParker]

Re: Simple - Copy field value to another in a grid

Keith
This was answered by David Kates:


"Create your button, and in it's Javascript onClick event (text mode) do this..."

Code:

var calledFrom = {grid.Object}.getValue('D','Called_From');
{grid.Object}.setValue('D','Call_Back', calledFrom);

Thats for syncing from a field called "Called_From" so what happens is the field in detail view called "Call_Back" equals the value in Called_From

so I took it a step further with another button to copy the fields from the jobsite address with a click to the billing address fields. Heres the code I used

var getadd1 = {grid.Object}.getValue('D','address');
{grid.Object}.setValue('D','Billing_Address', getadd1);

var getcity1 = {grid.Object}.getValue('D','city');
{grid.Object}.setValue('D','Billing_city', getcity1);

var getstate1 = {grid.Object}.getValue('D','state');
{grid.Object}.setValue('D','Billing_State', getstate1);

var getzip1 = {grid.Object}.getValue('D','zipcode');
{grid.Object}.setValue('D','Billing_zipcode', getzip1);

So I hope with these two examples you can figure out the logic of creating a variable - assigning it the entered value from a field and then setting the value of another field with the variable.

Thank you David for taking the time to explain it to me by showing me a working clear example! I get it!

[kstans]

Re: Simple - Copy field value to another in a grid

This is what I have in the onlick

var getadd1 = {grid.Object}.getValue('D','MAILINGADDRESS1');
{grid.Object}.setValue('D','PHYSICALADDRESSLINE1', getadd1);

It does nothing in working preview, or in the published version.

I'm wondering if it's because it's not saved yet?

[CharlesParker]

Re: Simple - Copy field value to another in a grid

This worked fine for me in a normal grid, with similar pasted into the onclick event for javascript (textmode)
I am not sure about your fields being referenced in all caps. I heard javascript is case sensitive but not sure in this case.
I would try naming your fields in all lowercase but again not sure about that as far as I can tell this should work fine.

[kstans]

Re: Simple - Copy field value to another in a grid

Ok I changed the first line to match the Field name and added a window.alert. The message I get is false?

var getadd1 = {grid.Object}.getValue('D','Mailingaddress1');
window.alert(getadd1);

[GGandhi]

Re: Simple - Copy field value to another in a grid

Using a button on a new record in a dialog

var getadd1 = {grid.Object}.getValue('D','Mailingaddress1');

you want to use in dialog, but using grid methods.
will not work.
look for e.dataSubmitted property.
and e._set property
for example

dim add1 as c
add1 = e.dataSubmitted.mailingaddress1
e._set.physicaladdressline1.value = add1

will copy in dialog.

[Davidk]

Re: Simple - Copy field value to another in a grid

Keith,

Govindan is right in that you're using grid methods in a place in the dialog where (in this case) they don't belong.

However... there's still no need to make a round trip to the server to get this done...

var _phone = {dialog.Object}.getValue('PHONE');
{dialog.Object}.setValue('FAX', _phone);

in a client-side event will get you what you want.

You were putting your original code into the client-side onClick event... right? In Text mode.

At the bottom of that Text mode screen you'll a link... Insert UX Component Method... where you'll find the format of these and other methods.

[kstans]

Re: Simple - Copy field value to another in a grid

I'm about to give up. I know we are real close, but it doesn't work.

It's component type is updateable grid. layout is form. And it's set to create a new record. The copying needs to take place before the save.