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... | |