Office - Sorry Me again
Asked By DUNNER
09-Aug-07 04:30 PM
I want to design a form with 8 drop down list boxes each having a choice of
values between 0 - 10. I would like to creat a box or field that will take
the entered value from the 8 boxes and display the total of the sum of the 8
added together. I looked in the help and couldn't find a specific help
topic. Am I on the right track or should I use a different control?
Thanks for any assistance
Del Dobbs
Dobbs
(1)
Textbox
(1)
Field2
(1)
Field1
(1)
Field3
(1)
Field8
(1)
Field6
(1)
Field7
(1)
SS replied...
Yes, you can do that. Add a text box to show the sum of the 8 values selected
from the drop downs.
1. Right click the text box and select 'text box properties'.
2. There will be small button named as 'fx' to the right side of the 'Value'
textbox (in the default value section). Click it. It will open another small
form.
3. Click 'Insert field or Group' button and select the first drop down. Add
a plus sign manually after the added field. Again click the 'Insert field or
Group' button to add the second drop down. Repeat this step to add all the
drop down boxes. Your formula will look like this:
field1 + field2 + field3 + field4 + field5 + field6+ field7 + field8
4. Click Ok twice to close the open dialog boxes.
5. Preview the form, select values in dropdowns. The text box will show the
sum of all the values.
SSA
MOSS MVP
then rules - I can't make them work? Office I have been trying to make field1, 2 or 3 feed data into in field2 based on what the user enters in field3. The logic seems to make sense, but when i populate field3, field1 remains blank Field1 = text box Field2 = text box Field3 = text box Field3 = rule logic is if field4 = 1.0 then fill with data from
should be placed on each of them. Thanks! Craig InfoPath Discussions Anuma (1) Infopath (1) Field1 (1) Field2 (1) Field3 (1) Text1 (1) Text2 (1) Text3 (1) Hi, Take three fields (field1, field2, field3). And add following two conditions to every field. For field1: . = "" and . . / my field2 ! = "" . = "" and . . / my:field3 ! = "" For Field2: . = "" and . . / my:field3 ! = "" . = "" and . . / my:field1 ! = "" For Field3: . = "" and . . / my
as a validation error. Thanks in advance. Regards, Karen InfoPath Discussions TextBoxesfield2 (1) SilverSands (1) TextBox (1) NnglanI (1) Lierde (1) Semicolon (1) Infopath (1) Field1 (1) n ng lan I created a dummy field, which was concatenation of all the indicates end of word, it would not pick up Plan A I created an input TextBox field1 and a repeating table with TextBoxes field2, field3, and field4. For the data validation for field1, I specified that: if field2 does not contain field1 and if field3 does not contain field1 and if field4 does
the results of calculations. I have a rule defined to update the value of (say) field2 when field1 has a particular value. Unfortunately this rule seems to be applied in a totally random manner. . . Notes: field1 is populated automatically using a calculated value. Is this an issue? Is there an order http: / / www3.sympatico.ca / lornarourke / InfoPath Discussions Enthusiast (1) Explicity (1) Interests (1) Lornarourke (1) Field2 (1) Field1 (1) Hi all: I have solved this one on my own. . . or if not solved, then at least found a workaround: One field's (field1) value is used via rules to set the value in another field field2). Field2 has a default value. I only wanted to set the value of field2 for two
in advance, somen InfoPath Discussions Checkbox (1) I’ve (1) Disallows (1) €˜n’ (1) Field1 (1) Field2 (1) Times (1) Somen (1) There might be an easier way but here is what I have done. Create a repeating section. Inside the repeating section insert a check box (field1). Outside of the repeating section place a text box (field2). In the rules for field1 set the condition to 'if field1 = TRUE' and the action to 'set field2's value to 1'. Then in the conditional formatting for field1 set the condition to 'if field2 = 1' and the action to 'disable this control' Field2