General

Re: Using Default Answers containing calculated values

Qazi Anis — Fri, 15 Jan 2010 13:57:16 GMT

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

Re: Using Default Answers containing calculated values

DarrylGould — Fri, 15 Jan 2010 09:19:48 GMT

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

Re: Using Default Answers containing calculated values

Qazi Anis — Fri, 15 Jan 2010 05:16:02 GMT

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.

Re: Using Default Answers containing calculated values

DarrylGould — Thu, 14 Jan 2010 15:58:48 GMT

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

Re: Using Default Answers containing calculated values

DarrylGould — Thu, 14 Jan 2010 11:35:30 GMT

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

Re: Using Default Answers containing calculated values

Qazi Anis — Thu, 14 Jan 2010 09:07:51 GMT

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

Using Default Answers containing calculated values

DarrylGould — Thu, 14 Jan 2010 08:52:06 GMT

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