Search Results
21 functions found:
| 1. | AddOrdinalSuperscript ( number ) |
| Paul, Peak 14 LLC | |
| Adds a superscripted ordinal text to the passed number | |
| 2. | ExtractListSegment ( list ; divider ; SegmentNum ) |
| Paul, Peak 14 LLC | |
| Use when you have a list that contains multiple values per list item and you only want a single value. | |
| 3. | FilterLayoutObjectNames ( searchString ) |
| Paul, Peak 14 LLC | |
| Use to get a list of all object names on the current layout that contain the searchString | |
| 4. | FormatTimestamp ( theTimestamp; format ) |
| Paul, Peak 14 LLC | |
| Formats a timestamp using the excel format method | |
| 5. | GetBaseTableName ( fieldOrTO ) |
| Paul, Peak 14 LLC | |
| Gets the base table name (how it's listed in database management) from a field or table occurance | |
| 6. | GetCurrentTimeZoneUTCOffset () |
| Paul, Peak 14 LLC | |
| Returns a number that is the current timezone's UTC offset | |
| 7. | GetDataFileID ( path ) |
| Paul, Peak 14 LLC | |
| Returns the ID of the OPEN file with the passed path | |
| 8. | GetFrontPanels ( objectNameList ) |
| Paul, Peak 14 LLC | |
| Use to find the name(s) of the current front panels. If objectNameList is null, will use all object names on layout | |
| 9. | GetIncrimentValue ( currentValue ; theList ; operator ) |
| Paul, Peak 14 LLC | |
| Get the next value in a list based off the current value | |
| 10. | isField ( reference ) |
| Paul, Peak 14 LLC | |
| Use to find out if a string is a reference to a field or not. Can be an actual field reference or just the same text as a field | |
| 11. | IterateThrough ( listOrArrayOrObject; thisVariableName; iterationVariableName ) |
| Paul, Peak 14 LLC | |
| Iterates through a list, array or object | |
| 12. | JSONArrayAppendList ( json ; path ; appendList ; jsonType ) |
| Paul, Peak 14 LLC | |
| Appends a list of values onto a JSON Array. Maintains existing null values | |
| 13. | ListMax ( theList ) |
| Paul, Peak 14 LLC | |
| Finds the max value of a list | |
| 14. | PerformEquationOnList ( theList ; equation ; listItemKey ; errorReplace ; option) |
| Paul, Peak 14 LLC | |
| Performs a mathmatical calculation on each line item and returns the option | |
| 15. | Range ( start, stop, step ) |
| Paul, Peak 14 LLC | |
| Returns a list of numbers given the parameters | |
| 16. | SetVariable ( varName ; varValue ) |
| Paul, Peak 14 LLC | |
| Use when you want to set a variable with a variable name or not in a script. | |
| 17. | SQLGetColumn1Where ( returnField ; whereField ; whereValue; andSearch ) |
| Paul, Peak 14 LLC | |
| Does a simple SQL Statement with where query(ies). If the whereField is left blank, will return all of the values in returnField | |
| 18. | SQLGetField ( field ) |
| Paul, Peak 14 LLC | |
| Use to get the table name for SQL use from a field. Can use a reference as a field so it doesn't matter if the field or table name changes | |
| 19. | SQLGetTable ( field ) |
| Paul, Peak 14 LLC | |
| Use to get the table name for SQL use from a field. Can use a reference as a field so it doesn't matter if the field or table name changes | |
| 20. | SumList ( theList ) |
| Paul, Peak 14 LLC | |
| Sums a list. Normally this would be very quick and easy, but sometimes having null values can mess up what would otherwise be a very simple process. | |
| 21. | TimeRounder ( theTime; toTheNearest ) |
| Paul, Peak 14 LLC | |
| Rounds the time to the nearest amount | |