I'm still not exactly sure what you want to calculate.  You say that you want to
determine whether the month and year that a person last had sex was "within" 3,
6, or 12 months?  Within 3, 6, or 12 months of what?  The present date?  Or some
other date?

Presuming you are comparing the date the person gives you with the present date,
I would use the technique shown in Date Example 3 on page 356 of the Pendragon
help file.  Even though you only ask each person for a month and year, I would
suggest adding day 1 to the value to make for easier calculations.  For example,
if someone tells you "July 2008", I would enter "July 1, 2008" (or 1/7/08
(European format) or 7/1/08 (U.S. format)).  While this won't be exactly right,
it won't be far off.

Then use this script (or something like it):

calculate:
   result = now - $[DateLastSex]
   result = result / 86400
   answer = result / 30

This gets you an average number of months since the person last had sex.  Again,
it's not exact, but it's close.  As the example shows, you can round to a
certain decimal place or to an integer, if you want to.

I think adding a day to the person's date estimate is easier than the other
possible approaches, and isn't necessarily any less accurate.

Dave






________________________________
From: Poloko Owen Rabai <rabaip@...>
To: pendragon-forms@yahoogroups.com
Sent: Thursday, July 30, 2009 12:43:31 PM
Subject: Re: [pendragon-forms] Re: Round to nearest 100


Ok, let me explain!
Usually in my program, i'll have a field askin a person when was the
last time he or she had SEX, so because usually a person wil remember
the month and the year, i decided to make month and year as separate
fields, from there i'll try to add up the two and want to determine if
the sex act was within 3 months or 6 then 12 months, i work for a
voluntary counsellin and testin centre thats why its important. Please
help out.

On 7/30/09, Dave Hockman-Wert <dhwert@yahoo. com> wrote:
> Could you explain this more clearly?  I'm not sure what you mean.  If you
> want to discard day and month, that just leaves the year, right?
>
> What result do you want to get?
>
> dave
>
>
>
>
> ____________ _________ _________ __
> From: Poloko Owen Rabai <rabaip@gmail. com>
> To: pendragon-forms@ yahoogroups. com
> Sent: Wednesday, July 29, 2009 12:54:22 PM
> Subject: Re: [pendragon-forms] Re: Round to nearest 100
>
>
> Hello guys!
> I have a situation, i wanna discard day and the month from the date in
> taken from the calender. Please help out because i've tried to
> cauculate the seconds and subtract from the year.
>
> On 7/29/09, Neal Aven <nealaven@yahoo. com> wrote:
>> Thanks for the suggestions, Dave...
>>
>> I've managed to work through this.  It turns out that I had to correct
>> three
>> things:
>>
>> 1.  the MATHLIB.prc file (which is required for scientific functions like
>> 'round') was not installed on my handheld.
>>
>> 2.  'round' does not seem to work on currency fields... I've changed it to
>> a
>> numeric field.
>>
>> 3.  currency fields are stored as a number of cents... therefore, had to
>> adjust math to divided and multiply by 10,000 (rather than 100).
>>
>> Thanks again,
>>
>> Neal
>>
>> --- In pendragon-forms@ yahoogroups. com, Dave Hockman-Wert <dhwert@...>
>> wrote:
>>>
>>> What field types are field #1 and #2?  If they are integer, your script
>>> might not work.  I'm not sure how PF handles temporary variables; the
>>> field type of variables might have to fit with the associated field type.
>>> If that's not it, you might want to use different variable names, such as
>>> "temp" in line 3 (temp = round result), but it doesn't seem like that
>>> should matter either.
>>>
>>> If neither of the above suggestions help, I would recommend changing the
>>> script to put the output of each step into field #2, to see where the
>>> script is breaking down.
>>>
>>> Dave
>>>
>>>
>>>
>>>
>>> ____________ _________ _________ __
>>>  From: Neal Aven <nealaven@.. .>
>>> To: pendragon-forms@ yahoogroups. com
>>> Sent: Wednesday, July 22, 2009 9:31:05 AM
>>> Subject: [pendragon-forms] Round to nearest 100
>>>
>>>
>>> Hi all,
>>>
>>> In field #2, I am trying to round a dollar value in field #1 to the
>>> nearest 100 but I am not having success with the script. Here's what I've
>>> got:
>>>
>>> calculate:
>>> result = $1 / 100
>>> result = round result
>>> answer = result * 100
>>>
>>> On the handheld, this returns a value in field #2 of $0.00 every time.
>>>
>>> Any suggestions?
>>>
>>> Best regards,
>>> Neal
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>
>>
>>
>
> --
> Sent from my mobile device
>
> " A warrior doesn't give up what he loves... he finds the love in what he
> does."
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>

