How to get RecordType field as Decimal if source field is decimal

Question

Felw amount fields i have created as DECIMAL in Database, but it got mapped as INTEGER in Appian record. How to get decimal as a datatype in Appian as well? What should be the source field datatype to achieve this?

Varun Teja Gurrapu · Accepted Answer

Hi Anvesh Shetty , I suggest you to change the record field type as Decimal according to the requirement here, Basically amount will be decimal most of the times, please take as general. And one more thing is your DB datatype may be decimal(10,0), change it to decimal(10,2). As you can see in above pictures , we can't map if the parameters in datatype is incorrect, in this way you can change the record type field data type. Hope this helps you!!!

How to get RecordType field as Decimal if source field is decimal

Top Replies