Newbie Questions

Re: Form Completion Percentage in VB

Frederik Van Lierde — Mon, 15 Dec 2008 10:45:06 GMT

Do you nned this in VB? There are way to to this out-of-the-box. All depends an how your datasource is structured. The fields you like to count, are they just fields under the root, or are they fields within a repeating node ?

The next example shows the xpath to calculated the percentage of how many lines were filled in correctly within a repeating node
So i éade an extra field ControlIsExecuted related to rules to be sure and gets Y as all fields are fillid in, otherwhise N

count(/my:expenseReport/my:MyControls/my:MyControl/my:ControlIsExecuted[text() = "Y"]) div count(/my:expenseReport/my:MyControls/my:MyControl) * 100

/my:expenseReport/my:MyControls/my:MyContro 0 repeating node
ControlIsExecuted = the fields i need to check
div = divide

I hope this directs you to a solution (outside VB)

Re: Form Completion Percentage in VB

Jimmy — Sat, 13 Dec 2008 14:15:47 GMT

Hello again,

I'm afraid it really isn't as simple as that, in C# or in VB. I will try to think of a way to determine the number of completed nodes vs. the number of nodes in the form and will get back to you soon.

Re: Form Completion Percentage in VB

Christoffel de Gruyter — Fri, 12 Dec 2008 13:38:54 GMT

int numberOfFields = nodeList.Count;

Courtesy of Shiva :).

Re: Form Completion Percentage in VB

Jimmy — Fri, 12 Dec 2008 13:34:38 GMT

If you show us the C# code you have, somebody here would be happy to give you the VB equivalent.

Form Completion Percentage in VB

Christoffel de Gruyter — Fri, 12 Dec 2008 12:15:15 GMT

Hey, I have asked this question before and I did get a reply but only in C#.

Sadly, I now found out that my entire form is made in VB, not C.

My question is really, could anyone give me code that calculates how many fields are filled in and converts that into a percentage?

This would be very usefull for my metadata, I'm kinda stuck with it. I need to learn my .net soon!

Thanks for the help.