--
Sent from my mobile device

" A warrior doesn't give up what he loves... he finds the love in what he does."






[Non-text portions of this message have been removed]

Ok, let me explain!
Usually in my program, i'll have a field askin a person when was the
last time he or she had SEX, so because usually a person wil remember
the month and the year, i decided to make month and year as separate
fields, from there i'll try to add up the two and want to determine if
the sex act was within 3 months or 6 then 12 months, i work for a
voluntary counsellin and testin centre thats why its important. Please
help out.

On 7/30/09, Dave Hockman-Wert <dhwert@...> wrote:
> Could you explain this more clearly?  I'm not sure what you mean.  If you
> want to discard day and month, that just leaves the year, right?
>
> What result do you want to get?
>
> dave
>
>
>
>
> ________________________________
> From: Poloko Owen Rabai <rabaip@...>
> To: pendragon-forms@yahoogroups.com
> Sent: Wednesday, July 29, 2009 12:54:22 PM
> Subject: Re: [pendragon-forms] Re: Round to nearest 100
>
>
> Hello guys!
> I have a situation, i wanna discard day and the month from the date in
> taken from the calender. Please help out because i've tried to
> cauculate the seconds and subtract from the year.
>
> On 7/29/09, Neal Aven <nealaven@yahoo. com> wrote:
>> Thanks for the suggestions, Dave...
>>
>> I've managed to work through this.  It turns out that I had to correct
>> three
>> things:
>>
>> 1.  the MATHLIB.prc file (which is required for scientific functions like
>> 'round') was not installed on my handheld.
>>
>> 2.  'round' does not seem to work on currency fields... I've changed it to
>> a
>> numeric field.
>>
>> 3.  currency fields are stored as a number of cents... therefore, had to
>> adjust math to divided and multiply by 10,000 (rather than 100).
>>
>> Thanks again,
>>
>> Neal
>>
>> --- In pendragon-forms@ yahoogroups. com, Dave Hockman-Wert <dhwert@...>
>> wrote:
>>>
>>> What field types are field #1 and #2?  If they are integer, your script
>>> might not work.  I'm not sure how PF handles temporary variables; the
>>> field type of variables might have to fit with the associated field type.
>>> If that's not it, you might want to use different variable names, such as
>>> "temp" in line 3 (temp = round result), but it doesn't seem like that
>>> should matter either.
>>>
>>> If neither of the above suggestions help, I would recommend changing the
>>> script to put the output of each step into field #2, to see where the
>>> script is breaking down.
>>>
>>> Dave
>>>
>>>
>>>
>>>
>>> ____________ _________ _________ __
>>>  From: Neal Aven <nealaven@.. .>
>>> To: pendragon-forms@ yahoogroups. com
>>> Sent: Wednesday, July 22, 2009 9:31:05 AM
>>> Subject: [pendragon-forms] Round to nearest 100
>>>
>>>
>>> Hi all,
>>>
>>> In field #2, I am trying to round a dollar value in field #1 to the
>>> nearest 100 but I am not having success with the script. Here's what I've
>>> got:
>>>
>>> calculate:
>>> result = $1 / 100
>>> result = round result
>>> answer = result * 100
>>>
>>> On the handheld, this returns a value in field #2 of $0.00 every time.
>>>
>>> Any suggestions?
>>>
>>> Best regards,
>>> Neal
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>
>>
>>
>
> --
> Sent from my mobile device
>
> " A warrior doesn't give up what he loves... he finds the love in what he
> does."
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>

--
Sent from my mobile device

" A warrior doesn't give up what he loves... he finds the love in what he does."

Could you explain this more clearly?  I'm not sure what you mean.  If you want
to discard day and month, that just leaves the year, right?

What result do you want to get?

dave




________________________________
From: Poloko Owen Rabai <rabaip@...>
To: pendragon-forms@yahoogroups.com
Sent: Wednesday, July 29, 2009 12:54:22 PM
Subject: Re: [pendragon-forms] Re: Round to nearest 100


Hello guys!
I have a situation, i wanna discard day and the month from the date in
taken from the calender. Please help out because i've tried to
cauculate the seconds and subtract from the year.

