Hello myDBR Representative,
How are things going? I am trying to apply formatting to an editable crosstab column. The trick is that the formatting is conditional. I have managed to get it to correctly show the conditional formatting when the crosstab table loads (and refreshes) but when a user inputs a new value or updates a value it is returned without the appropriate formatting.
The value column has some values that need to be percents and I was wondering if it's possible to conditionalize the "suffix" parameter of the col_value_set function? I would like to conditionally apply append a "%" to the value column (column C) of the column B type (which for simplicity shows either "Percent" or "Number"). I would like column C to append the "%" when column B is "Percent" and not when it is "Number".
Do you have a method for implementing this conditional suffix logic?
PS: I just noticed the col_value_text function. I imagine I can theoretically apply the conditional formatting in my insert/update function for the editable column and return the suffix there but I'm guessing the returned value wouldn't be implicitly converted to a numeric value. Do you concur? If that's the case it isn't preferred for sorting/export reasons and I'd be looking for another solution.