Difference between property type and cell properties type
I have a property "amount" set as "pxTextInput". The ruleset is locked so I can't change and it is used by different rulesets that it is not easy to change the property type.
In one of the section the property shows as "Text Input" under cell properties. Can I change it to "Currency" so users can only type numeric values? The actual property type will remain the same as "pxTextInput" but under section the cell properties will have "currency".
Do cell properties only affect UI ? Anyone see if this could be an issue?
You can change the control (example, pxTextInput to pxCurrency) in the section. And it will be presented as a currency. But it will not behave as a number as the underlying property rule has the type "Text". If I read your description properly. And when you try to use the property rule in declare expressions for example, it will be treated like a string.
Now if the property called "amount" is actually "decimal" type and the control and validation is shown as "pxTextInput". You won't have any issues from a data standpoint using the property as a number in declare expressions etc. Just over ride the control in the section.
There were some issue I found while using "currency" type in cell properties of a pxTextInput type. In some sections I was seeing correct behaviour where it wouldn't allow user to type any alpha characters. But on some sections it was behaving as text field, allowing any character to be entered, even though the cell type was set as currency.