You should be able to define the lookup table in JavaScript, and then
use it in a rule to return the appropriate result. Something like this:
function GetIndex(array, item)
{
for (var i = 0; i < array.length; i++)
{
if (array[i] == item)
return i+1;
}
return 0;
}
function RankItems(array)
{
var result = "";
var rank = 0;
for (var i = 1; i < arguments.length; i++)
{
var item = arguments[i];
var index = GetIndex(array, item);
//result += index + "\t" + item + "\n";
if (index && (!rank || rank > index))
{
rank = index;
result = item;
//result += "*result: " + item + "\n";
}
}
return result;
}
var MyRanking =
[
"ABC",
"PQR",
"XYZ",
"DEF",
"MNO"
];
//return RankItems(MyRanking, "MNO", "PQR", "XYZ");
// above returns "PQR"
return RankItems(MyRanking, Field("Col1"),
Field("Col2"), Field("Col3"), Field("Col4"));
Dan
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable
Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--
