Count empty form fields

RLJB

We have an application type form, it's about 60 fields across 8 sections (displayed as tabs).

I'm looking for a "quick" way of displaying a "% complete", basically counting out of the 60 how many are UNDEFINED.

The only solution we can think of is to have another 60 fields with a counter for each field and then sum them. This is really a bit of a pain and a lot of maintenance.

Does anyone know of a better way? Ideally something like a Function that can count multiple attributes if UNDEFINED all in one rule using one attribute to store the result (so we can do a gauge).

All ideas welcome!

tford

Can any one of the 60 ever go from defined back to undefined?

tford

If once they are defined, it can never go back to undefined, you could have one counter and a rule for each of the 60 fields being counted.

The rule would be something like:

IF BO.Field1 WAS CHANGED TO DEFINED ... add 1 to BO.Counter

Otherwise, it gets a bit more complicated. If it gets defined, then undefined, then defined again, you have to get more complicated in the rules to keep adding and subtracting from the counter.

customaware

Hi Rod,

How about some Bred Crumbs like this...

I can send you the html and css if you like.

Works nicely.

hpl123

eagles9999 wrote
Hi Rod,

How about some Bred Crumbs like this...

IMAGE

I can send you the html and css if you like.

Works nicely.

Nice job Mark 🙂.

tford

How about some Bread Crumbs like this...

Mark .. would be nice to have your solution posted here on the forums.

customaware

No problem Tom.....

Here it is……

HTML cell….

.wizard a:first-child {
-moz-border-radius: 4px 0 0 4px;
-webkit-border-radius: 4px 0 0 4px;
border-radius: 4px 0 0 4px;
}
.wizard a:last-child {
-moz-border-radius: 0 4px 4px 0;
-webkit-border-radius: 0 4px 4px 0;
border-radius: 0 4px 4px 0;
}

.wizard .badge {
margin:0 5px 0 18px;
position:relative; top:-1px;
font-family: Arial;

}
.wizard a:first-child .badge {
margin-left:0;
font-family: Arial;
}
.wizard .current {
background:#007ACC;
color:#fff;
font-family: Arial;
}
.wizard .current:after {
border-left-color:#007ACC;
}
.wizard a:hover { text-decoration: none; }
.wizard a:not(.current):hover { color:#08C; }
.wizard .done {
background:#e1fcc9;
color:#000;
font-family: Arial;
}
.wizard .done:after {
border-left-color:#e1fcc9;
}

</style>
<div class="wizard">
<a class=<<Booking.Progress1>>><span class="badge badge-inverse">1.</span>Request Flight Solutions</a>
<a class=<<Booking.Progress2>>><span class="badge badge-inverse">2.</span>Provide Solutions</a>
<a class=<<Booking.Progress3>>><span class="badge badge-inverse">3.</span>Select Solution</a>
<a class=<<Booking.Progress4>>><span class="badge badge-inverse">4.</span>Reserve Solution</a>
<a class=<<Booking.Progress5>>><span class="badge badge-inverse">5.</span>Approve Flights</a>
<a class=<<Booking.Progress6>>><span class="badge badge-inverse">6.</span>Issue Ticket</a>
<a class=<<Booking.Progress7>>><span class="badge badge-inverse">7.</span>Complete</a>
</div>

<<Booking.ProgressX>> are the attributes in the Booking BO and I use a task to set them to either…

new…..default colouring grey
current…… Dark Blue
done……… Light Green

hpl123

Great stuff, thanks for sharing..

kklosson

Not elegant but I would just create a basic process:

Object.Counter=0

If Object.Attribute1 IS DEFINED THEN
INCREASE Object.Counter BY 1

If Object.Attribute2 IS DEFINED THEN
INCREASE Object.Counter BY 1

etc...

Object.Percent=Object.Counter / [Number of Fields] *100

kklosson

BTW, the donut gage can be placed on the form to display the percent complete in a visual manner.

RLJB

Thanks for your responses, none of them are ideal as you need at least a rule and even another attribute for each question.

Support, a function would be very useful here.... Like the COUNTA in excel, so it can be used to count the number of cells in a selected range that contain data including text, numbers, dates.

It's needed for compliance monitoring, not just helping a user understand how far through a big form they are.

hpl123

RLJB wrote
Thanks for your responses, none of them are ideal as you need at least a rule and even another attribute for each question.

Support, a function would be very useful here.... Like the COUNTA in excel, so it can be used to count the number of cells in a selected range that contain data including text, numbers, dates.

It's needed for compliance monitoring, not just helping a user understand how far through a big form they are.