Functions in PowerUX enable makers to manipulate and transform data efficiently, helping to build dynamic and interactive applications. These functions can be used for string processing, numerical calculations, and data formatting, making it easier to work with user input, control properties, and dynamic values.

​
String Functions

  • To Upper Case: Converts all characters in a string to uppercase.
  • To Lower Case: Converts all characters in a string to lowercase.
  • Concat: Joins multiple strings together.
  • Replace: Replaces the first occurrence of a specified substring with another string.
  • Replace with Regex: Replaces text using a regular expression pattern.
  • Replace All: Replaces all occurrences of a specified substring with another string.
  • Replace All with Regex: Replaces all matches of a regex pattern with another string.
  • Char At: Returns the character at the specified index in a string.
  • Slice: Extracts a section of a string between start and end indexes.
  • Substring: Extracts a substring starting at a given index with a specified length.
  • Trim: Removes whitespace from both ends of a string.
  • Trim Start: Removes whitespace from the beginning of a string.
  • Trim End: Removes whitespace from the end of a string.
  • To String: Converts a value to a string.
  • Includes: Checks if a string contains a specified substring, returning true or false.
  • Starts With: Checks if a string starts with a given substring.
  • Ends With: Checks if a string ends with a given substring.
  • Length: Returns the number of characters in a string.
  • Index Of: Returns the first index of a specified substring, or -1 if not found.
  • Last Index Of: Returns the last index of a specified substring.

​
Number Functions

  • To Exponentatiol: Converts a number to exponential notation with a specified number of decimal places.
  • To Fixed: Formats a number to a fixed number of decimal places.
  • To Precision: Formats a number to a specified total number of significant digits.
  • Add: Returns the sum of two numbers.
  • Subtract: Returns the difference between two numbers.
  • Multiply: Returns the product of two numbers.
  • Divide: Returns the quotient of two numbers.

​
How to Use Functions

  1. Invoke Functions IntelliSense:
    1. Start typing in a formula or expression field, and IntelliSense will automatically suggest available options.
    2. Use $ to manually trigger IntelliSense.
  2. Select a Suggested Value:
    • Use arrow keys to navigate suggestions.
    • Press Enter to select an option.
  3. Filter and Search:
    • Type part of a name to filter results dynamically.
    • IntelliSense highlights relevant matches.