On 7/29/09, Neal Aven <nealaven@yahoo. com> wrote:
> Thanks for the suggestions, Dave...
>
> I've managed to work through this.  It turns out that I had to correct three
> things:
>
> 1.  the MATHLIB.prc file (which is required for scientific functions like
> 'round') was not installed on my handheld.
>
> 2.  'round' does not seem to work on currency fields... I've changed it to a
> numeric field.
>
> 3.  currency fields are stored as a number of cents... therefore, had to
> adjust math to divided and multiply by 10,000 (rather than 100).
>
> Thanks again,
>
> Neal
>
> --- In pendragon-forms@ yahoogroups. com, Dave Hockman-Wert <dhwert@...>
> wrote:
>>
>> What field types are field #1 and #2?  If they are integer, your script
>> might not work.  I'm not sure how PF handles temporary variables; the
>> field type of variables might have to fit with the associated field type.
>> If that's not it, you might want to use different variable names, such as
>> "temp" in line 3 (temp = round result), but it doesn't seem like that
>> should matter either.
>>
>> If neither of the above suggestions help, I would recommend changing the
>> script to put the output of each step into field #2, to see where the
>> script is breaking down.
>>
>> Dave
>>
>>
>>
>>
>> ____________ _________ _________ __
>>  From: Neal Aven <nealaven@.. .>
>> To: pendragon-forms@ yahoogroups. com
>> Sent: Wednesday, July 22, 2009 9:31:05 AM
>> Subject: [pendragon-forms] Round to nearest 100
>>
>>
>> Hi all,
>>
>> In field #2, I am trying to round a dollar value in field #1 to the
>> nearest 100 but I am not having success with the script. Here's what I've
>> got:
>>
>> calculate:
>> result = $1 / 100
>> result = round result
>> answer = result * 100
>>
>> On the handheld, this returns a value in field #2 of $0.00 every time.
>>
>> Any suggestions?
>>
>> Best regards,
>> Neal
>>
>>
>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>
>
>

--
Sent from my mobile device

" A warrior doesn't give up what he loves... he finds the love in what he does."






[Non-text portions of this message have been removed]

Hello guys!
I have a situation, i wanna discard day and the month from the date in
taken from the calender. Please help out because i've tried to
cauculate the seconds and subtract from the year.

On 7/29/09, Neal Aven <nealaven@...> wrote:
> Thanks for the suggestions, Dave...
>
> I've managed to work through this.  It turns out that I had to correct three
> things:
>
> 1.  the MATHLIB.prc file (which is required for scientific functions like
> 'round') was not installed on my handheld.
>
> 2.  'round' does not seem to work on currency fields... I've changed it to a
> numeric field.
>
> 3.  currency fields are stored as a number of cents... therefore, had to
> adjust math to divided and multiply by 10,000 (rather than 100).
>
> Thanks again,
>
> Neal
>
> --- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@...>
> wrote:
>>
>> What field types are field #1 and #2?  If they are integer, your script
>> might not work.  I'm not sure how PF handles temporary variables; the
>> field type of variables might have to fit with the associated field type.
>> If that's not it, you might want to use different variable names, such as
>> "temp" in line 3 (temp = round result), but it doesn't seem like that
>> should matter either.
>>
>> If neither of the above suggestions help, I would recommend changing the
>> script to put the output of each step into field #2, to see where the
>> script is breaking down.
>>
>> Dave
>>
>>
>>
>>
>> ________________________________
>>  From: Neal Aven <nealaven@...>
>> To: pendragon-forms@yahoogroups.com
>> Sent: Wednesday, July 22, 2009 9:31:05 AM
>> Subject: [pendragon-forms] Round to nearest 100
>>
>>
>> Hi all,
>>
>> In field #2, I am trying to round a dollar value in field #1 to the
>> nearest 100 but I am not having success with the script. Here's what I've
>> got:
>>
>> calculate:
>> result = $1 / 100
>> result = round result
>> answer = result * 100
>>
>> On the handheld, this returns a value in field #2 of $0.00 every time.
>>
>> Any suggestions?
>>
>> Best regards,
>> Neal
>>
>>
>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>
>
>

--
Sent from my mobile device

" A warrior doesn't give up what he loves... he finds the love in what he does."

Thanks for the suggestions, Dave...

I've managed to work through this.  It turns out that I had to correct three
things:

1.  the MATHLIB.prc file (which is required for scientific functions like
'round') was not installed on my handheld.

2.  'round' does not seem to work on currency fields... I've changed it to a
numeric field.

3.  currency fields are stored as a number of cents... therefore, had to adjust
math to divided and multiply by 10,000 (rather than 100).

Thanks again,

Neal

