onClick event upon Grid line on Form

Hi,

I am working on MT Cloud environment.

I have simple form on which I put Grid component from Toolbox menu:

This Grid is not connected to any Collection. It is just for representing data which I get from IDM ION API. Like this:

And now I need to call FormScript function when user selects one or more Grid lines. But when I try to use Trace View to see what event is trigger when click on Grid line is happen, nothing shows up, Trace View remains empty.

So is this setup even possible? Or is there any other component which can be better for my use? I don't want to store these data. Just present file list to user. Then he selects one or more lines, and after that I will process these files, and save data from it to Primary collection.

Find more posts tagged with

Accepted answers

unknown

Yes, the 'Object' referred to in StdObjectSelectCurrentCompleted is the IDO collection. There are several benefits from using an IDO, not least of which you can call StdObjectSelectCurrentCompleted. You can create the IDO against a 'dummy' table (one with minimal columns) and use unbound columns for the data you are getting back from the ION API. There is no need to save the data back to the table so the dummy table with have no rows and no columns. I have a single dummy table from which I create many IDO's. I did make a form which creates an IDO from the data returned from M3 program MRS001MI transaction LstFields, as I was needing this so frequently.

I don't know how you will do the multi select though. I have looked at this before with no answer. When you call an event from StdObjectSelectCurrentCompleted you will only be able to refer to the current record. You could add a column called 'selected' set as a check box. When you select the first record you can remember the row number, when the second (last) row is selected you can check the selected column for all rows between the first and second (I hope that makes sense). However, it's not making use of the standard feature of being able to highlight multiple rows in a grid. The only time that seems to be used is copying data out of the system.

0911060553270289.pdf

unknown

The forms depend on a framework we have built in Mongoose. They will not function without this, but you should be able to get the general feel of it.

First the IDO's - use IDO Import

