Data Connections

Re: Filtering by JobNumber and make calculations

Clay Fox — Wed, 09 Jan 2008 16:36:46 GMT

We have a whole Project Tracker solution in InfoPath, which uses SQL on the backend and integrates with SharePoint so I know it is possible.

If you would like to see a demo send me an email.

Re: Filtering by JobNumber and make calculations

viperay — Wed, 09 Jan 2008 16:17:56 GMT

Actually i need a project time sheet for my company i also need to make calculations to be able to see cost for specific jobs. What do you suggest me to do? Is infopath good solution for that? i want to store data in sharepoint, but i am also thinking to create seperate asp.net pages and store data in sql directly. which one should i do? which one is more compatible for my requirements?

Re: Filtering by JobNumber and make calculations

Clay Fox — Wed, 09 Jan 2008 00:51:58 GMT

There are some blogs and posts for showing unique entries only in adrop down. You need to look at the preceding:: function.

Put a rule on the drop down.

Action Set a field value

Sum(workhours[title=dropdown])

Something like that would set your total field to the sum of all work hours where the title equlas the one chosen in the dropdown.

Filtering by JobNumber and make calculations

viperay — Tue, 08 Jan 2008 23:22:39 GMT

Hello. i am designing project time database for my company. I have several

problems that i cannot solve.
Here is a ss of database.
http://img186.imageshack.us/img186/7493/27419234dg1.jpg

Here is a ss of my infopath form.
http://img132.imageshack.us/img132/6066/11593780hy1.jpg

The first problem as you see on the form i created a drop down menu and bind 
that menu to title field of Project Time Database. As you see drop down shows 
one job number 4 times because there is four entry for that job number on the 
job time database. I want to see job numbers only one time on that drop down 
menu.

Secondly as you see on the form i ahve a text box named Total Work Hours. 
This text box is gonna show the total work hours for jobs. So in that example 
i should be able to pick one number from the drop down menu (70123 for this 
example), and infopath should get the job hours for job number that i choose 
(4, 3, 2, 1.5 for this example) and after infopath should sum the work hours 
up and put the total on the total work hours text box (10.5 for this example).

I hope i am clear enough. So do you have any suggestions according my 
requirements?
Thank You