--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@...> wrote:
>
> What field types are field #1 and #2?  If they are integer, your script might
not work.  I'm not sure how PF handles temporary variables; the field type of
variables might have to fit with the associated field type.  If that's not it,
you might want to use different variable names, such as "temp" in line 3 (temp =
round result), but it doesn't seem like that should matter either.
>
> If neither of the above suggestions help, I would recommend changing the
script to put the output of each step into field #2, to see where the script is
breaking down.
>
> Dave
>
>
>
>
> ________________________________
>  From: Neal Aven <nealaven@...>
> To: pendragon-forms@yahoogroups.com
> Sent: Wednesday, July 22, 2009 9:31:05 AM
> Subject: [pendragon-forms] Round to nearest 100
>
>
> Hi all,
>
> In field #2, I am trying to round a dollar value in field #1 to the nearest
100 but I am not having success with the script. Here's what I've got:
>
> calculate:
> result = $1 / 100
> result = round result
> answer = result * 100
>
> On the handheld, this returns a value in field #2 of $0.00 every time.
>
> Any suggestions?
>
> Best regards,
> Neal
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

What field types are field #1 and #2?  If they are integer, your script might
not work.  I'm not sure how PF handles temporary variables; the field type of
variables might have to fit with the associated field type.  If that's not it,
you might want to use different variable names, such as "temp" in line 3 (temp =
round result), but it doesn't seem like that should matter either.

If neither of the above suggestions help, I would recommend changing the script
to put the output of each step into field #2, to see where the script is
breaking down.

Dave




________________________________
  From: Neal Aven <nealaven@...>
To: pendragon-forms@yahoogroups.com
Sent: Wednesday, July 22, 2009 9:31:05 AM
Subject: [pendragon-forms] Round to nearest 100


Hi all,

In field #2, I am trying to round a dollar value in field #1 to the nearest 100
but I am not having success with the script. Here's what I've got:

calculate:
result = $1 / 100
result = round result
answer = result * 100

On the handheld, this returns a value in field #2 of $0.00 every time.

Any suggestions?

Best regards,
Neal







[Non-text portions of this message have been removed]

If you find that the handhelds are at different patch/OS levels, please let
us know. I'm curious.

Thanks,
Greg

On Jul 8, 2009 3:51pm, Dave Hockman-Wert <dhwert@...> wrote:
> Okay, I solved my own problem.





> I am using a Pocket PC, and had set the Advanced Properties for my forms,
> Security tab, to "Use Backup If Available". But I didn't have a Compact
> Flash card in the Pocket PC.





> When I changed the setting to "Disable Backup Feature", the TRACE message
> no longer appeared. So that's the solution. The PDA must have been
> looking for the CF card and sent the error message when it couldn't find
> it.





> I'm still a little confused as to why the TRACE message showed up on some
> PDAs but not others, but I suspect it has to do with the versions of
> Windows Mobile they are using.





> Dave














> ________________________________


> From: Dave Hockman-Wert dhwert@...>


> To: pendragon-forms@yahoogroups.com


> Sent: Wednesday, July 8, 2009 8:33:08 AM


> Subject: [pendragon-forms] TRACE error in Pendragon Forms 5.1

















> Pendragon Forms user friends,





> I've had a new problem arise on two of my TDS Recon PDAs since loading
> Pendragon Forms 5.1. Upon leaving any record in any form in PF 5.1, we
> get a TRACE dialog box error:


> "Trace message at:


> Unable to create:


> 00002A08


> /PALM/PFDATA. BAK"





> What's strange is that this is showing up on only two of seven TDS
> Recons. Yet they all have PF 5.1 loaded with the new CAB that you gave
> me, and they all have the same forms on them. I do have the "Backup if
> available" option selected for most of the forms and no Compact Flash
> cards inserted yet, but I'm not sure why this would affect some PDAs
> differently than the others.





> In an initial attempt to solve this problem, I uninstalled all versions
> of PF (5.0 and 5.1) and even used Windows Explorer to delete the PF
> folders. After reinstalling, the TRACE error still shows up.





> Do any of you have any idea what might be happening? Have you experienced
> something like this before? If so, I'd really appreciate any help you can
> offer.





> Thanks,


> Dave





> [Non-text portions of this message have been removed]























> [Non-text portions of this message have been removed]











> ------------------------------------





> Yahoo! Groups Links





> To visit your group on the web, go to:


> http://groups.yahoo.com/group/pendragon-forms/





> Your email settings:


> Individual Email | Traditional





> To change settings online go to:


> http://groups.yahoo.com/group/pendragon-forms/join


