[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SharePoint / InoPath NaN error

Posted on 2012-09-11
Medium Priority
Last Modified: 2012-09-11

I have a Form Library I am using to create Company Bills. I have a field in my Form which is used to calculate the VAT of the Bill items.

When I preview the Form it works grand but when I upload it to the Site and go to create a new Form the field which has the default value applied (ie the calculated VAT) it displays NaN (Not a Number) error.

If I submit the Form you can see for a split second that the value is then set and once I reopne the Form after submission it has the correct value displayed.

I changed the default Form opening on the Library to open in the client application and this resolved the issue but I cant keep it like this - various reasons but basically I need it to open in the browser.

Can anyone help with this issue or tell me why it's doing this?

Question by:Tugsol
  • 2
LVL 28

Accepted Solution

clayfox earned 2000 total points
ID: 38386575
It sounds like an issue with postback, which you can research and experiment with.  Browser forms try to limit the number of refreshes they do for performance.  It sound like initially there is not a value to multiply but it does not refresh once there is.

The lowtech method is to change it from a default and put an action on the total field that when it changes set the VaT field.  That probably would trigger the refresh as well.

Www.infopath.com has more info on browser forms.

Author Comment

ID: 38386975
Hi clayfox,

I've had a quick play around with it but it's still happening. I have tried setting it up using an initial value in the required fields as I had read that that can be an issue. It still happens even with a value having been set to begin with.

I then took the default value off the VAT field and created a Rule instead which sets the value when a required field changes. This didn't work and probably isn't what I'm after as I think a Rule only runs once and doesn't refresh?!?

I then reset the default value of the VAT field but removed the tick box to recalculate the value but still no joy.

Any other ideas? Or how else can I get the Form to refresh?


Author Closing Comment

ID: 38387264
Sorry, I think I misread the second half of your post. It was indeed an issue with the postback. I changed the postback option to Always for the control in question.

Thanks for your help!

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month19 days, 11 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question