How to pass a variable from a grid to a dialog

[coleresources]

I created a dialog for the purpose of allowing my user's to send an e-mail to customer's from within the A5 app that would also commit the communication to the SQL database. I have an action javascript button that opens the dialog and what I would like to do is pass along some of the information from the selected record where the action button exists to the dialog. I have gone into Argument Bindings and have set the session variable with the following code.

donorid = {javascript}function(rowNum) { return {grid.object}.getValue('G','ID',rowNum); }(rowNum)

In the default value for the dialog I have set the default value to =session.donorid and have tried =donorid

When opening the dialog I receive the error "Record Not Found". I also was wondering. Is it possible to use the send e-mail action javascript inside of a dialog?

Any feedback is much appreciated.

[aburningflame]

Re: How to pass a variable from a grid to a dialog

In the grid add a button:
Click the OnClick Javascript event.
Add New Action>In Line Javascript

Add this code:
window['__callingGridAlias']={grid.Object}.gridId;
window['__callingGridRow']='{Grid.RowNumber}';
{grid.Object}.rowCollapse({Grid.RowNumber}); //i add this because then it collapses the row, and when the user expands the row, it forces a refresh

Add New Action
Open Dialog Component


In your DIalog, Client Side Events

OnInitializeComplete:
var grid_id=window['__callingGridAlias'];
var row_num=window['__callingGridRow'];
if (typeof grid_id !='undefined' && typeof row_num !='undefined'){
var sub_id=window[grid_id+'_GridObj'].getValue('G','SUBSCRIBER_ID',row_num);
{dialog.Object}.setValue('cmbSubscriberID',sub_id);
{dialog.Object}.setValue('txtSubscriberID',sub_id);
}

I also put this code in the 'AfterResetForm' event.

Good luck

[coleresources]

Re: How to pass a variable from a grid to a dialog

This doesn't appear to work for me.

I found a video that Selwyn created and followed his tutorial. I am trying to use the following javascript as provided in the example as inline javascript before the action to open the dialog. It throws me an error.

window['v_var1'] = {grid.object}.getValue('G','ID',{Grid.RowNumber});
window['v_var2'] = {grid.object}.getValue('G','EmailAddress',{Grid.RowNumber});

Is the syntax wrong here?

[eblaschka]

Re: How to pass a variable from a grid to a dialog

Hi

I was not very successful with the "window[" syntax shown in the video.

I have used the $sa and $ga methods with success. Just make sure that you investigate the fully qualified names of the fields with Firebug.

wiki.alphasoftware.com/Getting+and+Setting+Values+and+Attributes+Core.JS&structure=What

[coleresources]

Re: How to pass a variable from a grid to a dialog

Eriks,

Thank you for your response. I am not too familiar with JS but am working to try and become more proficient. I am not sure how to get the value into a dialog control using that method. I attempted it but don't think I have the proper syntax for referencing the parent grid/fields.

I am working with the method Scott provided. I am sure there is something I am doing wrong.

I've created a action button on the parent grid with two actions. The first action is inline javascript. The script is
window['__callingGridAlias']={grid.Object}.gridId;
window['__callingGridRow']='{Grid.RowNumber}';
Which Scott provided. The second action is to open the dialog.

On the dialog in the OnInitializeComplete I have this script entered:
var grid_id=window['__callingGridAlias'];
var row_num=window['__callingGridRow'];
if (typeof grid_id !='undefined' && typeof row_num !='undefined'){
var donor_id=window[grid_id+'_GridObj'].getValue('G','ID',row_num);
var donor_EmailAddress=window[grid_id+'_GridObj'].getValue('G','EMAILADDRESS',row_num);
{dialog.Object}.setValue('Donor',donor_id);
}

I also created a video so that you could see for yourself what I am doing and probably doing wrong.

http://www.envisionsolutions.net/vid...esToDialog.swf

Thank you!

[aburningflame]

Re: How to pass a variable from a grid to a dialog

Hi cole, the code I gave you works. I have it working in a current application. I tried to help you quickly, but it looks like their may be something specific on your grid that is causing the code not to work. If you would like help with this issue, you can contact me at [email protected]. We provide support to other alpha developers and I'm sure we would be able to assist yo with this issue and any other you may find.


Feel free to contact me if you can't get this figured out.

[gaby_h]

Re: How to pass a variable from a grid to a dialog

Josh
The syntax you posted appear to be correct.
2 ways to go about it:

1) Use an unbound Dialog and use a session var as per you original post. I copy pasted you expression and it worked.

2) Use a bound dialog, bind it to the table the grid is based on (Customers I suppose), no need for session var. When you select the table to do the binding in the dialog, make sure the pk you specify in here is the same you specify in the Open Dialog js on the grid . In the Open Dialog actionJS button in grid select Populate dialog with data from table, and select the same pk as in dialog.
HTH
Try and let's know

[coleresources]

Re: How to pass a variable from a grid to a dialog

Gaby,

You are awesome. I guess the problem was the fact that I had bound the dialog to a table. Once I removed that my original method worked fine. Binding it really was going to make it easier though to write the data to the database as well as shoot the e-mail off. I guess that is a limitation or I am missing something.

[gaby_h]

Re: How to pass a variable from a grid to a dialog

A bound dialog should work. If you are getting 'Record Not Found' error, it's most likely due to a pk issue; the pk selected in the dialog when doing the biding (select table window) must be the same pk field selected in the Open dialog js.
A basic scenario is: in the dialog in Select table under table proper -> primary key field: custid
In the open dialog button on grid, in Populate data from table category -> Control on current component: custid

[aburningflame]

Re: How to pass a variable from a grid to a dialog

If you use my method, im not quite sure, but make sure the fields you are using .GetValue on are Textboxes (or some other type of readable control e.g checkbox, select box).
Ive seen alpha have trouble when yout ry to GetValue from labels or custom fields.

If you need to you can make a dummy field.
Example:
SELECT *, donor.id as dummy_donor_id FROM donor

Then you can put dummy donor id as a textbox control on the grid with the Hide Row option checked.