> (Yahoo! ID required)





> To change settings via email:


> mailto:pendragon-forms-digest@yahoogroups.com


> mailto:pendragon-forms-fullfeatured@yahoogroups.com





> To unsubscribe from this group, send an email to:


> pendragon-forms-unsubscribe@yahoogroups.com





> Your use of Yahoo! Groups is subject to:


> http://docs.yahoo.com/info/terms/








[Non-text portions of this message have been removed]

Hi all,

In field #2, I am trying to round a dollar value in field #1 to the nearest 100
but I am not having success with the script.  Here's what I've got:

calculate:
result = $1 / 100
result = round result
answer = result * 100

On the handheld, this returns a value in field #2 of $0.00 every time.

Any suggestions?

Best regards,
Neal

Okay, I solved my own problem.

I am using a Pocket PC, and had set the Advanced Properties for my forms,
Security tab, to "Use Backup If Available".  But I didn't have a Compact Flash
card in the Pocket PC.

When I changed the setting to "Disable Backup Feature", the TRACE message no
longer appeared.  So that's the solution.  The PDA must have been looking for
the CF card and sent the error message when it couldn't find it.

I'm still a little confused as to why the TRACE message showed up on some PDAs
but not others, but I suspect it has to do with the versions of Windows Mobile
they are using.

Dave




________________________________
From: Dave Hockman-Wert <dhwert@...>
To: pendragon-forms@yahoogroups.com
Sent: Wednesday, July 8, 2009 8:33:08 AM
Subject: [pendragon-forms] TRACE error in Pendragon Forms 5.1





Pendragon Forms user friends,

I've had a new problem arise on two of my TDS Recon PDAs since loading Pendragon
Forms 5.1.  Upon leaving any record in any form in PF 5.1, we get a TRACE dialog
box error:
"Trace message at:
Unable to create:
00002A08
/PALM/PFDATA. BAK"

What's strange is that this is showing up on only two of seven TDS Recons.  Yet
they all have PF 5.1 loaded with the new CAB that you gave me, and they all have
the same forms on them.  I do have the "Backup if available" option selected for
most of the forms and no Compact Flash cards inserted yet, but I'm not sure why
this would affect some PDAs differently than the others.

In an initial attempt to solve this problem, I uninstalled all versions of PF
(5.0 and 5.1) and even used Windows Explorer to delete the PF folders.  After
reinstalling, the TRACE error still shows up.

Do any of you have any idea what might be happening?  Have you experienced
something like this before?  If so, I'd really appreciate any help you can
offer.

Thanks,
Dave

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

Pendragon Forms user friends,

I've had a new problem arise on two of my TDS Recon PDAs since loading Pendragon
Forms 5.1.  Upon leaving any record in any form in PF 5.1, we get a TRACE dialog
box error:
"Trace message at:
Unable to create:
00002A08
/PALM/PFDATA.BAK"

What's strange is that this is showing up on only two of seven TDS Recons.  Yet
they all have PF 5.1 loaded with the new CAB that you gave me, and they all have
the same forms on them.  I do have the "Backup if available" option selected for
most of the forms and no Compact Flash cards inserted yet, but I'm not sure why
this would affect some PDAs differently than the others.

In an initial attempt to solve this problem, I uninstalled all versions of PF
(5.0 and 5.1) and even used Windows Explorer to delete the PF folders.  After
reinstalling, the TRACE error still shows up.

Do any of you have any idea what might be happening?  Have you experienced
something like this before?  If so, I'd really appreciate any help you can
offer.

Thanks,
Dave





[Non-text portions of this message have been removed]

I am just getting back into using Pendragon and have upgraded to 5.1. It was
working fine yesterday but as of today I can no longer edit forms. Every time I
try to edit a form the program quits responding and sends an error message to
Microsoft. I am running on Visa with Office 2003. Any suggestions.

That sounds like it should work, but just make sure you don't add the "pound"
symbol to the field value itself, or you won't be able to do math on that field.
But if all you want to do is display it, I suppose it doesn't matter.

Cheers,
Dave




________________________________
From: gas_installer <gas_installer@...>
To: pendragon-forms@yahoogroups.com
Sent: Wednesday, June 3, 2009 1:51:48 AM
Subject: [pendragon-forms] Re: Replacing the default currency $ symbol for a £
symbol for  s UK user





Many thanks, Dave for your response!
Yes it would seem that pasting a £ symbol into the form would be a good
workaround.
I plan to use PF to create/print invoices from a handheld - so that's why the
concern over the currency symbol. If, (in creating the print script) the field
is NOT formatted to 'currency' and a £ symbol pasted in as a text string before
it, this should produce the desired effect, I assume?
Many thanks again

