Change value in datatable column on load

I have a column in a datatable that contains either a 1 or 2 as the data. How can I display “Reserved” instead of 1 and “Completed” instead of 2?

Hello @dmcconnell68 ,

You can use template property of datatable’s column.

Please, check the snippet: Code Snippet

Thanks, I actually found a similar example last night and got this working. One other question, on this column I have it set as selectFilter. The dropdown filter box shows the original values, 1 or 2 instead of “Reserved” or “Completed.” How can I make the dropdown filter show the textual values?

Dear @dmcconnell68 ,

You can use richSelect filter and its suggest property
Please, check this snippet: Code Snippet