Pushing Podio
Search
🔍

Fast & Efficient Podio App Searching

We all have some massive apps in our Podio setups that we need to use on a regular basis. Something like this:

Trying to find the specific item you're looking for can be a real pain. Podio's built-in search does not allow you to search a specific field and if you have to find items in such an app on a regular basis, you might find yourself dipping into your emotional support vodka before noon.

There is a better Way

What we really want, is a simple table where we can search on any field:

This is easily done using a ProcFu mini app with a Data Sync into your MySQL database.

If you don't already have MySQL connected to your ProcFu account - please read this first.

Step 1 - Podio App

The first thing we're going to do is just create a regular Podio-based mini app on this table.

For your start screen, select Podio as authentication, and click on the "+" to create the second screen:

For the main list screen, select the Podio app, and select all fields you want to show:

Step 2 - Convert to SQL

Now, click on the blue database icon next to the app name:

Our friendly helper, Prockie, will pop-up in the bottom right corner and offer to convert this to a SQL sync'ed screen for you:

Click on OK Sure and you'll be presented with a list of MySQL connections to create the sync in, or if you've already created a sync for this app, you'll be given that sync as an option.

After selecting the sync or the connection for a new one, Prockie will convert the screen to a SQL screen:

⚠️
Please note: new syncs can take a while to populate - especially with large apps. You can check their progress on the Data Syncs page.

Now, if you save and launch this app, the experience is much faster, but searching is still limited to all fields, instead of individually by field:

Step 3 - Make Searchable

Back in the mini app editor, click on the blue table icon next to the table name of the screen:

This time, Prockie will offer to build filter for your table:

Click on OK Sure and the where and order by clauses will be replaced by tokens, and behaviours will added to the Before Process and On Render events:

(If you want to see the reference for the PfJs class, please refer to the docs).

Step 4 - Finishing Touches

To make the whole app full-width, add this to the footer of the screen:

<style>
/* make the whole screen wider */
.pfmcappwrapper { max-width: 96vw !important; }
</style>

It would look like this:

And lastly, to open the item in Podio when a row is clicked, add this to the end of the On Render code:

/* when a row is clicked, open the item in Podio in a new tab */
$("table.pftable tbody tr", target).off("click").on("click", function(){
	var id = $(this).attr("data-i");
	window.open("https://podio.com/x/y/item/"+id);
});

The full On Render code would look like this:

Result

If you now save and launch the app, you'll have a nice table view of your Podio app data:

And the best part is that you can not only search by individual fields, but super-fast, and still click through to the item in Podio.

💡
Note that you can also search for ranges using =>, eg 50=>100

Now just bookmark this app, and leave the emotional support vodka for after work 😆

(c) 2021 Globi Web Solutions | Join the Discussion in our Podio Workspace.