Đã hoàn thành

Create Google Sheets with Scripts (we have Excel with Macros today)

We are a wholesale distributor of products with a fairly simple Excel Spreadsheet and some simple macros to make it more user friendly. Basically, it's a tool where the order-taker can add a customer to the queue which is displayed on a TV in the warehouse. Then, a warehouse associate assigns themselves to the order. When complete, the warehouse associate completes the job and it's removed from the queue. Those three transactions are time-stamped so we can later see the amount of time between creation/assignment and assignment/completion.

HOWEVER, there is too much lag when we share the document on our network with multiple users. So, my thought was to try Google Sheets. Problem is that I don't know Google Sheets. Do you? If so, can you create a functioning tool for us? I'm completely open to functional improvements (perhaps a Google form for the input) and style improvements.

Attached is what we have today in Excel.

Thank you!

Kĩ năng: Excel, Google App Engine, Javascript

Xem nhiều hơn: google sheets macro language, google sheets custom menu, excel macros in google sheets, google sheets script examples, google sheets button to run script, record macro google sheets, convert excel macro to google spreadsheet, google sheets macro button, google sheets scripts, create google search excel data, create google calendar event using excel vba, google com interface excel spread sheets, excel create character sheets, create product sheets excel, create invoices microsoft excel macros, create google maps markers excel, create google base excel xml feed, google earth scripts macros, excel macros scripts, excel google finance scripts

Về Bên Thuê:
( 5 nhận xét ) Concord, United States

ID dự án: #16521106

Được trao cho:


Hi, I am good with Google App Script and developed few applications for a part-time job. I reviewed your requirements and have few questions. Can you please contact me so that we can discuss in detail. Thank you! Thêm

$200 USD trong 3 ngày
(27 Đánh Giá)

Hi, I am good at Excel vba and google scripts. I have reviewed the details of the macro file. It is possible to have with google sheets. I have created similar ones earlier. Looking forward to work on the project Thêm

$150 USD trong 1 ngày
(705 Đánh Giá)

I have started working with Google App script in order to upgrade from Excel macros to cloud based sheets, so i completely understand your approach towards the problem, i have worked on more than 50 such personal googl Thêm

$100 USD trong 5 ngày
(1 Nhận xét)

11 freelancer đang chào giá trung bình $183 cho công việc này

$155 USD trong 3 ngày
(58 Nhận xét)

A proposal has not yet been provided

$250 USD trong 1 ngày
(35 Nhận xét)
$155 USD trong 3 ngày
(23 Nhận xét)

Hi, You won’t make the right candidate selection without knowing what your project on building a functional Google sheet document with scripts will look like. Fortunately, I can show you how your job will look like be Thêm

$150 USD trong 3 ngày
(30 Nhận xét)

Hi i can create google app script to insert order in spreadsheet. i have done same work before, submit user form data to spreadsheet date and month wise. i will finish this work in 1 day. send me message for little fur Thêm

$350 USD trong 1 ngày
(13 Nhận xét)
$111 USD trong 3 ngày
(2 Nhận xét)

We are using google sheet for years now, and make it available for sharing to all our employees

$233 USD trong 7 ngày
(0 Nhận xét)

A proposal has not yet been provided

$155 USD trong 3 ngày
(0 Nhận xét)