Season 4, Episode 9 - A couple advanced tricks with ProcFu - Supercharged! with Jordan Samuel Fleming

Episode Transcript
Available transcripts are automatically generated. Complete accuracy is not guaranteed.
Narrator (00:00):
Welcome to powered by podio automation is everything.
supercharge your business withpodio. Get ready for another
episode of supercharged withJordan Samuel Fleming your
weekly dive into the awesomeimpact workflow and automation
you can have on your businesswhen it's powered by podio. Join

(00:22):
us each week as we learn fromthe top podio partners in the
world as we investigate systemintegrations and add ons and
hear from real business ownerswho have implemented podio into
their business. Now, join yourhost Jordan Samuel Fleming, CEO
of game changers for this week'sepisode.

Jordan Fleming (00:45):
Hello, and welcome to this week's episode
of supercharge on your host,Jordan Samuel plumbing, here to
talk all about the power ofworkflow and automation. When
your business is powered bypodio, and how today it's
another one of those semi groupepisodes. A regular recurring
character you're gonna be seeingmore and more is of course our
CTO Andrew Creston, mainlybecause he's got such a

(01:08):
technical understanding of howpodio can be designed, built,
integrated, and other systemsAPI work, etc. that he joins us
again, because we are joined bynone other than Andreas houden.
Rock again, those of you as Imentioned on the podcast, if you
don't know his name, you knowhis work. Because if you use
podio, then you probably useglobey flow now called Citrix.

(01:32):
podio work flow automation, I'mnever gonna get that quote,
right. He invented it. Andreally it is the globey flow
slash pw A that is the beatingheart of most people's systems.
It is the automation tool thatis so comprehensive. He's come
back to the podcast, so thatAndrew he and I can dive a bit

(01:52):
more into the mini apps. This isan interesting episode because I
will say right off the bat,it gets a bit technical at times
I do try and you know, westarted out as as you know, non
technical as we can be. But youknow, as towards the end, I let
them go and they talk geek stufftogether. But it's really
interesting because we touch ontwo kind of key things of how

(02:14):
his one of his newer tools procfoo, which of course, all the
links will be in the in thepodcast. proc foo, has really
kind of levelled up podioworkflow and automation in the
same way that globey flow did.
There's a certain level whileproc foo is taking us even

(02:36):
further. And we talk about twokinds of things. Number one, we
focus heavily throughout thewhole episode on the concept of
many apps, because many apps areso incredibly powerful. And we
talk about use cases. It'sbasically ways in which you can
take podia data, and externaliseit so that other people can, can
use that interact with the data,use that data, whatever, whether

(02:59):
that is a form that they canfill in, submit and then edit
again very easily. Or whetherit's a full portal where you
know, you've got a customer thatyou know a group of customers
who they you want them to beable to log in somewhere, see
all the open projects, see thetasks that are open, maybe
update things or send a newrequests, all that can be done

(03:20):
in the proc food mini apps. AndI will say for those of you who
may be at the more the beginninglevel, you can start out with
proc food, many apps right away,I can do it. I started out with
the basics. We do talk more inthis episode about some of the
more, you know, lights and bellsand whistles. But the very

(03:40):
basics of it can be done byanyone. And quite honestly, you
can set up your first one inabout five minutes. I did it.
That's how long it took me. Thesecond thing we talked about,
and this is for the more geekyamongst us is that proc foo has
this new sequel sync servicewhere you can essentially
dynamically create a sequeltable based on your podio

(04:03):
workspace based on a podio appand immediately start sinking
the data up to sequel and usethe sequel data inside the mini
apps to be able to filter andsearch super quick. Anybody who
knows anything about podio knowsthat you know if you've got
10,000 items in an app searchingthrough that can take a long

(04:25):
time. And that's because that'snot how that's not what podio is
really built to do. It's youknow it's a difference between
podio and sequence and ways sowe get embedded into that into
the the latter half so it'sreally game to half's there are
a lot of beginner things that Ireally do recommend you take a
look at. And then of course wegot the more advanced things at
the end which is fascinating. Ilearned a lot as I always do. I

(04:46):
do encourage everyone if usingpodio head over to proc foo Of
course all the links are goingto be in the podcast description
on the YouTube etc. On the webpage. Try it out. It is an
incredible value for the cost.
You can get the $25 a month planon proc fu and that gets you
access to many apps. That is ano brainer in my opinion just
for going to the podcast asalways, as always, please take a

(05:09):
moment right now give thepodcast a like give it a little
review it really helps boost itup so more and more people see
it I get feedback from peoplewho listen to it they've got
specific things they want tohear us talk about or things
they want us to dive in pleasesend it into me no problem go to
we are game changers calm hit usup, send us in a form, get in

(05:30):
contact with me on podio I lovelove to hear it. And of course
if you've got an interestingpodio story to tell, please go
to we are game changers comm andsign up. I'll stop waffling on,
and I'll leave you in thecapable hands of Andreas,
Andrew. And me. Let's listen in.

Andrew Cranston (05:54):
So there are it did when you ask the question
What's new? So one of the thingsthat I know that's new in many
apps is the ability to look attable views. And well, where the
data is being pulled from SQL.
So yeah,

podio Okay, well, guys, well, I've already
started recording. Um, so

Andreas (06:13):
I pretty much say somebody

I I don't know Is anybody else coming? The
podio partners, the podiopartners from the bar very
unreliable

Andreas (06:26):
from the bar.

But anyway, more importantly, I mean, there are
obviously we've got you undress.
If you've not noticed thatstarted the podcast already. I'm
gonna fade this bullshit in. Butwe've got you Andreas, returning
champion with Andrew returningchampion to returning champions.
And for those of you who needthe briefest of refresher is

(06:52):
Andreas. If you use podio, youhave been touched by Andrea so
to speak, likely because he canmake it sound so. Andreas is
lurking. Andreas is obviouslythe the founder of globey, which
is a is a software provider morethan anything in Canada. And

(07:16):
most critically people will knowit as the guy who built globey
flow now called Citrix. podioworkflow automation. pw a and
they obviously but you know, ifyou use podio in any sense of
beyond just a blue box, thenchances are you use Andrea's his

(07:38):
work. He's also got productsaround email, global mail.
Better super menu, inbox, whichI still can't figure out how to
use one day he's going to teachme and most importantly, which
was we're going to focus ontoday proc foo. And critically
focusing on the miniapp functionof frog. So because I think

(08:00):
there are I mean, certainly anAndrew can back me up here. The
I've seen an explosion from thesystems we build. proc foo has
levelled up, I think it's fairto say proc foo has taken our
systems up a notch. In manyways. Some of the things you
know, our developers, thedevelopers who work who don't

(08:23):
necessarily have Andrews keptcapabilities have enormous
capabilities in proc foo now andmany apps has brought in
enormous functionality. And hugeuse case for us. With incredibly
ease. I you know, and so I wantto focus on that today. Let's

(08:43):
just could we maybe talk about acouple use cases. Let's start by
just some use cases. Let's setthe set the table so to speak,
with some use cases on miniapps. How about each of us give
our favourite use case of miniapps right now. Andreas, you
start putting you on the spot.

