Validate Length calculation

I need to limit the number of characters allowed in a few fields. I have a
field setup for each of the fields I need to count characters in that does a
Length (fieldname) for each field giving me the number of characters in the
field.

I need to validate that count to make sure it doesn't exceed the number of
characters I want to allow in that field. So for example, a name field is
limited to 35 characters. If you enter more than 35 characters, I need
something to popup and say that the number of characters in the name field
has exceeded 35 (or something like that).

I can't figure out how to validate the length calculation (or am I barking
up the wrong tree?)

Thanks in advance for amy help.

Re: Validate Length calculation

On Sep 6, 4:10 pm, "mmspgh" wrote:
> I need to limit the number of characters allowed in a few fields. I have a
> field setup for each of the fields I need to count characters in that does a
> Length (fieldname) for each field giving me the number of characters in the
> field.
>
> I need to validate that count to make sure it doesn't exceed the number of
> characters I want to allow in that field. So for example, a name field is
> limited to 35 characters. If you enter more than 35 characters, I need
> something to popup and say that the number of characters in the name field
> has exceeded 35 (or something like that).
>
> I can't figure out how to validate the length calculation (or am I barking
> up the wrong tree?)
>
> Thanks in advance for amy help.


Open the Options for your field that users will enter the info into.

- Go to the "Validation" Tab
- Check the box "Maximum number of characters" and enter the number 35
(or however many you want the limit to be)
- Check the box "Display custom message if validation fails and enter
your custom message.

You can do it with calculations, but I'm lazy, so I'd use the built in
validations.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reality is the leading cause of stress...
....amongst those in touch with it.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
WinXP Pro 32 & 64Bit / FMP Adv 9.0v1
VoicesInMyHead
a.k.a. The Voices
No, we're not... Yes, we are...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
The only reason some people get lost in thought
is because it's unfamiliar territory for them.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: Validate Length calculation

Some of the fields are calculation fields, and thus, don't have that simple
validation available.

For example, the name goes into a first name field, middle name field and
last name field then combines into a name field through a calculation
listing it as last name, first name. The name field (which shows the full
name) can have no more than 35 total characters.

The fields that aren't a calculation, of course, can use the option you
offered.

"VoicesInMyHead" wrote in message
news:1189124257.953021.13880@w3g2000hsg.googlegroups.com...
> On Sep 6, 4:10 pm, "mmspgh" wrote:
>> I need to limit the number of characters allowed in a few fields. I have
>> a
>> field setup for each of the fields I need to count characters in that
>> does a
>> Length (fieldname) for each field giving me the number of characters in
>> the
>> field.
>>
>> I need to validate that count to make sure it doesn't exceed the number
>> of
>> characters I want to allow in that field. So for example, a name field is
>> limited to 35 characters. If you enter more than 35 characters, I need
>> something to popup and say that the number of characters in the name
>> field
>> has exceeded 35 (or something like that).
>>
>> I can't figure out how to validate the length calculation (or am I
>> barking
>> up the wrong tree?)
>>
>> Thanks in advance for amy help.
>
>
> Open the Options for your field that users will enter the info into.
>
> - Go to the "Validation" Tab
> - Check the box "Maximum number of characters" and enter the number 35
> (or however many you want the limit to be)
> - Check the box "Display custom message if validation fails and enter
> your custom message.
>
> You can do it with calculations, but I'm lazy, so I'd use the built in
> validations.
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Reality is the leading cause of stress...
> ...amongst those in touch with it.
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> WinXP Pro 32 & 64Bit / FMP Adv 9.0v1
> VoicesInMyHead
> a.k.a. The Voices
> No, we're not... Yes, we are...
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> The only reason some people get lost in thought
> is because it's unfamiliar territory for them.
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
>

Re: Validate Length calculation

