1 Reply Latest reply on Mar 17, 2011 8:11 AM by philmodjunk

    calculation, script trigger? make a record unaccessible from a portal

    kilbot

      Title

      calculation, script trigger? make a record unaccessible from a portal

      Post

      Is there to use a check box so as when it is checked it would make the record unaccessible from a portal on another table?

      Thanks

        • 1. Re: calculation, script trigger? make a record unaccessible from a portal
          philmodjunk

          Use a portal filter or relationship on the portal that includes matching to a value (or absence of a value ) in that field.

          With a portal filter (FileMaker 11 Only), you can simply use IsEmpty ( portalTable::CheckboxField )

          With older versions, you'd need to play games with the relationship to get the same results.

          Please note that the change in values won't automatically remove the record from another user's portal the instant the value is changed. The other user won't see the record disappear until their screen is refreshed.