I have a script where several fields are concatenated together including one which contains a number:
function Third_Party_Charges_Csv() {
// Fetch content from table
var third_party_charges = record.getFieldValue('fld-021cfb3cc4f446ddbf5f9463c7b5d620');
// Define field ids from table columns
const item_id = 'fld-410bdf5d624a4651b8a803becd9c6578';
const cost_per_item_id = 'fld-6cea4aa73ad44b6f91ba7f566e321790';
const number_id = 'fld-95791fbc24bd4f3ca714756e5dd6a060';
const cost_id = 'fld-a0be1b009c6a4a99a1784d36da134ee3';
var txt = [];
// Loop over all entries and fetch field content.
for (var n = 0; n < third_party_charges.length; n++){
var third_party_charge = third_party_charges[n];
var item = third_party_charge.getFieldValue(item_id);
var cost_per_item = third_party_charge.getFieldValue(cost_per_item_id);
var number = third_party_charge.getFieldValue(number_id);
var cost = third_party_charge.getFieldValue(cost_id);
// Format field content as desired
txt.push((n+1) + ". " + item + ": £" + cost_per_item + " x " + number + " = £" + cost);
}
// Combine each formatted table row
return txt.join(" - ");
}
Third_Party_Charges_Csv();
In the field it displays (as currency) as, eg 32.40, but in the script it shows as 32.4.
Is there a way to make the script show numbers with two decimal places?
-
This topic was modified 3 months, 2 weeks ago by
Brendan.
-
This topic was modified 3 months, 2 weeks ago by Brendan.
cost_per_item.toFixed(2) should do it.
Brendan,
Thank you for the answer.
Victor
FYI…pasted Vitor’s original post into the assistant GPT. For the record, I liked Brendan’s very concise and to the point response better, for my typical requests. Anyway, here is the complete GPT response:
To display numbers with two decimal places in your Tap Forms script, you can use JavaScript’s toFixed() method. Here is your script modified to ensure that numbers are formatted to always show two decimal places:
function Third_Party_Charges_Csv() {
// Fetch content from table
var third_party_charges = record.getFieldValue(‘fld-021cfb3cc4f446ddbf5f9463c7b5d620’);
// Define field ids from table columns
const item_id = ‘fld-410bdf5d624a4651b8a803becd9c6578’;
const cost_per_item_id = ‘fld-6cea4aa73ad44b6f91ba7f566e321790’;
const number_id = ‘fld-95791fbc24bd4f3ca714756e5dd6a060’;
const cost_id = ‘fld-a0be1b009c6a4a99a1784d36da134ee3’;
var txt = [];
// Loop over all entries and fetch field content.
for (var n = 0; n < third_party_charges.length; n++){
var third_party_charge = third_party_charges[n];
var item = third_party_charge.getFieldValue(item_id);
var cost_per_item = parseFloat(third_party_charge.getFieldValue(cost_per_item_id)).toFixed(2);
var number = parseFloat(third_party_charge.getFieldValue(number_id)).toFixed(2);
var cost = parseFloat(third_party_charge.getFieldValue(cost_id)).toFixed(2);
// Format field content as desired
txt.push((n+1) + “. ” + item + “: £” + cost_per_item + ” x ” + number + ” = £” + cost);
}
// Combine each formatted table row
return txt.join(” – “);
}
Third_Party_Charges_Csv();
By using parseFloat() and toFixed(2), this script ensures that the cost_per_item, number, and cost fields are always displayed with two decimal places [oai_citation:1,javascript – Format number to always show 2 decimal places – Stack Overflow](https://stackoverflow.com/questions/6134039/format-number-to-always-show-2-decimal-places) [oai_citation:2,javascript – How to format numbers? – Stack Overflow](https://stackoverflow.com/questions/5731193/how-to-format-numbers).
.