<?xml version="1.0" encoding="utf-8"?>
<ObjectStudioExport Version="060000">
<PropertyClasses>
<PropertyClassDef Name="m3i_FLDP">
<Description>Decimal Places</Description>
<PropertyAttributes>
<ColumnDataType>decimal</ColumnDataType>
<DataDecimalPos>0</DataDecimalPos>
<DataLength>1</DataLength>
<DataType>Decimal</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Decimal Places</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_FLDS">
<Description>Field description</Description>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataLength>60</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Description</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_FLNM">
<Description>Field name</Description>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataLength>10</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Field name</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_FRPO">
<Description>From position</Description>
<PropertyAttributes>
<ColumnDataType>decimal</ColumnDataType>
<DataDecimalPos>0</DataDecimalPos>
<DataLength>4</DataLength>
<DataType>Decimal</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>From position</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_InOut">
<Description>Input / Output</Description>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataLength>1</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>In/Out</LabelStringID>
<InlineList>ENTRIES(iIn,oOut) DISPLAY(2) VALUE(1)</InlineList>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_LENG">
<Description>Length</Description>
<PropertyAttributes>
<ColumnDataType>decimal</ColumnDataType>
<DataDecimalPos>0</DataDecimalPos>
<DataLength>3</DataLength>
<DataType>Decimal</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Length</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_MAND">
<Description>Mandatory</Description>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataLength>1</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Mandatory</LabelStringID>
<InlineList>ENTRIES(1Yes,0No) DISPLAY(2) VALUE(1)</InlineList>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_MIDS">
<Description>Program Description</Description>
<AccessAs>Infor</AccessAs>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataLength>40</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Description</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_MINM">
<Description>program</Description>
<AccessAs>Infor</AccessAs>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataLength>8</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Program</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_TOPO">
<Description>To position</Description>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataDecimalPos>0</DataDecimalPos>
<DataLength>4</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>To position</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_TRDS">
<Description>Transaction Description</Description>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataLength>60</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Description</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_TRNM">
<Description>Transaction</Description>
<AccessAs>Infor</AccessAs>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataLength>30</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Transaction</LabelStringID>
</PropertyAttributes>
</PropertyClassDef>
<PropertyClassDef Name="m3i_TYPE">
<Description>Type</Description>
<PropertyAttributes>
<ColumnDataType>varchar</ColumnDataType>
<DataLength>1</DataLength>
<DataType>String</DataType>
<IsReadOnly>1</IsReadOnly>
<LabelStringID>Type</LabelStringID>
<InlineList>ENTRIES(AAlphanumeric,NNumeric,DDate) DISPLAY(2) VALUE(1)</InlineList>
</PropertyAttributes>
</PropertyClassDef>
</PropertyClasses>
<IDODefinitions>
<IDODefinition Name="m3i_MRS001MI_LstFields">
<ServerName>m3i_M3Integration</ServerName>
<AccessAs>OLL</AccessAs>
<LabelStringID>om3i_MRS001MI_LstFields</LabelStringID>
<RevisionNo>5</RevisionNo>
<RevisionDate>2021-05-05T09:03:26</RevisionDate>
<ReplaceFlag>0</ReplaceFlag>
<QuoteTableAliases>0</QuoteTableAliases>
<Tables>
<Table Name="M3CE_Dummy" Alias="dmy" Type="PRIMARY" />
</Tables>
<Methods />
<Properties>
<Property Name="unb_FLDP" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_FLDP</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_InOut" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_InOut</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_o_FLDS" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_FLDS</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_o_FLNM" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_FLNM</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_o_FRPO" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_FRPO</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_o_LENG" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_LENG</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_o_MAND" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_MAND</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_o_TOPO" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_TOPO</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_o_TYPE" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_TYPE</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
</Properties>
<Rules />
</IDODefinition>
<IDODefinition Name="m3i_MRS001MI_LstPrograms">
<ServerName>m3i_M3Integration</ServerName>
<AccessAs>OLL</AccessAs>
<LabelStringID>om3i_MRS001MI_LstPrograms</LabelStringID>
<RevisionNo>4</RevisionNo>
<RevisionDate>2021-05-05T09:03:38</RevisionDate>
<ReplaceFlag>0</ReplaceFlag>
<QuoteTableAliases>0</QuoteTableAliases>
<Tables>
<Table Name="M3CE_Dummy" Alias="dmy" Type="PRIMARY" />
</Tables>
<Methods />
<Properties>
<Property Name="unb_o_MIDS" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_MIDS</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_o_MINM" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_MINM</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
</Properties>
<Rules />
</IDODefinition>
<IDODefinition Name="m3i_MRS001MI_LstTransactions">
<ServerName>m3i_M3Integration</ServerName>
<AccessAs>OLL</AccessAs>
<LabelStringID>om3i_MRS001MI_LstTransactions</LabelStringID>
<RevisionNo>3</RevisionNo>
<RevisionDate>2021-05-05T09:03:50</RevisionDate>
<ReplaceFlag>0</ReplaceFlag>
<QuoteTableAliases>0</QuoteTableAliases>
<Tables>
<Table Name="M3CE_Dummy" Alias="dmy" Type="PRIMARY" />
</Tables>
<Methods />
<Properties>
<Property Name="unb_o_TRDS" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_TRDS</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
<Property Name="unb_o_TRNM" Binding="UNBOUND" Sequence="0">
<PropertyClass>m3i_TRNM</PropertyClass>
<PseudoKeyFlag>0</PseudoKeyFlag>
<PropertyAttributes />
</Property>
</Properties>
<Rules />
</IDODefinition>
</IDODefinitions>
</ObjectStudioExport>

Then the form sync

<Caption>cm3i_APIFields</Caption>

<PrimaryDataSource>V(fds_DataSource)</PrimaryDataSource>

<EventToGenerate>BackBtn</EventToGenerate>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<BitmapFileName>sys_BackBtn.png</BitmapFileName>

<HelpString>sBack</HelpString>

<MenuName>StdHelp</MenuName>

<Post301Format>THEMECLASS(SystemBtn)</Post301Format>

</Component>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<MenuName>StdHelp</MenuName>

<DefaultFrom>sys_BannerNav()</DefaultFrom>

<Post301Format>JUSTIFY(R) STB()</Post301Format>

</Component>

<Caption>ssys_CreateIDO</Caption>

<EventToGenerate>CreateIDO</EventToGenerate>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>ssys_CreateIDO</EffectiveCaption>

</Component>

<Caption>Description</Caption>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<MenuName>StdHelp</MenuName>

<Post301Format>JUSTIFY(R)</Post301Format>

<EffectiveCaption>Description</EffectiveCaption>

</Component>

<EventToGenerate>StdFormSpreadsheetCopy</EventToGenerate>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<BitmapFileName>sys_Excel.png</BitmapFileName>

<Post301Format>THEMECLASS(ClearBtn)</Post301Format>

</Component>

<DataSource>object.unb_o_FLDS</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>Description</EffectiveCaption>

</Component>

<DataSource>object.unb_o_FLNM</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>Field name</EffectiveCaption>

</Component>

<DataSource>objects</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

</Component>

<DataSource>variables.varIDOName</DataSource>