On Sep 6, 7:13 pm, "Dan Tschippert" wrote:
> Some of the fields are calculation fields, and thus, don't have that simple
> validation available.
>
> For example, the name goes into a first name field, middle name field and
> last name field then combines into a name field through a calculation
> listing it as last name, first name. The name field (which shows the full
> name) can have no more than 35 total characters.
>
> The fields that aren't a calculation, of course, can use the option you
> offered.

My Bad!

There are a few options depending on exactly how you want it to look/
act. I made a sample file for ya with a couple options:

http://members.cox.net/voicesinmyhead/fmp/validation35.fp7

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reality is the leading cause of stress...
....amongst those in touch with it.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
WinXP Pro 32 & 64Bit / FMP Adv 9.0v1
VoicesInMyHead
a.k.a. The Voices
No, we're not... Yes, we are...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
The only reason some people get lost in thought
is because it's unfamiliar territory for them.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: Validate Length calculation

On Sep 6, 8:13 pm, "Dan Tschippert" wrote:
> Some of the fields are calculation fields, and thus, don't have that simple
> validation available.
>
> For example, the name goes into a first name field, middle name field and
> last name field then combines into a name field through a calculation
> listing it as last name, first name. The name field (which shows the full
> name) can have no more than 35 total characters.
>
> The fields that aren't a calculation, of course, can use the option you
> offered.
>
> "VoicesInMyHead" wrote in message
>
> news:1189124257.953021.13880@w3g2000hsg.googlegroups.com...
>
> > On Sep 6, 4:10 pm, "mmspgh" wrote:
> >> I need to limit the number of characters allowed in a few fields. I have
> >> a
> >> field setup for each of the fields I need to count characters in that
> >> does a
> >> Length (fieldname) for each field giving me the number of characters in
> >> the
> >> field.
>
> >> I need to validate that count to make sure it doesn't exceed the number
> >> of
> >> characters I want to allow in that field. So for example, a name field is
> >> limited to 35 characters. If you enter more than 35 characters, I need
> >> something to popup and say that the number of characters in the name
> >> field
> >> has exceeded 35 (or something like that).
>
> >> I can't figure out how to validate the length calculation (or am I
> >> barking
> >> up the wrong tree?)
>
> >> Thanks in advance for amy help.
>
> > Open the Options for your field that users will enter the info into.
>
> > - Go to the "Validation" Tab
> > - Check the box "Maximum number of characters" and enter the number 35
> > (or however many you want the limit to be)
> > - Check the box "Display custom message if validation fails and enter
> > your custom message.
>
> > You can do it with calculations, but I'm lazy, so I'd use the built in
> > validations.
>
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > Reality is the leading cause of stress...
> > ...amongst those in touch with it.
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > WinXP Pro 32 & 64Bit / FMP Adv 9.0v1
> > VoicesInMyHead
> > a.k.a. The Voices
> > No, we're not... Yes, we are...
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > The only reason some people get lost in thought
> > is because it's unfamiliar territory for them.
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

You don' tneed to use calculation fields, you can use Text fields with
an Auto-Enter Calculation instead (allow Always Replace) and follow
the validation options per Voices.

Re: Validate Length calculation

OK, I tried this suggestion. Used a text field NAME, and set it to auto
enter by calculation to join the first, middle and last names. This part
works fine. I can't however get the validation to work for the number of
characters from the validation tab for the NAME field.

