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

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

Recommended Posts

  • Newbies
Posted

I need help creating a simple date range search script. I want to do the following:

1. Click button to begin search.

2. Enter layout with Calendar to select start date.

3. Click "next" button to continue.

4. Enter layout with Calendar to select end date.

5. Click "next" button to continue with search.

6. Go to layout X and print.

Thanks in advance. I know this isn't that hard, but I'm a little overwhelmed with figuring all this out since I haven't used Filemaker since the mid 90's.

Alden

Posted

Doing finds across layouts isn't the way to go. You would either need to create all these fields on one layout, use a relationship, or use some kind of dialog plug in that would allow you to have the calander drop down in a custom dialog box.

Posted

You could create one layout that looks like a popup. so a script would do the following...

Open New Window

Go To Layout [Date Picker (or whatever you call it)]

Adjust window [Fit]

Then the layout can have two fields: StartDate and EndDate, each field would be a date field so then you could click on the field details and make sure that the pop-up calendar will appear. The layout should also have a Continue or Next button, which will run another script (and a cancel button that will run the script step: Close Window [Current Window] )

Close Window[Current Window]

Go to Layout[Whatever layout you want to print]

Enter Find Mode[ ]

Set Field [ Date ; StartDate & "..." & EndDate]

Perform Find

Print Setup (if you need to adjust the print setup)

Print

Hope this works!

Martha :bigshades:

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