Skip to main content ↑ ↓
Topic: Custom Item (Read 4623 times) previous topic - next topic

Custom Item

Hello

If i have stored 0 and 1 for Yes and No in the database. when i am showing the list or view how do i display Yes for 0 and No for 1.


Cheers

Re: Custom Item

Reply #1 –
You can set the DisplayType of the field to "Custom". Then edit the custom code.

Sample

Re: Custom Item

Reply #2 –
Thanks Emman its exactly what i was looking for and good to see you back in Action

Re: Custom Item

Reply #3 –
How about reading the values for 1 and 0 from the table itself? How to achieve this with Master - Detail record relationship?

For example, there is a Sales table with Item ID. The Item Names are in another table. So, how to show the Item Name in Sales table instead of Item ID which is the value of the field in table?

Re: Custom Item

Reply #4 –
Hi Ross,

You have to use Table Join to get the details from another table. With that, you get all the detail table fields and then you select the fields you want.

 

Re: Custom Item

Reply #5 –
Hi Ross,
Thanks for the reply, i was following the same approach of storing the table and then joining them, but its not the right approach as it keeps hitting the table for each row, what i wanted is something like decode or case function for display a different active/inactive values.

Cheers