"Grip" wrote in message
news:1189171318.084507.255800@g4g2000hsf.googlegroups.com...
> On Sep 6, 8:13 pm, "Dan Tschippert" wrote:
>> Some of the fields are calculation fields, and thus, don't have that
>> simple
>> validation available.
>>
>> For example, the name goes into a first name field, middle name field and
>> last name field then combines into a name field through a calculation
>> listing it as last name, first name. The name field (which shows the full
>> name) can have no more than 35 total characters.
>>
>> The fields that aren't a calculation, of course, can use the option you
>> offered.
>>
>> "VoicesInMyHead" wrote in message
>>
>> news:1189124257.953021.13880@w3g2000hsg.googlegroups.com...
>>
>> > On Sep 6, 4:10 pm, "mmspgh" wrote:
>> >> I need to limit the number of characters allowed in a few fields. I
>> >> have
>> >> a
>> >> field setup for each of the fields I need to count characters in that
>> >> does a
>> >> Length (fieldname) for each field giving me the number of characters
>> >> in
>> >> the
>> >> field.
>>
>> >> I need to validate that count to make sure it doesn't exceed the
>> >> number
>> >> of
>> >> characters I want to allow in that field. So for example, a name field
>> >> is
>> >> limited to 35 characters. If you enter more than 35 characters, I need
>> >> something to popup and say that the number of characters in the name
>> >> field
>> >> has exceeded 35 (or something like that).
>>
>> >> I can't figure out how to validate the length calculation (or am I
>> >> barking
>> >> up the wrong tree?)
>>
>> >> Thanks in advance for amy help.
>>
>> > Open the Options for your field that users will enter the info into.
>>
>> > - Go to the "Validation" Tab
>> > - Check the box "Maximum number of characters" and enter the number 35
>> > (or however many you want the limit to be)
>> > - Check the box "Display custom message if validation fails and enter
>> > your custom message.
>>
>> > You can do it with calculations, but I'm lazy, so I'd use the built in
>> > validations.
>>
>> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>> > Reality is the leading cause of stress...
>> > ...amongst those in touch with it.
>> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>> > WinXP Pro 32 & 64Bit / FMP Adv 9.0v1
>> > VoicesInMyHead
>> > a.k.a. The Voices
>> > No, we're not... Yes, we are...
>> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>> > The only reason some people get lost in thought
>> > is because it's unfamiliar territory for them.
>> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> You don' tneed to use calculation fields, you can use Text fields with
> an Auto-Enter Calculation instead (allow Always Replace) and follow
> the validation options per Voices.
>

Re: Validate Length calculation

On Sep 7, 9:22 am, "mmspgh" wrote:
> OK, I tried this suggestion. Used a text field NAME, and set it to auto
> enter by calculation to join the first, middle and last names. This part
> works fine. I can't however get the validation to work for the number of
> characters from the validation tab for the NAME field.
>
> "Grip" wrote in message
>
> news:1189171318.084507.255800@g4g2000hsf.googlegroups.com...
>
> > On Sep 6, 8:13 pm, "Dan Tschippert" wrote:
> >> Some of the fields are calculation fields, and thus, don't have that
> >> simple
> >> validation available.
>
> >> For example, the name goes into a first name field, middle name field and
> >> last name field then combines into a name field through a calculation
> >> listing it as last name, first name. The name field (which shows the full
> >> name) can have no more than 35 total characters.
>
> >> The fields that aren't a calculation, of course, can use the option you
> >> offered.
>
> >> "VoicesInMyHead" wrote in message
>
> >>news:1189124257.953021.13880@w3g2000hsg.googlegroups.com.. .
>
> >> > On Sep 6, 4:10 pm, "mmspgh" wrote:
> >> >> I need to limit the number of characters allowed in a few fields. I
> >> >> have
> >> >> a
> >> >> field setup for each of the fields I need to count characters in that
> >> >> does a
> >> >> Length (fieldname) for each field giving me the number of characters
> >> >> in
> >> >> the
> >> >> field.
>
> >> >> I need to validate that count to make sure it doesn't exceed the
> >> >> number
> >> >> of
> >> >> characters I want to allow in that field. So for example, a name field
> >> >> is
> >> >> limited to 35 characters. If you enter more than 35 characters, I need
> >> >> something to popup and say that the number of characters in the name
> >> >> field
> >> >> has exceeded 35 (or something like that).
>
> >> >> I can't figure out how to validate the length calculation (or am I
> >> >> barking
> >> >> up the wrong tree?)
>
> >> >> Thanks in advance for amy help.
>
> >> > Open the Options for your field that users will enter the info into.
>
> >> > - Go to the "Validation" Tab
> >> > - Check the box "Maximum number of characters" and enter the number 35
> >> > (or however many you want the limit to be)
> >> > - Check the box "Display custom message if validation fails and enter
> >> > your custom message.
>
> >> > You can do it with calculations, but I'm lazy, so I'd use the built in
> >> > validations.
>
> >> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >> > Reality is the leading cause of stress...
> >> > ...amongst those in touch with it.
> >> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >> > WinXP Pro 32 & 64Bit / FMP Adv 9.0v1
> >> > VoicesInMyHead
> >> > a.k.a. The Voices
> >> > No, we're not... Yes, we are...
> >> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >> > The only reason some people get lost in thought
> >> > is because it's unfamiliar territory for them.
> >> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> > You don' tneed to use calculation fields, you can use Text fields with
> > an Auto-Enter Calculation instead (allow Always Replace) and follow
> > the validation options per Voices.

