I have a form that has many columns for inserting in description, quantity and price, of different items,
In this form, I want to have a total of all of the previously entered in prices to make a total price.
Im thinking of using a sum array but i dont know how to have the array change depending on where the total will lie.
Any help will be amazing
Thank you all in advance.
What are the names of the total fields?
You can use following calculation:
I think OP want something like dynamically total field, if 5 fields are filled he want total to be at 6th field, if 10 fields are filled he wants total to be at 11th field...etc
This is possible with a script.
Thank you, Yes that is exactly right! Sorry if my explanation of what I was trying to achieve was sub-par.
Do you think you would be able to point me in a direction in terms of the script I would use, or if you could send a link through to anyone else who has achieved this?
Thank you kindly for your responses
Any information would be greatly appreciated.