portal rows from checked checkboxes

[vierdewereld]

Can't seem to understand the relationship trick that needs to be applied.

A Value List shows a checkboxlist from the field (text).

I need to have the checkboxes that are selected (on each record differently) appear as rows in a portal. This way I can click in the portal and go to the related record in the same document.

Really handy to move between records.

Any ideas?

[LiveOak]

If I understand you question, you want records with ANY checkbox selection to show up in the portal, not just a particular selecton. If this is the correct question:

Create a calculated field (make sure it is stored and indexed):

PortalKey (calculation, number, stored, indexed) = notIsEmpty(YourField)

Create another field to match this one:

kOne (calculation, number, stored, indexed) = 1

Create a self-relationship with kOne <---> PortalKey

Base your portal upon this relationship.

-bd

[vierdewereld]

Hi LiveOak, thanks for your reaction.

Cool idea the PortalKey calc.

I just need to have the checkboxes that are selected on that record in the portal.

Sorry for being unclear.

[Fenton]

I can't see how to do this. Portals can only show what's in the records. The field in the portal is going to show multiple values, because that's what a checkbox field is.

The only way I can see to do this would be to send the checkbox values out into a small file as separate records. Then a simple Go To Related Record ["Checkbox"] would give you a list you could click to come back to records matching one value.

This is in fact what I've done, in an archive file of information with index words.

Or to create separate buttons over the mulitiple values, based on Position of carriage return (not over checkboxes though, they won't work for this either; you don't know the order or the position of any particular item).

Maybe someone else can solve. It's a twister for sure.

[ernst]

Hi vierdewereld,

If I understand the question correctly then you could get the desired result by defining a second valuelist that shows values from the field(text), but only from a relation.

For this relation use a 'self' relation that relates to the same record, for example by having a unique serial number on each record and have the relation's left and right field use that serial number.

I attached a small example.

Regards,

Ernst.

(Goed he, zo lekker onduidelijk in het Engels...)

checkbox test.fp5.zip

[Ugo DI LUCA]

Hi,

Still not clear what you're looking for.

Seems like I have the same interpretation than Fenton, and quite the same suggestions.

Though, you could perform this "add items" step in the related file (or line item),

- each checkbox being new records,

- scripted,

- related to the Foreign ID by another scripted Indexed ID.

You therefore would have 2 Target keys in the related file. One that match only 1 record, and one that returns all "related" related records.

That's the way my parts in Items are pulled into the Line Item...

[vierdewereld]

WOW Thanks for all the quick reactions!

(Goed he, zo lekker onduidelijk in het Engels...)

You're right Ernst, I have some trouble explaining things in English.

Anyway, attached is my solution and it is as easy as can be.

When you see it you will probably say:

[color:"brown"] WHY DIDN'T YOU SAY SO THE FIRST TIME!

Perhaps you can put this solution to a use somewhere.... enjoy!

linked by checkbox.zip