• derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,676

Topic: Tablegrid Display - Boolean

Good Afternoon Dmitry,

I have a field (DOCUMENT_FLAG) defined as boolean;  it's purpose is to show if there are any missing documents for a selected record. 
At the moment, in the tablegrid the values in the DOCUMENT_FLAG column show as either 'Yes' or 'No' but I would like it to show as either 'Yes' or ' ' (blank)  because it is then much easier to see the exceptions.
All of the combinations I have tried in my script come back with errors such as 'incompatible' TCell', 'String'.  What is the correct syntax? 
Thanks,

Derek.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Tablegrid Display - Boolean

Hello,


You can create calculated field for it.

CASE WHEN DOCUMENT_FLAG=1 then 'Yes' else '' end


Also you can send me your project to support@drive-software.com
I'll try to help you.

Dmitry.
  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,676

Re: Tablegrid Display - Boolean

Dmitry. 
It's working exactly how i want it to now.  I've also added cell colour highlighting so the exceptions are very easy to see.
Thanks as always for your help and your quick response.
Derek.