Skip to main content
venkateshg4665
Known Participant
Jul 1, 2025 2:27 PM UTC
Question

Extract Integers from Text field in recpord

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
Brainy
Jul 1, 2025 2:31 PM UTC

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
Known Participant
Jul 1, 2025 2:47 PM UTC

 [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
Brainy
Jul 1, 2025 2:49 PM UTC

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

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