Calculations Not Working
I have tried various types of calculations within my account, but none of them seem to be working. I even requested help from Sara, who gave me a formula to copy exactly, which didn't work.
var blank = @somevariable
'Booking Details\n===\n---\n'
I also tried a calculation to just figure out the remaining balance of an account.
"$ " + (@Amount Invoiced - @Amount Paid)
I tried to delete the "@" symbol as it doesn't show when selecting a variable in the tutorial video, but it just deletes the whole variable. Any help would be appreciated.
-
Hi Alan,
what doesn't work? Do you get an error notification in the preview under the calculation field?
Both calculations work for me - see screenshots:
The result of your first calculation: http://goo.gl/pJPmDn
is: http://goo.gl/KTLa1EThe result of your second calculation: http://goo.gl/DvNZwH
is: http://goo.gl/1hRpWWWhat shall the first calculation show?
var blank = @somevariable;
'Booking Details\n===\n---\n'Are in the second calculation "@Amount Invoiced" and "@Amount Paid" number fields?
The @-symbol is shown in the blue marked field token for some weeks now, Podio changed it some weeks ago. Before that, the @-symbol hasn't been shown (therefore it isn't in the tutorial), but that doesn't effect the functionality of the field token in any way.
Rainer
-
Hi Alan,
I've published an app to the market that contains a simple calculation like the one you are looking for. Maybe you can try that and see if that works for you? It could be a starting point to get you going with calculations: https://podio.com/market/apps/100519-
Have a great weekend! Best,
Stefan -
Stefan,
I downloaded your calculations app and it still does't work for me. I wonder if it has something to do with my account.
http://screencast.com/t/f49VmTpl45qy -
Hi Alan,
Podio can be a little confusing when it comes to calculations, because everything seems to update instantly, but calculations don't. Calculation results don't update immediately after you create a new item.
Try this: After you created the item, can you try closing and opening it again (or simply reloading the page)? If that doesn't show the correct result, please contact Podio's support and report the issue: https://help.podio.com/hc/en-us/requests/new
Best,
Stefan -
Hi Alan,
"title" was the name of the field in my app I used as an example. You have to select one of your fields, whatever field in this case. Podio needs a @field in a calculation, whether you need it or not for what you want to display.
If you only want to show some text in your calculation field and you only write the formula 'Booking Details\n===\n---\n' Podio will ask for a field . Than you have to outwit Podio. This trick doesvar blank = @whateverField;
If you declare @whateverField as a variable (var) this field doesn't show up in the calculation, it's "passive" - but for Podio a @field is in the calculation field and Podio is satisfied. Instead of declaring it as a var you can also use
//@whateverField
// flags the following text as a "Don't use the text for the calculation"A variable you can use later in the calculation if you need it. For example:
'Booking Details\n===\n---\n' + blank
will be displayed asBooking Details
Content of whateverField
another example:
var amInvoice = @Amount Invoiced;
var amPaid = @Amount Paid;
"$ " + (amInvoice - amPaid)To use vars is recommended e.g. if your field names are long or if you use one field name several times in a calculation field. With vars your calculation (code) is easier to read. You even can do complete calculations in a var and than use it for a further calculation (in the same calculation field).
Rainer
-
I found the solution to the calculation problem in Podio.
What you need to do is start with a parenthesis and end with a parenthesis (). For example, you need to have it in this format (@hourlyrate*@hoursworked) or ((@hourlyrate*@hours) + @overtime).
It took me a while to figure this out.
Let me know if this is helpful.
Please sign in to leave a comment.
Comments
9 comments