Using Default Answers containing calculated values - InfoPath Dev
in

InfoPath Dev

Using Default Answers containing calculated values

Last post 01-15-2010 05:57 AM by Qazi Anis. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 01-14-2010 12:52 AM

    Using Default Answers containing calculated values

    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 will be [another area where the user can add their own values]" The problem I have is that while the user can update the default value, and save the form, when they re-open it, the original default value is displayed without the amended text. I have found that the solution works fine if I turn the default value does not contain any calculated fields, but I need the calculated field to be included. Can anyone suggest a solution? Many thanks Darryl
    Filed under:
  • 01-14-2010 01:07 AM In reply to

    Re: Using Default Answers containing calculated values

    go to properties of your control on which you want default value and uncheck Update this value when the result of formula is recalculated

    Qazi Anis
    Technical Architect
    Bitwise Inc
  • 01-14-2010 03:35 AM In reply to

    Re: Using Default Answers containing calculated values

    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

  • 01-14-2010 07:58 AM In reply to

    Re: Using Default Answers containing calculated values

    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

  • 01-14-2010 09:16 PM In reply to

    Re: Using Default Answers containing calculated values

    a question darry, if the data field feeding the calculated field is update do you want to update all values irrespective of if they are default values or whether they have been updated by user. in that case i would suggest you have rule on the feeding fields.

    Qazi Anis
    Technical Architect
    Bitwise Inc
  • 01-15-2010 01:19 AM In reply to

    Re: Using Default Answers containing calculated values

    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 possible?

     Thanks

    Darryl

  • 01-15-2010 05:57 AM In reply to

    Re: Using Default Answers containing calculated values

    i am sorry to say, but there is no such thing

    Qazi Anis
    Technical Architect
    Bitwise Inc
Page 1 of 1 (7 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.