.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

creating formula with if in infopath

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#


Well..here is the scenario. I have an expenses claim form where there is 3 columns, column 1 - type of currency (USD or RM) and column  2 - price unit, column 3 - converted currency value. There is also a list in sharepoint called exchange rate with two columns, title consisting of {USD, RM} and another column, exchnage rate consisting of the the exchange rate in numbers..

So what I need is.

converted currency value = if (type of currency= USD), then price unit * exchange rate


                                      if (type of currency = RM), then price unit * exchange rate

how do I do this in the infopath function column..


View Complete Post

More Related Resource Links

Creating report from Infopath library/submitted forms

Hi, I got a form that has repeating table containg data. The form is submitted to a form library on MOSS 2007 site. Some of the key fields from the form has been promoted to the library, which allows creating views and gives the user a quick report based on the filter. Now, the user wants similar function, however the data is stored in the repeating table. I can use double eval function to combine data from each columns and promote them to the library. But obviously, it doesn't give the user accurate/the kind of report he is looking for using the views. Do you have any suggestion? The only option I can think of is storing each row from repeating table into an Access database or sharepoint list. But that'll also involve making sure correct data is being updated in these secondary data source when updating the form.  Pman http://www.pmansLab.com/

Creating a Custom List Definition that uses InfoPath Form



I have created a custom list definition in Visual Studio 2010.  By default it is using the out of the box "pages\form.aspx" for the New/Edit/Display form rendering. 

I am just wondering if it is possible to use an InfoPath form as default for the New/Edit/Display form?

I have tried to create a custom list with custom info path form thru the UI, and export the site as WSP.  I have analysed the files and notice a few things:

1.) I need to add a XmlDocument section in the Schema.xml for displayifs/editifs/newifs.aspx

2.) I need to provision the xsn in "Lists/{List Name}/Item"

3.) I need to provision the *ifs.aspx in "Lists/{List Name}/Item"

As you see, some of the settings required the {List Name}.  That's mean I can't really create a list definition that is reusable because I need to know the List Name before hand. Is there any way to specify the path with some kind of variable instead of static list name?

Furthermore, I notice that the "Developer" tab is missing from the Ribbon when I modify form, hence I can do any code behind.  Is this a limitation, or is there a workaround?



Wilson | SharePoint Egg's Blog

Error when creating Issues Web Database: The formula contains a syntax error or is not supported.



I have been trying to create an Issues Web Database on one of our MOSS 2010 servers, but I keep getting the error "The formula contains a syntax error or is not supported" when I try to. I have tried this on one of our other 2010 environments and it works fine but for some reason it happens just one this one.

In the error logs I found this:

Error updating field: List: Issues, SchemaXml: <Field DisplayName="OpenedDate" Type="DateTime" Required="TRUE" Format="DateOnly" xmlns="http://schemas.microsoft.com/sharepoint/soap/" Name="OpenedDate"><DefaultFormula>=TODAY()</DefaultFormula><DefaultFormulaValue></DefaultFormulaValue><Validation Message="Value must be greater than 1/1/1900.">=OpenedDate&gt;=DATETIME(1900,1,1,0,0,0)</Validation></Field>. Exception: Microsoft.SharePoint.SPException: The formula contains a syntax error or is not supported.

Does anyone have an idea as to what the cause might be?


Help creating a unique form number in Infopath


I have read the other blog posts about this, and the other users seem to have some success, but I dont' understand HOW they got it to work.

This appears to be the solution, but its not working for me. It just seems to be giving me the time in HHMMSS when I do it: http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/a68b1129-deb3-41a9-a077-c3e8fc3ef86a/

I need to create a unique invoice number based on three parts: Salesperson's initials + date (represented as yymmdd) + a unique number (perhaps the time? but it has to be listed without any formatting, just HHMM)

Ultimately I want the form to have this number going ABYYMMDDHHMM 

Thanks so much

Sample: Creating Simple Web Part Mashups with InfoPath 2010

Explore the code as you learn to create a simple Web Part mashup on SharePoint Server 2010 with InfoPath 2010 and the InfoPath Form Web Part.

Creating a Simple Web Part Mashups with InfoPath 2010

Learn how to create a simple Web Part mashup on SharePoint Server with InfoPath and the InfoPath Form Web Part.

Creating your SharePoint Governance Plan

One of the most common questions that I get from prospects as I'm talking to them about the creation of a governance plan and process is what does it look like. In other words, there are materials available which describe what should be in a governance plan but there isn't a ton of guidance on what the process of creating a governance plan and process are.

Creating Paging for a Repeater Control

A common question is "How do I implement paging within a Repeater?" Although the beauty of the Repeater control is its flexibility, you're on your own for building most functions. ASP.NET 2.0 has included some new controls that provide paging, as does the DataGrid in ASP.NET 1.1. However, this tip shows you how to roll your own paging for a simple data viewer.

Creating an AJAX Repeater in ASP.NET MVC

The "TaskList" is a tried an true example of the most basic thing that you can do in any framework. Unfortunately, I had some problems finding a really good example of all the steps necessary to get a task list to work in ASP.NET MVC 1.0.

Creating a Generic Entity Framework 4.0 Repository

With .NET 4.0 right around the corner, I thought it would be cool to download Visual Studio 2010 beta 2 and start playing around with the next release of Entity Framework.

The initial release of Entity Framework came with a great deal of criticism. To make matters worse, there was a large uproar when it was rumored that Microsoft would be abandoning LINQ to SQL, in favor of Entity Framework. This was because, at the time, many developers felt Entity Framework was an inferior technology to LINQ to SQL. To set things right, Microsoft proactively moved forward with improving Entity Framework, in time for the 4.0 release of the .NET Framework. This is good news because my initial impressions, so far, have been nothing but positive.

Creating a Simple Class in C#

The second article in the C# Object-Oriented Programming tutorial describes how classes are created in C# and how behaviour, in the form of publicly visible and private, hidden methods can be added. This demonstrates some of the uses of encapsulation

Creating SharePoint items with CreateItemActivity

Instead of creating new list items from code in your workflow you can use CreateItemActivity. CreateItemActivity can be used for creating list items or files. Properties of interest for this activity are the following (most of them are self-explanatory):

Creating an Excel Spreadsheet programmatically using VB.NET

The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000. The majority of Excel programmatic functionality is exposed through Automation via the type library Excel9.olb. The intention of this article is to express that a managed application can interrelate with Excel as a COM server.

Creating an Excel Spreadsheet and Adding Data to It Programmatically

The Interoperability services make it veryeasy to work with COM Capable Applications such as Word and Excel. Thisarticle reveals using Excel from a managed application. Excel is thespreadsheet component of Microsoft Office 2000. The majority of Excelprogrammatic functionality is exposed through Automation via the typelibrary Excel9.olb. The intention of this article is to express that amanaged application can interrelate with Excel as a COM server.

Creating Excel file from C#

I used below coding for create a excel sheet.I got from on web site.
In below coding there is no problem.Its create the excel file.If i run second time,its ask to overwrite the current excel file.If I said "Yes" then it ok ,but If I select cancel button,its generate the Error message.The exception is

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend