search

Felicious / Taiwan-Numba-ONE

Front-end Google App Script that uses Google Forms, Sheets
1 stars 0 forks source link

Enable Sheet Assignment by ID #3

Closed Felicious closed 3 years ago

Felicious commented 3 years ago

Project Currently Available For One Spreadsheet. This project currently only reads from Taiwan Cafe's August 8, 2020 Spreadsheet, but the app should take orders and create receipts from any spreadsheet.

Solution The web app should first request a spreadsheet ID from the user (page should save the last used ID for convenience).

How to check for your Spreadsheet ID

  1. Open the Spreadsheet and look at the URL
  2. It should begin with "https://docs.google.com/spreadsheets/d"
  3. The long string of random letters and numbers that comes after and stopping at the slash / is your ID

Example: https://docs.google.com/spreadsheets/d/{this part is your ID!!!}/edit?pli=1#gid=1551129613

Felicious commented 3 years ago

Resolved with this commit : https://github.com/Felicious/Taiwan-Numba-ONE/commit/24105de31a59c304e2e236fb5f578b32f1fbfcf7