I’m trying to create an app to track inventory for my employer. I work for a contractor who needs to keep track of inventory on several different job sites.
I created an app using a Google Form that essentially uses dependent dropdowns. For example, in the first section they select the site location from the drop down, the next section they select the category, the next section they select the item from that category, so on and so forth.
The inventory for each job site is recorded in its own tab on the worksheet. What I’m trying to do is get the app to automatically send the data it collects its respective tab.
I’m not 100% sure this is even possible. I’m a total newbie and not even sure where to start, can anyone make any suggestions?