You are viewing limited content. For full access, please sign in.

Question

Question

Create a report via a votes forms

asked on February 8, 2022 Show version history

Hi All, I need some ideas and requirements in a forms format. My goal is to create a report on how many votes a certain candidate (of many candidates) accumulated each candidate's votes and display who has most votes to least votes. Basically, something like a voters ballot. Every year we have a "person of the year" and we do it on paper.

So I'm basically looking to create a Forms process. 

0 0

Replies

replied on February 8, 2022 Show version history

I have done a voting processing previously for our staff to vote for things (vote for the best Halloween costume, etc.)

The form allows them to vote on the list of options.  I use a Radio button element if I want to to ensure they can only select one option or a checkbox element if they can select multiples.  I even use HTML in the options for the voting (with the Halloween costumes, it includes an image of the costume).  This form triggers a Workflow when submitted.  The Workflow verifies that the person submitting the vote hasn't voted previously, and a few other validity checks (i.e. can't vote for yourself).  If the vote failed, it emails the employee to notify them.  If the vote succeeded, it records it to a database table.

Then I have a Database View that pulls the records from the voting, but does an aggregation with tallies and percentages.

Another process in LFForms (with the submit button hidden) does a lookup of the database view and adds some visual elements to display as a graph/chart.

1 0
replied on February 8, 2022

Nicely, thought of.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.