Google Sheets sidebar to find and populate particular rows
$30-250 USD
Plačilo ob prevzemu
I am building a simple inventory system to track holdings over time. I have part names and numbers, and a range of inventory values for each, as in this sample:
[login to view URL]
I would like a custom sidebar to add to this and similar sheets, with two core functions:
1) I enter a part number into a text field, and a newvalue into another text field, and push enter. The sidebar populates the leftmost-unfilled-column of the correct row with newvalue.
2) I enter a part number into a text field, push enter, and the sidebar displays the current inventory for this.
ID projekta: #16748065
Več o projektu
6 freelancerjev ponuja v povprečju za $122 na tem delu
Hi there, I will be happy to help you with that. The Google Script will add a custom menu to the spreadsheet interface near to the Help menu. When you click it, it will show the sidebar with two buttons inside it, u Več
I completely understand your requirement, I have built many such record management, order management and warehouse management scripts in Google Sheets. I also provide additional features such as automated email upda Več
You'll get a menuitem in the main menu to open the sidebar. There you add new values or search for an article.