Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Calculated Field not working properly via PHP


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

Recommended Posts

  • Newbies
Posted

I have a 2 related tables and 1 of the tables has a calculated field which counts the number of related records in the other field and returns 1 if there are records and 0 if there aren't records. When viewed in the FileMaker client, the values are working properly, however, when fetching the records via PHP all of the values are 0. The calculated field is

 If ( Count(table::IDField)>0  ; 1; 0)

Am I doing this wrong or is there a better way to do this?

Posted

Check if the account you are using to connect to the database from PHP has permissions to access records from the related table.

  • Newbies
Posted

The problem was based on global variables. I hadn't realized they were set on a per user basis, thanks for the help.

This topic is 5029 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.