Interestng. I can't get the calc to update if it violates the
"Maximum..." condition. Possible bug? However, it will work if you
use the validate by calculation = Length(NAME) < 4
..

Re: Validate Length calculation

That worked, thanks Grip!

"Grip" wrote in message
news:1189171318.084507.255800@g4g2000hsf.googlegroups.com...
> On Sep 6, 8:13 pm, "Dan Tschippert" wrote:
>> Some of the fields are calculation fields, and thus, don't have that
>> simple
>> validation available.
>>
>> For example, the name goes into a first name field, middle name field and
>> last name field then combines into a name field through a calculation
>> listing it as last name, first name. The name field (which shows the full
>> name) can have no more than 35 total characters.
>>
>> The fields that aren't a calculation, of course, can use the option you
>> offered.
>>
>> "VoicesInMyHead" wrote in message
>>
>> news:1189124257.953021.13880@w3g2000hsg.googlegroups.com...
>>
>> > On Sep 6, 4:10 pm, "mmspgh" wrote:
>> >> I need to limit the number of characters allowed in a few fields. I
>> >> have
>> >> a
>> >> field setup for each of the fields I need to count characters in that
>> >> does a
>> >> Length (fieldname) for each field giving me the number of characters
>> >> in
>> >> the
>> >> field.
>>
>> >> I need to validate that count to make sure it doesn't exceed the
>> >> number
>> >> of
>> >> characters I want to allow in that field. So for example, a name field
>> >> is
>> >> limited to 35 characters. If you enter more than 35 characters, I need
>> >> something to popup and say that the number of characters in the name
>> >> field
>> >> has exceeded 35 (or something like that).
>>
>> >> I can't figure out how to validate the length calculation (or am I
>> >> barking
>> >> up the wrong tree?)
>>
>> >> Thanks in advance for amy help.
>>
>> > Open the Options for your field that users will enter the info into.
>>
>> > - Go to the "Validation" Tab
>> > - Check the box "Maximum number of characters" and enter the number 35
>> > (or however many you want the limit to be)
>> > - Check the box "Display custom message if validation fails and enter
>> > your custom message.
>>
>> > You can do it with calculations, but I'm lazy, so I'd use the built in
>> > validations.
>>
>> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>> > Reality is the leading cause of stress...
>> > ...amongst those in touch with it.
>> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>> > WinXP Pro 32 & 64Bit / FMP Adv 9.0v1
>> > VoicesInMyHead
>> > a.k.a. The Voices
>> > No, we're not... Yes, we are...
>> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>> > The only reason some people get lost in thought
>> > is because it's unfamiliar territory for them.
>> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> You don' tneed to use calculation fields, you can use Text fields with
> an Auto-Enter Calculation instead (allow Always Replace) and follow
> the validation options per Voices.
>