Calculating Based on Value List (Again)

External Since: Oct 24, 2008 Posts: 10

All,

I hope that sending a new post on a old subject is not considered a
faux pas, if so please let me know how to go about amending my older
post.

Hans, Harry,

Thank you for your help, but the Pattern Count is not working
properly.

As you are aware, in my database, in the "Admissions" section,
potential clients are asked a series of questions including "Do You
Have Suicide Thoughts", and "Have You Ever Attempted Suicide".

In order to reduce redundancy between departments, I try to use as
much existing data as possible so as a client moves from department to
department within our facility, the same questions do not have to be
asked again.

In this case when the client reaches the Medical Department, they need
to know if the client is suicidal or has attempted suicide. Seeing
that the Admissions Staff has already asked this question, I wanted to
pre-populate this answer on the Medical side.

I used the PatternCount function as such:

PatternCount ( Client Records::Presenting Problem Checklist ; "Suicide
Attempts" )

and formatting the field's number to "Format as Boolean" Show Non
Zeros as "Yes", Show Zeros as "No"

The problem is that they all show up as "No".

The easy thing to do would be to copy the check box field over to the
medical side, but medical does not need all 17 questions listed in
this particular field.

What am I missing?

External Since: Oct 24, 2008 Posts: 10

On Dec 16, 2:44 pm, Hans Besjes wrote:
> Hi Eric,
>
> On 12/16/2008 20:15:26 Eric wrote:
>
> > All,
> > I hope that sending a new post on a old subject is not considered a faux
> > pas, if so please let me know how to go about amending my older post.
>
> It don't see why Wink

>
> It would however be easier to continue the existing thread. That makes it easier to find the previous post(s) on the subject and then you won't have to explain everything again...
>
>
>
> > Hans, Harry,
> > Thank you for your help, but the Pattern Count is not working properly.
> > As you are aware, in my database, in the "Admissions" section, potential
> > clients are asked a series of questions including "Do You Have Suicide
> > Thoughts", and "Have You Ever Attempted Suicide".
> > In order to reduce redundancy between departments, I try to use as much
> > existing data as possible so as a client moves from department to
> > department within our facility, the same questions do not have to be asked
> > again.
> > In this case when the client reaches the Medical Department, they need to
> > know if the client is suicidal or has attempted suicide. Seeing that the
> > Admissions Staff has already asked this question, I wanted to pre-populate
> > this answer on the Medical side.
> > I used the PatternCount function as such:
> > PatternCount ( Client Records::Presenting Problem Checklist ; "Suicide
> > Attempts" )
> > and formatting the field's number to "Format as Boolean" Show Non Zeros as
> > "Yes", Show Zeros as "No"
> > The problem is that they all show up as "No".
> > The easy thing to do would be to copy the check box field over to the
> > medical side, but medical does not need all 17 questions listed in this
> > particular field.
> > What am I missing?
>
> That is the 64.000 dollar question Wink

>
> And the answer is not that obvious ;(
>
> You may want to check the type of the calculation field and resulting content of it.
>
> You can do this by putting a duplicate field on your layout formatted as Edit Box. If the PatternCount function does not evaluate properly, it may be that the result is an EMPTY field, which also will be shown as "No".
>
> Is the spelling of "Suicide Attempts" EXACTLY the same in the value list and in the field definition? No double spaces, non-breaking spaces, ...??
> Easiest way to check/correct this is to copy the text from your value list and past it into the calculation.
>
> I can't think of anything else...
>
> Hans Besjes

Hans,

I copied and pasted the field twice, once as the formatted checkbox
field, and once as an edit field. On records that show "Suicide
Attempts" as checked, it also appears in the edit box as "Suicide
Attempts". So I copied and pasted the text "Suicide Attempts" into
the calculation just to make sure it was spelled correctly. My
calculation still say "no".

It has got to be me. Is there a different way to get my field to
display whether or not "Suicide Attempts" has been checked?