Y24-284 - Well input validation

[harrietc52]

User story

As a user, when filling in a sample manifest, I would like there to be some validation of any column with a well location input. There is currently validation on upload, but it would be helpful to have some validation of the input whilst populating the sheet as there is copy and paste errors, and this would save time as catching the error earlier. The validation should check the well location is valid e.g allow only 1 letter and then 1 or 2 numbers. 'E11'. Question: Do we want to limit the letters to A-H etc or this might depend on the plate type in the given manifest

Who are the primary contacts for this story
@harrietc52

Who is the nominated tester for UAT
Rich Clark

Acceptance criteria
To be considered successful the solution must allow:

• Sample Manifest columns for well location input to have validation to ensure they are of a correct format
• Format to be 1 letter followed by up to 2 numbers
• A pop up appears whilst editing the manifest if the well location isn't valid

References
This story was a spin out story from:
#4083

Additional context
Add any other context or screenshots about the feature request here.