Hi,

I've been learning FileMaker over the last few months. One thing I haven't really approached is loops, and this is the first time that I think I really need to use them, although I hope if I'm wrong that you'll let me know.

I want to have a queue system where each new record is given the highest rank and I'd like to have this feature:

a text box where you can enter a new rank (let's say X) for a record and have a script move the record currently at X to X+1, and so on.

If you've used any ranking feature, like Netflix' queue, it should work very similarly.

I don't want to ask anyone to do the grunt work for me, obviously, but I'd really appreciate it if you can give me the overview on how to use loops (or not) and in conjunction with which functions.

Thanks for any help.

Edited August 6, 200916 yr by Guest

I think you are looking for something like this:

http://excelisys.com/web/downloads/index.php

Click on Portal Line Shifter.

That's exactly the idea. However, if there are more records, and one of them needs to be moved 40 spots, I'd like to just have an input field to assign its new rank and move all the other affected records accordingly. That's why I think I might need a loop.

Thanks for your example. It is pretty neat.

Not my example. It's Excelisys's. I shared your thanks though.

Also, I am working on the whole NetFlix queue concept using Script Triggers... file soon.

Edited August 6, 200916 yr by Guest