Need to allow a user to select a range of Locations from a Grid

I'm working on a project that will allow a stockroom manager to mark locations as "allowed" for a given task. My Form's current state looks like this:

Screen capture of the current Form design

If the user checks boxes manually, or uses any of the 3 buttons at the bottom the Form works perfectly. The "Main Location" drop list acts as a filter to only work with a specific Location, and causes the Primary Collection (and Grid) to display all the possible Locations that can be selected.

What I need is some way for the user to enter/select a "start" and "end" location that are in the current Main Location. Ex: 10 00 01 through 10 00 358. Then have the three buttons perform their action on the range specified.

I was trying to allow the user to use just a Combo Box to set the values, but I'm hitting the record cap for entries. I'm wondering if I should just make it two Edit fields, tie it to Locations & then just run the check to see if what they typed in is a valid Location.

Is that the best way to process a range of values in a Grid? I was originally trying to do something similar to Excel with row selection but it is not possible.

Find more posts tagged with

Syteline Development

Accepted answers

BradleyBrown

One way could be to use a start and end button that are enabled when the user checks the "Select range of locations" checkbox. The user selects the first row in the grid then clicks Start. The selected rows Location, or whatever property value you want displays in the edit component. Record the rowID or key value from the selected row as your starting value.

The user repeats the process for the End row. When the user clicks the End button, along with setting the necessary values you can check the boxes in the grid between the selected rows with form script.

All comments

BradleyBrown

Stephen Cena

So you are saying still use the existing Check Boxes, just alter their behavior so they can be used with the fields you added? I like the idea, I just want to be sure I'm understanding you correctly. Or does the Grid have some way to tell you the currently selected row? (Haven't headed back to documentation yet)

M3_Group_Amir_Presentation_230523.pdf

Legacy Contributor

You could try something on the form Service Order To Be Invoiced Report

BradleyBrown

I was suggesting that the user click the row, then click the start button above the grid. Repeat for the end row.

The way you suggest might work as well. You could use a data change event on the checkbox to determine the row selected, and whether the start row has already been selected and then set variables accordingly. That would be a little more work to do in form script, but would save the user the additional clicks to the Start/End buttons above the grid as I suggested.

Once you've determined the start and end rows you can use form script to check all the grid checkboxes.

Stephen Cena

I'd much prefer your solution as it's less hassle. Can the Grid tell you what the currently selected row is, or can the Primary Collection?

Legacy Contributor

Of course you could always do it the SyteLine way and just have the user use User Preferences to override the drop-down list record cap to show all the entries in the drop-down lists. I believe there is also a record cap override you can set in the List Source definition or on the component itself (ThisForm.Components("MyComponent").RecordCap = 0 or something like that).

Stephen Cena

"With great power comes great responsibility". We've got users who still manage to cause problems even with the record caps in place.

More serious reason, users aren't really trained on how to use CSI rather "this is what you do".

Legacy Contributor

I have had to do something similar to get around record caps, lets say you are generating a pick list and need to manually select 50 serial numbers but they are in a list of 500 and the serial numbers are randomly selected, there is not a good way to do this on there end so I added a field they can barcode scan into and form script to search the grid for a matching record and select it for them, so all they need to do now is scan, scan, scan. In the Form Script, once I hit the record cap, I check to see if there are more rows with the IDOCollection.GetMoreRows() method storing a count of records (GetNumEntries) before and after to tell me when I have hit the end of the serial list.

0911060553270289.pdf

Copyright © 2025 Infor. All rights reserved.