Help / guidance in creating an app that can connect via api..

October 22, 2015 17:50

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

Comments

19 comments

Andreas Garnæs

October 23, 2015 08:48
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
0

Comment actions Permalink
Yohan Hidalgo

October 23, 2015 19:41
Thank you Andrea, was wondering if this can be done manually using Podio API / developer areas?
0

Comment actions Permalink
Andreas Garnæs

October 24, 2015 05:12
Sure, if you have the right skills then you can do it yourself.
0

Comment actions Permalink
Yohan Hidalgo

October 26, 2015 17:33
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.
- need to bring the data from hubspot to podio
- create or gobiflow will help in the calculation service and pdf output
- lastly deliver pdf to client.
what do I do?
0

Comment actions Permalink
Andreas Garnæs

October 26, 2015 20:35
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.
0

Comment actions Permalink
Yohan Hidalgo

October 26, 2015 23:12
You're absolutely correct. Let's start in small steps:
1. we need to sync the data from hubspot to Podio.
2. Gobiflow will work with us, but they require to have data in Podio first.
3. Once we finalize with gobiflow, we need to receive that updated data to Podio to send to our client, which it was synced from Hubspot.. originally.
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,
0

Comment actions Permalink
Andreas Garnæs

October 27, 2015 08:38
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.
0

Comment actions Permalink
Yohan Hidalgo

October 27, 2015 15:05
will you know of any applications that can connect via api in Podio?

many thanks,
0

Comment actions Permalink
Andreas Garnæs

October 27, 2015 15:31
What do you mean by applications that can connect via api in Podio?
0

Comment actions Permalink
Yohan Hidalgo

October 27, 2015 15:34
Sorry, Podio Apps - customized apps so it calculates or manipulates the data I import.
0

Comment actions Permalink
Andreas Garnæs

October 27, 2015 15:42
Sorry, but I'm still not sure what you're asking. Please be as specific and concrete as possible.
0

Comment actions Permalink
Yohan Hidalgo

October 27, 2015 20:14
calculations
0

Comment actions Permalink
Yohan Hidalgo

October 28, 2015 21:01
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)
0

Comment actions Permalink
Andreas Garnæs

October 29, 2015 11:56
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;
  }
}
```
0

Comment actions Permalink
Yohan Hidalgo

October 29, 2015 19:35
Where in an app in my workspace in Podio? or with globiflow for instance?
0

Comment actions Permalink
Andreas Garnæs

October 30, 2015 07:36
The calculation fields would be in an app in Podio.
0

Comment actions Permalink
Yohan Hidalgo

October 30, 2015 16:55
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
0

Comment actions Permalink
Yohan Hidalgo

October 30, 2015 17:14
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?
0

Comment actions Permalink
Andreas Garnæs

October 31, 2015 17:05
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.
0

Comment actions Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?