Discover M-Files Workspaces: All work available in the right business context, automatically!
➡️ Learn How it Works

Options
  • Locked Locked
  • Replies 6 replies
  • Subscribers 9 subscribers
  • Views 719 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Change display of Boolean Values

Former Member
Former Member
Hi Folks,

A customer has indicated that they need the fields we have assigned as Boolean to display a Yes/No value rather than a Y/N.

I have not been able to find a way to change this, am I just missing something obvious?

The only other work around I can think of is to change the fields from Boolean to choose from list = yes / no, but would like to avoid this as there are several hundred property definitions that needs to be adjusted.

Many thanks,
Pod
Parents
  • Hi Pod,
    As I said, it is not in M-Files but in your Word or Excel document you need to handle this.
    So you need to edit the inserted field in the template or document itself, not in M-Files.
    When you insert a plain M-Files property into a Word document the field code in Word will look something like this:
    {DOCPROPERTY "MFiles_PG813AF1C4F5874EC892D9D92FF1FDE6DD" \* MERGEFORMAT}

    and it will show a "Y" for yes and a "N" for no if it is a boolean type property.
    You need to manipulate the way Word displays the result, and you do this by adding some logic to the field code in Word.
    So the code in my example says "if the M-Files property yields a "y" then show "Yes" else show "No".
    You can change the last bit to show anything you like - even to add different background colors etc.
    Please follow the link to get guidance on how to edit the field code in Word.
Reply
  • Hi Pod,
    As I said, it is not in M-Files but in your Word or Excel document you need to handle this.
    So you need to edit the inserted field in the template or document itself, not in M-Files.
    When you insert a plain M-Files property into a Word document the field code in Word will look something like this:
    {DOCPROPERTY "MFiles_PG813AF1C4F5874EC892D9D92FF1FDE6DD" \* MERGEFORMAT}

    and it will show a "Y" for yes and a "N" for no if it is a boolean type property.
    You need to manipulate the way Word displays the result, and you do this by adding some logic to the field code in Word.
    So the code in my example says "if the M-Files property yields a "y" then show "Yes" else show "No".
    You can change the last bit to show anything you like - even to add different background colors etc.
    Please follow the link to get guidance on how to edit the field code in Word.
Children
No Data
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.