Jump to content
Sign in to follow this  
ernst

Multiple Select in List View

Recommended Posts

Edit -> Latest version is MultipleSelect v2, somewhere down this thread.

This is a simplified example of how to implement multiple selection of records in Filemaker's List view and perform an operation on such selections.

One of the advantage of this method is that it's completely 'network happy' as far as the selecting goes.

When performing an operation on the selected records in a shared database there is of course a chance that a record is being modified by another user, in which case an error is reported. Error handling could be more elaborate then in this example.

One slight disadvantage is that the maximum selection is limited. In this example to about 6400 records. (64000 divided by amount of 'ID'digits+1)

The same idea of multiselecting can also be implemented in portals.

Regards to all,

Ernst

Share this post


Link to post
Share on other sites

There seems to be something missing. Or is just me.

smile.gif

Share this post


Link to post
Share on other sites

looks (or doesnt, since the attachment is missing) like a copy all records (ID fields) in a global text field, then go to related record.

Share this post


Link to post
Share on other sites

I just checked the error capturing when performing an operation on the selected set on our network and some more work needs to be done on that.

Update- did some tweaking and things look promising. Now adding an error message that describes exactly which records were NOT updated because of being editted by another user.

Will try to post the results tomorrow.

Regards,

Ernst.

Share this post


Link to post
Share on other sites

Cool file Ernst.

Just wanted to mention that Christian guess was wrong. This is another method laugh.gif

Be curious!

Thanks again for sharing.

Share this post


Link to post
Share on other sites

Hi, thanks for the positive reactions, and here's the next version...

Added:

- Select All & None function (using the method that Christian suspected!)

- Error checking on the maximum amount of selected records, which is actually 6399 (in stead of 6400)

- Improved multi-user/network behaviour when an operation is performed and one or more of the the selected records are being editted by an other user.

Could not get the multi-user error logging as neat as I wanted without sacrificing speed, so this version just reports that an error occurred updating one or more records and updates the rest of the selection.

The problem is that the operation on the selection gets performed on a seperate layout, looping down through a portal. If a portal record is being editted by another user, filemaker will just not perform the 'goto portal' scriptstep, so one can't read ID of the offending record.

I tried another approach that does not work with a portal and therefor makes accurate error-logging possible, but found that method 4 (!) times slower than the portal looping method.

So I suppose the choice of which method to use depends on whether the operation to be performed is 'critical' or not.

The reason for ranting and raving so much about this all is that I found that the users of my databases really love being able to do multiple-select in Filemaker, but that perfoming operations can cause true Havoc when the error capturing and -logging is not really foolproof...

Anyway, if people are interested in the 'safe but slow' method, and maybe also when they are not, I will post a worked out example with a true error log when I've had the chance to test it out on the network.

Last remark: the file uses a 'custom dialog' and therefor need FIlemaker 6 or higher.

Regards to all,

Ernst

MultiSelect v2.fp5.zip

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.