On my UI, user can change data type from drop down menu and enter a value against it. User can also change data type and data value at anytime. Now let’s say, user has selected String data type and entered a string value against it like shown in image below:
Now if user changes data type of this column to Integer, what will happen with the string value? Since Integer type cannot hold string values. Should string value be discarded immediately as data type is changed to numeric or should there be a warning message that your value will be discarded if you continue? (I want to avoid warning message since user can change data types and values quite frequently and this will irritate the user.) Is there any other way to handle this scenario? Can I observe such kind of behavior on any already implemented UI for help? Please guide.