Gareth Horton
July 12th, 2002, 02:49 PM
You're welcome!
I tend to check this board several times a day, but it seems to have been quiet for
some time now. Usually a person would get several answers to their problem. I guess
you can say you lucked out that "someone" monitors the board ;).
Hopefully it will pick up soon, I've got a question out here about the Conference
CD availability and usually a Datawatch Rep answers. On second thought, that may
be where they're all at :).
Hope they get back soon!
Liz wrote:
> Nicholas,
> Thank you so much!
> It worked perfectly. It seems like you really know your stuff.
> Thanks again!
>
>
>
>
> Nicholas Osdale wrote:
> > In situations like this I usually rename the field to something like DispostionTrap and hide it.
> > Then create a calculated field called Disposition as such:
> >
> > IF(DispositionTrap = "9999", "2PAT", DispositionTrap)
> >
> > Hope That Helps
> > Liz wrote:
> > >
> > > I was wondering if there was a way to get data from another field to input into a field if it matches a certain criteria. For example I have 4 fields.
> > >
> > > Disposition, Status, And Previous Disposition.
> > > 2PAT PATIENT 2NEW
> > > 2REQ REQUEST 2000
> > > 9999 CLOSED 2PAT
> > >
> > > The above information is needed, however, when the Disposition is 9999 (as seen above)
> > > I need the data in "Previous Disposition" to overwrite that field so it will look like this:
> > >
> > > Disposition, Status, And Previous Disposition
> > > 2PAT PATIENT 2NEW
> > > 2REQ REQUEST 2000
> > > 2PAT CLOSED 2PAT
> > >
> > >
> > > I'm sure this is so simple but I just can't figure it out being the newbie that I am.
> > > Any suggestions would be greatly appreciated.
> > > I'm glad this board is around, I've learned alot from everyone's posts. smile.gif
> > >
> > >
> >
>
I tend to check this board several times a day, but it seems to have been quiet for
some time now. Usually a person would get several answers to their problem. I guess
you can say you lucked out that "someone" monitors the board ;).
Hopefully it will pick up soon, I've got a question out here about the Conference
CD availability and usually a Datawatch Rep answers. On second thought, that may
be where they're all at :).
Hope they get back soon!
Liz wrote:
> Nicholas,
> Thank you so much!
> It worked perfectly. It seems like you really know your stuff.
> Thanks again!
>
>
>
>
> Nicholas Osdale wrote:
> > In situations like this I usually rename the field to something like DispostionTrap and hide it.
> > Then create a calculated field called Disposition as such:
> >
> > IF(DispositionTrap = "9999", "2PAT", DispositionTrap)
> >
> > Hope That Helps
> > Liz wrote:
> > >
> > > I was wondering if there was a way to get data from another field to input into a field if it matches a certain criteria. For example I have 4 fields.
> > >
> > > Disposition, Status, And Previous Disposition.
> > > 2PAT PATIENT 2NEW
> > > 2REQ REQUEST 2000
> > > 9999 CLOSED 2PAT
> > >
> > > The above information is needed, however, when the Disposition is 9999 (as seen above)
> > > I need the data in "Previous Disposition" to overwrite that field so it will look like this:
> > >
> > > Disposition, Status, And Previous Disposition
> > > 2PAT PATIENT 2NEW
> > > 2REQ REQUEST 2000
> > > 2PAT CLOSED 2PAT
> > >
> > >
> > > I'm sure this is so simple but I just can't figure it out being the newbie that I am.
> > > Any suggestions would be greatly appreciated.
> > > I'm glad this board is around, I've learned alot from everyone's posts. smile.gif
> > >
> > >
> >
>