Book Entry Form - dtolpin/yycat GitHub Wiki

Entering books into the excel table is cumbersome. To facilitate the book entry, an entry form opening on the current line is proposed.

  • The form contains all fields of the line, conveniently grouped.

  • There is a button `autofill'.

  • If all fields are empty, the fields are copied from the previous row.

  • In addition, some fields are filled automatically if empty, for example: * call number * transliterations

https://developers.google.com/apps-script/guide_user_interfaces explains how to program a form.

  • I must ensure that the ids are unique. I am going to use a Spreadsheet Query formula,