display customized cell text values in filter

posted on November 9th, 2022

Closed

Eric Malalel asked on November 9, 2022

I load data from a JSON file and I have a property 'status' whose value is null, 0, 1, 2, or 3.
Using the customizeCell function, I display test values in cells:

null: nothing (blank)
0 : 'not yet satisfied'
1 : 'started'
2 : 'satisfied'
3 : 'not satisfied'

How can I display these text values instead of numbers in the filter of this column?

3 answers

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ November 11, 2022

Hello, Eric!

Thank you for reaching out to us.

Kindly note that the possible workaround is to change numbers to names in the data source.
If our assumptions are correct and you are using numbers instead of status names in calculated value formulas, we cannot suggest any other workaround for this case.

Feel free to contact us in case of any other questions.

Best regards,
Solomiia

Public

Eric Malalel ⋅ November 12, 2022

I changed my datasource for this column from number to string, as values are not used in formulas.
So it works, you can close this ticket.

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ November 14, 2022

Hello, Eric!

Thank you for your feedback.

We are glad to hear that the suggested approach works for your case.

Feel free to contact us in case of any other questions.

Kind regards,
Solomiia

This question is now closed