Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 4630 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have a simple FM11 database of inventory. I have set the Privilege Set's (File>Security>Privilege Set) Custom Records Privileges "View" "Limited" to the calculation "On Web = 1" (without quotes) - where "On Web" is the checkbox field that has the boolean of 1 or 0.

So, if the record has "On Web" checked, the record shows up on the website. All this is working fine, as long as the person enters a variable in the find, but if they just click "Find Records", all the records in the database show up. Here's the kicker - all the records that are are not "On Web" are there, it is just that their contents are blank - so, FM is being literally correct, they are not allowed to "view" the record, but it still includes it in the result - albeit, in a blank row.

How can I get FM to not include these records? The site is at:

http://mobayen.macusa.net/findrecords.php

I hope I am being clear here - only took me 30 minutes to write the two paragraphs above...

I am not a php coder (sorry) - this just may be a bug? Or does something in my method look suspicious?

Thanks for any help

-- Don

Posted

Can't tell much without looking at the php code (which we can't see by viewing the site), but it seems like something like:

foreach($records as $record){

	 $checkweb =  $record->getField('On Web');

	 if($checkweb == 1){

		  // your line item display code here;

	 }

}

ought to work.

Posted

You really don't need Custom Privilege's to do this.

just adding a criteria that any search also includes 'On Web == 1' in it will do the same thing... As per doughemi, without php code it's hard to say exactly how to implement this.

This topic is 4630 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.