Search Results
24 functions found:
1. | 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. | |
2. | colorContrast ( color ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns a 0 for dark and 1 for bright | |
3. | coloris ( defaultColour ; swatches ; targetScript ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns html and javascript for coloris colour picker to be rendered in a webviewer. | |
4. | coloris.js |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
javaScript functions for coloris custom function | |
5. | colorTint ( color ; tint ; output ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns a colour tint of given hex colour | |
6. | containerAttributesAsJSON ( container ; attributeName ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns container attributes as JSON array with added filetype if file has file extension | |
7. | convertWeight ( value ; input ; output ; precision ; separator ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Converts input of weight to grams, ounces or pounds | |
8. | distanceToTarget ( targetLat ; targetLng ; startLat ; startLng ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns distance between two sets of gps coordinates in metres. | |
9. | doOnOrientationChange ( fmScript ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Triggers a designated FileMaker Script upon device orientation change | |
10. | fullTableSQLasJSON ( tablename ; condition ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Performs SQL query on designated table and returns response wrapped as JSON. | |
11. | getObjectLeftPosition ( object ; offset ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns objects left position on Layout | |
12. | getObjectTopPosition ( object ; offset ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns objects left position on Layout | |
13. | isUUID ( uuidString ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Test if input string is a uuid | |
14. | JSON.eSQL ( field ; modifier ; table ; join ; condition ; group ; order ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns ExecuteSQL as a JSON in FileMaker Data API structure | |
15. | JSON.MakeArrayObject ( ValueList ; Separator ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Simple function that wraps a list of values in an array object. | |
16. | JSON.URLParameters ( JSONpayload ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns JSON as url parameters | |
17. | listWeekDays ( startsOnSunday ; dayLength ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns a list of weekday names in language (locale) set by operating system | |
18. | locationJSON ( accuracy ; timeout ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns response from Location function as JSON instead of return delimited text | |
19. | locationValuesJSON ( accuracy ; timeout ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns response from LocationValues function as JSON instead of return delimited text | |
20. | passwordGenerate ( pwLength ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
This function generates a random password that includes uppercase letters, lowercase letters, digits, and special characters, ensuring diversity and security. | |
21. | 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”). | |
22. | roundToNumberInList ( target ; array ; operator ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Round a target value to nearest number in given list | |
23. | SQLasJSON ( tablename ; fields ; condition ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Performs SQL query on designated table and returns response from declared fields wrapped as JSON. | |
24. | URLParameters.JSON ( payload ) |
![]() ![]() ![]() ![]() ![]() |
|
Jonni™ | |
Returns url parameter format as JSON | |