Is it possible to select multiple rows in a list or table view? I have not been able to accomplish this.
not in a native way like option click / shift click in rows
you can have a helper field ('checkmark') to select (check them..) several lines and then start further actions (using conditional formatting, selected lines can have another colored background), You can get those lines via 'find', etc.
depends on what You want to do with those lines
Thanks, that is what I suspected. I will use the 'helper field' concept.
The helper field may not be ideal since it will not work very well in multi-user environments where you have to worry about record locking and stepping on each other's "found sets".
Instead, collect the IDs of the records that the user clicks on in a global text field or variable. You can use that list to conditionally "highlight" the selected records like Markus indicated. You can also find them by looping through that global field or variable and construct a find request.
If the solution is multi-user, a simple checkbox helper field will not suffice. As you check/uncheck the helper field, the other users will also have their helper fields checked/unchecked.
I use a double helper field. One field to hold the unique value assigned to the current user and another to show a check mark when selected by the user (Hide Object When also works). I also allow for non-adjacent and range selections by using the command and shift keys. There are also Select All and Select None buttons available.
Things to think about.
'I also allow for non-adjacent and range selections by using the command and shift keys.'
This is what I thought was not available.
He's talking about using the Get(ActiveModifierKeys) function within a script.
Using global text field, go to related records also can make found set. (of course need additional relationship)
I've took this from ulearnit but sadly link is broken
You create that script, you attach it to a field
Set Field [ Bible Articles::glb current record_id ; Get ( RecordID ) ]
Set Variable [ $modifier ; Value: Get ( ActiveModifierKeys ) ]
If [ $modifier=1 ]
Set Variable [ $$selected ; Value: Let(me=Get ( RecordNumber ); GetNthRecordSet ( Bible Articles::G3 Ref G3 et srefs ; Min($$origine_foundset_number;me) ; Max($$origine_foundset_number;me) ) ) ]
If [ $modifier=16 ]
Set Variable [ $$selected ; Value: List($$selected;Bible Articles::G3 Ref G3 et srefs) ]
If [ $modifier=0 ]
Set Variable [ $$selected ; Value: Bible Articles::G3 Ref G3 et srefs ]
Set Variable [ $$origine_foundset_number ; Value: Get ( RecordNumber ) ]
Perform Script [ “set destination layout” ]
Then, you put a big text empty box along the line, in he background, with transparent fields, and you put conditional formatting on it for the background color as below
Bible Articles::glb current record_id=Get ( RecordID )
not IsEmpty (FilterValues ( Bible Articles::G3 Ref G3 et srefs ; $$selected ))
In these exemple "Bible Articles::G3 Ref G3 et serfs" is the key of the table
You can try to check this link
Checkbox Record Selection In A Multi-User Environment – FileMaker Inspirations
Depending on the way you are using the the selection for you could store a list of keys in a global variable and use that.
"depends what You want to do with those lines"
- can make it easier... also, if You are running a standalone version..
Thanks for all the suggestions and links, I have several options to solve my issue.
Retrieving data ...