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.
Watch Question

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:
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.


No valid answer given.

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