Skip to main content
venkateshg4665
venkateshg4665
July 1, 2025
Question

Extract Integers from Text field in recpord

  • July 1, 2025
  • 6 replies
  • 0 views

Hi everyone,

I am working on a task where I want to compare values in a read-only grid. The data in the field consists of text-type values, for example: k(100), k(101), SH(300).

While applying filters in the read-only grid, I want data whose values are greater than 100. Here, we should check only the number in the text.

is there any possibility to achieve this functionality

6 replies

stefanhelzle0001
stefanhelzle0001
July 1, 2025

Create a custom record field, choose expression, and use the tointeger() function to extract the number. Then you can use this new field for sorting and filtering.

venkateshg4665
venkateshg4665Author
July 1, 2025

 [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] Thank you for the reply, I tried this approach, but I am getting this error when i used tointeger(recordtype!fieldName)
error:
Test currently unavailable due to an error There was an error with the custom record field "Custom Record Field". Expression evaluation error at function 'tointeger': Could not cast from Record Field to Number (Integer). Details: CastInvalid

stefanhelzle0001
stefanhelzle0001
July 1, 2025

You have to reference the field value, not the field.

tointeger(rv!record[recordtype!YOUR_RECORD.FIELD])

Terms & ConditionsAccessibility statement