I can't get find a range of dates with a script. The following script is supposed to find the last 12 records on the layout. The Perform Find results in the error that the provided find criteria is not correct. Even if I use Enter Find Mode and insert the variables, I get the same error. What gives?
Layout [ “Log” ]
Show All Records
Sort Records [ Keep records in sorted order; Specified Sort Order: Log::Date; ascending ] [ Restore; No dialog ]
Go to Record/Request/Page [ Last ]
Set Variable [ $End; Value:Log::Date ]
Set Variable [ $start; Value:$end-12 ]
Perform Find [ Specified Find Requests: Find Records; Criteria: Log::Date: “$start...$end” ] [ Restore ]
//Enter Find Mode [ ]
//Set Field [ Log::Date; $start...$end ]
I have a database that lists grant applications.
I need for my user to be able to view the records in a number of ways according to certain criteria for analysis purposes. These records are displayed in a List layout.
I need to be able to:
1) see only records where the submission dates are between x and y
2) filter these records according to what is selected in 2 dropdowns - Outcome and Status. The Outcome field dropdown value list is : <blank>, granted, unsuccessful, unknown. The Status field is dropdown value list is: <blank>,submitted, in progress, finalised. The <blank> is where that dropdown criteria are not required.
Ideally, I'd like to be able to set the dates, select from the dropdowns and perform the find, but happy to do it in 2 steps if necessary.
I've tried several things from solutions found searching the internet, but nothing seems to work and I'm getting increasingly frustrated with it. I'm not a coder and anyone good enough to help me out here needs to be aware of this. While I've been using FM on and off for a number of years, I'm by no means an expert or even near it.
Thank you in advance for any guidance with this. You guys have helped me out in the past.
Hi there - I need to create a simple crosstab report and wondered if filemaker 17 has this functionality built in ? If not can somebody point me in the right direction on this please. It would be very much appreciated.
Also once ive created a series of reports how can i combine them so they appear at the press of a button in a single document ?
Any help would be much appreciated.
I have a runtime solution that was created in FMP 12. This no longer works on High Sierra or Mojave.
My iMac just gave up the ghost , but Mojave would not have run on that machine anyway.
So Instead of sinking money into a new Mac, I am looking to see if there is anyone here on the forum that I could hire to render the runtime for Mojave (from the previous fmp12 file), do a simple runthrough to verify that everything works well and then create an installer package/DMG to get me (and my customers) back up and running. Thanks for your time and consideration!on in this matter