Jump to content

Prioritizing Portal Rows


This topic is 6152 days old. Please don't post here. Open a new topic instead.

Recommended Posts

hello,

I am attempting to prioritize rows in a portal. I have tried having a field that is a drop down with the values 1-5, but the fields stay the same, regardless of what data i pull from related tables. has anyone else had experience in prioritizing related information in portals?

Link to comment
Share on other sites

I have been able to sort the data using this method, however, as i switch between records, the data in the priority field stays the same.. Meaning that, if on Record 5 items 1,6,13,15, and 25 are priority 1, when i switch to Record 127 these same items are still listed as priority 1...

Link to comment
Share on other sites

basically, the portal loads PRODUCTION ITEMS that are still in need of being produced. sometimes, only a few parts of the job need to be produced first, while the others can wait. the portal now loads related records, sorted by the JOB ID. I would like to be able to have a single record for each JOB ID, and within this a portal that lists all parts ready to be produced. I need the priority button/field to move the needed items to the top of the list. does this sound possible?

Link to comment
Share on other sites

Yes thats pretty simple, in the row have a button that enters .5 in the priority field, then GTRR(SO) ...sort the records and make a serialized scripted replace on the entire set:

http://www.filemaker.com/help/Script-Steps52.html

But beware, the method isn't multiuser safe, if thats the case must the serial number be pre- or postfixed with the username, in a pilcrowdelimited field that then is translated into the sortorder field.

--sd

Link to comment
Share on other sites

I don't think you need to go as far as scripting a replace, since the internal order of records with the same priority doesn't matter (or so it seems).

A portal sorted by priority should be the answer. It looks like the real problem is with the implementation of this.

Link to comment
Share on other sites

This thread reminded me of a question I've intended to ask:

Does anyone know of a way (maybe a summarizing calculation of some sort) to cause the portal to spontaneously refresh following a selection from the value list?

In the past, I've used a plug-in to trigger a refresh script, but I've often wondered if there wasn't a better way.

Link to comment
Share on other sites

This topic is 6152 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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