We have a form with fields below:
- Code
- Item Name
- Description
When we reviewed the list of 'Code' in customer database, we noticed that the 'Code' values tends to be quite long. It seems like the users use the 'Code' field to input descriptions.
Expectation:
- Code: USA10012002
- Item Name: Drain Filter Separator
- Description: Element: 5 micron Bowl Construction : Metal Drain : Automatic Max Pressure : 175 PSIG Max Temp. : 120°F (49°C)
Outcome from users:
- Code: USA10012002 Drain Filter Separator Element: 5 micron Bowl Construction : Metal Drain : Automatic Max Pressure : 175 PSIG Max Temp. : 120°F (49°C)
- Item Name: Drain Filter Separator
- Description: -
We plan to now add a text limit for 'Code' to encourage users to use the fields correctly and utilize the Description field as supposed to.
However, how will this impact the existing users that have been using 'Code' as 'Descriptions'?
[Update as of 27/05/2022] I believe one of the contributing factor where users use 'Code' as 'Description' is because the 'Description' field comes later in the sequence. We also realised we have 2 'Description' fields. One is in the 'Sell' section and one in the 'Buy' section. Expectation: (Item: Box), Buy(Price: $5.00, Description: Always buy in bulk from Jennifer), Sell(Price: $8.00, Description: Please add company logo to box). While users actually want to put item descriptions such as dimension, specs, etc. Something our team need to relook.