Andreas (09:06):
I think my favourite one is to create many portals of
podio data where you're givingexternal customers access to
only the ship that they needaccess to. In a really quick and
easy way that they don't have toeven bother with podio they
don't need a podio login. Butthey can still maintain their
own accounts and any record thatyou basically hold on them. This

(09:29):
is like help desks billing. It'sendless really whatever you have
in podio which is about somebodyelse outside you can let them
self manage their data

and not critically bring them into
podio. Correct. Andrew?

Yeah, I mean having having like a full so so
basically, you talked about theexternal facing side of things.
Now, we have definitely seen alot of benefit there as well.
But one of the things that Thatgets under reported is the
internal benefits of using miniapps for improving the podio

(10:08):
user interface in places where,where it's lacking. So one thing
that that and you've providedmany solutions for this on your
blog and in other places, alwayslooking at the best way, or the
best ways to be in one app, andcreate an item in another app
with a relationship or fieldsfilled in automatically from the

(10:31):
previous app, or whatever, andthen being taken to that new
item automatically. Because weall know that there's a lot of
ways in which you can create anitem from one app and then get a
comment or field relationshipfield updates, or maybe use
markdown tables, and then you goin, but they're all reliant on,
obviously, the user interface,not not crapping out on you. But

(10:53):
when you go from one item toanother using a redirect, you're
there, and then you can juststart working from it. So we've
done this in a couple ofdifferent ways. We use External
links primarily. And they usejQuery, which is like a very
well known JavaScript plugin toredirect the user to another
account works great and pw a,but it's just create an item

(11:14):
here and go. Now, that has notnecessarily been sufficient when
there's form validationinvolved. And we want people to
be able to fill out forms withreal hard data. So we now use it
internally a lot in places wherethe user wants to create a new
item, click on the link, andit's a form in proc foo, where

(11:34):
some of the things have beenfilled in some of those
variables get to be pulled infrom the item, you've clicked
the item, click the link fromand then fill in the fields that
you want and use proc script andJavaScript to try to do some
validation, create the item withproc foo, and then take the user
somewhere back to the miniappback to the new item, whatever

(11:56):
you want to do. And the redirectbit in proc script works awesome
too. For that, you know, procscript does make things a lot
easier, I think to chew on thanthe average person's ability to
kind of know what jQuery is andknow what JavaScript is, you
know, it's it's, it's moreachievable. So I like it for
internal purposes. And we wealmost always now approach a lot
of internal creation processeswith with either proc foo, or,

(12:18):
or External links, but

Andreas (12:19):
proc foo, when there's validation to be not used. Not
to mention, then with yourforms, you can also have
dependent dropdowns. You canhave tabs.

I'm gonna push I'm gonna go that I obviously
love the portal element of themini apps, we use it internally,
we use it for our own things, webuild it for clients. But I also
think that the miniapp soeloquent elegantly solves some
of the biggest problems withpodio, webforms podio web forms

(12:55):
are shipped styling wise, you'vegot no control over like
anything at all. But mostimportantly, there's no vowel,
there's no drop, there's nocontextual, if they answer this,
open up these things, if there'sthis, make sure this is
required, but only in the youknow, there's no flexibility.
And the pre filling elements isa pain. And then going back into

(13:18):
it is a pain, like trying togive someone an option to re
edit a form they've submitted itjust doing it via podio you can,
but it's shit. And it is andit's so easy to fuck it up and
you like you can just so easy totell, you know, you've got to
show the field. If it's arelation, you've got to show the

(13:41):
field and then they could fuckit up and all this sort of thing
with proc foo because you canlike show a field but lock it in
the miniapp. And because you cando all these things, they are a
huge power webform. Like if youuse web forms at all, you get
proc foo and do them betterstart to do them better, give

(14:03):
them better access, give thembetter features. And it's
incredibly easy to do. And Ithink that's my thing. One of
the things I love about it andresearch

so you you and now Andreas like and one of the
things that's that's awesome ofproc foo is that you're always
adding new stuff. And sometimesit's difficult to kind of keep
up with it all because there'sthere's new stuff every day
essentially, it's like followingfish like you got to be you got
to be like a proc head you haveto like stay literally right on
top of everything. So further towhat Jordan had said with web
forms inside you, you've builtan ability to create just like a

(14:36):
web form builder, right whereyou can drop in fields and do
things with the with the resultsAt the very end rather than
having it based on a podio item.

Andreas (14:46):
The generic form but you have to build your own HTML
for it.

Sure. But but but the fact that you have and
then you and I have talked abouttalked about this privately is
that like I mean for me procfoo. I've said this before also,
but prop foo. For me, it's kindof an awakening in that it lends
me enough motivation to learnhow to code on my own. And once
you move into your ownenvironment, you can you start
to get a few more powers. Andyou can see the the

(15:12):
manoeuvrability is sometimes ofbeing in an environment where
you have more control. But thegreat thing about proc foo, and
it opens up more and more everyday, is that between JavaScript
and the proc script, and headersand footers before process after
process, you are giving people alot of power, where they can
control elements in a controlledenvironment, they don't have to
worry about rolling out theirown environment, their own

(15:34):
server, their own bullshit,which is bullshit, it's a hard
life to live. So to have thisworld where you can play around
with, yes, I have to know my ownHTML, but anybody can learn that
if they're really trulymotivated, to how to build a
proper form, and say, okay,learn how to do it here in a
safe, controlled environment.
And then those tools will helpyou reach out further to to when

(15:58):
you're when you're in your ownenvironments, right. So

this idea of is safe, it sounds like we will get
very fucking fair. Now, whenyou're going to need to learn
HTML, but just the line of codethat caused you the most hassle?
Yeah. And actually, I mean,before we get into some
specifics here, I want to sortof, again, I always, a lot of
people listen, this podcast arenew to poke at podio. And

(16:25):
they're getting into podio. SoI, I want to break it down just
I want to examine those two usecases that you that you guys
gave the internal and theexternal portal kind of notion,
because for those people who arenot that familiar with the
concept of a pope, a portal, andand how it relates to podio
data, obviously, the greatthing, I think we all agree, the

(16:45):
great thing about podio is thatyou can very rapidly build these
data structures, apps, you canlink them together, you can
build simple workflows, complexworkflows, you can do, you can
build a system in such a smallamount of time compared to so
many other options out there,and that's wicked. But there are

(17:07):
times when you have all thisdata all this you know, you've
got your your finance data, oryour your projects, data and
your you know, all these littlebits of data in podio. But
you've got an externalconsultant, who simply needs to
see a benefit. And, and andprovide an update, see some
project files or see someproject information and provide

(17:29):
an A click something and providean update to bring them into
podio? If they only have to dothat once a month. It's not It's
madness, because you're gonnabecome a fucking podio support
where they log in at once amonth ago. Wait, where do I go
to this? What's this? What's theblue box? I don't understand.
Like, it's, it's hard for thoseof us who use podio every day, 5