--- In pendragon-forms@ yahoogroups. com, Dave Hockman-Wert <dhwert@...> wrote:
>
> I can't find anything either.  My sense would be that you just have to use it
as is and assume it's in pounds instead of dollars.  This could work okay unless
you need the ability to discern between both dollars and pounds, i.e., you are
tracking both currencies in the same form.
>
> You could also add some note in the field name that makes it clear it's pounds
instead of dollars.  I just checked, and it is possible to paste a pound sign
from MS Word into a PF form.  So it seems like that would be a reasonable
workaround.
>
> Dave
>
>
>
>
> ____________ _________ _________ __
> From: gas_installer <gas_installer@ ...>
> To: pendragon-forms@ yahoogroups. com
> Sent: Saturday, May 16, 2009 2:08:15 AM
> Subject: [pendragon-forms] Replacing the default currency $ symbol for a £
symbol for  s UK user
>
>
>
>
>
> Does anyone have any idea how this could be achieved? I don't see any settings
within PF to change this.
> Thanks
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]

Many thanks, Dave for your response!
Yes it would seem that pasting a £ symbol into the form would be a good
workaround.
I plan to use PF to create/print invoices from a handheld - so that's why the
concern over the currency symbol. If, (in creating the print script) the field
is NOT formatted to 'currency' and a £ symbol pasted in as a text string before
it, this should produce the desired effect, I assume?
Many thanks again


--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@...> wrote:
>
> I can't find anything either.  My sense would be that you just have to use it
as is and assume it's in pounds instead of dollars.  This could work okay unless
you need the ability to discern between both dollars and pounds, i.e., you are
tracking both currencies in the same form.
>
> You could also add some note in the field name that makes it clear it's pounds
instead of dollars.  I just checked, and it is possible to paste a pound sign
from MS Word into a PF form.  So it seems like that would be a reasonable
workaround.
>
> Dave
>
>
>
>
> ________________________________
> From: gas_installer <gas_installer@...>
> To: pendragon-forms@yahoogroups.com
> Sent: Saturday, May 16, 2009 2:08:15 AM
> Subject: [pendragon-forms] Replacing the default currency $ symbol for a £
symbol for  s UK user
>
>
>
>
>
> Does anyone have any idea how this could be achieved? I don't see any settings
within PF to change this.
> Thanks
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

I can't find anything either.  My sense would be that you just have to use it as
is and assume it's in pounds instead of dollars.  This could work okay unless
you need the ability to discern between both dollars and pounds, i.e., you are
tracking both currencies in the same form.

You could also add some note in the field name that makes it clear it's pounds
instead of dollars.  I just checked, and it is possible to paste a pound sign
from MS Word into a PF form.  So it seems like that would be a reasonable
workaround.

Dave




________________________________
From: gas_installer <gas_installer@...>
To: pendragon-forms@yahoogroups.com
Sent: Saturday, May 16, 2009 2:08:15 AM
Subject: [pendragon-forms] Replacing the default currency $ symbol for a £
symbol for  s UK user





Does anyone have any idea how this could be achieved? I don't see any settings
within PF to change this.
Thanks







[Non-text portions of this message have been removed]

Does anyone have any idea how this could be achieved? I don't see any settings
within PF to change this.
Thanks

thank you

--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert <dhwert@...> wrote:
>
> See p. 352 in the Users Guide.  It describes how to write a script that
truncates a number to a desired number of decimal places.  Simply stated, it
involves multiplying the number times 10000, adding 0.5, and then dividing by
10000.
>
> The example below is for truncating to two decimal places.calculate:
> if $2 = null then
> return
> endif
> result = $1 / $2
> result = result * 100
> result = result + 0.5
> result = integer result
> answer = result / 100
>
> This isn't exactly what you want, but I'm not sure one is able to specify the
number of decimal places in a Number field.
>
> Good luck,
> Dave
>
>
>
> ________________________________
> From: olyfungus <olyfungus@...>
> To: pendragon-forms@yahoogroups.com
> Sent: Monday, March 16, 2009 12:25:31 PM
> Subject: [pendragon-forms] setting decimal places
>
>
> Hello.
> I am using Forms 5.1, and would like to set a number field to have 5 decimal
places i.e ##.##### I have yet to find any solutions, or scripts that would
accomplish this parameter (other than currency field options suggested in these
forums for for older versions of the software). Any help would be appreciated.
> Eric
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

