Re: Count function not inlcuding first Field in Browser

Hilary Stoupa — Wed, 15 Aug 2012 14:42:37 GMT

I'm going to guess the issue here may be postback. Try setting postback to always on your people picker field and see if that changes the results - under the properties of the control, on the browser tab.

In general, you only want to do this if things aren't working as anticipated - since when the form posts back, it sends it data to the server. But it is the first thing I try when I have a "works in preview, not in browser" issue.

Count function not inlcuding first Field in Browser

jerryO — Mon, 13 Aug 2012 12:32:20 GMT

Hi everyone, I have a strange problem,

I have a IP Browser form that has 10 seperate people picker fields. (requirement of the form, cannot use repeating table)

I have a concatenate field that is setup to hold the list of these 10 seperate fields seperated by ";".

I have another field on the form(countmembers) that counts the number of members using the count function on the concatenate field. This total members field should show how many total members are entered into the fields.(non blank fields)

If I preview the form from the IP designer eveything works fine. When I publish the form to SharePoint and open the form with a browser, the count function does not count the first people picker field when a value is added.

The concat field updates the total members field with a rule that contains the following which runs when the field changes:

When I add a member to the first people picker field using a browser, the count members stays at 0. If I use the preview in the IP designer it changes to 1 and works perfectly.

I added an image showing the form in a browser and in the IP Preview.

Browser Forms

Re: Count function not inlcuding first Field in Browser

Count function not inlcuding first Field in Browser