Project Description
I need a google sheet created with a table that runs on an android phone. The table should include the following: Office Number, Account Number, Store Number, Employee Number, Date (automatic), Start Time (automatic). Each of these fields except date/time are validated against a list that we can create and change. if the entry is on the list, then the data is shown to the right of the entered number. So, if the store number is 100, then the store info that corresponds fills in to the right. If its not in that list, then the data would show up as RED.
After this, we have these fields: Area (up to for digits numerical), Section (up to 4 digits numerical), PriceX Quantity. Area and Section are also validated and a description shows up next to the data entered with the corresponding data from a list (so if you type in Area : 100 then, the list may say area 100 is Backroom so "Backroom" shows up next to 100, same with Section.
The Price X Quantity field could have 129x12 or 129 x 12 x 5 (chain multiplication) and the field next to that will have the extension automatically adding the decimal. so 100 x 5 becomes 5.00 in that field.
For this field, if the extention is over $100 then there is an audible beep, if the extension is over $500 then there are 2 beeps, if the extension exceeds $1000 then it beeps three time.
This form will be on a phone but will transfer the data to a spreadsheet on a PC. If we can create a working Table then we can work on additional functions handled on the full sheet on the PC.
Thank You for your help.