I have a weird problem. When opening existing or creating new forms on my PC the
contents of the left side of the form design window (preview area) are all
blacked out or empty white cells. Even the buttons ("Next" "End" ect) are empty.
However the fields are all still there and their contents and settings (Field,
data, visual,ect) are perfectly visible in the content window....This came about
after a reload of pendragon which makes me think there is some obscure setting
that is off. Any ideas out there??

See p. 352 in the Users Guide.  It describes how to write a script that
truncates a number to a desired number of decimal places.  Simply stated, it
involves multiplying the number times 10000, adding 0.5, and then dividing by
10000.

The example below is for truncating to two decimal places.calculate:
if $2 = null then
return
endif
result = $1 / $2
result = result * 100
result = result + 0.5
result = integer result
answer = result / 100

This isn't exactly what you want, but I'm not sure one is able to specify the
number of decimal places in a Number field.

Good luck,
Dave



________________________________
From: olyfungus <olyfungus@...>
To: pendragon-forms@yahoogroups.com
Sent: Monday, March 16, 2009 12:25:31 PM
Subject: [pendragon-forms] setting decimal places


Hello.
I am using Forms 5.1, and would like to set a number field to have 5 decimal
places i.e ##.##### I have yet to find any solutions, or scripts that would
accomplish this parameter (other than currency field options suggested in these
forums for for older versions of the software). Any help would be appreciated.
Eric







[Non-text portions of this message have been removed]

Try thisInitialise answer +1
you will need to enter the first number e.g 1 then it will start adding up
regards
mphatso

On Sat, Mar 14, 2009 at 5:42 PM, jncrafton <jncrafton@...> wrote:

>   I am trying to make a +1 button to tabulate Trailers that I am counting.
> I am having trouble scripting it. The questions look like this:
> Fishing Vehicles ________________
> +1 (button)
>
> I am trying to make it so that each time I hit the button the number in the
> fishing vehicles answer line goes up one. The field label for the fishing
> vehicles line is "fishing"
>
>
>



--
Mphatso A. Mpambe
Cell: 07748134264


[Non-text portions of this message have been removed]

Hello.
I am using Forms 5.1, and would like to set a number field to have 5 decimal
places i.e ##.#####  I have yet to find any solutions, or scripts that would
accomplish this parameter (other than currency field options suggested in these
forums for for older versions of the software). Any help would be appreciated.
Eric

Could it be something like this?

click:
   $[fishing] = $[fishing] + 1

Is that not working?  If not, what is it doing instead?


Dave



________________________________
From: jncrafton <jncrafton@...>
To: pendragon-forms@yahoogroups.com
Sent: Saturday, March 14, 2009 10:42:44 AM
Subject: [pendragon-forms] Basic Scripting


I am trying to make a +1 button to tabulate Trailers that I am counting.  I am
having trouble scripting it.  The questions look like this:
Fishing Vehicles ____________ ____
+1 (button)

I am trying to  make it so that each time I hit the button the number in the
fishing vehicles answer line goes up one.  The field label for the fishing
vehicles line is "fishing"







[Non-text portions of this message have been removed]

I am trying to make a +1 button to tabulate Trailers that I am counting.  I am
having trouble scripting it.  The questions look like this:
           Fishing Vehicles ________________
                   +1 (button)

I am trying to  make it so that each time I hit the button the number in the
fishing vehicles answer line goes up one.  The field label for the fishing
vehicles line is "fishing"

Has anyone had any experience getting the Pendragon GPS control to run on the
Trimble GeoXT (2005 series) units? The forms install fine on the CE platform,
but i've been unable to connect to the internal GPS.

Thanks for any assistance you can provide.

-Joe

Hey,
I hope am not the first ugandan using PF. Anyway, i have all my tools
nicely designed and now i need to place them on a card [SD] installer
so i could install on multiple devices.
Does anyone know how to go about this?

Oh, I see what you mean now.

I don't think you can do this within Pendragon, but you can in MS Access.  So
the easiest thing to do would be to fix this issue in the post-processing.  In
Access, there are LTrim, RTrim, and Trim functions that remove leading and/or
trailing spaces.

Also, you can build an expression in a query using "InStr" to find the location
of any particular string (letter, space, etc.) within a string.  You can use
this in combination with Left, Right, or Mid, to trim a string to a particular
punctuation mark or the like.

Dave




________________________________
From: Dawn Anastasi <danastasi@...>
To: pendragon-forms@yahoogroups.com
Sent: Tuesday, November 25, 2008 8:33:19 PM
Subject: [pendragon-forms] Re: Trim function


