Google Sheets sidebar to find and populate particular rows
$30-250 USD
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #16748065
Σχετικά με την εργασία
6 freelancers κάνουν προσφορές κατά μέσο όρο $122 για αυτή τη δουλειά
Hi, can help. Will develop that custom sidebar. > 2) I enter a part number into a text field, push enter, and the sidebar displays the current inventory for this. what exactly you want display? short descri Περισσότερα
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 Περισσότερα
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 Περισσότερα
You'll get a menuitem in the main menu to open the sidebar. There you add new values or search for an article.