(17:51):
billion times a day. You we canlike, zip around and just like,
you know, it, we don't eventhink about it. But for people
who aren't like any system forpeople who don't do it a lot. It
is it is it is very, there's alot of friction there. So the
idea the concept of a portal,sitting on top of podio. If
you're building, you know, ifyou've got someone like external

(18:14):
consultants, customers who wantto be able to see their invoices
or projects, see statuses orsubmit orders are what anything,
these things, you can leveragethe power of podio to do all
this workflow, and build righton top of it, sucking all that
information out and displayingit and letting people interact
with it in a way where they justlog in, they just

Andreas (18:38):
but it's not just for to make life easier for those
outside contacts, even for yourinternal team. And for yourself.
Like I have a lot of apps whereI'm only interested in a few
fields, I'm interested in onebutton. And I wanted to work one
handed on my mobile device. Andyou can't do that in podio.
Because you're not you have allthat functionality of podio in a

(19:00):
little mobile app. It's clunky,it's difficult. And all I want
is to be able to scroll up anddown, select something and go
okay or not okay. And then itdisappears.

That's the point. I was just I was just
tried to set the context of whatof what it means to have a
portal. But actually, that's agreat use case of we I think we
all know, we've all felt thatthe podio app on the mobile is
not a very if you've got a lotof data is not a very good user
experience. Finding shapedsearching shit, scrolling

(19:32):
through shit, opening up an appand editing it is not great. You
can build us many apps to buildweb friendly little versions of
what you need from an app thatyou can just have on your
homepage of your phone and go. Ido that for my inbox, my email
inbox. I've got a mini app thatsits on my my phone so that I

(19:52):
don't have to scroll and clickand I just open it up. I search
for the contact, write an email,boom done. It's respond. We have
there and

and and we also have a mini app form to create a
new email to somebody wherenormally would involve creating
an item and letting global maildo its thing. Like we can just
let every lead Proko gather allthe information at once, and
then act on it once once youclick a single button. The
mobile friendly nature of it isan important thing to note too,
like the the mobile app on inpodio does make things

(20:22):
challenging, if you don't, it'sit's it's really great if you
have strict filtered viewsalready set up. But sometimes
those views are dynamic, they'realways changing the things that
you care most about. And likeyou said, having less stuff on
the screen, if you do have anapp that's 100 fields deep,
being able to only have a fewthings. But you know, we just

(20:42):
finished building a massive appfor a survey company with that
has a field team and anybodylistening that has that's
working with companies that theywould have people out in the
field, definitely need to thinkabout using things like mini
apps to feed information topeople without them having to,
you know, seven clicks versustwo. And I've done a lot of

(21:02):
fighting over a single click.
But we're not talking about asingle click here, when you
compare what you can get out ofa mini app versus versus the app
itself, the native app.

Well, and and can we and maybe I'm dressed.
And I guess we can probably evenshow kick. Andrew, could you
show could you load up in thebackground? Because this is
obviously a YouTube? And Ishould have thought about this
before? And I have thought aboutit all day. Because I was like,
What can I show? Well, I'm noteven sure it's one thing to show

(21:33):
the output. Right? It's onething to show the output of
these things, which we can do.
And I can I can share my screenin a bit. But actually, could
you load up our proxy accountand open up the behind the
scenes of one of our SupportPortal?

Are you are you asking me to get more technical
that I understood, I hear thatI'm not

getting technical I but I just want to
make

Andreas (22:00):
sure those are now strictly prohibited at the
beginning?

I don't want to get too technical, but I think
but actually, I think this allsounds great in theory, but but
actually we show people it's notthat fucking hard. It's not that
complex is actually a goodthing. Because many apps I can
do, I can do it. And if I can doit, you can do it.

What an endorsement. Can I get that on a
button, I want a button thatsays that Jordan can do it,
anybody. So so so you know, andagain, keeping up with the
keeping up with the the thenewest and greatest like this
brockie. You know, obviously,once everybody saw that Jiffy,

(22:49):
where all you did was clickedlike two things. And a whole
massive mini app was builtbefore your eyes like you're
it's that you're getting betterat rolling these things out. For
people we've, we've gotten intoa good groove. But when when
you're starting out, it's reallyall about relationships need to
figure out how one is going toenter the system. And for us.
Now, what we do generally is youhave a global item that

(23:13):
represents a person or a companylike company's app or an
employee's app. And then webuild an authentication
structure normally would like anMD five hash or some kind of
password that stored at theitem, so that the user has a
link that they can click on. Andwe say this is your link, when
you click, we try to make it asdynamic and as unguessable as
possible. But we say this isyour link. And when you click on

(23:33):
it, it logs you in as you andthen we're able to reach out
into the system using anyrelationships that you're
related to show me all of yourleads, show me all of your
contacts, show me all of yourcondition, Ledger's your this,
your that and then just you knowuse filters to try to break them
up. So that's what's going onhere, you can see all the arrows
pointing back to our globalrecord, which is Client Profile.

(23:58):
And then everything else thatwe're showing here is either
based on how much time ourclient is working with us in the
scope of our support contracts.
And then support guides. So theblue represent tables, and then
the yellows are actually theindividual items. And each table
leads to an item which thenleads back to, to the to the to
the dashboard of sorts or youknow, back to the back to the

(24:23):
homepage. So yes, you can seehere that you can choose to show
or hide certain fields as yousee fit. And then this is really
where lots of stuff happens. Sofor instance, like we're
showing, we're hiding the, we'reshowing a detail page where you
should normally be able to editit and save it. But we're using
jQuery here or JavaScript tohide that button so that the

(24:47):
user is not able to do that. Soit just becomes straight up
display only. And then you know,within some of the table views
you can show like where the appis coming from. which fields are
showing? And a couple of timeswe've hacked in with the
behaviours to be able to controlwhat happens when the user
clicks on some items. And this

is really interesting. Can you open that
up, I just want to. So what'sreally cool here again, so what
we're doing is is essentiallyjust kind of linking together
screens. This screen, you'regoing to show a table. And then
when they click on an item, it'sjust like in podio, you got a
table view, right within thelist of all your items, you have
10 items, a table view shows 10items in a table, you click on

(25:33):
one, it takes you to the detail,just like podio, this is the
same thing. This is the samething. But here, what we're able
to sort of say, Okay, see, yousee it, we're getting it from
this app, we're seeing the youknow, these are the
relationships we're goingthrough, we're displaying it as
a table when we're showing thesetypes of fields, you can get

(25:55):
even more complex with some ofthese other little bits of bells
and whistles. But the truth is,this is as easy as it is to show
a table of data from podio thatpeople can view regardless of
whether they're in podio or not.
quite high up. Sorry, guys.
Quick commercial time, June2021, we are launching

(26:19):
supercharged masterclassesseries on our website www.we are
game changers calm. I'mincredibly excited by this quick
commercial, it is an opportunityfor you to learn a lot more
about podio and the ecosystemand opportunities around it. So
you learn about podio you learnabout how to create basic
automations, you learn moreadvanced things you learn about

(26:41):
communication integration,basically, it's a chance for you
to dive deeper into the gamechanges collective brain and
help you take your podiodevelopment to the next level.
And of course, as a superchargedlistener, and the game changes
masterclass user, you will haveaccess to some amazing help
resources via our company, ifyou need a little extra help

