3 Replies Latest reply on Oct 6, 2014 2:09 PM by Mike_Mitchell

    how to select multiple records


      I have a found set of records, and user wants to perform an operation on a specific subset of these. At moment she marks each record individually - tedious as often more than 20. Is there a way to select multiple records, as one might do in excel (does not have to be the same method)?

      Thanks for any help.


        • 1. Re: how to select multiple records

          Felicity -


          Presumably, this is in a List view? If so, you can set up a button for the user to click that, when clicked with no modifier key, starts the selection, and, when clicked with a modifier key (say, Shift) completes the selection. You can then use Get ( RecordNumber ) to mark the starting and ending points and mark all records in between. Alternatively, you can just change the button's appearance using Conditional Formatting to indicate that a selection has been started and then, should the user choose the same record, simply cancel the operation (or just choose the one record, based on your business rules).


          NOTE: I suggest you use a variable to mark the user's selections. Marking a field on each record will not be multi-user safe, as one user's selections will interfere with another user's selections. You can create a return delimited list of selected keys and use that to determine what records have been selected.





          • 2. Re: how to select multiple records

            wow, that was quick.

            thanks sooo much Mike.

            thought it might be something like this, but glad to have method affirmed by an expert.


            • 3. Re: how to select multiple records

              Well, eventually an expert might confirm. Until then, you can work with what I gave you.