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 8571 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Right now I have a search page which is working well, but when no records are found, the format file simply is empty, except for the navigation bar. This could be misleading to the user. I've tried to search the forum for this question, but I guess I'm looking in the wrong place. Is there a simple way to include a message in the format file saying "no records were found"? thanks.

Posted

No found records is Error 401. Any error will cause the error format file to be displayed (specified in the -error CDML tag).

I'm surprised you are seeing a format file with no records... are you correctly specifying an error file?

Posted

I'm new at all this so you'll have to bear with me. I think I figured out why it is not working, but with my limited knowledge of fm, i'm not sure how to get around it. the problem is that i'm trying to search a database of courses. the search page is simply a dynamic drop down menu of all courses in the course db. The retrieved records are based upon a portal of related records. The portal represents instances (dates, times) of a particular class. So even if a particular course has no scheduled dates in the date portal, it is still technically a "found record". But if there is no info. in the course portal, i want an error message, not an empty format file. I'm not sure how to get around this. Thanks.

Posted

OK, create a calc field in the master db that counts the number of related records (use the Count() function).

On the html format file, use an IF conditional that displays the portal if the count cal field is >0 ELSE create a little message to say there are no records/classes/whatever.

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