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?
Discussion posts and replies are publicly visible
Hi Anvesh Shetty , Can you try changing the field to Double in the database so that it can be mapped to the Appian record field as Number (Decimal)? I think it will work. Let me know if it works or not.
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!!!