Search Results
37 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. | chartColumnStacks ( width ; height ; defaultArray ; dataArray ) |
| Jonni™ | |
| Draws stacked vertical columns based on range and value input using SVG. Customisable with JSON for appearance, padding, stroke, and alignment. | |
| 3. | chartDoughnut ( width ; height ; defaultArray ; dataArray ) |
| Jonni™ | |
| Displays a multi-segment doughnut chart using SVG, with support for custom colours, stroke width, segment padding, and end caps. | |
| 4. | chartRowStacks ( width ; height ; defaultArray ; dataArray ) |
| Jonni™ | |
| // Draws stacked horizontal rows based on range and value input using SVG. Customisable with JSON for appearance, padding, stroke, and alignment. | |
| 5. | 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. | |
| 6. | colorContrast ( color ) |
| Jonni™ | |
| Returns a 0 for dark and 1 for bright | |
| 7. | coloris ( defaultColour ; swatches ; targetScript ) |
| Jonni™ | |
| Returns html and javascript for coloris colour picker to be rendered in a webviewer. | |
| 8. | coloris.js |
| Jonni™ | |
| javaScript functions for coloris custom function | |
| 9. | colorTint ( color ; tint ; output ) |
| Jonni™ | |
| Returns a colour tint of given hex colour | |
| 10. | containerAttributesAsJSON ( container ; attributeName ) |
| Jonni™ | |
| Returns container attributes as JSON array with added filetype if file has file extension | |
| 11. | convertWeight ( value ; input ; output ; precision ; separator ) |
| Jonni™ | |
| Converts input of weight to grams, ounces or pounds | |
| 12. | distanceToTarget ( targetLat ; targetLng ; startLat ; startLng ) |
| Jonni™ | |
| Returns distance between two sets of gps coordinates in metres. | |
| 13. | doOnOrientationChange ( fmScript ) |
| Jonni™ | |
| Triggers a designated FileMaker Script upon device orientation change | |
| 14. | fullTableSQLasJSON ( tablename ; condition ) |
| Jonni™ | |
| Performs SQL query on designated table and returns response wrapped as JSON. | |
| 15. | getObjectLeftPosition ( object ; offset ) |
| Jonni™ | |
| Returns objects left position on Layout | |
| 16. | getObjectTopPosition ( object ; offset ) |
| Jonni™ | |
| Returns objects left position on Layout | |
| 17. | isUUID ( uuidString ) |
| Jonni™ | |
| Test if input string is a uuid | |
| 18. | JSON.eSQL ( field ; modifier ; table ; join ; condition ; group ; order ) |
| Jonni™ | |
| Returns ExecuteSQL as a JSON in FileMaker Data API structure | |
| 19. | JSON.MakeArrayObject ( ValueList ; Separator ) |
| Jonni™ | |
| Simple function that wraps a list of values in an array object. | |
| 20. | JSON.URLParameters ( JSONpayload ) |
| Jonni™ | |
| Returns JSON as url parameters | |
| 21. | lastPairedWeekendsInRange ( startDate ; endDate ) |
| Jonni™ | |
| Returns a return-separated list of FileMaker-formatted dates representing the last Weekends of each month between the start and end dates where both Saturday and Sunday fall within the same month. | |
| 22. | 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. | |
| 23. | 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. | |
| 24. | listWeekDays ( startsOnSunday ; dayLength ) |
| Jonni™ | |
| Returns a list of weekday names in language (locale) set by operating system | |
| 25. | locationJSON ( accuracy ; timeout ) |
| Jonni™ | |
| Returns response from Location function as JSON instead of return delimited text | |
| 26. | locationValuesJSON ( accuracy ; timeout ) |
| Jonni™ | |
| Returns response from LocationValues function as JSON instead of return delimited text | |
| 27. | passwordGenerate ( pwLength ) |
| Jonni™ | |
| This function generates a random password that includes uppercase letters, lowercase letters, digits, and special characters, ensuring diversity and security. | |
| 28. | 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”). | |
| 29. | 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. | |
| 30. | progressBarASCII ( completePct ; totalBlocks ; colorBar ; colorBackground ; fontSize ; showPercent ) |
| Jonni™ | |
| Renders a colored text-based progress bar using hex colors, font size, and percentage, with optional percent label. | |
| 31. | 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. | |
| 32. | 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. | |
| 33. | progressDoughNut ( width ; height ; defaultArray ; dataArray ) |
| Jonni™ | |
| Generates a customisable, rounded progress doughnut using SVG for display in a FileMaker Web Viewer. | |
| 34. | progressRings ( width ; height ; defaultArray ; dataArray ) |
| Jonni™ | |
| Draws a multi-ring SVG progress doughnut using customisable ring data. | |
| 35. | roundToNumberInList ( target ; array ; operator ) |
| Jonni™ | |
| Round a target value to nearest number in given list | |
| 36. | SQLasJSON ( tablename ; fields ; condition ) |
| Jonni™ | |
| Performs SQL query on designated table and returns response from declared fields wrapped as JSON. | |
| 37. | URLParameters.JSON ( payload ) |
| Jonni™ | |
| Returns url parameter format as JSON | |