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

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

Recommended Posts

Posted

This should be straight forward but it's not - to a newbie anyway.

What I'm trying to do is perform a find based on a date calculation of a membership database. If the find doesn't locate any records, it should show the custom dialog that says, "No membership renewals due in 7 days." When you hit 'OK' it will go back to  a layout called "Member Detail" and sort all the records in the database.

If it finds any records it will go to a new card window, sort them and display the records found. 

The problem is when it doesn't find any records the default Filemaker dialog pops up first saying, "No records match this find criteria." and has the usual 'Cancel', 'Continie' and 'Modify Find' buttons showing. If you hit the Continue button, then my custom dialog pops up. How do I stop the default dialog popping up and just have my custom dialog show?

The script is shown below.

Thanks,

James.

 

Enter Find Mode [ ]

Set Field [ MEMBER::Membership Date Due; Get ( CurrentDate ) + 7 & "..." & Get ( CurrentDate ) + 7 ]

Perform Find [ ]

If [ Get ( FoundCount ) = 0 ]

Show Custom Dialog [ Title: "7 Day Search Results"; Message: "No membership renewals due in 7 days."; Default Button: “OK”, Commit: “Yes” ]

Go to Layout [ “Member Detail” (MEMBER) ]

Show All Records

Sort Records [ Keep records in sorted order; Specified Sort Order: MEMBER::Name_Last; ascending ]

[ Restore; No dialog ]

Else If [ Get ( FoundCount ) > 0 ]

New Window [ Style: Card; Name: "Upcoming Membership Renewals"; Using layout: “Memberships Due In 7 Days” (MEMBER); Close: Yes; Minimize: No; Maximize: No; Resize: No;

Menu Bar: No; Dim parent window: Yes; Toolbars: No ]

Sort Records [ Keep records in sorted order; Specified Sort Order: MEMBER::Member_Name; ascending ]

[ Restore; No dialog ]

Go to Record/Request/Page

[ First ]

Else

Go to Layout [ “Dashboard” (_GLOBAL) ]

End If

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