Hello Friends; Greetings from Rusty Old Palestine; Today I would like to discuss with you if it is worth while to allocate resources to this feature: [adding an equation box to custom fields, which multiply, divide, add, or subtract numbers and then calculate and send the sum to another field] […

Brilliant idea, it would be really great

The latest version (18.7.64) allows to set custom field to number type. This allows to do these calculations using custom themes. Let’s say you have two custom fields: Field 1 Field 2 and you want to show on invoice Field 3 which is total of Field 1 and Field 2 All you have to do is inject foll…

Great! It’s possible to do addition a standard field + custom field; e.g. Invoice Total + Custom Field.

Check the latest version (18.7.72). You can now do something like: {{ table.totals["Total"] | plus: custom_fields["Field 1"] }} or: {{ table.totals["Balance due"] | plus: custom_fields["Field 1"] }} etc.

lazy question: what happens if you change an existing custom field from “text” type to “number” type? I have used a custom text field to store numbers but would like to change it to a number field now but do not want to lose my existing values.

I changed an exiting text field to a number field and the data I had already entered remained and was now formatted as a number :slight_smile:

Hello, Regarding to this thread, I have another specific question. In my business I sometimes have to deal with rights. This means that a percentage of my article price should be invoiced as rights (with a different VAT). Example: EDITING OF CORPORATE MOVIE €250 21% €…

Do the two lines have different vat amounts? In this case you must have two lines in the invoice.

You cannot do anything close to what you describe, @Bart_De_Jonge . Tax codes cannot be applied to custom fields, only line item amounts, which cannot be involved in calculations with custom fields. Taxes are interwoven through the hard coding in some fairly complex ways. Those calculations have to b…

Equation into a custom field & sum into another custom field

Topic		Replies	Views
Calculations with custom fields	9	1418	February 22, 2022
Calculating total of column	33	4367	January 18, 2023
Addition/subtraction of numbers in 2 separate lines	8	583	January 18, 2023
Custome Fileld calculation	6	525	January 18, 2023
Calculation improvements for custom fields	14	1195	January 18, 2023

Equation into a custom field & sum into another custom field

Related topics