Search Results
33 functions found:
| 1 . | AddRemoveItem( theList, value, AddRemoveAuto ) |
| Kyle Williams, Dreamclinic Massage | |
| Allows you to Add or Remove an item from a list either automatically or directly (will not create duplicate items) | |
| 2 . | DateRange ( Range ) |
| Kyle Williams, Dreamclinic Massage | |
| Creates a searchable date range to populate any date field while in Find Mode | |
| 3 . | FoundCt( pk_Field ) |
| Kyle Williams, Dreamclinic Massage | |
| Looks up the table using the primary key field to determine how many records exist in that table | |
| 4 . | FoundSet_List ( field, isUniqueList ) |
| Kyle Williams, Dreamclinic Massage | |
| Create a List or a Unique List of values from one field from the found set of records. | |
| 5 . | GetAsFMTimestamp ( source ) |
| Kyle Williams, Dreamclinic Massage | |
| Converts any date or timestamp (including Unix and UTC) to a valid FileMaker formatted timestamp | |
| 6 . | GetAsFMTimestamp_Offset( source; HrsOffset; Include_Seconds ) |
| Kyle Williams, Dreamclinic Massage | |
| Similar to my other Function GetAsFMTimestamp, but provides 2 additional parameters | |
| 7 . | GetDuration ( tsStart, tsEnd, DurationType ) |
| Kyle Williams, Dreamclinic Massage | |
| Calculates the duration between 2 timestamps in | |
| 8 . | GetFieldRepetitionCount ( FieldName ) |
| Kyle Williams, Dreamclinic Massage | |
| Allows you to easily look up the maximum number for repetitions for a field | |
| 9 . | GetNumberListAsText ( numList ) |
| Kyle Williams, Dreamclinic Massage | |
| Used to convert a list of ids or numbers to a string of text | |
| 10 . | IsEven |
| Kyle Williams, Dreamclinic Massage | |
| Is the number Even? | |
| 11 . | IsNumeric (text) |
| Kyle Williams, Dreamclinic Massage | |
| Is the string numeric? (is it a number?) | |
| 12 . | IsValidJSON( JSON ) |
| Kyle Williams, Dreamclinic Massage | |
| Used to determine if we are passing valid JSON | |
| 13 . | JSON.GetValueLists ( isVirtualList ) |
| Kyle Williams, Dreamclinic Massage | |
| This creates JSON that can be used to look up an id or JSON designed to populate a Virtual List | |
| 14 . | JSON.List_Layouts |
| Kyle Williams, Dreamclinic Massage | |
| Creates a List of all Layouts and Layout IDs in JSON format | |
| 15 . | JSON.List_Tables |
| Kyle Williams, Dreamclinic Massage | |
| Lists all Table information in JSON format | |
| 16 . | JSON.PrependArray( JSON ) |
| Kyle Williams, Dreamclinic Massage | |
| This will add a new item to the beginning of a JSONArray | |
| 17 . | JSON.stringify |
| Kyle Williams, Dreamclinic Massage | |
| Converts JSON to a string of text | |
| 18 . | JSONCountKeys ( JSON ) |
| Kyle Williams, Dreamclinic Massage | |
| Counts the Keys in your JSON to provide a Found Count. | |
| 19 . | JSONFormat( JSON ) |
| Kyle Williams, Dreamclinic Massage | |
| Formats JSON and eliminates BOM (invisible) characters | |
| 20 . | JSONGetElementsAsVariables ( JSON; Globals; Prefix ) |
| Kyle Williams, Dreamclinic Massage | |
| Converts JSON to Variables or Global Variables (Supports JSON sub arrays) | |
| 21 . | JSONMergeListOfArrays ( ListOfArrays ) |
| Kyle Williams, Dreamclinic Massage | |
| 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. | |
| 22 . | LeadingZeros( value, numDigits ) |
| Kyle Williams, Dreamclinic Massage | |
| Converts any number into a string and pads the number with leading zeros until the number of required digits is achieved. | |
| 23 . | MatchFirstName ( Name1, Name2, ShowMatchList ) |
| Kyle Williams, Dreamclinic Massage | |
| Used to help match/merge duplicate client entries (should always try matching with email/phone/birthdate first) | |
| 24 . | MatchFirstName_Multi ( Name1, Name2, ShowMatchList ) |
| Kyle Williams, Dreamclinic Massage | |
| Match Multiple first names. | |
| 25 . | NextDateRange ( StartDate ; TimePeriod ; WholePeriod ; FindPrevious ) |
| Kyle Williams, Dreamclinic Massage | |
| Generate Date Ranges for Creating Daily, Weekly, Monthly, or Yearly Reports | |
| 26 . | PhoneFormat (Phone) |
| Kyle Williams, Dreamclinic Massage | |
| (A simplified version of phone.format) | |
| 27 . | PhoneFormatList ( PhoneList ) |
| Kyle Williams, Dreamclinic Massage | |
| Formats all of the phone numbers in a list of phone numbers | |
| 28 . | SpellNumber ( Amt ) |
| Kyle Williams, Dreamclinic Massage | |
| Converts Currency into Text (does not require any other functions) | |
| 29 . | sqlF( field ) |
| Kyle Williams, Dreamclinic Massage | |
| Converts a field reference to a valid ExecuteSQL field reference | |
| 30 . | sqlT( field ) |
| Kyle Williams, Dreamclinic Massage | |
| Converts table name into quoted text of the table name | |
| 31 . | _GetAsBoolean ( value ) |
| Kyle Williams, Dreamclinic Massage | |
| Converts common boolean text entries in addition to numbers to 1 or 0 | |
| 32 . | _GetAsTimestamp ( tsDate, tsTime ) |
| Kyle Williams, Dreamclinic Massage | |
| Use this to merge a Date and a Time into one timestamp | |
| 33 . | _UniqueValues( _list ) |
| Kyle Williams, Dreamclinic Massage | |
| Creates a list of unique values without the trailing return carriage... | |