General

Re: Published Formula Not Working

dpapworth — Fri, 23 Mar 2012 18:42:56 GMT

Hilary Stoupa:
That's a sign of a postback issue! Right click the controls in question, and under the properties, check the browser forms tab. Try setting postback to always and see if that resolves your issue.

That worked perfectly. Thank you so much!

Re: Published Formula Not Working

Hilary Stoupa — Fri, 23 Mar 2012 16:51:31 GMT

That's a sign of a postback issue! Right click the controls in question, and under the properties, check the browser forms tab. Try setting postback to always and see if that resolves your issue.

Re: Published Formula Not Working

dpapworth — Fri, 23 Mar 2012 14:55:33 GMT

So I've gotten a little bit farther with my issue. The formulas do seem to be working correctly, it's just that the fields aren't automatically updating as they should. As a check box is checked the field "quantityA" should be incremented by one. This works as expected with all of the similar forms I have in production now. However, using this form, these values only seem to get updated if I choose to leave the form somehow. For example if I choose "Close" from within SharePoint, the modal dialog pops up asking if I'm sure. Now I can see in the background that my fields have updated correctly. The fields also update if I choose to submit the form. I'm just not sure why the fields aren't updating in real time. Any suggestions would be great. Thanks again!

Published Formula Not Working

dpapworth — Thu, 22 Mar 2012 20:44:30 GMT

Hello, I'm having a problem with a couple of formulas not working after being published to a SharePoint site. What I have at the bottom of the form are (typically hidden) fields that calculate the number of check boxes that have been checked. They work by using "count(a1[. = string(true())]) + count(a2[. = string(true())]) + count(a3[. = string(true())])..." and so on. I have one field that gets the sum of check boxes "a1" through "a45", one that gets the sum of "a46" through "a90", and one that gets the sum of "a91" through "a107". So when you click one of the check boxes, the total is incremented by one. This works perfectly in the designer. Not so much in SharePoint, and I'm not sure why. I have similar forms in production, which have identical formulas, that behave just fine. However, I did notice that it will detect when you check "a1" or "a46", which are the first two check boxes in each of the formulas. I'm not sure where to go from here; my formulas verify and have worked previously, and I can't reproduce this behavior anywhere outside of SharePoint. I've attached my file if anyone would like to take a look. If you could offer any advice, that would be great. Thank you in advance!