Hello,

i was wondering if someone can help me. basically i have small
database with contact information and couple field to track payments.

field names
Paid - Value List, Content (Yes or NO)
Amount - number field.

what i want to do is when user choose Yes from the Value List. I want
to force the user to enter an amount in the amount field.

i am running FM 6.0 on mac os X tiger.

Thanks
Vic

In article <1186005409.805256.240140 [at] x35g2000prf.googlegroups.com>,
WebMaster <webmaster [at] asmt.com> wrote:

> Hello,
>
> i was wondering if someone can help me. basically i have small
> database with contact information and couple field to track payments.
>
> field names
> Paid - Value List, Content (Yes or NO)
> Amount - number field.
>
> what i want to do is when user choose Yes from the Value List. I want
> to force the user to enter an amount in the amount field.
>
> i am running FM 6.0 on mac os X tiger.

The Validation options (in the Define Field window) for the Amount
field are what you looking for. You'll need to use the validate by
calculation option.

The Amount field's data will be valid when either:
Paid = "No" and Amount is Empty
or Paid = "Yes" and Amount is not empty

This gives you a validation calculation of:

(
(Paid = "No") and (IsEmpty(Amount))
)

or

(
(Paid="Yes") and not (IsEmpty(Amount))
)


Make sure to turn OFF the "Validate only if field has been modified at
the bottom of the define calculation window.

Also make sure to turn ON the "Strict" option in the Validation section
so that users can't override the message and still leave the Amount
field incorrect.


When trying to leave the record, the database will then display an
"error" message (which you can customise) whenever the user:

- leaves the Paid field empty (Amount can be anything or empty)

- enters "No" in the Paid field and enters an Amount

or - enters "Yes" in the Paid field and leaves the Amount empty

After clicking on the message's OK button the data entry cursor will be
waiting in the Amount field, but users can go back and change the Paid
field instead if they need to.




Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

"Helpful Harry" <helpful_harry [at] nom.de.plume.com> wrote in message
news:020820071812384697%helpful_harry [at] nom.de.plume.com...
> In article <1186005409.805256.240140 [at] x35g2000prf.googlegroups.com>,
> WebMaster <webmaster [at] asmt.com> wrote:
>
>> Hello,
>>
>> i was wondering if someone can help me. basically i have small
>> database with contact information and couple field to track payments.
>>
>> field names
>> Paid - Value List, Content (Yes or NO)
>> Amount - number field.
>>
>> what i want to do is when user choose Yes from the Value List. I want
>> to force the user to enter an amount in the amount field.
>>
>> i am running FM 6.0 on mac os X tiger.
>
> The Validation options (in the Define Field window) for the Amount
> field are what you looking for. You'll need to use the validate by
> calculation option.
>
> The Amount field's data will be valid when either:
> Paid = "No" and Amount is Empty
> or Paid = "Yes" and Amount is not empty
>
> This gives you a validation calculation of:
>
> (
> (Paid = "No") and (IsEmpty(Amount))
> )
>
> or
>
> (
> (Paid="Yes") and not (IsEmpty(Amount))
> )
>
>
> Make sure to turn OFF the "Validate only if field has been modified at
> the bottom of the define calculation window.
>
> Also make sure to turn ON the "Strict" option in the Validation section
> so that users can't override the message and still leave the Amount
> field incorrect.
>
>
> When trying to leave the record, the database will then display an
> "error" message (which you can customise) whenever the user:
>
> - leaves the Paid field empty (Amount can be anything or empty)
>
> - enters "No" in the Paid field and enters an Amount
>
> or - enters "Yes" in the Paid field and leaves the Amount empty
>
> After clicking on the message's OK button the data entry cursor will be
> waiting in the Amount field, but users can go back and change the Paid
> field instead if they need to.
>
>
>
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)


Harry,

I have been trying to do something similar, so I was waiting for the answer.
What I am trying to accomplish is a
drop down (value list) that goes to another layout when a selection is
clicked. I have tried several calculations, but
no luck. Can you give me a hint? I'd like to figure this out, as much as
possible, by myself. I just think I'm using the wrong
type of calculation.

Thanks

On Aug 2, 1:12 am, Helpful Harry <helpful_ha... [at] nom.de.plume.com>
wrote:
> In article <1186005409.805256.240... [at] x35g2000prf.googlegroups.com>,
>
> WebMaster <webmas... [at] asmt.com> wrote:
> > Hello,
>
> > i was wondering if someone can help me. basically i have small
> > database with contact information and couple field to track payments.
>
> > field names
> > Paid - Value List, Content (Yes or NO)
> > Amount - number field.
>
> > what i want to do is when user choose Yes from the Value List. I want
> > to force the user to enter an amount in the amount field.
>
> > i am running FM 6.0 on mac os X tiger.
>
> The Validation options (in the Define Field window) for the Amount
> field are what you looking for. You'll need to use the validate by
> calculation option.
>
> The Amount field's data will be valid when either:
> Paid = "No" and Amount is Empty
> or Paid = "Yes" and Amount is not empty
>
> This gives you a validation calculation of:
>
> (
> (Paid = "No") and (IsEmpty(Amount))
> )
>
> or
>
> (
> (Paid="Yes") and not (IsEmpty(Amount))
> )
>
> Make sure to turn OFF the "Validate only if field has been modified at
> the bottom of the define calculation window.
>
> Also make sure to turn ON the "Strict" option in the Validation section
> so that users can't override the message and still leave the Amount
> field incorrect.
>
> When trying to leave the record, the database will then display an
> "error" message (which you can customise) whenever the user:
>
> - leaves the Paid field empty (Amount can be anything or empty)
>
> - enters "No" in the Paid field and enters an Amount
>
> or - enters "Yes" in the Paid field and leaves the Amount empty
>
> After clicking on the message's OK button the data entry cursor will be
> waiting in the Amount field, but users can go back and change the Paid
> field instead if they need to.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)

Thank you, it work like a charm.

In article <47nsi.8$ia3.2 [at] newsfe03.lga>, "Latka Gravis"
<itsmewhoelse [at] fastmail.fm> wrote:
>
> Harry,
>
> I have been trying to do something similar, so I was waiting for the answer.
> What I am trying to accomplish is a drop down (value list) that goes to
> another layout when a selection is clicked. I have tried several
> calculations, but no luck. Can you give me a hint? I'd like to figure this
> out, as much as possible, by myself. I just think I'm using the wrong type
> of calculation.
>
> Thanks

You can't automatically go to another Layout when data is entered into
a field, unless you're using an "event" plug-in of some sort (or
perhaps the newest version of FileMaker?).

FileMaker doesn't have the ability to perform a script just by entering
data in a field or leaving a field (you can make a field a button and
run a script when clicked on, but that doesn't work with pop-up menu /
list fields, and it wouldn't help here anyway).

You can get around this most easily by putting a "Go" button next to
the field that the user clicks to run the script.

Whichever way you do it, the script is the same - check the data in the
field and go to the appropriate layout using a pile of If statements.
eg.
If [IsEmpty(LayoutField)]
Beep
Message ["Please choose an option"]
End If
If [LayoutField = "Layout_1"]
Go To Layout [Layout_1]
End If
If [LayoutField = "Layout_2"]
Go To Layout [Layout_2]
End If
If [LayoutField = "Layout_3"]
Go To Layout [Layout_3]
End If
etc.


Another way would be to use the LayoutNames function, but only if the
values in the pop-up menu are exactly the same as the names of the
layouts or the options are in the same order as the Layouts (without
gaps caused by extra Layouts).



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)