Limiting Value List to Records in Constrain Found Set

[zach20]

Hello,

 

I have a Value List referencing the values of Field A. There are 10 records containing Field A: Record 1 - Field A contains "1", Record 2 - Field A contains "2", etc up through Record 10 - Field A containing "10". I'm wondering if it's possible that when the found set of these records is constrained and only 4 records are visible, have my Value List contain ONLY those 4 records currently being displayed by the constrained found set.

 

The Drop-Down Menu featuring the Value List is used on another Table.

 

I have zippScript if I need to run anything upon changing field values.

 

Is this possible? Or is there some other similar method?

 

Thanks!

Zach

[AHunter3]

short answer: no

 

 

why: because a value list can only be drawn from indexed fields, and even if there were a Get function such as Get (IsPartOfFoundSet) or Get (IsCurrentlyFound) — which there's not — it would be of no use except when unstored and if unstored it could not be indexed.

 

long answer / exceptions / workarounds: If you are doing a Find, there are some criteria involved which constitute your Find request(s); loosely speaking, there's always going to be a way that you can have a selfjoin relationship between the table and itself, where only the records with the criteria used in your Find request(s) match the relationship, and then set up your value list to show only related values.

 

This is practical if your Find is a Find that you will be repeating each time, either exactly the same or the equivalent; and if the fields being searched on are indexed fields or where indexed fields with the correct info in them can be created and deployed in cases where they are not.

 

You can also "cheat" with a script (which could be ZippScript-fired I suppose) that loops thru the found set and "harvests" the values then dumps them into a local field in the current record, which you then access via a self-join relationship that only matches the current record to itself, like Serial Number = Serial Number or calcfield RecID defined as Get (RecordID) used as RecID = RecID, that sort of thing.

[zach20]

Hello,

 

I ended up trying your suggestion:

 

 

You can also "cheat" with a script (which could be ZippScript-fired I suppose) that loops thru the found set and "harvests" the values then dumps them into a local field in the current record, which you then access via a self-join relationship that only matches the current record to itself, like Serial Number = Serial Number or calcfield RecID defined as Get (RecordID) used as RecID = RecID, that sort of thing.

 

I got exactly what I'm looking for.

 

Thank you!

Zach