I have a shipment weight calculator sheet.,
There is a list of products,I fill in the quantity of each product that
is going in a particular shipment.
The sheet then adds up the products weighst and gives me a combined weight.
All of the above works well.
-----------------------------------------
I want to add this feature: Updating of stock level for each item based on
each shipment, but ONLY when I click on an update button.
Example, some times I just want to see how much a package will weigh but
not update the stock levels, so I fill in the quantities of for each
product going in the package, it then shows me the total weight.
BUT, I only want it to subtract (UPDATE) the stock levels
based on the shipment contents IF I click on an "update" button (or enter a
1 into the triggering cell).
What is the best/easiest way to do this?:
idea 1) I can insert an image than when I click on it it performs a script
to run a formula in the stock level cell(s)
Anyone have a link for how to script something similar. I know
how to have an a script run when an image is clicked on, but don't know how
to cause it to have a formula run in a cell only when the image is clicked.
idea 2) Is there a way to conditionally cause a cell to run it's formula
only when a certain value is entered into a cell. i.e the "trigger/button"
cell has a 1 in it versus a zero. The simple "conditional format" menu does
not have an option for this.
Thanks for any advice,links etc.
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
