Search Results
26 functions found:
| 1. | DateRange ( Range ) |
 Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Creates a searchable date range to populate any date field while in Find Mode | |
| 2. | FoundCt( pk_Field ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Looks up the table using the primary key field to determine how many records exist in that table | |
| 3. | FoundSet_List ( field, isUniqueList ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Create a List or a Unique List of values from one field from the found set of records. | |
| 4. | GetAsFMTimestamp ( source ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Converts any date or timestamp (including Unix and UTC) to a valid FileMaker formatted timestamp | |
| 5. | GetAsFMTimestamp_Offset( source; HrsOffset; Include_Seconds ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Similar to my other Function GetAsFMTimestamp, but provides 2 additional parameters | |
| 6. | GetDuration ( tsStart, tsEnd, DurationType ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Calculates the duration between 2 timestamps in | |
| 7. | GetNumberListAsText ( numList ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Used to convert a list of ids or numbers to a string of text | |
| 8. | IsEven |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Is the number Even? | |
| 9. | IsNumeric (text) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Is the string numeric? (is it a number?) | |
| 10. | IsValidJSON( JSON ) |
 Average rating:
5.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Used to determine if we are passing valid JSON | |
| 11. | JSON.List_Layouts |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Creates a List of all Layouts and Layout IDs in JSON format | |
| 12. | JSON.List_Tables |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Lists all Table information in JSON format | |
| 13. | JSON.PrependArray( JSON ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| This will add a new item to the beginning of a JSONArray | |
| 14. | JSON.stringify |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Converts JSON to a string of text | |
| 15. | JSONFormat( JSON ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Formats JSON and eliminates BOM (invisible) characters | |
| 16. | JSONGetElementsAsVariables ( JSON; Globals; Prefix ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Converts JSON to Variables or Global Variables (Supports JSON sub arrays) | |
| 17. | MatchFirstName ( Name1, Name2, ShowMatchList ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Used to help match/merge duplicate client entries (should always try matching with email/phone/birthdate first) | |
| 18. | MatchFirstName_Multi ( Name1, Name2, ShowMatchList ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Match Multiple first names. | |
| 19. | NextDateRange ( StartDate ; TimePeriod ; WholePeriod ; FindPrevious ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Generate Date Ranges for Creating Daily, Weekly, Monthly, or Yearly Reports | |
| 20. | PhoneFormat (Phone) |
|
Average rating:
4.1 |
|
| Kyle Williams, Dreamclinic Massage | |
| (A simplified version of phone.format) | |
| 21. | PhoneFormatList ( PhoneList ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Formats all of the phone numbers in a list of phone numbers | |
| 22. | SpellNumber ( Amt ) |
|
Average rating:
4.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Converts Currency into Text (does not require any other functions) | |
| 23. | sqlF( field ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Converts a field reference to a valid ExecuteSQL field reference | |
| 24. | sqlT( field ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Converts table name into quoted text of the table name | |
| 25. | _GetAsBoolean ( value ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Converts common boolean text entries in addition to numbers to 1 or 0 | |
| 26. | _GetAsTimestamp ( tsDate, tsTime ) |
|
Average rating:
0.0 |
|
| Kyle Williams, Dreamclinic Massage | |
| Use this to merge a Date and a Time into one timestamp | |