(27:01):
yourself at discounted rates.
Now, let's head back to thepodcast, check it out. And that
to me is like, again, I takeeverything back down to the
basics for the people who arejust getting started. You could
build in probably if you wantedto build a simple mini app that
showed a table of an app wherethey clicked and it took it into
the thing into the item to showthe details and they could edit

(27:24):
certain fields and submit them.
I'm guessing without any bellsand whistles, you could build
that in how long?

I mean, we rolled them out now in less than
a half a day like like

one or two screens table and item view. You
can roll that out in no time atall. I mean it with no bells and
whistles. Yeah, to take you 510minutes.

Now with this proxy, you probably could
literally roll it out inseconds, you know? So yes.

So I think that's a really and this is the
output of that, where we if yougo, you know, we've got the NIC
pulling in, you just know whatit is. But But if you go if we
go back to the main page, justas an example. So here's lots of

(28:17):
information. And then we've gotsome cool bits, we've got these
buttons at the top, which are abit more complex to do. But if
we go to the support button, sothe guides, whatever, it's
essentially that's the homepage,right? And so you can see how

we're using the UI and they're light up now look
at that look, see, like thingsare changing all the time. And I
just I can't even keep up. Soyeah, so we are actually that
and this is it. Like it's, it'sso complex, that you really have
to you know, there's so much todo with it. Right. But we have
found these ways. And obviouslyif so if it doesn't do something

(28:50):
and Andre is learns that it'llbe doing it like five minutes
later. So that's the otherbenefit,

Andreas (28:54):
I suppose. If I don't click on them, too. Oh, yes. On
these Yeah. What a doubleclicking do maybe maybe I need
to make it myself. No, youshouldn't have to if you double
click on it should take you tothe screen. Oh, I'm not sure I

(29:19):
think without moving the mouseso much, maybe. Are you on a
Mac? I am.

Unknown (29:26):
Yeah.

Andres foiled.

I feel his pain I go, I go through the same
thing. So. So the, the, theability to show like these
little, that's a perfect exampleof one of these sort of little
things that are hidden off inthe background where you're able
to control navigation. And thenalso the same like when somebody
submits a form normally would godirectly back to where you came

(29:54):
from, but you can controlnavigation, you control where
the user is, and you create allthese screens. We started Get
off by building all of theseapps as separate apps. Oh, we
need to tape we need a Ledger'sapp. And we need this app. And
we need to navigate peoplearound with links. But now it's
all a unified interface. You cantake anybody anywhere in the
app, as long as there'sinformation about who's logged

(30:17):
in, and you can conform to that.
So

if you go, can you go back to the, the actual
view of this, like the Yeah, soif you think about this, for
those of you will be able towatch this. This is an example.
So this, this miniapp issomething we roll out to all of
our customers who are on supportcontracts, with game changes,
and you're able to see thedifferent months what you've
spent, what you've what you'vedone, you're able to review,

(30:42):
every time we log time time, weare able to view what we've
logged what we've done ourupdate on it, all the guides we
provide prepare for you, whichare essentially just like guides
of here's what we've done, andhere's your you know, here's how
to do it. And here's how towatch the video. But if you
think about this, and take it toyour own business, this probably

(31:02):
you know, there's probably 50different ways something like
this externalising the data youhave in podio, That, to me is
the key, using the benefit ofpodio to drive all the workflow
all the stuff you want. And thenexternalising in a way that
makes all of our clients canjust see that they can scroll
through. And they there's noconfusion. And and and it's

(31:26):
really no work for anybody,which is a huge benefit.

I'm curious what now without showing the
without showing the actualinformation.
Which one of these is, this isit. So you can kind of see like

(31:55):
another structure. So samething, all of our apps are
really like an entry point wheresomebody is logging in, and then
we use that as a relationship.
And then we start showing otherinformation, right? So right, so
so the dashboard shows, this islike another style, right? So So
in our style, the one we showedbefore, we immediately take the
user to the item, which theylogged in through. But here

(32:16):
instead of that we don't wedon't want to take the the
person into the employee record.
So instead, we land them on thedashboard. And here they can go
wherever they want. I don't knowif Wi Fi there's a Mac. Yeah. So
So it's the same thing. And thenwhen you're viewing it, you can
actually move around, and thenalways go back to the dashboard.

(32:37):
It's always your like, your homescreen.

Nice. And, but and like this, again, this is
not, I mean, okay, it takes abit of you know, you're gonna
have to play around with it. Butthis is a very accessible thing.
You know, if you don't want allthese bells and whistles where
we've got some extra bells andwhistles, you can create these
pretty easily if by just gettinga proc Food Guide and playing

(33:01):
around. Right? Well, in somecases automatically. Yeah,
sorry, I miss.

Andreas (33:06):
Most of them are iterative, we you start off
building an app and it startswith one screen, then it becomes
two, then it becomes three, thenyou add a few behaviours, a
couple of buttons, add a coupleof dashboards with charts and
graphs. And, you know, theybuild out slowly over time.

Absolutely, Jordan Jordan is right, though
it is very accessible. And, andlike I said, it's a good
opportunity to be in that safe,controlled environment, and be
able to not not have to worryabout that side of things and
just play around and get errorsand figure out what the errors
mean and learn from them. Andyou and you know, like, there's,

(33:46):
you know, within proximo miniappalso has like a text box. where,
you know, the main goal is justto show text. But I've actually
found a lot of good uses for oneother use case that just popped
into my head that we shouldmention is somebody wanted a web
hook to grab some data thrustedinto podio, and then redirect

(34:09):
the user somewhere else. So sortof like a confirmation land have
have them land on a proxy webhook, study what the data of the
web hook says, get someinformation from somewhere, and
then redirect them somewherebased on another thing. So that
text box was actually handy forus to kind of just have a place
to land, catch URL parameters,which you can very easily pull

(34:33):
out in the behaviours tab, dothings with them, and then
redirect the user to another toanother place if they want to.
So you find these little useseven for screens that you don't
you know, like some screens havea lot of other little hidden
gems that you kind of have totest on your own. It's really

Andreas (34:55):
funny that you mentioned that I actually hacked
tech screens myself just acouple of weeks ago to
Incorporate Ajax calls into manyapps, so that you can have, you
know, any screen that's showingnormally, and click a button
that then loads another screenin the background, which is just
a text screen that has somebehaviours attached that do
things in the background andreport back to the main screen.

I mean, that's awesome. So you're using like a
remote curl and the proc scriptto do that. Yeah, exactly.
Right. So So you have these,these text screens set up. And,
and they can do other procscripts, you know, it's almost
like your own back end, and thisminiapp that can do things. And
then you know, buttons can cancall these, these, these pages
and, and be able to, to catchdata, right, where we're using

(35:41):
URL parameters, but it's thesame kind of principles.

So in essence, with with with this, you in the
same way that I would say globeyflow has, like, there's easy
entrance ways into globey flow,there's beginner, medium and
expert, right, like you, as abeginner with globey flow, you
can do some really cool easythings, hey, let's, when this
happens, create an item overhere and link it or you know, do

