ryancyq / roster-google-sheets-add-on Goto Github PK

ReadMe or screenshots about how to use the add on.

To add capability of filling up multiple rosters using the same lookup data

• Configuration per sheet
• Columns for Lookup or Fillup must be in the same sheet

Allow custom date format on columns to display when filling up timetable on fill up sheet

For columns in fill up and look up, each columns need to be selected individually.

It would be good if the ranges can be selected all together at once when they are ordered subsequently

In "Create New" side bar, add an option to create google form for roster indication.
This will bind the google sheet and form together seamlessly

Currently, Create New & Create From Existing are the only ways to create roster.

There should be an Edit view which allow user to edit existing configuration without creating

Currently, CreateNew -> CreateFromExisting -> Save Configuration.

If saving process is interrupted, user would be required to re-configure the create new flow again

To support custom timings or dates to trigger fillup operation.

fillup means the job to update fill up section with look up data

When weekly frequency is selected during new fill up sheet creation, days in week should be disable where if the day is not in the range of the given start & end dates period