Search Results
31 functions found:
1. | badgeStack ( width ; height ; defaultArray ; badgeArray ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Generates overlapping circular badges with custom text and styles from JSON, rendered in SVG for display in a FileMaker Web Viewer. | |
2. | CheckReservedSQL ( keyword ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
This function checks if a given keyword is an SQL reserved word or contains invalid characters, returning either an “OK” message or a warning. | |
3. | colorContrast ( color ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns a 0 for dark and 1 for bright | |
4. | coloris ( defaultColour ; swatches ; targetScript ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns html and javascript for coloris colour picker to be rendered in a webviewer. | |
5. | coloris.js |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
javaScript functions for coloris custom function | |
6. | colorTint ( color ; tint ; output ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns a colour tint of given hex colour | |
7. | containerAttributesAsJSON ( container ; attributeName ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns container attributes as JSON array with added filetype if file has file extension | |
8. | convertWeight ( value ; input ; output ; precision ; separator ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Converts input of weight to grams, ounces or pounds | |
9. | distanceToTarget ( targetLat ; targetLng ; startLat ; startLng ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns distance between two sets of gps coordinates in metres. | |
10. | doOnOrientationChange ( fmScript ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Triggers a designated FileMaker Script upon device orientation change | |
11. | fullTableSQLasJSON ( tablename ; condition ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Performs SQL query on designated table and returns response wrapped as JSON. | |
12. | getObjectLeftPosition ( object ; offset ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns objects left position on Layout | |
13. | getObjectTopPosition ( object ; offset ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns objects left position on Layout | |
14. | isUUID ( uuidString ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Test if input string is a uuid | |
15. | JSON.eSQL ( field ; modifier ; table ; join ; condition ; group ; order ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns ExecuteSQL as a JSON in FileMaker Data API structure | |
16. | JSON.MakeArrayObject ( ValueList ; Separator ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Simple function that wraps a list of values in an array object. | |
17. | JSON.URLParameters ( JSONpayload ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns JSON as url parameters | |
18. | LastSaturdaysInRange ( startDate ; endDate ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns a return-separated list of FileMaker-formatted dates representing the last Saturday of each month between the start and end dates. | |
19. | LastSaturdaysInRangeSQL ( startDate ; endDate ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns a comma-separated list of SQL-formatted dates representing the last Saturday of each month between the start and end dates. | |
20. | listWeekDays ( startsOnSunday ; dayLength ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns a list of weekday names in language (locale) set by operating system | |
21. | locationJSON ( accuracy ; timeout ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns response from Location function as JSON instead of return delimited text | |
22. | locationValuesJSON ( accuracy ; timeout ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns response from LocationValues function as JSON instead of return delimited text | |
23. | passwordGenerate ( pwLength ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
This function generates a random password that includes uppercase letters, lowercase letters, digits, and special characters, ensuring diversity and security. | |
24. | passwordStrength ( password ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
This function evaluates the strength of a password based on various characteristics and assigns a strength level (“Weak,” “Medium,” “Strong,” or “Very Strong”). | |
25. | pillCloud ( width ; height ; defaultArray ; pillArray ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Generates a responsive SVG-based group of pill-shaped chips from a JSON configuration, suitable for use in a Web Viewer. | |
26. | progressBarSingle ( width ; height ; radius ; colorBackground ; colorFilled ; pctFilled ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Generates a horizontal progress bar based on a single percentage value, using two custom colours to indicate completed and remaining progress. | |
27. | progressBarStacked ( width ; height ; radius ; backgroundColor ; segmentArray ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Creates a horizontal progress bar composed of multiple coloured segments, defined by a JSON input with individual percentage values. | |
28. | progressDoughNut ( width ; height ; defaultArray ; dataArray ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Generates a customisable, rounded progress doughnut using SVG for display in a FileMaker Web Viewer. | |
29. | roundToNumberInList ( target ; array ; operator ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Round a target value to nearest number in given list | |
30. | SQLasJSON ( tablename ; fields ; condition ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Performs SQL query on designated table and returns response from declared fields wrapped as JSON. | |
31. | URLParameters.JSON ( payload ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns url parameter format as JSON | |