TMS Softare, LLC, d/b/a Taylor Made Services
This is the Home page for the Text Sting Number formatting and Numbers to Words Calculation's Template.
Visit our Business home page at www.tms.us
Download the latest version from TMS Templates.
TMS Software, LLC, developed this extension for the Claris Community. It is a FileMaker solution that provides calculations for Text Sting Number formatting and Numbers to Words Calculation's Template.
The template is for FileMaker Checking and Number's Text String Calculations. This template helps convert numbers in text string calculations with formatted numbers in the way you can format fields with the Inspector in Layouts.
Using this tool, you can convert 12345.6 to a text string such as "Please pay $12,345.60 by tomorrow" with the number formatted as you specify for currency, thousands separator and decimal separator, and number of decimals.
Additionally, you can convert a number to text such as 12345.60 to "*** Twelve Thousand Three Hundred and Forty-Five Dollars and Sixty Cents ***", which is commonly used with checks.
This tool requires FileMaker Pro version 18 or higher. It provides examples as a field calculation, scripting calculation, and custom function.
The template is licensed at no cost and can be found at tms.us/FM We only request you give us credit in your calculations, script and/or documentation.
This is an extension meaning it is not designed to be a final solution. This is for you to use to copy, edit and incorporate the script into your own solution.
We hope this solution can assist you in your business process needs!
The solution is provided as-is with no warranty of functionality and was prepared as freeware released to the FileMaker community. TMS Software, LLC retains the rights to the code, but asks that if you make use of it, you give us appropriate credit. And if you need assistance in implementing this solution, our consulting services are available and you can contact us at www.tms.us or 877-709-7072.
This software was developed by Taylor Sharpe, FMCD, the President and owner of TMS Software, LLC, a FileMaker Business Alliance member and certified developer. He is also the Co-Chapter Coordinator of the FileMaker Pro Users Group of Dallas. You can contact Mr. Sharpe at Taylor@tms.us