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
  • Former Member
    Former Member

    So this is really a matter of handling the inserted field in Word rather than configuration in M-Files.
    You can get some guidance on this in wordmvp.com/.../MMergeIfFields.htm and similar posts on the Internet.
    I have successfully tested a field code with this content
    { IF {DOCPROPERTY "MFiles_PG813AF1C4F5874EC892D9D92FF1FDE6DD" \* MERGEFORMAT} = "Y" "Yes" "No"} 

    meaning that if the Boolean value from M-Files is TRUE ("Y") then write "Yes" else write "No".
    As stated in the link above you cannot type in the curly brackets {} yourself, you must use Ctrl-F9 to insert them in Word. It is a bit tricky but doable!


    Hey bright-ideas,

    I've had a go but I can't seem to get it to work. Can I be a bit thick and ask whereabouts within this string I place the M-Files property? Or does the property I'm trying to display as Yes not go inside the string?

    I've tried it a whole bunch of ways but none of them seem to work.

    Many thanks,
    Pod
Reply
  • Former Member
    Former Member

    So this is really a matter of handling the inserted field in Word rather than configuration in M-Files.
    You can get some guidance on this in wordmvp.com/.../MMergeIfFields.htm and similar posts on the Internet.
    I have successfully tested a field code with this content
    { IF {DOCPROPERTY "MFiles_PG813AF1C4F5874EC892D9D92FF1FDE6DD" \* MERGEFORMAT} = "Y" "Yes" "No"} 

    meaning that if the Boolean value from M-Files is TRUE ("Y") then write "Yes" else write "No".
    As stated in the link above you cannot type in the curly brackets {} yourself, you must use Ctrl-F9 to insert them in Word. It is a bit tricky but doable!


    Hey bright-ideas,

    I've had a go but I can't seem to get it to work. Can I be a bit thick and ask whereabouts within this string I place the M-Files property? Or does the property I'm trying to display as Yes not go inside the string?

    I've tried it a whole bunch of ways but none of them seem to work.

    Many thanks,
    Pod
Children
No Data