I have this app built using Retool to capture daily production data from my factory.
There are 3 shifts in a day, and this field is a dropdown.
A: 4AM to 12PM
B: 12PM to 8PM
C: 8PM to 4AM
There are a total of 42 looms.
The date defaults to the day of the recording. Tapping it should open a calendar to select the date.
There is a text box to enter Remarks.
Every other field is a numeric field, and has some form of validation (number should be less than a number, and greater than a number).
When you click the submit button, the data is written to a Google Sheets row.
Link to the Google Sheets workbook: https://docs.google.com/spreadsheets/d/1Q-w1uWNwSb_M5Ee8WzdgVwvDvyO_WmXupM9TSHP7Nro/edit?gid=0#gid=0
Name of the data tab in Google Sheets: 'Log'.
Headers in the Google Sheets tab 'Log':
User
Timestamp
ReadingDate
Shift
Loom
RPM
Efficiency
WARP
WEFT
Picks
Meters
CFM
OpenMTR
Remarks
Attempts
Create a simple mobile-responsive web app, to intake this data. | A shadcn/ui and v0 generation - v0