(36:07):
that and then as you grow inconfidence and scale and you
keep experimenting and and youknow you can you move up the
ranks and you suddenly start tobe able to do more, it sounds to
me like with proc foo, ingeneral, you've got that's like
the same progress just a levelup. It's like, it's like globey
flow or pw a has the starter tothe expert level. And then you

(36:31):
go up to you know, once you getthe expert, sort of like that
game, you know, back in the day,we used to play games, and you'd
start on like, the easy. Andonce you beat it easy, you'd
have to move up to the hardversion like that, you know, and
I think do like Wolfenstein 3dhad the like catty don't hurt me
level, which is like talkingnot? For those who, yeah,

(36:54):
probably don't remember thatgame. But what was the shit and
I played it the other day on amodulator. And it was awesome to
try to guess. But it sounds tome like props was that same
like, you could you can getstarted with a number of these
things relatively basically,once you reach a level of going
to proc foo, and then you caneven grow growth even further,

Andreas (37:15):
right, you can get most stuff done, just straight out of
the box. And if you're abeginner, I would suggest Do not
touch behaviours, like coldevents and behaviours that's
starting to get into theadvanced levels. But just from
the point and click interface,you can build your screens
connect your screens decide whathappens when you know, when what

(37:36):
is clicked and what is selected.
You can build some very, verypowerful portals.

Absolutely, absolutely. So now we've got a
bit of time left. So given thatwe've captivated everybody's
attention on proc foo and miniapps. But But given that we've
talked a bit about the basicshere, I mean, you were talking
earlier, before I chastise youinto getting not getting too

(38:06):
technical about this SQL, newSQL thing that I don't even know
what the fuck it is. So go on,we've got some time

Andreas (38:16):
ago is your friend.

So to explain like is I've always seen SQL is
a bit of a boon once you get tothat level. But you're the it
seems to me the covers that youhave earlier that it's not that
bad. So go on, talk about thething you're talking about.

Andreas (38:30):
SQL is a database. And it's designed to be queried, and
to return data to you reallyquickly. podio is built on a
database, but because it is sostructurally powerful, and
structurally nonconforming. It'snot just a regular database. And

(38:51):
that makes it quite slow,especially when you start doing
API calls from a distance.
Trying to get basic searches andbasic views out of podio is a
lot slower than a traditionaldatabase. Now, one of the new
beta features in proc foo is adatabase sync, where you can
connect any MySQL database toyour proxy account. And then
mirror any podio app to yourMySQL database. And it happens

(39:15):
it starts off in the background.
So it depends on how many itemsyou have in your app. It'll warm
up, do the sync, it instals theweb hooks into the app in podio.
So anytime you make a change toan item in podio, it'll come
through. It has backgrounddemons that keep checking for
changes. So if you've gotcalculation fields that don't

(39:37):
trigger any web hooks, we willstill catch those changes in
time. And if you use them inmany apps, any edits you make in
the front end and many app getautomatically pushed to the data
sync as well. So you're mysequel beta of that app is as
correct as is possible. And nowthat you can create Make them

(40:00):
Well, once you've connected yourMySQL database to your proxy
account, instead of thetraditional table screens where
you use a podio view or a searchpodio app, you can replace just
that screen. So imagine you hadyour podio view, when you click
on an item, you get your podioitem, take out the podio view,
replace it with the my sequelrepresentation of that podio

(40:23):
view. And when you click, youstill go to the actual podio
item. It's just that one screenthat now is a lot faster, is a
lot more powerful, because youcan put in searches into views,
which you can't do in podio, youcan't say select from this view
where something is somethingover, you know, email address
contains Gmail, you can't dothat it's impossible. So one of

the things that I found about one of the
negatives, if I'm going to gonegative, that I found about
many apps where you're dealingwith, and I'm guessing this
solves it, when you're dealingwith an app that has you know,
1000 items, and you're loadingup a table view with 1000. I
like it with an app that has1000 items, and that it's slow

(41:07):
as shit, because podio is slowshit when that like it's, it's a
podio limitation, I'm assuming,and the larger your app, your
app and all these factors,right? The big just so that if
you're loading up acommunications app, if
smartphones got connected, andyou've got a mini app connected
to the smartphone communicationapp, and you got 250,000 calls

(41:27):
logged, then you know you'regonna be sitting there going,
Oh, my God, and then your duckand die. What you're saying, as
I understand it, then is becauseproc fuking can connect to SQL
and essentially, just go you doit and it goes okay, this up,
don't worry, I'm gonna sendeverything up there
automatically. Then, on yourminiapp, when you're looking at

(41:50):
a table view, you're taking thattable view from SQL nicodemo.
Correct. Which should befucking,

which is milliseconds, you can you can
gather a million items from fromSQL in like a matter of
milliseconds. So So yeah, ifthere's no comparison and like,
like Andrea said, another,another huge benefit is the fact
that you are able to do queriesor using that that table
interface that Andre ismentioning, be able to do

(42:19):
queries on fields that are notnormally query Abul in podio. So
if you think about your filtersin podio, you can do a where a
relationship contains this orrelationship contains that you
know, dates between x and y. Butyou can say show me where a
single text field contains thewords, invoice. So in this case,

(42:39):
we can query text fields,because SQL can query anything.
So you can search through thedata in much in much different
ways. And it is fast it islightning fast. And that's the
way that it's meant and

as I understand it, and again, I'm gonna play
the the natural role of this islike an old style infomercial.
What else can I do?

Andreas (43:03):
That's not all right?

But no, I'm gonna play the the natural role
of the dummy in this. But myunderstanding is that with that
globey flow has an ability topush to a SQL table. But to do
that, my understanding and likethis could be wrong, you
essentially have to build atable in SQL, which is an exit

(43:28):
like, I've got a field herecalled name, I need to build a
table with a field called name,I've got to, you know, you're
essentially building it herebuilding here and telling global
pw a to to go Okay, when thisshit happens. Push this shit to
there. Right? That's right, kindof how it works in globey flow

(43:49):
or pw s? That's right. Yeah. Sowhat and that is, then means you
have to build all the tables.
And you've got to createautomations and if then one
thing changes like my fuckingour blah, blah, blah, you gotta
we do everything or adjusted,right? What is the difference
with this capability explainedto me the difference here.

Andreas (44:11):
So coming back to the globey flow one or pw one? Yes,
you have to pre build your tablein MySQL, then globey flow will
do a sync, an initial sync, andthen everything that happens
after that will be based on webhooks. So if you have
automations, that don't fire thewebhook event, those changes

(44:32):
will never make it to your SQLdatabase.

Or for if hooks tend to be, you know, not not
very friendly that day.

Andreas (44:42):
Also calculations which happened to be so so
calculations wouldn't make itthrough. Right. Now the
difference in the proxy datasync is you add a data sync with
the click of a button. Youbasically just select your app,
select your app, select your SQLdatabase that you've connected.
And that's it. proc foo willtake care of the rest.

Can I ask what is proc foo? As far as data
types go? Do you have data typesin SQL set based on the type of
field or is everything justbasically go into SQL as text.

