
Hi Yohan,
If you're interested in getting expert help with your app, please check out this page: https://podio.com/site/en/partners
Best,
Andreas
Hi guys!
I need Help / guidance in creating an app that can connect via api.. with other sources and have this tool calculate values before outputs a pdf, csv. etc.
Thanks
Please sign in to leave a comment.
Hi Yohan,
If you're interested in getting expert help with your app, please check out this page: https://podio.com/site/en/partners
Best,
Andreas
Thank you Andrea, was wondering if this can be done manually using Podio API / developer areas?
Sure, if you have the right skills then you can do it yourself.
Hi Andreas,
I searched both partners and API docs, getting pro help, but there are limitations that may turn this process in several services.. which I wished to eliminate by moving to Podio.
what do I do?
So far, you haven't really described what you want to accomplish in very much detail. As such, I have a hard time guiding you in the right direction. If I understand you correctly though, you have very specific requirements, which may indeed either require you to either write a custom integration yourself or one or more third-party integrations.
You're absolutely correct. Let's start in small steps:
Can I import export current data from hubspot to Podio using a csv?
The reason I ask, is that none of Podio partners, like Zapier, Podbox, cannot help me with synching current data (deals) to Podio. Afterwards, yes.
thanks,
I'm not familiar with Hubspot, but I can see they have an API. You will need to write some code which syncs data between the two.
Yes, you can import CSV files from Hubspot into Podio.
will you know of any applications that can connect via api in Podio?
many thanks,
What do you mean by applications that can connect via api in Podio?
Sorry, Podio Apps - customized apps so it calculates or manipulates the data I import.
Sorry, but I'm still not sure what you're asking. Please be as specific and concrete as possible.
calculations
Hi Andreas, calculations like:
=IF(B17="Yes",$B$32,0)
minimum - rounding - X / + -
=IF($I$7<501,80,IF($I$7<1001,160,160+(($B$31-1)*$K$5)))
for this do I need to create an input form, then related to another app that makes the calculations from this input form (app)
You'll need to create a calculation field per formula like this. A rough translation would be something like this:
=IF(B17="Yes",$B$32,0)
becomes @FieldA ? @FieldB : 0
=IF($I$7<501,80,IF($I$7<1001,160,160+(($B$31-1)*$K$5)))
becomes
if(@FieldA < 501) {
return 80;
} else {
if(@FieldA < 1001) {
return 160;
} else {
return 160 + (@FieldB - 1) * @FieldC;
}
}
Where in an app in my workspace in Podio? or with globiflow for instance?
The calculation fields would be in an app in Podio.
Dear Andreas,
When adding the code to either an app using javascript, like you showed:
=IF(B17="Yes",$B$32,0) becomes @FieldA ? @FieldB : 0
=IF($I$7<501,80,IF($I$7<1001,160,160+(($B$31-1)*$K$5))) becomes
and this..
if(@FieldA < 501) {
return 80;
} else {
if(@FieldA < 1001) {
return 160;
} else {
return 160 + (@FieldB - 1) * @FieldC;
}
}
... the second part of my inquiry, is what I would add to an application, but can I use this code in a calculation field of that app, and come up with a total?
I need to do set a value to the below fields, and make a calculation:
1 var type = car
2 var a = 1
3 var b = 1
4 var c = 1
5 var d = No
6 var e = No
7 var f = Yes
8 var g = 500
9 var subTotal = 750
10 var h = 300
11 var i = 450
12 var j = i * b
13 var k = subTotal * b
14 var total = 1550.00
then, if var 1 (type) == "car" then calculate:
1 For var g =IF(f ="Yes",g*b,0) RESULT 500
2 For var subtotal =IF(OR(type ="car",type ="bike"), 750,850) RESULT 750
3 var i =IF(a>1,(a-1)*450,0) RESULT 0
4 var total =SUM(j+k) RESULT 1,550.00
many thanks,
Yohan
sorry forgot to ask the "When adding the code to either an app using javascript, like you showed:" question ::
do I have to create calc fields for each var, or can create all in one calc field with end result of total?
1) You should only add a calculation field for each thing you want displayed on the item. You can calculate sums using reports: https://help.podio.com/hc/en-us/articles/201019638-Filters-and-reports
2) You can convert the Excel to Javascript similar to the examples I've provided already.