<Hidden>False</Hidden>

</Component>

<Caption>ssys_IDOName</Caption>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<Post301Format>JUSTIFY(R)</Post301Format>

<EffectiveCaption>ssys_IDOName</EffectiveCaption>

</Component>

<DataSource>object.unb_InOut</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<PropertyClassName>m3i_InOut</PropertyClassName>

</Component>

<DataSource>object.unb_o_LENG</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>Length</EffectiveCaption>

</Component>

<DataSource>object.unb_o_MAND</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>Mandatory</EffectiveCaption>

</Component>

<DataSource>variables.varMIDS</DataSource>

<Hidden>False</Hidden>

<MenuName>StdHelp</MenuName>

<Post301DataType>DEFAULTVALUE(No)</Post301DataType>

</Component>

<DataSource>variables.varMINM</DataSource>

0911060553270289.pdf

All comments

BradleyBrown

You may be looking for the StdObjectSelectCurrentCompleted form event. However, I'm not certain of its behavior when selecting multiple grid lines, though that should be easy enough to test.

Pavel Matras

But my problem is little bit different. When I turn on Log trace, and click on any Grid Line, no event shows up in log. Maybe that must be something that Grid is doesn't connected to any Collection, only displays data from ION API. I just want to know if this is standard behavior, and I have to do Grid connected to Collection, or if is any solution for this, how to do it on Grid without Collection.

unknown

0911060553270289.pdf

Pavel Matras

Thanks for that idea. Please will be possible for you to post here exported XML for such a form using this dummy table, so I can inspire myself how to do that?

Thanks a lot.

unknown

The forms depend on a framework we have built in Mongoose. They will not function without this, but you should be able to get the general feel of it.

First the IDO's - use IDO Import

Then the form sync

<Caption>cm3i_APIFields</Caption>

<PrimaryDataSource>V(fds_DataSource)</PrimaryDataSource>

<EventToGenerate>BackBtn</EventToGenerate>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<BitmapFileName>sys_BackBtn.png</BitmapFileName>

<HelpString>sBack</HelpString>

<MenuName>StdHelp</MenuName>

<Post301Format>THEMECLASS(SystemBtn)</Post301Format>

</Component>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<MenuName>StdHelp</MenuName>

<DefaultFrom>sys_BannerNav()</DefaultFrom>

<Post301Format>JUSTIFY(R) STB()</Post301Format>

</Component>

<Caption>ssys_CreateIDO</Caption>

<EventToGenerate>CreateIDO</EventToGenerate>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>ssys_CreateIDO</EffectiveCaption>

</Component>

<Caption>Description</Caption>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<MenuName>StdHelp</MenuName>

<Post301Format>JUSTIFY(R)</Post301Format>

<EffectiveCaption>Description</EffectiveCaption>

</Component>

<EventToGenerate>StdFormSpreadsheetCopy</EventToGenerate>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<BitmapFileName>sys_Excel.png</BitmapFileName>

<Post301Format>THEMECLASS(ClearBtn)</Post301Format>

</Component>

<DataSource>object.unb_o_FLDS</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>Description</EffectiveCaption>

</Component>

<DataSource>object.unb_o_FLNM</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>Field name</EffectiveCaption>

</Component>

<DataSource>objects</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

</Component>

<DataSource>variables.varIDOName</DataSource>

<Hidden>False</Hidden>

</Component>

<Caption>ssys_IDOName</Caption>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<Post301Format>JUSTIFY(R)</Post301Format>

<EffectiveCaption>ssys_IDOName</EffectiveCaption>

</Component>

<DataSource>object.unb_InOut</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<PropertyClassName>m3i_InOut</PropertyClassName>

</Component>

<DataSource>object.unb_o_LENG</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>Length</EffectiveCaption>

</Component>

<DataSource>object.unb_o_MAND</DataSource>

<ReadOnly>False</ReadOnly>

<Hidden>False</Hidden>

<EffectiveCaption>Mandatory</EffectiveCaption>

</Component>

<DataSource>variables.varMIDS</DataSource>

<Hidden>False</Hidden>

<MenuName>StdHelp</MenuName>

<Post301DataType>DEFAULTVALUE(No)</Post301DataType>

</Component>

<DataSource>variables.varMINM</DataSource>

0911060553270289.pdf

Pavel Matras

Thanks a lot for that. I were able to build simple solution like this. But when I exiting form, I am receiving this message. It is possible to suppress it somehow? Or before exiting for I must delete all lines, and then this message will not popup?

Copyright © 2025 Infor. All rights reserved.