Andreas (45:11):
Most things go in as text. If you have category
values they go through, if youhave category values where the
biggest value is less than 256characters in length, it'll go
through as a VAR char. dates anddate times will come through as
dates and date times. And thingslike contacts and and app

(45:33):
references. actually gets splitinto two fields, one with the
comma separated IDs, and onewith comma separated titles. Ah,
that's to make referencing andsearching much easier.

Yeah, cuz the because because that was one
sticking point. For mepersonally, where it was you
Everything is a relationship. Sowhen I'm in my own environment,
those IDs are super critical.
And just looking at relationshipitems by their title is good for
view purposes. But it's not sogreat for KPI and data
collection purposes. So havingthose IDs is is money in the
bank. And again, new informationto me today, the fact that you

(46:08):
can get these tables built foryou is is incredible, I'm
assuming Wayne. Yeah. Okay, Butwait,

Andreas (46:16):
there's more. So to create a data sync, yes, you
just select the app, select thedatabase and click a button.
There is also a proc script tocreate a data sync given an app
ID so that you can do thisdynamically. I have a I
basically have a little procscript piece of code that will

(46:37):
take a whole workspace and justcreate sinks for every single
app in the workspace. Andthere's another proc script that
will do a repair on one. Solet's say you made some
modifications to your app inpodio. There's new fields or
something, you just call thatscript, which you can also do in
the UI, you can click repair,and if there's a lot
individually, but you can call ascript that forces a full resync

(46:59):
it makes sure all your fieldsare there. If anything got
deleted accidentally in mysequel, it'll re add it for you.

That is one very important limitation to
note about the pw a version ofthe sequel sync. And Andre has
mentioned a couple of them. Oneis like if you're running, if
you're building your own flows,and some of them don't have hook
event checked, then that stuffwill never get picked up on
those web hooks. But also justin general, some people do
experience errors with the pw async, but there's no

(47:26):
Unfortunately, there's nosupport. I mean, it's something
that you build for your ownpurposes and kind of just bolted
on. It says in big bold lettersexperimental you know, people
lose their shit over it, but itis an experimental from a from a
pw a perspective, it is notprimetime ready, like you really
want to use it for yourself useit for testing purposes. But But
proc foo is a mature solution,that repair option alone is

(47:50):
really like what pw a reallyneeds, because there's no other
way to do it other than to stopand restart. And your data syncs
happened in the background.
Whereas pw a data syncs. Ifyou're starting off sinking into
an app that has like 10,000items, you've got to sit there
on that screen and watch it andwatch it and watch it and watch
it watch it for days, possiblydepending on how many items you
have in there.

Andreas (48:12):
So so there's nobody exceeds its rate limits, it
could die.

Right? So there's enormous, enormous
benefits to these processes andprocesses running in the
background versus you needing tokeep a browser window open for
them.

Can I ask you another dumb question then
Andreas because it sounds to melike two dumb questions. It
sounds to me then that you withthese this script or these
scripts, you have negated theneed to manually build the
tables and SQL. Which is fuckingsounds good to me like that is
like a boring shifting have todo. Particularly where there is

(48:50):
like we work sometimes in otherlanguages like Lithuanian and
and fuck it. Yes. Oh mygoodness. Yes. You know, and
having to build those fuckingtables where you're like, like
her. You heard her to Sorry,sorry. Sorry. Sorry. I can't
show Did that hurt you alreadyhere. But that's one thing. And

(49:12):
the second would be question of.
So to do that. How come How hardis this like, was

the script where you can have literally
launch a whole workspace worthof apps with one single proc
foo, call write tables syncstarts like literally everything
at this single click of abutton. I don't see how would
you get any easier than that.

Andreas (49:32):
But you know what it also does for you. It gives you
a full backup of your wholepodio account. Just in case.

So to get started to this, what would I
What would you like if I wantedto do this because I wanted to
do this. What would I need toget started How will I the my
first dummy version of thiswhere I just I have a workspace
with a bunch of shit. Ish Okay,do it in the screen, that's even

(50:01):
better. For those of you who arelistening, get on your screen.

I mean, that's it, right? So it looks like you
supply an app, you decide if youwant to include counts, I'm
assuming the name. The columnsare named for the external ID of
the field or using the field ID.
When you when you create thetable, the name of the column,
is it the external is that thetext based external ID? Are you
using the the field ID?

Andreas (50:29):
Is this not the guy? I thought this was the guy? No,
no. Okay. Too many things. Itshould be under. No, it should
be under proc food at thebottom. Ah, okay. There st
create. Okay.

Unknown (50:48):
Okay, yeah. So

wait, so, Sam, so

you would go into your configuration, and you
would add your SQL connectionhere, I've got a couple added
already. And that's a date.
That's a digitalocean. So again,if you're if you're not even
sure about that, I won'tdemonstrate it here. But if you
go to a YouTube, go to YouTubeand type it in, you go to
digitalocean comm, you sign upfor an account, you say create
database droplet, create managedatabase, it rolls out in

(51:16):
seconds, it gives you all of thehostname, the port, everything
that you do, and then you gointo the settings and you
whitelist these IPS, and thenyou can connect it. And it's as
simple as that just filling inall of those data. And then back
to this guy. That's what youwould supply here, right is what
you ever you called your secretconnection.

Andreas (51:36):
Or you can do it in the UI if you go from the menu and
go to database settings. On thetop right, the menu in proc foo.

I get this is the one I had played for before
like actually getting it workingwith with an app and it but if
this is all that so the user nolonger has to build their tables
at all or do any field mapping.
It's all automatic. Okay, well,that's awesome. Yeah. Yeah,
that's Yeah.

Andreas (52:08):
And taking that into our control, instead of making
this a user responsibility andgiving them control, just made
these things so much morestable, because we know what
every field type is.

Yeah, no, you're right. It. I mean, like,
everything can be boiled downto, you know, dates, and
everything else as texts likenumbers can be read. For those
that are like most people, we'regoing to be using this don't
care if a number is expressed astext or an integer or whatever.
Like it's even converted if youreally cared that much. But But
the question, I'm going to askyou, though, the column names,

(52:40):
are they external IDs? If I gointo SQL after this is done, the
columns are the external IDs?
Perfect?

Yeah. Yeah. Oh, so it really is that simple.

So yeah, it's a, it's a one click solution to
get any app into into a SQLdatabase. And again, if you're
listening to this, go todigitalocean. And it should ask
them for advertising money. Buthonestly, like, if you're
starting out from a, from aenvironment perspective, I tried
to use AWS, I spent a goodcouple of days on it. And I

(53:11):
couldn't get a fucking thingdone. I couldn't get a single
thing done. I had no idea what Iwas doing. It was complicated.
But digitalocean you just go inone, click CREATE DATABASE,
boom, you get the parametersthat you drop in here. And then
according to Andre is theworld's your oyster. So that's,
that's awesome. That's awesomethat you don't have to build the
tables anymore. You know. Now,if I don't want to be negative,

