Good Morning,This seems very simple, but I can't figure it out:I have a
numeric field that I need a user to enter a number. This number can be
either whole or a decimal with 2 trailing values after the decimal
point. For example:11.151.30 etc.I need the field to display the whole
number if there is no decimal value, but if there is a decimal value
then I need the field to always display 2 numbers after the decimal. I
have gotten the field to show the first two examples above, but in the
3rd exam...
Paul,I ran across this OLD thread while researching a problem and hoped
you could expand just a bit.I am trying to add hours and minutes, just
as above. However, I report everything in fifteen minute
increments.Example: 1.15 = one hour fifteen minutes 1.30 = one hour
thirty minutesWhen I add as you suggested, I get 165 minutes / 60 = 2.75
hours. I need this answer to display as 2.45 (two hours and 45 minutes).
If I add these with normal math, the above problem works correctly, but
the answer doe...
Thanks again!But this only works if I am inputting only “25”, “50”, or
“75”. Not if I enter numbers with decimals such as “1.25”. Can I use a
wildcard to represent the whole number?
Thanks so much for trying to help!!I need to calculate leave taken by an
employee in 15 minute intervals.For example: 1.15 hours of vacation (one
hour and fifteen minutes)+2.30 hours of holiday leave (two hours and
thirty minutes)+ 4.45 hours of sick leave (four hours and forty-five
minutes)= 8.30 hours of total leave taken (eight hours and thirty
minutes)Anything I try has calculated it as:1.252.504.75=8.50I have to
have it formatted in 15 minute increments instead of decimalsAny
ideas?Gene-O
Good Afternoon,I am making a form where we report how much leave is
being used. The leave will be reported in 15 minute increments. (Ex:
fifteen minutes = .15; one-half hour = .30; 45 minutes = .45) I need to
be able to add these up and have them keep this format of 15 minute
increments. Also, I need the display to be a decimal instead of a colon,
if possible. (Ex. 3.45 instead of 3:45).any advice is
appreciated!!!Gene-O
Good Afternoon,I have a 2 page form that I am creating.The first page is
a timesheet. It has 2 fields of interest which are both repeated in a
table with 15 rows:The first field is named "Date1". This field contains
the day of the month (ex. 1, 2,
3...)form1.subform[1].Table1[0].Row1.Date1The second field is named
"amIN". In this field, the employee will enter the time they started
their shift. (ex. 08:00)form1.subform[1].Table1[0].Row1.amINThe second
page will have fields where the employee wil...
Good Afternoon All,I am not very familiar with subforms, so PLEASE
help!I have created a file with a drop down box called "Applicant Type".
There are 4 possible values in this box: "Individual" "Partnership"
"Assocation" and "Corporation". I have created 4 subforms with
corresponding names: "IndividualSub" "PartnerSub" "AssociationSub"
"CorporationSub". All of these subforms are "hidden" in the Initialize
Event of each one.I am trying to create a script that makes the
appropriate subform become ...
thank you thank you thank you thank you Francis!I tried (in vain) to get
the round function to work before. You're answer was correct!have a
wonderful day!Gene-O
Thanks for your reply!However, I cannot download the sample. I get a
message that says the file is damaged and cannot be downloaded.Any other
suggestions??Gene-O
HELP!I have ready many posts on this subject, and can't figure out why
mine won't work - it seems so simple:I have NumericField1 and
NumericField2. I want to multipy the user entered value from
NumericField1 by a fixed value (in this case .555) to return a currency
rounded up to the nearest cent (hundredths decimal point). I have tried
using the field pattern options, but NONE of them will round up, they
just return a dollar value with 2 decimal places.For example:I enter
"307" into NumericField...
I have created a dynamic form with 4 radio buttons. Each of these
buttons makes a hidden subform appear. They work just fine. However,
when I click on a radio button, the check mark, cross, etc. that marks
the radio button appears breifly in the button but then disappears. The
radio button still functions properly thought.anybody have any
ideas?thanks so much!Gene-O
No, it’s Static.Lt. Gene SchrieberAlabama Alcoholic Beverage Control
BoardEnforcement District 1P.O. Box 1755Florence, Alabama 35631(256)
764-2435(256) 766-1793 Faxwww.abc.alabama.gov"Attitude is a choice"
Thanks for the replies!!If I create a test form, these scripts work
perfectly. For some reason, they won't work on the form I need them
to.Any ideas?????thanks!!!
I have a form with a drop-down field that has 3 possible values (Today,
Tommorrow, Next Week). Below this drop-down field is text field
(TextField10) that needs to be filled out by the user ONLY if "Next
Week" is selected in the drop-down. I would like for TextField10 to be
hidden unless "Next Week" is selected. For TextField10, I have
"this.presence="hidden" written into the initialize event so it is
hidden when the user opens the form. This works.For the drop-down field,
I have:if (this.rawVal...
I'm sorry, but the sample does not do what I need the form to do!Here is
the script I have:var fullTime = 0var breakTime = 0if (amIN ne null and
pmOUT ne null) then if (Time2Num(amIN.formattedValue, "HH:MM") lt
Time2Num(pmOUT.formattedValue, "HH:MM")) then fullTime =
Abs(Time2Num(amIN.formattedValue, "HH:MM") -
Time2Num(pmOUT.formattedValue, "HH:MM")) / (60 * 60 * 1000) else
fullTime = 24 - Abs(Time2Num(pmOUT.formattedValue, "HH:MM") -
Time2Num(amIN.formattedValue, "HH:MM")) / (60 * 60 * 1000) e...
I apologize if I didn't make myself clear! I am just not familiar enough
with scripting to know where to insert your script to make it work.Here
is the latest script I have from you. WIll you please insert the
addition to make it calculate amIN and amOUT if they are the only two
entries? var fullTime = 0var breakTime = 0 if (amIN ne null and pmOUT ne
null) then if (Time2Num(amIN.formattedValue, "HH:MM") lt
Time2Num(pmOUT.formattedValue, "HH:MM")) then fullTime =
Abs(Time2Num(amIN.formattedValue,...
Radzmar,I copy/pasted your script, and I can't get it to work. It
calculates the total shift for all four fields, and it calculates past
midnight, but I can't get it to calculate just the first two fields
(amIN and amOUT) only. I pasted it into the calculate event in
FormCalc.Any ideas?thanks so muchGene-O
Radzmar,Thanks so much this goes past midnight as promised. I have one
more problem with it though....Sometimes, an employee may only work in
the morning (8am until noon) and take the rest of the day off with no
break. I need your script to calculate those hours as a total and not
wait for all of the fields (amIN, amOUT, pmIN, pmOUT) to be filled
before reaching a total hours. Here is the script again, just in case
you need it for the field names: var fullTime = 0var breakTime = 0 if
(amIN ne nu...
Hello All,I am working on a timesheet for employees. It has 4 time
fields (amIN, amOUT, pmIN, pmOUT) to allow for a lunch break. I have a
script that calculates well for normal business hours. BUT, if the work
shift goes past midnight, then it does not calculate correctly.Here is
what I have in FormCalc in a calculate event:var fullTime = 0var
breakTime = 0 if (pmIN ne null and pmOUT ne null) then if
(Time2Num(amIN.formattedValue, "HH:MM") < Time2Num(pmOUT.formattedValue,
"HH:MM")) then fullTime...
Radzmar,I’m sorry to bother you again, BUT, I have run into a problem.
In certain instances, the calculation does not handle crossing midnight
well at all. I have attached a copy of the form so you can see the
results.Please note on Thursday the 3rd, and Friday the 4th, I am
getting a negative hour value return.Will you please help me
again!Thanks!Lt. Gene SchrieberAlabama Alcoholic Beverage Control
BoardEnforcement District 1P.O. Box 1755Florence, Alabama 35631(256)
764-2435(256) 766-1793 Faxww...
