Combine your data
& customize.
All the SQL-type power IT teams loved, now across apps. No developer required.
Compare similarities and differences.
As long as the data fields you are comparing are similar like an email to an email, Popdock will compare them between two lists and return either the data that is similar or the data that is different.
Join your Data
Some connectors have multiple lists that separate data that are related. In these cases a data join may be beneficial to give you the data you want to see. If both lists contain a unique ID, then they can be joined by that identifier to make a join. This helps to get the data from two or more lists into one.
Merge Data
While joining requires a unique ID, Popdock data merging requires similar data. You can merge a contact list from one connector with another or if your connector contains more than one company, you can merge the data of all the companies into a single list.
Summarize your data
Sometimes all the rows of data are not important, you want to know the big number or overall total. Popdock can help by summarizing your list to show you the average, count, distinct count, maximum, minimum, or sum of your data.
Use your terminology
Rename every list and field for the terms that make sense for your business.
Calculations & Data Transformation
Lacking the data you want to see?
Popdock allows a custom field that can be used to add a formula that will take the data from one of your default fields and either do a calculation with another field or combine the text of fields and show that data to you as a separate column in your list, if that is what you need.
Work with functions or add your scripting to transform the data into the right format.
Add Restrictions and Variables
Create lists with fixed restrictions and variables, so end users only have access to the data you want them to have.
Multi-company reporting
A lot of organizations need to report across all the companies they have set up in their accounting systems. Where relevant, Popdock makes this a simple experience for end users across our ERP connectors.
Present your combined data,
where your teams work.
Popdock Excel Add-in
