V8 custom formulas

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsV8 custom formulas
(Created page with "Make a field automatically be a mathematical result. Return 'total' as JSON key with value 'price' * 'tax_rate'. price and tax_rate are stored in a database, total is not. <s...")
 
Line 1: Line 1:
 
Make a field automatically be a mathematical result. Return 'total' as JSON key with value 'price' * 'tax_rate'.
 
Make a field automatically be a mathematical result. Return 'total' as JSON key with value 'price' * 'tax_rate'.
price and tax_rate are stored in a database, total is not.
+
price and tax_rate are stored in a database, total is not. This is a post process script that alters the response.
  
 
<source lang="javascript">
 
<source lang="javascript">

Revision as of 17:40, 29 June 2016

Make a field automatically be a mathematical result. Return 'total' as JSON key with value 'price' * 'tax_rate'. price and tax_rate are stored in a database, total is not. This is a post process script that alters the response.

var lodash = require('lodash.min.js');
 
lodash._.each(event.response.content.resource, function (record) {
 
    if (!record.tax) {
 
        throw "Tax is required!";
    }
 
    if (!record.price) {
 
        throw "Price is required!";
    }
 
    record.total = (parseFloat(record.tax) * parseFloat(record.price) / 100) + parseFloat(record.price);
});