FileMaker Sequence Helper Solution

SEQUENCE_HELPER is a module for FileMaker Pro developers that will make it easy for you to create re-orderable lists in your solutions.

Installation is a breeze. There are only 4 things that you’ll need to do to get up and running with it:

Create a new Calculation (text) field called "SEQUENCE_HELPER_ID" that has the following formula: GetFieldName ( <> )
Copy scripts from demo file into your solution
Give your sequence/order field a layout object name of “SEQUENCE_HELPER”
Attach the “Increment Sequence” and “Decrement Sequence

You can download the Demo File Here.

If you have any questions, be sure to post in the comment section below.

Cheers,

Matt Leering

Matthew Leering 11 April 2017 Report
Unfortunately, yes...
Since it is doing a Replace Field Contents, it will chug a little if you have a huge found set.
The user will be presented with a progress bar if it's going to take a very long time though, so at least there's that.

Know of something more efficient than a replace?
Always open to feedback.

Matt

Comment Link
Sarah 10 April 2017 Report
Neat prototype, thanks for sharing. If I change the number in the 2nd record to a higher number, i.e. 4, it makes it the 3rd record. Is this how it is supposed to work?

Comment Link
robert 06 April 2017 Report
Can I ask how this module copes with huge found sets? I am guessing the 'replace' might struggle a little too? Really nice demo file - very good ideas - cleverly put together in a robust way - thanks for sharing.

Comment Link