Multi select

[omagarc]

I have a desktop app that uses an xdialog box to display queried records from a table. The user multi selects items and these items are inserted into a transaction table.

Its like an invoice system where you can multi select multiple items from a pop up window and insert them into the detail table of an invoice.

I'd like to know if such a thing is possible at the web level where the items displayed in the queried in the pop up dialog box/component and the user can multiselect items and insert into a detail table.

The actual use is for a medical ordering system where a user can select muliple items to 'order'

[Peter.Greulich]

Re: Multi select

I'll stick my neck out and say, sure. But I haven't done this myself. Obvioulsy you can query a grid or display a 2nd queried grid. Grids can have optional check boxes (not fields) for the purpose of selection. Just not sure how you control program flow after checking the records you want.

[Bob Moore]

Re: Multi select

It's very much possible.
I've done this for a financial web app I built in V10.

That said, this is where solid knowledge of Javascript and Alpha's event model pay a big dividend.

[wmz]

Re: Multi select

I'll stick my neck out and say, sure. But I haven't done this myself. Obvioulsy you can query a grid or display a 2nd queried grid. Grids can have optional check boxes (not fields) for the purpose of selection. Just not sure how you control program flow after checking the records you want.

I would be interested to know the javascript version, but it's actually fairly easy when using an Ajax callback function that does not need any javascript.

1. Define a row based button or a grid toolbar button on the grid. Set the 'Has checkbox select column' property of the grid to true
2. In the button onclick() define a js action script for an Ajax callback named, say, 'ProcessSelected'
3. Define the Ajax callback in the grid and make sure the function's interface is as expected, i.e.

function ProcessSelected as C (e as P)
... 
end function

4. In the Ajax callback function you can now access the key values of the selected rows and execute some xbasic to add them to a transaction table or similar. The following example assumes you have a table in an SQL DB with a compound primary key (lastname, firstname):

function ProcessSelected as C (e as P)

   dim js as C  
   dim i as N
   dim selectedCount as N
	
   dim lastname as C
   dim firstname as C

   'Get number of selected records
   [B][COLOR="Blue"]selectedCount = e.checkboxRows.countChecked[/COLOR][/B]

   'Process key field values of selected rows
   for i=1 to [B][COLOR="blue"]selectedCount[/COLOR][/B]
      'Assuming that lastname is the first part of primary key 
      [B][COLOR="Blue"]lastname = eval("e.checkedRows.key" + i + "[1]")[/COLOR][/B]
      'Assuming that firstname is the second part of primary key 
      [COLOR="blue"][B]firstname = eval("e.checkedRows.key" + i + "[2]")[/B][/COLOR]
     
      'do something with the key values, i.e. add them to a
      'transaction table, retrieve other fields etc. using
      'regular xbasic code/SQL etc.
      '...

   next

   'Generate javascript code or just empty string	
   js="alert('Selected Records Processed');"

   ' Return javascript code to be executed after callback (optional)
   ProcessSelected  = js

end function

regards

Wolfgang

[Peter.Greulich]

Re: Multi select

Wolfgang,

That is very, very helpful. This is exactly the kind of useful and explanitory example that Alpha needs to provide much, much more of. Thanks!

[jkletrovets]

Re: Multi select

Wolfgang,

I couldn't agree more with Peter! Thank you for sharing!!!!

Regards,

Jeff

[omagarc]

Re: Multi select

Wolfgang,

THANKS! There is now way in the world I would have figured that out! Thanks for the detailed example and your time providing it!

regards,
omar

[mheller]

Re: Multi select

You would probably want the next action in the button onClick handler to close the grid or popup, and you might use the option to update the parent grid when the linked grid closes. You would also want to add some error checking to the callback function.

[jkletrovets]

Re: Multi select

You would probably want the next action in the button onClick handler to close the grid or popup, and you might use the option to update the parent grid when the linked grid closes. You would also want to add some error checking to the callback function.

Martin,

Would it be possible for you to provide the code to do that? As someone just getting going on the web side of things with Alpha -I think it would prove helpful to many here.

Regards,

Jeff

[Peter.Greulich]

Re: Multi select

Martin,

Would it be possible for you to provide the code to do that?

That's what we need. Concept may be useful, nut and bolts, critical.

[mheller]

Re: Multi select

I'd love to walk you through it, but I won't have time to do that until March. Sorry.

I don't think it will require code, just a box checked and another Action JavaScript step.

[chadbrown]

Re: Multi select

perhaps wolfgang should be on the payroll. :D

Chad

[wmz]

Re: Multi select

perhaps wolfgang should be on the payroll. :D

Chad

Chad (and all)

thanks for the good words. The payroll is an interesting thought ... black money preferred .... :)

seriously: The questions posted in this forum by you guys are all very valuable and interesting because sooner or later, I will also be confronted with many of them.

Actually, the checkbox select column is described in the help, just not 100% clear and done to the end. So I thought I can only fully understand it by doing it myself.

My "payback", if you so will, is learning by doing and learning from solutions shared by other members of this forum, so I hope everbody keeps posting & sharing !

regards

[NicholasWieland]

Re: Multi select

I'd love to walk you through it, but I won't have time to do that until March. Sorry.

I don't think it will require code, just a box checked and another Action JavaScript step.

We will be waiting with baited breath in March. Thanks in Advance.
:)

[omagarc]

Re: Multi select

Ok; I inserted the function in
Javascript
- Other
- Javascript function declarations

but when I click the button in tells me it cannot find the function.

I Placed a button on the grid row with an ajax callback where
submit data is high,
submit part is grid,
row number is {Grid.RowNumber},
callback type InternalXBasicFunction,
Function Name ProcessSelected

Not sure how to do this either: a grid toolbar button on the grid