formula showing sum of all records

[Wolfgang]

Hello, I need the formula in my own layout to get the amount of all records (for example the sum of all invoices).
It must be the formula that is automatically in the standard layout in the calculation row (sum, average, min, max, number). A new calculation field and sum (fieldname) etc. does not work …

[Brendan]

Hi Wolfgang,

Sure. You can get that.

In the JavaScript API docs there’s this function:

var total = form.getTotalOfField(field_id);

That’ll do it. It returns the same value as you see displayed at the bottom of the records list view.

Hope that’s what you’re looking for.

Thanks!

Brendan

[Wolfgang]

Thank you for the info. But no result is shown …
I use 2 field scripts (see screenshots).
– one with the line you mentioned above
– one using the formula of the list in the script window
No entries in the fields!

Wolfgang

Attachments:

You must be logged in to view attached files.

[Brendan]

Can you post your script?

[Wolfgang]

first:
var total = form.getTotalOfField(“fld-1af55213294146b68ad048a031b1cb70”);

second:
var fieldname_id = ‘fld-1af55213294146b68ad048a031b1cb70’;
var total = form.getTotalOfField(fieldname_id);

[Brendan]

Ok, well that should work.

And sorry, for some reason I didn’t see your attachments before.

Did you return the values later on in your script? Or did you just define the vars?

[Brendan]

Should be like this:

var fieldname_id = 'fld-1af55213294146b68ad048a031b1cb70';
var total = form.getTotalOfField(fieldname_id);
total;

[Wolfgang]

I tried and found:
the online manual only says:
form.getTotalOfField (“fld-1af55213294146b68ad048a031b1cb70”);

or
fieldname_id = ‘fld-1af55213294146b68ad048a031b1cb70’;
form.getTotalOfField(fieldname_id);

this works …

[Wolfgang]

Yes, the ‘total’ show-command was missing. This will also show the result…
Thank you Brendan

[Wolfgang]

the “get command” show this:
var field-name_id = ‘field-id’;
but I always get an error message:
TotalUmsatz: SyntaxError: Unexpected token ‘-‘. Expected ‘;’ after variable declaration., line:14

the “field-name_id” hyphen seems to be wrong!? Using “fieldname_id” as variable, it works.

[Daniel Leu]

I don’t think that the ‘-‘ is valid in the variable name. Try using

var field_name_id = ‘field-id’;

of

var fieldName_id = ‘field-id’;

[Wolfgang]

Hi Daniel,
that’s exactly what I wanted to say.
In Tap Forms in the script field the variable of the formula “get total of field from form” is displayed with “-” and always gave me an error message.
That’s why I removed the “-” and used “fieldname” or “field_name” …

[Daniel Leu]

Hi Wolfgang, what is your field name?

[Daniel Leu]

Now I see it….

Brendan, double-clicking on ‘Get total of field from form’ snippet returns

`var field-name_id = ‘field-id’;
var total = form.getTotalOfField(field-name_id);1

But the - is not a valid character to be used in a Javascript variable name.

The same applies to the other three Get... snippets.

[Brendan]

Hi Wolfgang,

Ah ok. I understand now. Ya, I see that there was a problem with my variable substitution code where Tap Forms replaced the tokens in my snippet code. I’ve just fixed this for the next update.

This happened when you double-clicked on the get total of field from form snippet.

Thanks for reporting this issue.

Brendan

[Author]

Posts