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
เกี่ยวกับโปรเจกต์
freelancer 6 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $122
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.