Viewing all entries of a value list in a portal

[SteveGriff]

Hi people,

I need a little bit of help solving out this feature: -

I have this field with a number of checkboxes. What I want to do is have a portal displaying the amount of records that each specific checkbox has been checked...

Example: -

Value List called "Cars": "Ferrari", "Skoda", "Lada"

In the portal

Ferrari Checked 4 times

Skoda Checked 6 times

Lada Checked 17 times

Any idea on getting the portal to show each item? I guess getting the count would be Count(Car_Checkbox == "Ferrari") or something... help!

(or would the only way to do it is to have 3 calculation fields having count() for each checkbox type?)

Thanxs

Steve Griff

[LiveOak]

It depends upon what you mean. 1) Do you want each row of the portal to be a single record with a particular checkbox selection or 2) each row of the portal to show the total of times a particular items has been checked.

If 2):

Portals are just views into other files. First you need to create another file in which each records is the total of the checks for a particular item. You will need a record for each selection "Nissan", "Toyota", "Suzuki", with the selection name is a field "Car". Relate the field "Car" back to the checkbox field in your original file. Create a total in your new file using a calculation defined as CarTotal (calculation, number) = Count(relationship::CheckboxField).

Then, create fields:

kOne (calculation, number, indexed) = 1

in both files. From your original file create a relationship to the new file matching kOne to KOne. Create a portal based upon this relationship and place the field kOneRel::CarTotal in the portal.

-bd

[SteveGriff]

cool, it works, thanxs!

Yeeha!