5 posts in this topic
Charts from value list
Hi can anyone point me in the right direction, I have a database that as a Field populated by a value list, i.e.,: Christmas,Easter,Mothers Day , etc. I want to chart how many records exist of each chosen category. I thought it would be from a summary field using Total of and count but that option isn't available, How do I get filemaker to count the number of uses of the word Christmas from that field , can anyone help please?
Thanks in advance
[PR] 24U released 24U Toolbox Plug-In 2.0
[FOR IMMEDIATE RELEASE]
24U released 24U Toolbox Plug-In 2.0
The 24U's ''swiss army knife'' for FileMaker developers is now rock stable and fully compatible with FileMaker Pro 14
Prague, CZ -- November 4, 2015
24U Software announces the version 2.0 of 24U Toolbox Plug-In, toolbox of the most useful calculation functions for daily use. The new version have been rewritten to be fully compatible with FileMaker Pro 14 and stable on FileMaker Server even when being used from several simultaneous threads.
Version 2.0 brings:
- Full 64-bit support for FileMaker Pro
- Improved stability on server
- Better registration interface
24U Toolbox Plug-In 2.0's 64-bit support was focused and tested not only on FileMaker Server, but also on FileMaker Pro 14 and FileMaker Pro Advanced 14. Now is fully compatible in both 32-bit and 64-bit modes.
The latest version of the plug-in works reliably with FileMaker Server when the same plug-in is accessed from multiple threads and sessions simultaneously and provides more ways to register the plug-in, and to find out whether the plug-in is registered even without user's interaction.
About 24U Toolbox Plug-In
24U Toolbox Plug-In is a robust FileMaker Pro plug-in which allows FileMaker Pro databases to:
- Execute FileMaker or System shell scripts to automate tasks inside/outside of FileMaker Pro
- Execute SQL commands to develop faster and keep your solution clean
- Match & replace regular expressions to find & replace text fast using patterns
- Merge data values into text while maintaining styling to quickly and easily apply templates
- Lookup DNS name for IP & vice versa to find out who is connecting from where
- Get current public IP to know more about clients and discover potential security attacks
- Define global keyboard shortcuts to avoid unnecessarily excessive use of script triggers
- Obtain precise microsecond timestamps to measure nearly unmeasurable chunks of time
- Get the type of a FileMaker variable to let your scripts make the right decisions
- Share variables between databases to avoid creating too many external data sources
Important update for 24U FM Bench users
24U Toolbox Plug-In is an essential element of the 24U FM Bench optimization tool. Upgrading to version 2.0, thanks to its improved stability, can be beneficial to all FM Bench users who use the tool to benchmark, troubleshoot, and optimize server-side scripts and web-enabled solutions.
Use 24U Toolbox Plug-In to add a completely new dimension to your server-side data processing
Server-side scripts can be efficiently used with FileMaker Server for nightly batch data imports and processing. The powerful features of 24U Toolbox Plug-In let you make this processing much faster and more powerful by being able to use system-level scripts, access your data with SQL queries, merging fields and variables into text, etc.
HOnza Koudelka, Software Division Manager of 24U, says: ''24U Toolbox Plug-In is designed to help FileMaker developers in their daily work by providing a solid toolbox of the most commonly needed simple but powerful functions. This Plug-In makes a lot of functions easier and it is also a key component of 24U FM Bench, our popular tool for optimizing FileMaker solutions.''
System Requirements and Compatibility
The plug-in is fully compatible with FileMaker Pro 11, 12, 13 and 14, and with FileMaker Server 12, 13 and 14.
- Mac OS X: Any Intel Mac, 4 GB RAM, Mac OS X 10.10 Yosemite, FileMaker Pro 14 Advanced and FileMaker Server 13 or newer
- Windows: 1.6 GHz processor, 4 GB RAM, Windows 8.1 or newer, FileMaker Pro 14 Advanced and FileMaker Server 13 or newer
- Mac OS X: Macintosh, 2 GB RAM, Mac OS X 10.7 Lion, FileMaker Pro 12 and FileMaker Server 12 or newer
- Windows: 1 GHz processor, 1 GB RAM, Windows Vista, FileMaker Pro 12 and FileMaker Server 12 or newer
Availability and Pricing
24U Toolbox Plug-In is available as a shareware. User can install 24U Toolbox Plug-In, and try it out for the period of 14 days free of charge. After this period, 24U Toolbox Plug-In can stop working and require a registration code. User will get this code after he pays for a license.
Licenses for 24U Toolbox Plug-In start at US$49 per user and US$499 per server.
Existing customers can upgrade to the new version at 50 % off the regular prices if placing order within 14 days upon release, and 30 % off if buying later.
Customers who have bought 24U Toolbox Plug-In within the last 30 days before the release of the new version are eligible for free upgrade.
Optional Premium Support and Implementation services are available with the purchase of 24U Toolbox Plug-In 2.0.
More info: http://www.24uSoftware.com/Toolbox
About 24U Software
24U is a key vendor of plug-ins for FileMaker Pro and a producer of FM Bench, the tool for auditing and optimizing FileMaker solutions. We unveiled the Marvelous Optimization Formula and teach how to efficiently optimize performance of your solution and processes by focusing on real bottlenecks. Optimizing your performance... Inventing unique iOS applications... Helping organizations to get more out of their technologies... Dedicated to creating the easiest to use FileMaker plug-ins... We connect the dare of education with the experience of industry to achieve the impossible.
Software Division Manager, 24U s.r.o.
(c)2015 24U s.r.o. All rights reserved. 24U, 24U Software, and FM Bench are trademarks of 24U s.r.o. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners. Pricing and availability are subject to change without notice.
We have a table of Suppliers.
We also have a table of Tasks.
When defining a Task, the user chooses a Supplier from a value list that is filtered by Territory.
i.e. the Task will have a Territory defined and only the Suppliers operating in that Territory are selectable.
However there are some Suppliers that work across ALL territories.
I would like to have a way that these Suppliers are included in the value list for ANY territory, so if the Task has the Territory defined as (say) Sydney, the value list will show the Suppliers relevant to Sydney AND Suppliers that cover all territories.
Free Video>>> FileMaker 14 SVG Icon Helper - Rev 2
By Richard Carlton
FileMaker 14 SVG Icon Helper - Rev 2 | FileMaker 14 Training
Download the FileMaker Pro 14 & FileMaker 14 for Mobile Devices Training Videos athttp://www.learningfilemaker.com
Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos
Please Subscribe While There.
This updated Revision 2 (August 2015) features Claus Lavendt, of DataManix, showing a free FileMaker solution that helps customize SVG icons for use on FileMaker 14 buttons.
Download a free copy of the SVG Icon Helper Tool here: http://fmstartingpoint.com/market.html
Richard Carlton Consulting, Inc. provides customized database development services for business, government, and non-profit organizations. Our core competency is FileMaker Pro, where we hold FileMaker's highest certifications. With a team of 27 staff, we are capable of deploying both small and large solutions for a wide variety of customers. We service all modern versions of FileMaker Pro, FileMaker Server, and FileMaker Go (for the iPad and iPhone). We also deploy FileMaker databases to the web, and offer PHP/Web Development, iOS Programming, FileMaker Server Support, and Hosting Services.
Please feel free to contact us at firstname.lastname@example.org
Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
For More Free FileMaker Videos Check out Http://www.filemakerfree.com
Please Comment, Like & Share All of Our Videos.
Feel Free to Embed any of Our Videos on Your Blog or Website.
Watch a FileMaker Training Review Video Here:
Follow Us on Your Favorite Social Media
Hi Guys, I'm stuck to say I wonder if it has with brain power to do...
Table "Pencils" fields:
State Text | Has one of two values: "Activated" or "Deactivated"
Brand Text |Can be one out of many brands......
Pricetag Numerical |the price of each pencil
Sum_Pricetags_samebranded_and_activated pencils Calculation |?????
This is what I can't figure out for the last calculation field in the table "Pencils", How do I make a calculation out of the following:
In the calculation I want the Pencils from the same brand and with the same state "Activated" have their pricetags summed up and only if the two conditions are met.
2 pencils are of same brand and they are both in the state "Activated". The one pencil have a pricetag of 18£ and the second one have a pricetag of 10£
Because they are of same brand and both have the same state, I want their price to sum up, 18+10=28£
It does not matter what the field say if the conditions are not met for other records, the field then can stay blank.