By Jim Gill
This is probably one of those questions which separates me from people that make money as developers and those that don't (that would be me). I have a simple script that compares two variables. The variables are populated with text (Peoples Names). Basically, if the the two variables are TRUE (the variables are equal) I want to stop the script. Despite the two variables being equal - the IF continues. I have noted when I use the same numbers to populate the variables - the script works as expected. Please tell me Filemaker is smart enough to evaluate text in variables. Below is the my script and attached is a screenshot of my debugging efforts.
As always - thank you to the people here which share your wisdom - a big reason I love Filemaker so much.
IWP: IWP: Bunk Choice Select
#This script allows WebD users to select bunkmates for the coming summer.
#List All Chosen Names
Set Variable [ $BR_List; Value:List ( BRE__BUNKSREQUEST_tog::Bunk Request Choice 1;BRE__BUNKSREQUEST_tog::Bunk Request
Choice 2;BRE__BUNKSREQUEST_tog::Bunk Request Choice 3;BRE__BUNKSREQUEST_tog::Bunk Request Choice 4 ) ]
Set Variable [ $BunkRequest; Value:Agegroup_Names_List::Name_Full ]
Set Variable [ $BR_Check; Value:FilterValues ( $BR_List ; $BunkRequest ) ]
#IF check to see if the names has already been selected
If [ $BunkRequest = $BR_Check ]
Show Custom Dialog [ Title: "No Duplicates"; Message: "You have already chosen this person. Please give us FOUR differnt names!
Thanks!"; Default Button: “OK”, Commit: “Yes” ]
Exit Script [ ]
If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 1 = "" ]
Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 1; $BunkRequest ]
Else If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 2 = "" ]
Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 2; $BunkRequest ]
Else If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 3 = "" ]
Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 3; $BunkRequest ]
Else If [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 4 = "" ]
Set Field [ BRE__BUNKSREQUEST_tog::Bunk Request Choice 4; $BunkRequest ]
[ Skip data entry validation; No dialog ]
By Richard Carlton
For this Coaches’ Corner tip, John Boubonis demos a simple technique for creating a multi-page Invoice. You can follow along with the demo by getting a free copy of our starter solution, FM Starting Point:
You can download FM Starting Point from this link:
FileMaker Coaches' Corner - Tip 3 - Multipage Invoices - Multipage Printing
Most Recent Upload https://goo.gl/Dbn9fm
Get up to speed with the FileMaker Pro 16 Video Training Course!
Top Rated Course by FileMaker Expert, Richard Carlton.
Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions.
The course is 50 hours of video content!
Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide.
Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers.
He has offices in California, Nevada, and Texas.
Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration.
Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.
Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.
RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA.
Please feel free to contact us at firstname.lastname@example.org
FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
Transform your business with the FileMaker Platform
Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos
Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16
Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing
Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos
A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data
Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project
Free FileMaker videos check out ...http://www.filemakervideos.com
Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com
Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php
Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php
FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review
Use FileMaker to create an app with the FileMaker Training Series
FileMaker Pro is a cross-platform relational database application from FileMaker Inc.
Comment, Like & Share Our Videos.
Feel Free to Embed any of Our Videos on Your Blog or Website.
Follow Us on Your Favorite Social Media
Text manipulation plug-in adds new script steps and online help for FileMaker Pro 16.
Alphen aan den Rijn, the Netherlands, November 13, 2017–Troi today announced the immediate availability of Troi Text Plug-in 4.5 for FileMaker Pro 16.
What is Troi Text Plug-in?
Troi Text Plug-in is a very powerful tool for dealing efficiently with text in your FileMaker Pro database. All from within FileMaker you can:
- Customize spell checking*
- Parse XML text into fields
- Get (unique) lines and sort words and lines
- Combine sets from 2 text fields:
- get all lines that are the same
- get all lines that differ
- and other combinations
* currently not available on FileMaker Cloud
What is new in version 4.5?
We rewrote Troi Text Plug-in for FileMaker 16 and it now has the following new functionality:
- Tested and made compatible with FileMaker Pro 16.
- Tested and improved compatibility with Windows 10 (Creators Update) and macOS 10.13 (High Sierra).
- Tested and made compatible to run under FileMaker Cloud 16.
- Rewrote and modernized the code in several places.
- Made various minor changes to the example files to better work with FileMaker Pro 16.
- Updated the User Guide and the Reference.fmp12 file.
Extra features when running FileMaker Pro 16
Version 4.5 adds the following new features when running in FileMaker 16:
- The Text Plug-in adds script steps when running FileMaker Pro 16. You can select these script steps in the script steps pane in Script Workspace, or you can begin typing the script step name, then choose the script step from the list that appears. The script steps expand the possible actions you can perform with FileMaker Pro. The following script steps are added:
- Learn Spelling
- Unlearn Spelling
- Set Spelling Ignore List
- Added new scripts to the Spelling.fmp12 example file, to demonstrate how to use the new external script steps of FileMaker Pro 16. The examples check if FileMaker Pro 16 is running and will then select these new scripts.
- Added support for online help for the functions and script steps of the plug-in. You can now easily get online help from the Troi website, by clicking the Help button (the small question mark button) next to the function description in the functions pane or the script step description in the script steps pane.
More detailed information on all changes and improvements implemented in Troi Text Plug-in 4.5 can be found at https://www.troi.com/products/textplugin/
More information on Troi plug-ins for FileMaker Cloud can be found at: https://www.troi.com/compatibility/filemaker_cloud/
Pricing & availability
A fully functional demo version of Troi Text Plug-in 4.5 is available for downloading at:
Licenses cost US$ 49 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site.
Version 4.5 needs a new registration. The upgrade is free for users who bought a license for Troi Text Plug-in on or after October 27, 2016. Eligible users will be sent a new registration. Contact us if you have not received yours after November 17, 2017.
Upgrades from licenses bought before October 27, 2016 are available from US$ 29 per user. Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site.
I'm an FM novice who has a functioning database, and I'm trying to add layers of functionality to it. One feature I'm trying to design is a script to search through a Gmail outbox with certain keywords.
In URLs, "%" translates to "%25". Filemaker appears to do this automatically - In Gmail syntax, you need to write "in%3Asent" to have the Gmail search bar contain "in:sent" which searches my outbox. Here's my current code for Go to URL:
This "%" bit translates to "%25". I've tried "\%", I've tried creating a string, x, then having it open x, but no matter what I cannot get "%" to show up as-is, it always translates to "%25". Is there any way around this? I've tried subtracting text, but I just can't seem to get it to work. Any bright ideas? I can't find an answer to this specific question of disabling URL string substitution.