Hi, I made a small database that will help me track frequencies of occurrences. However, my data input method is clunky and not feasible to use. I thought of designing a table that could remain as a blank "ticket" and I could use radio buttons as on / off, on being 1 and off being 0. This way, i could just make a few taps on a couple data cells, and when I'm done with my 3 or 4 "clicks" I could hit like an "enter" or "input" button. The data from my "ticket" would get exported into a background database, my table would be cleared and able to receive new data, and i could see my percentages changing. I'm only concerned with the percentages generated, not the frequencies of individual occurrences.
I got the idea when I ordered a pizza from Domino's online last night. The user clicks a few buttons, and when they are done, the order menu resets itself to blank, but the data got stored somewhere as my order.
That's what I want to do. And I want to use my Android phone to enter the data in Google sheets. But I have written the spreadsheet in excel and exported it into GS.
thanks.
Bookmarks