Jump to content
  • 0

Formatting Yes/No Field in Database



I'm working on a datapage and I have a yes/no column on this page. Instead of the column showing either "Yes" or "No", I would like it to show check marks to represent Yes and blanks to represent no.

I tried changing the formatting settings for this field to custom, but I can't find out how to make a custom check mark symbol; there doesn't seem to be one in the font and it doesn't seem to accept images. Is there anyway to do this?

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi ray985,

As i know, checkboxes are the fields that are editable. You can either check it or uncheck it. Such editable options are not available in result page. The result page is only for displaying records. But if your datapage is either a web form or update datapage, then you can create a checkbox instead of Yes/No. to do this, in your 'configure field' window of your datapage, select 'form element' as 'checkbox'. Thats it. You will get your check box.


Link to comment
Share on other sites

  • 0

Thanks. That makes sense. I was just looking for a way to show results as a check mark or check box. Instead of a columns of "Y" or "N", just have checks or no checks. I just think it looks a lot nicer on a results page than Y or Ns, but I can't figure out how to do it.

Link to comment
Share on other sites

  • 0

Hello everyone! This seems to be a little late but I found out that we can now use HTML symbols now. 

Here's how my Yes/No fields show up on my Tabular Results page:



What I did was I used the custom formatting option for the field: 


And then I used HTML code for the symbols which I got from here. I was also able to choose a color for each icon through the color for value option.



I hope this helps :-) 


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...