I've been trying all night to get this to work:
or the 'Drag and Drop using the separation model' http://www.excelisys.com/filemaker-tips-tricks-demos-downloads.php
But all ready have to give up when it come to the auto enter calculation for the handle script:
Let ( [
_trigger = handle ;
_sortdown = Get ( ScriptParameter ) > sort ;
$$sort_id = xLine items ID ;
$$slide_down = ase ( IsEmpty ( Sort LOWER::sort ) ; sort – 1 ; ( sort + Sort LOWER::sort ) / 2 ) ;
$$slide_up = Case ( IsEmpty ( Sort HIGHER::sort ) ; sort + 1 ; ( sort + Sort HIGHER::sort ) / 2 )
]; Main::gGraphics [ 6 ]
I don't know where the tables sort LOWER & sort HIGHER comes from..? or what filed gGraphics is..?
Tried to compare with the working demo file from excelisys but can't get access to see the tables or the different firleds
A simpler method is to add a number field with an auto-entered serial number and sort the portal on the values in the number field. When you need to make a change in the standard order of records in the portal, just edit the numbers in this "sort order" field.
Is there no way of getting the drag and drop to work? Just want to make it as user friendly as possible - for when I'm not using the database myself.
There are drag an drop methods that can work, but they aren't the simplest thing to correctly set up.
Is there a Way to make up and Down arrows to move the records up and down accordingly
I've figured it out now... thanks for every ones contribution...