I tried that, but unfortunately the value may have varying amount of
spaces at the end.  It's padded to 15 characters.  So for example a
value of 12345 would have 10 spaces but 1234567890 would have 5
spaces.  I just want to trim all ending spaces.

Is there a way to loop through the characters starting at the end and
stop when it encounters a valid value?

Dawn

--- In pendragon-forms@ yahoogroups. com, Dave Hockman-Wert
<dhwert@...> wrote:
>
> You should be able to use the "Left" or "Right" functions to
extract the leftmost "x" characters or the rightmost "x" characters
from any particular value.  Or the "Mid" function to extract a
section in the middle.  Check the Scripting Reference for more
details as needed.
>
> Dave
>
>
>
>
>
> ----- Original Message ----
> From: Dawn Anastasi <danastasi@. ..>
> To: pendragon-forms@ yahoogroups. com
> Sent: Wednesday, October 1, 2008 2:54:31 PM
> Subject: [pendragon-forms] Trim function
>
>
> Is there a "trim" function for stripping out leading and/or
trailing
> spaces from a field in a calculate event?
>
> Dawn
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]

I tried that, but unfortunately the value may have varying amount of
spaces at the end.  It's padded to 15 characters.  So for example a
value of 12345 would have 10 spaces but 1234567890 would have 5
spaces.  I just want to trim all ending spaces.

Is there a way to loop through the characters starting at the end and
stop when it encounters a valid value?

Dawn

--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert
<dhwert@...> wrote:
>
> You should be able to use the "Left" or "Right" functions to
extract the leftmost "x" characters or the rightmost "x" characters
from any particular value.  Or the "Mid" function to extract a
section in the middle.  Check the Scripting Reference for more
details as needed.
>
> Dave
>
>
>
>
>
> ----- Original Message ----
> From: Dawn Anastasi <danastasi@...>
> To: pendragon-forms@yahoogroups.com
> Sent: Wednesday, October 1, 2008 2:54:31 PM
> Subject: [pendragon-forms] Trim function
>
>
> Is there a "trim" function for stripping out leading and/or
trailing
> spaces from a field in a calculate event?
>
> Dawn
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

My application was designed and developed in Pendragon 4.0 and then we
had requirement for the Pocket PC. So we were forced to migrate to
5.1.0.
In my application i have picture taking facilty which was working on
4.0 .after upgrading to 5.1.0 this facilty is working differently.

If any question i can send the Form Design.
Thank you
Mini Abraham

Hi David,

As long as all you need is the RFID ID number, this might work.  The one
drawback I could see is that Pendragon Forms isn't always super fast going from
one record to another.  But with the "clone" function, it speeds up that
process.

If all you want to do is record each unique ID in a new record, I guess each
record will only have one field, the ID number.  So in that field, you could
write a script that would read a tag's ID (via barcode scanner or RFID Custom
Control or just a text field with brackets in the field name (in 5.1, if it
works for you -- hasn't worked for us), and then another script with the "clone"
function.  So for each new tag, PF would read that tag into the field and then
immediately clone the record and repeat the process in the new record.  The
limiting factor would be the speed with which PF can shift to the new record.

If you need to fill out any other data fields in the form, though, it would slow
this process down quite a bit.

Dave




----- Original Message ----
From: David Hipkin <david@...>
To: pendragon-forms@yahoogroups.com
Sent: Friday, October 17, 2008 4:03:32 AM
Subject: [pendragon-forms] RFID control


We are trying to establish whether the RFID control will allow us to
record the delivery of multiple items tagged with RFID tags. The
product arrives in bulk on a lorry and we need to record all items in
the delivery as they pass the PDA scanner. The volume and nature of the
product means that we cannot individually scan each item, the scanner
will be set to work on long range and grab all of the RFID tags it can
see.

How would we program a Pendragon form for PDA to capture and record
each item in the batch?






[Non-text portions of this message have been removed]

We are trying to establish whether the RFID control will allow us to
record the delivery of multiple items tagged with RFID tags. The
product arrives in bulk on a lorry and we need to record all items in
the delivery as they pass the PDA scanner. The volume and nature of the
product means that we cannot individually scan each item, the scanner
will be set to work on long range and grab all of the RFID tags it can
see.

How would we program a Pendragon form for PDA to capture and record
each item in the batch?

Your first solution worked - I changed all fields on the first page to
hidden and it automatically goes to the second page, thanks Dave.

You are brilliant!