(53:34):
but just as a, let me ask youthis, and maybe, maybe there's
already This is me being thedummy now. So, um, and I said to
you before, okay, that's okay.
Right. Okay. So then you wouldbe working here, okay. So single
result, multi result query,okay, write your query, right.
So something something if you'veever like considered this,

(53:58):
where, if you were to, ratherthan writing your own sequel,
to, to have a be more like JSONbased, right, so like, pass a
JSON object where you had, youknow, like, I could pull up my
own coding version of about,like, say, this field by this,

(54:18):
by this external ID equals this,or this field is greater than
this, and this field is lessthan this. So this field does
not equal this, like, supply aJason request, and have that
converted into SQL. Because forme, personally, I do more of
that in my own environment. So Inever write my own SQL queries.

(54:40):
I understand what's going onhere. But again, like the
average person would have to goand learn SQL what you should
do, trust me, take it from me,you should go and learn it. But
But Jason is the language of theof the present and it is the
language of the future. Andsometimes it's easier to Just
say, here's a JSON object worthof external IDs and competitors,

(55:01):
like, Can we just use thisinstead? Have you ever
considered that as an option?

Andreas (55:08):
I have considered it.
But Jason is not meant fordatabases. So it does not have a
standard representation of thiskind of information. So you'd
have to create a new kind of alanguage, which, you know, you
have SQL, Why do that? Yeah,hard. And proxy will actually
write a lot of the SQL for you.
So if you convert, if you go toany podio view screen, there'll

(55:31):
be an icon, which will launchproxy that will convert it for
you. And it'll generate the SQLfor you right there.

Yeah. So like, I'm in anybody who uses any kind
of back end frameworks thatinvolves modelling databases,
right. So like, I'm usingcodeigniter, here, people are
familiar with possibly Laravel,or Symphony, any kind of PHP
framework or front end frameworkwhere they use data modelling,
where you can do controlledwhere statements, right, so I

(55:59):
can load a model, I'm

gonna put a banner saying fucking technical,
technical,

you know, like, where I can say, Where, where
field one equals this, and whereI can say, Where, where field
two is greater than zero, youknow, like, this is sort of the
structured query language, whereyou break it up by parameter,

(56:32):
and you don't necessarily haveto do it. So I often build API's
where I can take advantage ofthis, we're all throw a
structured query as a JSONobject, and let whatever
framework I'm using break it upwhere you know, and then you can
see like the the operators here,right, that I have advantage of
does not equal, does not equalis less than is greater than so.
So again, just just talking to alot of possibilities, right? go

(56:55):
learn SQL, go do it. But at thesame time, like I do look for
opportunities to try to keepthings in, in the Jason realm
because it's a lot easier for meto explain to people and my
Deb's, what Jason is, versustelling him to go off and learn
SQL, you know, so, again, nottrying to be negative, because
obviously, having stuff in SQLis awesome. And if you're

(57:16):
working with SQL, then youshould learn how to at least
create very simple SQLstatements, select from this
table where these items equalsthis done, and that might be the
majority, and then maybe youcould filter through the
results. If you got the resultssuper fast. You could use like
proc script, or you could usecustom foo functions to kind of

(57:39):
filter out the ones that youdidn't care about. But, but But
still, you know, looking forways to try to make it easier to
query databases is something I'mpassionate about,

Andreas (57:49):
how do I share my screen? Within zoom, share
screen,

this is the guy who built globey flow.

Andreas (58:01):
That's awesome. When I click share screen, I get an
option of like 1000 windows, youhave too many fucking screens.

She should have, you should have your share
screen should allow you to sharea monitor a full screen or just
Ah, okay,

Andreas (58:15):
what are we seeing?

I'm seeing configuring customer projects.

Andreas (58:22):
So one of the things that the new proxy does for you,
given this is a podio view. It'sa related items view, which is
very easy to do in podio. Andthis is basically like what you
showed earlier, Andrew, with theexception of if I double click
Oh, I've got to fix that. But ifyou click on the Convert to

(58:46):
MySQL icon here, we'll get thislittle guy pop up. And you give
them permission to do that. Youcan then choose to create a new
table in an existing connection,or I've already got a sink set
up for that one. And he'll justgo and create everything for
you. So the sequel is writtenfor you right here. Oh,

good. Okay.
Yeah. Well, that's and, andthat's good for learning
purposes as well, watching whatthe system is teaching you how
to do things, right. So that'scool. Yeah,

Andreas (59:18):
but this is complicated stuff. I mean, this is SQL that
I had to use Stack Overflow forthis is not like SQL 101. That's
why I don't like it. That's whyI don't that's why I try to
avoid it. Because it is yourframework will not be able to
create SQL as good as this oris. No, you're right, you're
right. Because basically, thisSQL here is now looking for it's

(59:38):
looking at comma separatedinteger IDs and finding matches
in them.

You're absolutely right. I would have
to gather data, and I'd have tobreak it up after the fact which
I often do, right. But again,when you're dealing with SQL,
the the performance benefit, youknow, the difference in
performance is negligible, butat the same time, you're
absolutely right. And that'swhere the that's where the The
magic is, is when you learn howto use SQL. There's all these
commands that let you grab datafrom different tables and join

(01:00:07):
data together. And you can doalmost a lot of just from a
single query. And that's thestuff that kind of still
confounds me. That's the stuffwhere I call my developer. And
I'm like, here you do this. Youcan

Andreas (01:00:16):
also a good way to play with SQL is once you have it
connected, there's my adminthat's attached to everyone. So
for all your data syncs, if youclick on graph, click on any of
these the podio apps, it willtake you to the app in podio. Or
if you click on the MySQL link,it will take you to the my admin
link on Minar. Oh, no, yes, yes.
adminer. Yes.

Andrew Cranston (01:00:40):
Also, also something else that I cannot
recommend enough. Wheneveranybody starts using SQL,
something, a secondary softwareapplication to interact with the
data in your SQL database, it'scalled PHP myadmin. It gets in
your face, people want to rollit out and like use this use
this, but this tool is free, youcan get it@adminer.org I think

(01:01:01):
it is. And, and it's free. Andit's mega fast. And it has an
enormous amount of options. Thisis this is incredible. This is
absolutely stunning. That youcan get that just from a click

Andreas (01:01:14):
of a button that is, and you can see that the older
the column names are the x, theexternal field IDs. With the
exception of some, some changeslike this one, it'll add the
underscore, start underscore.
And if you have a field, a datefield that has an end, for
example, because my sequeldoesn't have the standard, and

(01:01:34):
anything that has IDs will havethe name of the field. And then
with underscore IDs, which givesyou a comma separated list of
just the item IDs.

Nice. Do you store the app item ID itself in
here as well? Nope, don't careabout it. Okay. I have one
client who cares about it. It'sannoying, but it's not an image.
It's not a big problem. Now,that's cool. No, the fact that
you can get that view right fromthere that is that is you're
blowing my mind. That's amazing.

Jordan Fleming (01:02:06):
Well, I'm glad address please,

Andreas (01:02:09):
I have a script, I should actually share that on
the proxy space that will justcreate a sink for every single
app in a given space.

