Boolean: Add submission data columns first -- revise to make more clear

Created on 2 April 2025, 8 days ago

Problem/Motivation

When editing the Google Sheets handler...

In the Submission data section...
Visually, it is presumed the order that the data fields appear in the list is the order they will be added to the spreadsheet... however, all submission metadata columns that appear first in the list are actually by default added last to the spreadsheet, AFTER the user submitted data.

The boolean "Add submission data columns first" is there to override this, but isn't totally intuitive to me...

  1. "submission data columns"? Even with the existing help text, it took me awhile to realize this boolean pertains specifically to the submission metadata columns, which there are over a dozen of these columns listed at the beginning (serial number clear down through locked, sticky, and notes).
  2. Since these metadata columns appear first in the visual list, it should default so they get added to the spreadsheet first, not last; the boolean should instead offer to override this to add those columns last.

Proposed resolution

Suggest to revise wordings as follows:

Boolean:

TO

(along with respective logic change in the code)

Boolean help text:

TO

πŸ“Œ Task
Status

Active

Version

2.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States fizcs3 Omaha, Nebraska; USA

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @fizcs3
  • @fizcs3 opened merge request.
  • πŸ‡ΊπŸ‡ΈUnited States fizcs3 Omaha, Nebraska; USA

    Created MR!12 above with suggested revisions, open to further review.

Production build 0.71.5 2024