Display state numeral as text

Display state numeral as text in a list table view.

Overview

The state column values (0 or -1) were showing as numerals instead of descriptive text like "New".
Ensure the field name in the CF table view settings matches the exact spelling of the database column.

Answered
cr cruser 10 Aug, 2018
Answer
In my list table view I have the columns ID, Location, Date Added, Status, Issue

What I would like to do is display the status (state column in database) as the value of New (instead of 0 or -1). Is there a way to do this?
cr cruser 10 Aug, 2018
I figured it out! Spelling. It's easy to misspeeeel a wordr when uyou think at the speed of light.
This topic is locked and no more replies can be posted.