CODEWITHSUNDEEP
javascriptgoogle-apps-scriptgoogle-sheets
Matt
Matt

Reputation: 1

Submit Button on Google Sheets

I am working on a project where I must have daily inventory entered by multiple locations into Google Sheets. There are up to 85 potential entries so I chose to create it in a spreadsheet instead of Google Forms.

The question that I have is, after data is entered into the Google Sheet, can I add a submit button that will record the data into a Master Sheet so I may generate reports and record the data over time?

Thank you in advance.

Upvotes: 0

Views: 4752

Answers (1)

Wicket
Wicket

Reputation: 38434

Short answer

Yes, it's possible.

Explanation

Google Sheets could be extended by using Google Apps Scripts. You could insert an image and assign a script to it but also you could use custom menus, dialogs, side bars and triggers.

Reference

Upvotes: 1

Related Questions