Newbie Questions

Re: Help Adding Financial Functions to InfoPath (PV, NPV, Rate, etc.)

crlsdcvs — Tue, 02 Jul 2013 18:03:08 GMT

thanks Hilary! I'll give it a try to your qRules. Regards,

Re: Help Adding Financial Functions to InfoPath (PV, NPV, Rate, etc.)

Hilary Stoupa — Tue, 02 Jul 2013 17:50:54 GMT

You can download a qRules trial here: http://www.qdabra.com/en/products/download/qRulesTrial.aspx

Re: Help Adding Financial Functions to InfoPath (PV, NPV, Rate, etc.)

crlsdcvs — Tue, 02 Jul 2013 17:49:25 GMT

Hi Hilary, I am interested in testing these commands, can you please forward them? I am finding myself with the same challenge as CSchebs Kind regards,

Re: Help Adding Financial Functions to InfoPath (PV, NPV, Rate, etc.)

Hilary Stoupa — Wed, 23 May 2012 17:08:08 GMT

Hi - I know this thread is a bit old, and you may have found a solution to your problem- but I wanted to let you know I just added 13 commands to qRules with the Financial methods - PV, NPV, Rate, IRR, etc. These will be part of qRules 4.2 which is being released around June 15, I believe.

Let me know if you'd like to beta test these new commands.

Re: Help Adding Financial Functions to InfoPath (PV, NPV, Rate, etc.)

CSchebs — Thu, 08 Dec 2011 17:22:11 GMT

I was just grasping for straws on the database, really. Does anyone know code I could use to accomplish adding these functions or know of resources I could use to create it myself?

Re: Help Adding Financial Functions to InfoPath (PV, NPV, Rate, etc.)

Hilary Stoupa — Thu, 08 Dec 2011 16:50:26 GMT

What would the Access database contain? I'm not sure I understand how a database could replace calculation functions - I'm having trouble envisioning that.

In that case, it may be that this is a situation where you'll end up having to write some custom code, unfortunately.

This blog post has some nice info that may help you get started.

Re: Help Adding Financial Functions to InfoPath (PV, NPV, Rate, etc.)

CSchebs — Thu, 08 Dec 2011 13:59:53 GMT

Thanks for responding!

I do have IP 2010 but not SharePoint - I thought of creating an Access database to link to, but can't figure out how to get that working properly either; do you have any other ideas I could try?

Re: Help Adding Financial Functions to InfoPath (PV, NPV, Rate, etc.)

Hilary Stoupa — Thu, 08 Dec 2011 00:21:19 GMT

Hi - any chance you are using InfoPath 2010? If so, do you have SharePoint 2010 installed with Excel Services configured? I realize this is a long shot and a lot of requirements, but with IP 2010 REST connections and the Excel Services REST API, you can actually use Excel as a calculation engine for InfoPath, no code required.

Help Adding Financial Functions to InfoPath (PV, NPV, Rate, etc.)

CSchebs — Wed, 07 Dec 2011 16:58:19 GMT

Hello - I'm developing a form for my business to use when creating repurchase invoices for our vendor. InfoPath is the perfect tool for this process and will make the experience much more user friendly than our current Excel workbook version, EXCEPT I can't figure out how to add financial functions to the fields. I've read in older posts that it may be possible but wasn't able to find any actual code to borrow - is this something that can be done? I've never done any programming so I'm a VERY green newbie- any help you can offer would be much appreciated!