InfoPath Dev

Hi I have a repeating table which I want to populate from the data in a SharePoint list. The SharePoint list has 5 fields: Title - Add 1 - Add2 - Add3 - Add4 In InfoPath, the first cell of the repeating table contains the "Lender". This field is a drop down, that is populated from the SharePoint list field [Title]. When the ...

I found a solution. I concatenated all of the score attributes, then set a rule to say that if the concatanation contained a 5 then the score is 5.  If the concatenation did not contain a 5 and contained a 4, then the score was 4, etc.

Hi  I have a questionnaire where each option answer for a question has a score.  i.e. if the question is: "What day is it?" Answer "Monday" scores 1; Answer "Tuesday" scores 2; Answer "Wednesday" scores 3; etc I can calculate the value of each question by using rules, and making the rules ...

 Absolutely ingenious!  Thanks Jimmy. That will work perfectly.

Hello I am trying to include a date field in a sentnece in an expression box.  The problem is that when the expression box shows the date, it appears in YYYY-MM-DD format.  I would like it to appear in 05 February 2010 format instead. Is there any way to do this? I am hoping that there is a function like:  ...

Hi Qazi I have around 10 fields that can influence the result of the default value, and I have around 40 default values, so using rules would be very time consuming.  I am hoping that there is a way to set a flag on the form, and when that flag is set, stop all calcualtions on the form.  Do you know if this is ...

Is there any way to stop all calculations when the form is opened / loaded?  If anyone has any script to do so, it would really help.  Thanks Darryl

Hi Qazi The problem with doing that is that if the data feeding the calculated field is updated, then the calculated field is not updated, as we have marked the field containing the default answer as being manually updated.  Any other suggestions?  Thanks Darryl

Hi All My requirement is as follows: Display a default value, that contains a calculated field's value, and allow the user to amend the default value, i.e. The default value of a question is: "The owner's house is worth [calculated field] and it will be sold to [area where the user can enter their own details], and the money ...