JMareel

Hello everyone and long time no see. I need help with coding again and have been searching and learning quite a bit but just can't seem to piece it together because I've never played with javascript. Can someone help me please? Here's the scenario. I have a Google Sheets workbook with a few sheets. First sheet is a dashboard for the user to enter data into a table. The other two sheets contain the data being accessed and manipulated by what is entered by the user in the dashboard once the CHECKOUT button is pressed. The javascript would be executed once the CHECKOUT button is pressed. I need the javascript to 1) read the user input data (text which I guess would be called strings) from the table in Dashboard sheet. User inputs the text name of an item in cell D7 and a number quantity in E7. 2) search the Inventory sheet for what was input in Dashboard sheet cell D7 and get the value of that items current amount. 3) Add or subtract the value of what was input in Dashboard sheet cell E7 with the item's current amount in Inventory sheet. Addition/Subtraction is determined if the checkbox is checked/unchecked in Dashboard sheet cell C7. 4) Update the new item's amount in the Inventory sheet. EXAMPLE: 1) User inputs in Dashboard sheet D7 "Apples" and in E7 "8" 2) CHECKOUT button is pressed. 3) Javascript searches Inventory sheet for "Apples" and finds its current amount is "10". 4) 8 is added or subtracted to 10. 5) New value of 18 or 2 is then updated in Inventory sheet for "Apples". Thank you to any and all that can help us find a solution because its been about a week we've been wrestling with this. Regards, JM

I have an "allbox" checkbox at the top of each table and below it regular checkboxes. If the "allbox" checkbox is checked it will in turn check all the boxes in that table only.The allbox checkboxes are named table1_allbox, etc.The item checkboxes are named table1_ItemName and value is ItemName, etc.-JM

OK I guess I'll try to figure out myself how to code the data to go to each page by studying how to use the SESSION parameter Another question I have is how do I have the Confirmation page count the number of items they checked so I can use that number to calculate the price? So if they checked 20 items then I want the Confirmation page to display the values of the checked items and then display total price by using the formula TOTAL PRICE = [# OF ITEMS] * [PRICE]? Could somebody help to code this and whatever else I need in my Confirmation page? Thanks much in advance -JM

Should I post the code of my Order page and what I have so far of my Confirmation page here in this thread so somebody with coding knowledge can help me out? I am just too anxious to get this problem solved so I can publish to the 'Net. Thank you so much for all the replies so far.-JMareel

1) The Order page has tables with items and a checkbox at the end of each row. Of course all tables with their checkboxes are contained in a form. Once they check the boxes next to the item they would like, they click SUBMIT and the value of each checkbox is passed to the Confirmation page. The value of each checkbox is just a two word phrase. There are currently maximum of 100 checkboxes than can be checked so I don't know if that classifies as alot of information being passed if they are all checked. 2) The Confirmation page opens displaying the choices they checked and the calculated price and choice of payment option and delivery method. Then CONFIRM ORDER is clicked.3) All the information on the Confirmation page is then sent via email to my email account.So all I need is to know what and how to code the Confirmation page to display what is in #2 above and how then to send the information displayed in the Confirmation page to an email that goes to me.Could someone please help me?!-JMareel

Hello everyone. I need some major help trying to complete and code my Confirmation page which needs to receive the data from the Order page. I have been trying to study code online especially here at w3schools which is a great site but to no avail Here is the scenario. I have a website that is ready to be published to the internet and hopefully make a difference in the community and at the same time make some side cash. The only problem is that the two important pages of this site are not completed yet. I have an Order page and a Confirmation page that needs to be completed. The user/customer clicks checkboxes on the items they would like in the Order page. Once they have checked all the boxes next to the items they want, they click SUBMIT which passes them to a Confirmation page. The Order page is complete and does what I would like it to do for now thanks to some help from another forum helper. My Confirmation page is what needs work because I have NO idea how to then pass the information from the Order page to the Confirmation page so it can list ONLY the items they checked, calculate and display the price based on the number of items they checked and then ask the user to check the method of payment and method of product delivery. Once they are 1) satisfied that the items listed on the top of the Confirmation page are correct, 2) have seen the price, 3) and checked the payment method and delivery option; they will click the SUBMIT button which would pass all that information from the Confirmation page to an email that goes to me. So basically it would look like this...Order page --> Confirmation page --> send email to me containing Confirmation page data.Would I need to post the Order page and Confirmation page code here in this thread to get a better answer and specific help?I would greatly appreciate any and all help because I am just waiting to complete these two web pages to publish my site to the 'Net.-JM