Search Results
21 functions found:
1. | AddOrdinalSuperscript ( number ) |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Adds a superscripted ordinal text to the passed number | |
2. | ExtractListSegment ( list ; divider ; SegmentNum ) |
Average rating: 5.0 | |
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 ) |
Average rating: 0.0 | |
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 ) |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Formats a timestamp using the excel format method | |
5. | GetBaseTableName ( fieldOrTO ) |
Average rating: 5.0 | |
Paul, Peak 14 LLC | |
Gets the base table name (how it's listed in database management) from a field or table occurance | |
6. | GetCurrentTimeZoneUTCOffset () |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Returns a number that is the current timezone's UTC offset | |
7. | GetDataFileID ( path ) |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Returns the ID of the OPEN file with the passed path | |
8. | GetFrontPanels ( objectNameList ) |
Average rating: 0.0 | |
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 ) |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Get the next value in a list based off the current value | |
10. | isField ( reference ) |
Average rating: 5.0 | |
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 ) |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Iterates through a list, array or object | |
12. | JSONArrayAppendList ( json ; path ; appendList ; jsonType ) |
Average rating: 5.0 | |
Paul, Peak 14 LLC | |
Appends a list of values onto a JSON Array. Maintains existing null values | |
13. | ListMax ( theList ) |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Finds the max value of a list | |
14. | PerformEquationOnList ( theList ; equation ; listItemKey ; errorReplace ; option) |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Performs a mathmatical calculation on each line item and returns the option | |
15. | Range ( start, stop, step ) |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Returns a list of numbers given the parameters | |
16. | SetVariable ( varName ; varValue ) |
Average rating: 0.0 | |
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 ) |
Average rating: 0.0 | |
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 ) |
Average rating: 0.0 | |
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 ) |
Average rating: 0.0 | |
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 ) |
Average rating: 0.0 | |
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 ) |
Average rating: 0.0 | |
Paul, Peak 14 LLC | |
Rounds the time to the nearest amount | |