How to prevent misentry by end-users when importing.
On my current model, there is an export module providing a CSV template for end-users. When end-users get this CSV, I’d like them to be submitting the date format correctly (ie Q1F Y23 rather than Q1FY23).
Does anyone know if there is a way to put a drop-down list on the date column of a CSV file to prevent possible misentry by end-users? As seen on the last screenshot, I can do this by selecting “ask each time import is run” for that column, but it will not be the most easy way for the end users.
I’d appreciate any help.