1) User should be able to enter only integer values with thousand separator and upto 10 digits and it should be client side validation.
I have a decimal type property and cell type is also decimal. I have configured thousand separator in cell properties but there is no max characters option in cell properties. In DB table the datatype is set to decimal(10,0). This is existing configuration and hence system will save upto 10 digits only in DB table. Submitting more than 10 digits gives commit error and now we need to show a custom error message.
I have configured IsInteger Edit Validate rule in the property. This makes sure that user cannot enter decimals. Hence, thousand separator and not allowing decimals is taken care of. However, In the UI when I enter 10 digits, Edit validate "IsInteger" rule throws an error, rather it should allow me to enter 10 digits.
I think I have to write a custom edit validate rule which will validate the length and also validate whether its integer. Need inputs on how to achieve this way or some other way is also fine.
***Edited by Moderator Marije to add Capability tags***
@PritamK0 Hi, In the UI field presentation tab there is editable settings under which you can mention the max and min characters. Can you try configuring that, this setting restricts user from entering more than the mentioned characters. PFB. Please see if it helps.