Hello all, I'm hoping you may be able to help.

I have a simple portal setup which monitors the "Job Progress' status of my records. I want to be able to use up & down arrows within each portal row to change the sort order, so I can prioritize and move more important jobs to the top of the list.

I have managed to do this in list view using the following scripts on up & down arrows to swop the numbers in a sort field with the sort order of the list set to sort by the sort no. field.

But these scripts don't seem to work in a portal... any ideas!?

this is the 'move up arrow' script -

this is the 'move down arrow'script -

Any help would be much appreciated!

Go to Record {Next] goes to the next record - not the next portal row. You could use the Go to Portal Row[] step instead, or do the swap in the child table after Go to Related Record[].

See also:

http://fmforums.com/forum/showtopic.php?tid/196029/post/294075/#294075

http://www.excelisys.com/demos-free-filemaker-pro-downloads.php

I'll give it a try and repost results! cheers.

Ok, the script works with go to portal row but it seems to create a blank record at the top and bottom of the portal? why does it do this? and how can I get rid of it. Is it something to do with the "exit after last' or 'Select entire contents'options?

These are my new scripts -

Up arrow script -

Down arrow script -

The [Exit after last] option has meaning only within a Loop block.

If your relationship is set to allow the creation of related records, and you navigate to the last portal row and set a field there, you will create a new child record.

So the exit after last option is not required right?

should I diss allow the creation of new child records within the relationship?

Sorry to sound a bit dumb, I'm just learning!

should I diss allow the creation of new child records within the relationship?

Either that, or make sure that the empty "phantom" row cannot participate in the swap. There is something very similar in my demo mentioned above: you cannot bump the first record up, or the last one down.

Thanks so much for your help, I have disallowed the creation of new records via the relationship and deleted the new child records the script was creating.

And the manual sorting is now working perfectly within my portal.

Many thanks!

Steve