Possible to Hide a Record in a Portal?

[FruitFul]

Greetings,

I have a solution for my photography studio. In it I have a portal that shows all of the sessions. Within each row there are check boxes to track its status 'in house'. Editting, at the lab, etc. Once the photos are picked up by the client, I would like for us to be able to click a 'hide' option within the portal that will simply drop it from the list...

Is there any way NOT to show all of a related record set? That you could somehow have a field that would trigger it NOT to show up in the portal?

[Fenton]

You just need a toggle field in the child table, Hide1,* a number field, with a Boolean value list (1); Field Format as a checkbox.

In the main table, a Constant1, = 1, calculation field (number, can be Unstored, but you might want to leave it stored, to use for other things). Then add that to the portal's relationship, as another criteria (you can do that in 7), but as "not equals".

Then, after clicking the checkbox in the portal, that record will vanish from the portal. You might want a short script to set the related checkbox, so it can Commit Records as the last step. Otherwise you'll have to click outside the portal to make it happen.

*Alternatively you can use an Visible checkbox, which would auto-enter 1, then clear it. Either way.

[FruitFul]

Edit: Answered my own questions

Works awesome! Thanks a ton :)

Edited July 26, 2005 by Guest