"Payload has transformed the way our clients manage content. It's an indispensable tool for any modern agency."
Microsoft chose Payload to tell the world about AI.
What type for monetary values
I would like to keep monetary (money/prices) in collections. Which type will be okay, number? But do I not lose precision on arithmetic problems?
Can I create own implementation for field compliant with: https://www.mongodb.com/docs/manual/tutorial/model-monetary-data/ ?
Selected Answer
@dawidmachon It is generally best practice to store monetary values in the smallest denomination, there are plenty of good articles out there explaining why this is the case.
So personally I would opt to use the number field almost always (storing as cents), and then add a description that displays the amount in a dollar amount.
1 replyRelated: #1924
Would be nice to get a full on money field like https://craftcms.com/docs/4.x/money-fields.html
Star
Discord
online
Get dedicated engineering support directly from the Payload team..