Search Results
42 functions found:
| 1. | AddRemoveItem( theList, value, AddRemoveAuto ) |
 Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Allows you to Add or Remove an item from a list either automatically or directly (will not create duplicate items) | |
| 2. | Age( Birthdate ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Calculates someone's age based on their given birthdate | |
| 3. | AgeOnDate( Birthdate, AgeDate ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Calculates someone's age based on their given birthdate and the specified date to use as their "Age On Date" | |
| 4. | DateRange ( Range ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Creates a searchable date range to populate any date field while in Find Mode | |
| 5. | FormatDate ( Date, Format ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Allows you to easily reformat any date | |
| 6. | FoundCt( pk_Field ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Looks up the table using the primary key field to determine how many records exist in that table | |
| 7. | FoundSet_List ( field, isUniqueList ) |
 Average rating:
5.0 |
|
| Kyle Williams, Augusto Digital | |
| Create a List or a Unique List of values from one field from the found set of records. | |
| 8. | GetAsCurrency ( Label, Num, RedNegative ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Formats any number into currency | |
| 9. | GetAsFMTimestamp ( source ) |
| Average rating:
5.0 |
|
| Kyle Williams, Augusto Digital | |
| Converts any date or timestamp (including Unix and ISO) to a valid FileMaker formatted timestamp | |
| 10. | GetAsFMTimestamp_Offset( source; HrsOffset; Include_Seconds ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Similar to my other Function GetAsFMTimestamp, but provides 2 additional parameters | |
| 11. | GetDuration ( tsStart, tsEnd, DurationType ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Calculates the duration between 2 timestamps in | |
| 12. | GetFieldRepetitionCount ( FieldName ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Allows you to easily look up the maximum number for repetitions for a field | |
| 13. | GetNumberListAsText ( numList ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Used to convert a list of ids or numbers to a string of text | |
| 14. | GetRecordAsJSON |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Gets all static fields as JSON from the current record's context | |
| 15. | IsEven(Number) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Is the number Even? | |
| 16. | IsNumeric (text) |
| Average rating:
2.0 |
|
| Kyle Williams, Augusto Digital | |
| Is the string numeric? (is it a number?) | |
| 17. | IsValidJSON( JSON ) |
| Average rating:
5.0 |
|
| Kyle Williams, Augusto Digital | |
| Used to determine if we are passing valid JSON | |
| 18. | isValidZip( zip ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| used to determine if entered zip is a valid 5 or 9 digit zip code | |
| 19. | JSON.GetValueLists ( isVirtualList ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| This creates JSON that can be used to look up an id or JSON designed to populate a Virtual List | |
| 20. | JSON.List_Layouts |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Creates a List of all Layouts and Layout IDs in JSON format | |
| 21. | JSON.List_Tables |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Lists all Table information in JSON format | |
| 22. | JSON.OmitArrayValues |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| This function will allow you to omit a list of values from an array using values from a second "Omit" array. | |
| 23. | JSON.PrependArray( JSON ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| This will add a new item to the beginning of a JSONArray | |
| 24. | JSON.SortArray_v2 ( $jsonConfig ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Sorts a JSONArray using a JSONArray | |
| 25. | JSON.stringify |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Converts JSON to a string of text | |
| 26. | JSONCountKeys ( JSON, Path ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Counts the Keys in your JSON to provide a Found Count. | |
| 27. | JSONFormat( JSON ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Formats JSON and eliminates BOM (invisible) characters | |
| 28. | JSONGetElementsAsVariables ( JSON; Globals; Prefix ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Converts JSON to Variables or Global Variables (Supports JSON sub arrays) | |
| 29. | JSONMergeListOfArrays ( ListOfArrays ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| This allows you to use a summary List or use List( table::name ) to look at a JSON array for several single records and merge them into one. | |
| 30. | LeadingZeros( value, numDigits ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Converts any number into a string and pads the number with leading zeros until the number of required digits is achieved. | |
| 31. | MatchFirstName ( Name1, Name2, ShowMatchList ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Used to help match/merge duplicate client entries (should always try matching with email/phone/birthdate first) | |
| 32. | MatchFirstName_Multi ( Name1, Name2, ShowMatchList ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Match Multiple first names. | |
| 33. | NextDateRange ( StartDate ; TimePeriod ; WholePeriod ; FindPrevious ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Generate Date Ranges for Creating Daily, Weekly, Monthly, or Yearly Reports | |
| 34. | PhoneFormat (Phone) |
| Average rating:
4.1 |
|
| Kyle Williams, Augusto Digital | |
| (A simplified version of phone.format) | |
| 35. | PhoneFormatList ( PhoneList ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Formats all of the phone numbers in a list of phone numbers | |
| 36. | SpellNumber ( Amt ) |
| Average rating:
4.0 |
|
| Kyle Williams, Augusto Digital | |
| Converts Currency into Text (does not require any other functions) | |
| 37. | sqlF( field ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Converts a field reference to a valid ExecuteSQL field reference | |
| 38. | sqlT( field ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Converts table name into quoted text of the table name | |
| 39. | _GetAsBoolean ( value ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Converts common boolean text entries in addition to numbers to 1 or 0 | |
| 40. | _GetAsTimestamp ( tsDate, tsTime ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Use this to merge a Date and a Time into one timestamp | |
| 41. | _PatternCount ( Text ; TextToSearchFor ; isCaseSensitive ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Provides an option to turn on or off the case sensitivity of the PatternCount function. | |
| 42. | _UniqueValues( _list ) |
| Average rating:
0.0 |
|
| Kyle Williams, Augusto Digital | |
| Creates a list of unique values without the trailing return carriage... | |