Knowledge Base

Using docparser and Workato to Create Records in Quick Base | INTERMEDIATE

Background

Quick Base is a great service for housing large amounts of data. Forms, imports, and automations are tools that make entering information into Quick Base efficient. They are good solutions for most use cases (If you would like to learn more about these tools, check out the links at the bottom of this article). However, each tool has some limitations: Forms are limited because you can only create one record at a time; Automations are limited by your access to other systems; Imports are limited to flat files.

What if you receive data from a client that needs to be entered into Quick Base, but they can only send you a pdf and are not willing to let you access their system? Without access to their system, Automations are out. Imports are out because a flat file is not provided. One solution is to insert the pdf information using a Form in Quick Base, but it becomes tedious very quickly if there are numerous records and it always has the risk of data entry error. Fortunately, there are other softwares that can be used to solve the problem of creating records from pdfs.

Docparser, a data capture software, and Workato, an integration software, are services that can be leveraged to efficiently create records in Quick Base from a pdf. In the situation outlined above, docparser can be used to read the pdf and extract the necessary information (parsing rules) for data entry in Quick Base. Then Workato can take the information from docparser and automatically create the records in Quick Base. Therefore, by leveraging docparser and Workato, hours of data entry and numerous potential data entry errors can be eliminated.

Workato Recipe – PDF to Quick Base Records

Outlined below is a workato recipe that will take the information extracted from the pdf via docparser and create the corresponding Quick Base records. If you need a refresher on Workato recipes, check out Creating Your First Workato Recipe.

  1. Set up a Document Parser and create the Parsing Rules in docparser;

  2. Create a trigger in Workato to “Fetch parsed data in docparser

  1. Create a list to capture the data from the Document Parser;

  1. Add items to the list that correspond to the fields in your Quick Base table;

  1. Create a loop and pass the information from the Document Parser into the list created in step 3 above;

  1. Compose a CSV from the list created earlier in your Workato recipe;

  1. Create and update records in Quick Base from the CSV file created in step 6;

If you want to learn other ways to enter information into Quick Base, check out the articles: Importing Data into Quick Base, Table-to-Table Import, Implementing Custom Imports, and API ImportFromCSV.


Copyright ©2020 - Quandary Consulting Group