We help IT Professionals succeed at work.

Sharepoint calculations in workflow

I'm using Sharepoint MOSS 2007 and Sharepoint Designer.

I have a list (form) that the user needs to fill out.  It has the standard name, date, category dropdowns, etc...  then there are 5 textboxes that the user can type info into, asking questions in those textboxes.  At the very bottom of the form, there is a textbox called "Total # of Questions".  This textbox needs to auto-populate with the number of the above Questions textboxes that were typed into.  Is this something that I would create a workflow for?  Or would it be done another way?  i tried creating a workflow, and created a variable, and had it populate to 1 if the textbox changed.  But it never seemed to trigger.  Not sure if I did it right.  Any help, suggestions, examples would be much appreciated.
Thanks!
Comment
Watch Question

Commented:
Do you need the calculation to happen in the form, while it is still not saved by the user?

If not, I'd suggest using a calculated column.  Formulas are similar to what you'd use in Excel.  See the following links:
http://office.microsoft.com/en-us/sharepoint-server-help/introduction-to-data-calculations-HA010121588.aspx?CTT=3
http://office.microsoft.com/en-us/sharepoint-server-help/examples-of-common-formulas-HA010105479.aspx?CTT=3
Yes, I need it to show up before they submit it, so they can see it.  Am I going to need to use javascript instead of a workflow?

Thanks for the help.

Author

Commented:
No valid answer given.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.