November 23, 200520 yr Is there a way to 'count' the number of records within a portal? For example say you have a portal and next to it is a box with the total number of records (as you switch records, the 'Count Total' adjusts accordingly).
November 23, 200520 yr Sure, define a calc field in the parent table that uses the Count() function to count some field in the related file that always has data, like the foreign key: Count Total (calculation, number result) = count(relationship::key)
November 24, 200520 yr Author Thanks! Works great : Next Question... I was also hoping to also use this new count field in a Value List. Basically allowing the user to see the most popular items first. However! When I attempted to use it in a Value List, it said that it would not work as the field could not be Indexed.... Any way around this? Edited November 24, 200520 yr by Guest
November 24, 200520 yr I think you'd need to script the update of the counts, setting a regular number field.
Create an account or sign in to comment