Instead of chasing jersey sizes through team chats, connect a Google Forms sizing form to Google Sheets, then turn checked responses into an approved bulk jersey order. This 2026 workflow...
Instead of chasing jersey sizes through team chats, connect a Google Forms sizing form to Google Sheets, then turn checked responses into an approved bulk jersey order. This 2026 workflow keeps size collection automatic and order submission under your control, with specific checks for reversible basketball jerseys and soccer kits.
A size tally does not tell you whose name belongs on which jersey. You need a player-level record connecting the garment, size, print name, number and quantity before you calculate totals.
FE Custom is best suited to Australian teams seeking online sports customisation. For a custom jersey order through FE Custom, confirm the selected garment's sizing information and the required order details before building your form. This workflow prepares your records; it does not create a direct store integration or place an order automatically.
The useful boundary is simple: Google Forms collects answers, Google Sheets organises them, and your nominated coordinator authorises the handover. Keep that boundary in your 2026 club ordering procedure, even when every response looks complete.
Expected result: A respondent can select a defined size and submit an identifiable garment request without inventing their own size label.
Keep jersey numbers as text. A numeric field does not suit a request where a leading zero matters, and it does not prevent two players requesting the same number.
Use 1 order line per garment selection. If a player needs a jersey and shorts, collect separate records or clearly separate garment-specific questions; do not assume the same size applies to both.
For reversible basketball jerseys, record one jersey as one physical garment. Do not double the quantity because it has two wearable sides. Add separate side-specific personalisation fields only when the agreed design needs them, and confirm the permitted arrangement before collecting answers.
For junior teams, collect a parent or guardian contact only where you need it for confirmation. Avoid unnecessary personal details. Explain who can access responses and keep the working spreadsheet restricted to the ordering team.
Expected result: New form submissions appear in the linked response spreadsheet, while the working tabs remain separate from the raw answers.
Submit 2 test responses before inviting the team: one ordinary request and one deliberate correction or duplicate. Verify the size choices, quantities and printed text in Sheets, then remove the test records from the working order.
Test the responder link in a signed-out browser as well. A form that works for its owner has not yet passed an access check for parents or players.
Do not build your order by editing player answers directly in the linked response tab. Copy the records into Checked order, then document corrections there alongside the player identifier and confirmation status.
The distinction matters when a respondent edits an answer. Your checked copy is not automatically synchronised with later form changes; reconcile it before approval. For a 2026 season order, include the season in the file name so the next coordinator does not reuse an old handover.
Expected result: Each approved line identifies a garment, its wearer, its size and its quantity, with no unresolved personalisation questions.
For size totals, select the checked data and choose Insert, Pivot table. Add garment, fit range and size under Rows, then quantity under Values, summarised by SUM. Exclude unapproved records before using the totals for handover.
Count garments, not submissions. One submission requesting multiple garments must contribute its quantity, not merely one response, to the size summary.
The handover follows a fixed sequence: collect responses, check sizes, resolve duplicates, approve records, then freeze the export. Keep the approval stage between the working spreadsheet and the supplier-facing document.
A reversible basketball jersey needs both a garment check and an artwork check. Record the player's size once, but review the proposed colours, names and numbers for each side wherever they form part of the agreed design.
Do not infer construction, fit or printing options from the word reversible. For FE Custom custom jerseys, confirm the selected garment's details before treating a design request as approved. The spreadsheet records your instructions; it does not establish what the garment supports.
Expected result: You have a checked export whose totals match its individual garment lines, ready for the submission method agreed with the supplier.
Do not assume FE Custom accepts a particular spreadsheet upload or file format. Confirm the handover method before sending the order, and use the jersey design proof and approval guide to keep artwork approval separate from roster approval.
Allowing original-response edits and collecting a separate correction are adjacent workflows, not interchangeable records. Choose the correction method before publishing your 2026 sizing form.
| Correction method | Best for | Advantage | Limitation |
|---|---|---|---|
| Original-response editing | Players correcting their own details before cutoff | Keeps the correction with the original response | Requires access to the edit link and reconciliation with your checked copy |
| Separate correction submission | Coordinators reviewing changes explicitly | Keeps the change request separate for checking | Creates another record that must be matched to the original |
Use original-response editing before approval; use a separately recorded amendment after approval. With Allow response editing enabled, instruct respondents to retain their edit link. If they submit again instead, match both records and confirm which answer replaces the other.
For a separate correction submission, require the player identifier, garment, old answer and replacement answer. Update Checked order only after confirmation, then rebuild the approved handover if it has not been submitted.
After submission, record the requested amendment separately and obtain supplier confirmation before changing the approved order record. Editing a spreadsheet does not amend an order already handed over.
Check publication and responder access first. Then inspect sign-in restrictions, including Limit to 1 response. Repeat the signed-out browser test after changing access; do not solve the problem by giving players spreadsheet editing access.
A copied working tab is a snapshot, not a live connection. Reconcile new responses and edits into Checked order before approval. Keep a visible review status so newly collected records do not enter the approved export unchecked.
Look for duplicate submissions, multiple garments and reversible jerseys counted twice. Compare each repeated identifier with the original response before removing anything. Use quantity sums rather than response counts when rebuilding the tally.
Set the working column to Plain text before entering the confirmed numbers. Check the reopened export too: spreadsheet software can reinterpret CSV values. Restore the intended text from the confirmed player record rather than guessing.
Treat the frozen export as the order record, not the live response tab. Record the amendment, identify the affected garment line and obtain confirmation before issuing a replacement file. Never leave two competing versions labelled final.
Reuse the structure for soccer jerseys, tennis tops or pickleball apparel, but rebuild garment and size choices from the relevant information each time. A basketball size list is not a club-wide sizing standard.
For a multi-team order, add squad and coordinator fields, then review number conflicts within each squad. Keep delivery coordination in your internal planning record, including the required event date and nominated Australian recipient; confirm timing separately rather than treating the form deadline as a delivery commitment.
For FE Custom custom jerseys, the next useful improvement is a documented handover checklist shared by successive team managers. Keep the selected garment reference, approved artwork reference and frozen roster together, with contact details stored separately.
How do I turn a Google Sheets sizing form into a bulk jersey order?
Collect sizes through Google Forms, link responses to Google Sheets, then check and approve garment-level order lines before exporting them. Submit the approved details through the method agreed with your supplier; the form does not place the order.
Can Google Forms send jersey sizes straight to Google Sheets?
Yes. In Google Forms, open Responses and select Link to Sheets to connect submissions to a spreadsheet. Keep raw answers separate from your checked order and approved handover.
Should players enter their usual T-shirt size?
Players should choose a size using the selected jersey's current chart, not their usual T-shirt label. Follow the chart's measurement method and distinguish youth and adult size ranges.
How do I count reversible basketball jerseys in a bulk order?
Count each reversible basketball jersey as one physical garment. Review both sides of the agreed design without doubling the garment quantity.
Can parents change a size after submitting the form?
Parents can edit their original response when Allow response editing is enabled and they retain access to the edit link. Reconcile the change with the checked order before approval; after submission, handle it as an amendment.
Does this workflow automatically submit an order to FE Custom?
No. This workflow collects and organises order information; it does not establish a direct ordering integration. Confirm the submission method and required details before handing over the approved order.
Is an Excel workbook or CSV better for the jersey handover?
Use the format requested by the recipient. An Excel workbook can retain multiple sheets, while a Google Sheets CSV export contains the current sheet; reopen either export to check the final data.
An order deadline is not an approval record. Before closing your 2026 collection, ask the checker to read the exported file rather than the live sheet. That checks the document you will actually hand over, including any changed number formatting or omitted tabs.
Your cart is currently empty.
Start Shopping