|
| Case Function with text message |
 |
Tue, 18 Mar 2008 22:04:24 -070 |
FM8.5
I want to create a field wherein a notice will appear based on the
'status' of an Order.
For example the statement;
Case (Status = "Shipped; "This Invoice is due " Date_Due; Status
= "2
Invoiced "This Invoice is due " Date_Due)
Is this correct? Is this how I get the text 'This Invoice is due' to
appear?
|
| Post Reply
|
| Re: Case Function with text message |
 |
Tue, 18 Mar 2008 22:33:03 -070 |
buck.matthew74@yahoo.com wrote:
> FM8.5
>
> I want to create a field wherein a notice will appear based on the
> 'status' of an Order.
>
> For example the statement;
>
> Case (Status = "Shipped; "This Invoice is due " Date_Due;
Status = "2
> Invoiced "This Invoice is due " Date_Due)
>
> Is this correct? Is this how I get the text 'This Invoice is due' to
> appear?
Perhaps with some better placed quotes and semi-colons...something like:
Case (
Status = "Shipped"; "This Invoice is due " & Date_Due;
|
| Post Reply
|
| Re: Case Function with text message |
 |
Wed, 19 Mar 2008 19:16:36 +120 |
In article <13u19chlgoamo9f@corp.supernews.com>, Howard Schlossberg
<howard@nospam.fmprosolutions.com> wrote:
> buck.matthew74@yahoo.com wrote:
> > FM8.5
> >
> > I want to create a field wherein a notice will appear based on the
> > 'status' of an Order.
> >
> > For example the statement;
> >
> > Case (Status = "Shipped; "This Invoice is due "
Date_Due; Status = "2
> > Invoiced "This Invoice is due " Date_Due)
> >
> > Is this correct? Is this how I get the text 'This Invoice is due' to
> > appear?
>
> Perhaps with some better placed quotes and semi-colons...something like:
>
> Case (
> Status = "Shipped"; "This Invoice is due " &
Date_Due;
> Status = "2 Invoiced"; "This Invoice is due " &
Date_Due)
Since it's the same result for both Status data, you could also use:
If (
(Status = "Shipped") or (Status = "2 Invoiced");
"This invoice is due " & Due_Date;
""
)
Either way should work. :o)
Helpful Harry
|
| Post Reply
|
|
|
|
|
|
|
|
|
|