This stream auto-updates
- Past hour
Duh. How embarrassing. But with that correction, it works perfectly. Thanks very much to everyone who helped.
doughemi replied to -dp-'s topic in Managing Scripts
Thank you very much for troubleshooting this, and for suggesting so efficient a correction to my code verbosity. I implemented all of your suggestions. I created a clone and imported. I changed Set Field to Insert Calculated Result. I changed the calculation to the one you suggested. It's still broken, but we're making progress. I can see what's happening in the debugger. It's entering only the first date in the calculation. For example, if I click on March, it enters "2017-03-01...?" So, it's not resolving the second half of the calculation. Here's a copy/paste of exactly what I entered. Date ( Get ( ScriptParameter ) ; 1 ; Year ( Get ( CurrentDate ) ) ) & "..." & Date ( Get ( ScriptParameter ) + 1 ; 0 ; Get ( CurrentDate ) )
I have a portal within my main layout that I use for all phone log comments and documents. Is there an example or a (best practice) way to create a search field that searches within that portal only and shows the correct records searched?
Kims, What do you wish to do in case of tie? For instance, two identical amounts can actually appear in different quartiles - the first being in section 3 (for example) and the next duplicate in section 4. Sorting, of course, sorts by Amount but then by order of creation. If you wish ties to hold the same quartile number, it might get more complicated.
Okay, I have managed to reproduce the problem. It's a bug. 1. How to work around the bug: Use Insert Calculated Result instead of Set Field. 2. How to avoid the bug: Save a copy of your file as clone (no records) and import the records into the clone. The new file's date format will be YYYY-MM-DD and your script will work. 3. How to avoid the bug and follow the best practice of not having your script depend on any date format: Make your script do: Enter Find Mode  Set Field [ Calendar::calDate; Date ( Get (ScriptParameter) ; 1 ; Year ( Get (CurrentDate) ) ) & ".." & Date ( Get (ScriptParameter) + 1 ; 0 ; Year ( Get (CurrentDate) ) ) ] Perform Find  where script parameter is a number between 1 and 12 (there's really no good reason to send the month name as text, then spend 12 lines of code converting it to a number).
My short date format is set to YYYY-MM-DD. I've attached a screenshot.
Still struggling unfortunately, thanks for your continued help. I copied the text from my Open URL script, everything is ok with the resultant email below except there’s no active hyperlink to my file. "mailto:=John Fower;Paul Bowater;Gerarda Hadfield;Josh Parker;Steve Bramley;Neal Fussey;Graham Crosby" & "&subject=Lookahead Report" & "&body=Dear All,%0D%0DPlease find below linked lookahead report.%0D%0DRegards, Adrian.%0D%0D&" & "&file://G:/Large Files With Links/OTM Planning/Lookahead Report.pdf"
Will Xu joined the community
First thing, your file's date format is MM/DD/YYYY. It is set to always use the current system's setting. Are you sure your OS short date format is YYYY-MM-DD? Because if it isn't, that would explain the described behavior.
See attached. I've deleted all but the relevant layout and script.Thanks. Organizer Copy.fmp12
Could you post a copy of your file with only the date field, the buttons and the script?
I'm stumped. I need a calculation that will return the quartile rank for a record within a set. I was able to easily do this in Excel, but not so sure how to do this in FileMaker, or if it is even possible to do so. Any tips would be greatly appreciated! For example: I have 14 records. I need to know in which quartile they ranked in based on the amount of their contributions.
kims joined the community
I didn’t know that I could leave the day out of the query. Thanks for the education. The date format is yyyy-mm-dd. Here’s the whole script thus far. ===== Set Variable [ $_year ; Value: Year (Get ( CurrentDate ) )]. /* I haven’t yet started working through what to do if the month is in the next calendar year. */ Set Variable [ $_range ; Value: Case ( Get ( ScriptParameter ) = "Jan"; $_year & "-01"; Get ( ScriptParameter ) = "Feb"; $_year & "-02"; Get ( ScriptParameter ) = "Mar"; $_year & "-03"; Get ( ScriptParameter ) = "Apr"; $_year & "-04"; Get ( ScriptParameter ) = "May"; $_year & "-05"; Get ( ScriptParameter ) = "Jun"; $_year & "-06"; Get ( ScriptParameter ) = "Jul"; $_year & "-07"; Get ( ScriptParameter ) = "Aug"; $_year & "-08"; Get ( ScriptParameter ) = "Sep"; $_year & "-09"; Get ( ScriptParameter ) = "Oct"; $_year & "-10"; Get ( ScriptParameter ) = "Nov"; $_year & "-11"; Get ( ScriptParameter ) = "Dec"; $_year & "-12"; "" )] Enter Find Mode [ Pause: Off ] Set Field [ Calendar::calDate; $_range ] Perform Find [ ] ===== When I run it through the debugger, I can see that it’s building the variables correctly, but it’s not populating the calDate field in the Set Field step. I tried using Set Field [ Calendar::calDate; “\” & $_range & \”” ] but it returned the same error. The error is 500, but I don’t know if validation fails because it doesn’t like what I’m unsuccessfully *trying* to enter, or if it’s not entering anything, which therefore fails validation.
Productive Computing, Inc. posted a topic in FileMaker Product & Service AnnouncementsSan Diego, CA - September 21, 2017 - Productive Computing, Inc., a Platinum member of the FileMaker® Business Alliance, is proud to announce the release of FM Credit Card version 18.104.22.168. This plug-in allows users to easily process credit card transactions in their FileMaker solution. To accompany this release, Productive Computing is also offering flat fee integration packages. Users have the option to integrate the plug-in themselves or purchase an integration package and Productive Computing will handle the scripting and integration process. "Our mission at Productive Computing is to bring the most widely used technologies and mission critical business services to the FileMaker Community – and we do this through our products and services. This includes easy to customize CRM solutions, FileMaker Hosting, FileMaker integrations with QuickBooks, Outlook and Exchange, reselling FileMaker and QuickBooks licenses, and now providing a low cost, flat fee credit card integration that allows you to process a credit card from within your FileMaker app." Keith Larochelle, Chief Financial Officer, Productive Computing, Inc. FM Credit Card functionality includes: Automate Credit Card Transactions - Perform authorizations and capture sales, issue refunds and credits, void charges, and create raw posts. Receive Approval Codes - Get approval codes for each transaction confirming if it successfully processed, if it was declined or if it returned any errors. Three Different Gateways - Use Authorize.Net, PayPal, and Authorize.Net Emulators. Build Custom Posts - Create custom posts to implement additional services offered by your gateway such as processing eChecks or Tele-Checks, Automated Clearing House, and PINless debit transactions. Secure and SSL Encrypted - Take advantage of industry leading SSL encryption to ensure all credit card transactions from FileMaker Pro are secure and safe. Access on Multiple Devices - Use the plug-in's functionality on desktop, laptop, iOS device, or via the web with FileMaker Pro, FileMaker Go, and FileMaker WebDirect (server-side only). Unlimited Users Per Server - With no per-user cost, you can scale your solution easily (server-side only). Clients can purchase the FM Credit Card as a standalone plug-in or with an Integration Package, which includes: - Installation and registration (including connection to your merchant account) - Layout modifications on an existing invoice or order in a current FileMaker app (maximum of two layouts) - Creation of the necessary fields to run FM Credit Card (Credit Card Number, Expiration Date, CVV Code, Capture Response Code, and Timestamp) - Addition of a button to your FileMaker app to process the credit card (Authorize and Capture) For this release, Productive Computing formed a strategic alliance with Pay it Forward Processing with the mission of giving their clients access to more affordable merchant processing rates (US and Canada only). Pay it Forward Processing can match any client's current rate and, in most cases, can reduce credit card fees, including American Express rates. Ninety-eight percent of Pay it Forward's customers saw a savings when compared to their current processor. Pay it Forward Processing also automatically enrolls its clients into their "Every Swipe Benefits Charity" give back program without increasing processing costs, enabling users to pay the same low rates and donate to a worthy cause with every swipe. "In addition to providing credit card integrations, we have formed a strategic alliance with a merchant services provider who we have personally vetted and currently use today. In an industry that is rife with unscrupulous or simply high priced merchant service providers, Pay it Forward Processing has proven to us that they provide the most competitive merchant service fees coupled with the best customer service. We also believe in their 'Every Swipe Benefits Charity' program and, in the 21 years we have been in business, they are by far the best and most affordable merchant services company we have ever used. For those interested, we can arrange to have a free analysis of their current merchant service fees to demonstrate potential savings." Keith Larochelle, Chief Financial Officer, Productive Computing, Inc Pay it Forward Processing offers custom processing programs, including Online, Point of Sale, Mobile and Software and every client is assigned a dedicated personal account manager to handle their questions and concerns. Other advantages to working with Pay it Forward include next day funding and assistance with PCI compliance registration. With no contract or termination penalties, Pay it Forward Processing earns their customers loyalty through quality service and not the threat of exorbitant exit fees. The FM Credit Card plug-in comes programmed to connect to three different gateways. Clients using one of the three supported gateways do not need to switch merchant provides in order to use the plug-in. This plug-in is available for client and server-side deployment and is compatible with: - Windows 7, 8, and 10 and macOS 10.11-10.13 - FileMaker Pro 14-16 (32-bit and 64-bit) and FileMaker Server 14-16 - Windows Server 2012 and 2016 and Mac Server 10.11-10.13 The plug-in is available for $35/year for a single user, $70/year for 10 users, and $250/year for server-side. The server-side plug-in includes a copy of the client-side plug-in for development purposes. The FM Credit Card Integration Package is available for $300 for client-side integration or $400 for server-side integration. For more information on the plug-in, please visit www.fm-creditcard.com and for more information on switching to Pay it Forward Processing, please contact Sales@productivecomputing.com. Plug-in Integration and FileMaker Pro Support: Want help getting this plug-in professionally installed into your FileMaker solution? Do you have other database enhancements you would like to have programmed? We can help! The process is easy - complete our online Request For Quote form (RFQ) or call us directly at (760) 510-1200 and one of our certified developers can work with you on improving your solution today. About Productive Computing, Inc. Since 1996, Productive Computing, Inc. has been helping its customers become more efficient and profitable by implementing custom software solutions using FileMaker Pro. Utilizing FileMaker Pro as a rapid application development tool, their certified FileMaker developers can create custom applications that a business can run on their Windows or Macintosh desktop computers, in a web browser, on an iPad or iPhone or shared simultaneously on all of these platforms. Productive Computing, Inc. also produces Core4 CRM and Core5 Starter Edition, two off-the-shelf productivity solutions designed to automate your workflow, as well as a suite of FileMaker Pro plug-ins that allow FileMaker Pro to integrate with third-party applications including Outlook, QuickBooks, Apple Contacts and Calendar, PDF forms, digital signatures, and biometric fingerprint scanners. In addition, Productive Computing, Inc. is a full-service FileMaker Pro hosting company. FileMaker hosting services allow customers to host their own FileMaker Pro solutions on Productive Computing servers in the cloud instead of purchasing and supporting the necessary server infrastructure themselves. These same servers also provide the infrastructure for customers who would prefer to subscribe to Productive Computing's Core4, Core5, or Vessel Service Solutions under a SaaS (Software as a Service) pricing model. Productive Computing, Inc. is one of only a few companies in the United States to have earned the highly respected Platinum level membership within the FileMaker Business Alliance and recently won the exclusive FileMaker Business Alliance Partner of the Year award. Productive Computing, Inc. 950 Boardwalk, Suite 205 San Marcos, CA 92078 www.ProductiveComputing.com firstname.lastname@example.org (760) 510-1200 Press Contacts: Productive Computing, Inc. Keith Larochelle (760) 510-1200 # # # ---------------------------------------------------
Fitch started following Scripting a query for a range of dates specified by parameter
Fitch replied to -dp-'s topic in Managing ScriptsThere should not be quotes around the string, could that be it? FYI, if you're looking for a particular month, you can set the Find criteria to simply month/year, or even just the month number if you only want the current year. https://www.filemaker.com/help/16/fmp/en/#page/FMP_Help%2Ffinding-ranges.html%23
You're not showing us how the $_range variable is being defined, so there's very little we can say. We also need to know what date format your file is using.
Who's Online 6 Members, 0 Anonymous, 86 Guests (See full list)
Who Was Online64 Users were Online in the Last 24 Hours
- john renfrew
- John May - Point In Space
- Rick Whitelaw
- Lee Smith
- John Chamberlain
- Mike Duncan
- Ocean West
- Don Kersey
- Peter Wagemans
- Ron Cates
- Will Xu
- Steve Martino
- Al Quimby
- David Wikström
- Becky Miller Tillis
- Josh Ormond
- Scott Pon