Yes, yes. You should share that that would be
good. Even. Even I fucking knowthat. I mean, um, so I just
just, you know, I, I promisedeveryone it wouldn't get geeky.
And we went off on a 15 minutegeek Fest, but I did invite
these fucking do so

Andreas (01:02:34):
promises your con.

Like I shouldn't. Yeah, I should know
better than that. I knew thatthis is the default. But there's
some really what I think is goodabout this in anyways, if you're
still listening to this, you'reyou're probably a geek or you
want to be a geek. But no, Ithink there's some really
accessible things here. There'saccessible bits of proc food,
the mini apps have someaccessible bits, but also have
as you've seen several absolutepowerhouse bits. And if we think

(01:03:00):
about the pricing of proc fooright now, like I don't know,
but my dress may hook us all inand then fuck us by jacking up
the price by 400 times. But Iwould also say that I think proc
foo is a for the power it givesyou it is a no brainer. Like I I
feel the same way global mail,which is another of Andres

(01:03:22):
project products. For the forthe power you get, you are
kidding, like you it's a nobrainer, go sign up, go to
Prague food calm, and sign up,because and get your plan that I
think the miniapp plan is likestarts on the second or third of
the tiers. Or, like the secondone, it's like 25 bucks a month

(01:03:44):
ish. And for 25 bucks a month,you get an enormous power, and
then it just scales up your thepower you even have, but I mean,
it's very accessible tool. Andit is a very accessible tool.
And the same I would say forglobal mail. You just like, just

(01:04:06):
like, if you use podio globeyflow became a, you have to have
it like that, that that that'sall there is to it. I feel like
proxies if you do any sort ofreal development in podio I feel
like proc foo is starting to gothe same way of like, Oh, you've

(01:04:27):
got to fucking use Roku. Like Imean that like that's all there
is to it. So you know, go overthere. And and I would encourage
everyone I will put in thepodcast, app page as well as the
links and the YouTube video, Iwill put the links to all of the
products that Andreas has.
Obviously proc foods, the one wespoke about tonight, but I would

(01:04:49):
encourage you to look at globalmail. For those of you you know
who do do a lot of email. Youcan see our solution that using
global We mail I still thinkwe've probably got the best one
out there. And it just gotbetter actually, Andrew just
made an improvement.

Another another cool use case for proc food are
my son's coming in at the worstpossible angle here today I'm
keep backing out to get awayfrom the sun. Another use case
that just popped up. So globeyMail does have an archive app.
So those of you who are use it,all of the emails get dumped
into an archive app. But it'schallenging, because that
archive is in one workspace. Andyou can't necessarily give a
bunch of users access toeveryone's emails. So we came up

(01:05:30):
with a solution where we wouldroll out a copy of this app to
everyone's now like Jordan said,the way we do email is that
everybody has their ownworkspace and everyone has their
own email log app and all theemails go there. So now in the
system that we just recentlybuilt, everybody has their own
archive app, as well, with theaddition of a relationship to
the email log in which itbelongs. And I recently learned,

(01:05:52):
again, recently that there inthis archive app is a JSON
payload containing everythingone could want to know what app
ID belong to what the item waseverything. So it's very easy to
use proc food to just grab thatinformation and create an item
in an app with the relationshipalready tuned to that item. And
then just fill everything inthat comes with it. And it's

(01:06:14):
working great. It's it really isit's it's awesome to be able to
be in your own log, and clickthrough and be able to see the
full, you know, as much as podiowill allow us write comments and
multi text fields being whatthey are, this is the best
solution possible to give theuser as close to the original
version of the email aspossible. And they really needed
that and it was good. Anothergood like I said, you know being

(01:06:37):
able to move around proc foo,create items from anywhere,
based on the fact that everyoneyou know, your your admin user,
or your master user has accessto all these workspaces. Yeah,
that ended up being reallyawesome solution. I'm glad we
could give that to them.

could do a, we'll do a new video of the
Yeah, we'll upgrade our, oursir, our emails internally as
well. We never, we very rarelyget to do our own system. But
we'll do that. And once we do,I'll do. I've done I did the
basics of email, then I did asupercharged email. And now I'm
gonna have to do like fuckinghyperdrive. But that's, uh, you

(01:07:17):
know, I do definitely encourageyou. In fact, you know, I'll
post the links in this podcastto those two email videos as
well. Because they the secondone uses proxy, many apps, it
shows you. But it just ingeneral, I think it shows what
you know, if you don't integrateemail and you wish you could. I

(01:07:38):
think it's the best solutionthat anyone's come up with
today. As far as I've seen, Ihaven't seen anyone who beats
our system. And Andres may sayhis inbox does, but I don't even
know how the fucking thingworks. So it doesn't count. But
anyway, listen, Andreas, Andrew,I want to thank you guys for not
geeking out too much. But I alsowant to thank you for giving

(01:08:01):
your insights into the mini andparticularly mini apps, because
I think many apps are a veryaccessible, understandable way
of why you'd want to start withprop foo. And those business
cases that we outlined, I thinkare relevant to any business, I
can't think of one that wouldn'thave a use case where you'd need

(01:08:22):
this either internally orexternally. And then, you know,
all the other things we'vetalked about that exciting
sequencing, which I does soundlike fucking crazy, crazy thing.
You know, there's a lot in here.
So if you you know, as always,this is taking your podio up
another level. But there aresome really accessible starts
here. And almost anyone I thinkcould probably start going. So I

(01:08:45):
encourage you all to click onthe links, check out the
products. And if you if you arestruggling, you've got a link to
the proc foo workspace, whereAndreas helps people but so does
everybody else. Um, I see Andrewhelping people I see just like
with the globey flow forum.

(01:09:05):
There's an enormous usercommunity of help there and I
encourage everyone to use it.
Any final thoughts boys beforewe before we finish

Andreas (01:09:17):
don't all speak at once it is Christ you guys. Thanks
for having me. It was fun.

Next time, actually, next time we do this
because I'll do it from homemaybe. And I will have a whiskey
or something cuz it's 2pm foryou, you can drink. Anyway,
thank you very much, guys. Don'tforget if you listen to this,
please do like, share and do allthe shit you should be doing
anyway. And if you haven't donealready, then then stop

(01:09:44):
listening and do it right now.
Jimmy Oh.

Narrator (01:09:48):
You've been listening to a supercharged with Jordan
Samuel Fleming. Subscribe todayon iTunes, Google Play or
Spotify for your weekly diveinto how you can supercharge
your business by making itpowerful. Word by podio Be sure
to check out our website we aregame changers.com where you can
learn more and arrange a 30minute call with Jordan daleview

(01:10:10):
understand how podiosupercharges you

All Episodes

Season 4, Episode 9 - A couple advanced tricks with ProcFu

Episode Transcript

Popular Podcasts

Crime Junkie

24/7 News: The Latest

Stuff You Should Know

.css-15opob5{left:0;position:absolute;top:0.8rem;} All Episodes

.css-14f5ked{margin:0;word-break:break-word;display:-webkit-box;-webkit-box-orient:vertical;box-orient:vertical;-webkit-line-clamp:2;overflow:hidden;}Season 4, Episode 9 - A couple advanced tricks with ProcFu