Operations with the portal rows

[199cm]

Hello!

Is there a possibility to show/hide portal rows?

I have a table in my database for offers, which operate with data from another table through the portal. And I have the invoices file, where the same portal is placed. No problems so far.

But, in invoices file I must hide some lines in portal. The deletion is not allowed, because the offer should stay untouched.

Is there a way to do this?

[Fenton]

By the "same portal" you mean the same relationship and fields.* You could add another criteria line to the relationship; something like: and "this" does not match "that", or it could be: and "this" matches "this". Either way could cause records to drop out of the portal. But at this point, we don't know which.

You just have to decide what the criteria that makes a difference is, and think about what fields would match. It may be necessary to create a "constant flag" field, which is a calculation, = 1 (that's it, result number), to match a newly created calculation field field (which produced a 1 only if specified conditions were met; it would be best if these were both Stored fields).

* If you duplicate and reassign a new relationship to the portal, you will need to retarget the fields. But all you have to do is rechoose the new relationship, the base field will still be selected; it goes pretty quick.

[Søren Dyhr]

But, in invoices file I must hide some lines in portal. The deletion is not allowed, because the offer should stay untouched.

Is there a way to do this?

But you need to explain why you haven't taken the deletions out of the users privileges, and then make it scripted to remove the last one entered provided the user id is the same as creator id?

--sd

[199cm]

Thanks for your reply!

I should apologize, I forgot to mention one important thing in my post. The deletion of portal rows in my invoice table should be a user choice. When a invoice is created, portal shows all the records from offer. After this with the help of check boxes user decides which row to hide. It would be easy, to delete the row but I need just hide.

[bruceR]

This might be easier with Filemaker 11 filtered portals.

[Søren Dyhr]

After this with the help of check boxes user decides which row to hide. It would be easy, to delete the row but I need just hide.

There is a userinterface issue here, not quite abiding to...

http://developer.apple.com/Mac/library/documentation/UserExperience/Conceptual/AppleHIGuidelines/XHIGIntro/XHIGIntro.html

--sd

[Fenton]

Simple example

Hide_Portal_Rows.fp7.zip

[199cm]

Thank you very much Fenton!

This is exactly, what I need!

[Fenton]

Good. Small addition. It is nice to run a script to reset checkboxes like this, so it has immediate visual effect, rather than having to click out of the portal to see what happened.

You would probably not put the Hide checkbox in the 2nd portal, unless the person looking at the filtered portal has business rules permission to hide things from themselves.

Hide_Portal_Rows2.fp7.zip