Drew Bradford's Portfolio

work

Some noteworthy projects I have built.

Service Task Calculator

A robust UI tool built with JavaScript and QuickBase to define and scope Professional Digital Storage Services.

Importing spreadsheet data into QuickBase generates the content and behavior of the front end UI. Document variables in the spreadsheet integrate with the Document Generator tool mentioned below. No coding is required to complete this step.

Users of the front end UI scope services by assigning task quantities. Users can also add co-provider information, additional roles and expenses.

This is the front end user interface generated by the spreadsheet data. Notice that the task quantity calculates the level of effort (LOE) for roles assigned to the task.

Document Generator

Word Document generation tool for legal agreements spanning the globe. Many factors determine which type of document is generated, which sections are used, the verbiage, as well as the formatting of the document.

Document section content is stored and editable in QuickBase. Modifications are done in a convenient graphical editor that writes HTML behind the scenes allowing non technical users to modify the dynamic document content.

A custom legal document is generated based on many factors including service type, deal type, geo, sales district, billing type, risk category and more. The document is attached to the bid in QuickBase and is ready to be signed by both parties.

Bid Generator

A bid generation tool that does a multi stage cost factor analysis to determine the cost of multiple services and combine them into a bid. The steps below illustrate this process.

Users are prompted to fill out a simple QuickBase form. The Save button launches the JavaScript program that executes step 2 and 3.

Form selections drive the cost factor analysis to calculate the scope of each service. There are different sets of cost factor lookups depending on the service type.

A complete bid is created and ready for approval workflows. Users are unburdened of the multi stage cost factor analysis that goes into each service, all with a simple button click.

Risk Category Matrix

A risk category matrix to assign, measure and flag risky bids for evaluation to prevent financial losses.

Here is a simplified representation of the matrix that assigns a risk category to a bid. It is always active, requiring no user action to run. Built with native QuickBase tools.

open source

quickbase-js

A Typescript API client for the Quickbase JSON RESTful API.

Support for various authentication types (user token, temporary tokens, SSO token), concurrent rate limiting strategies, auto pagination, js date conversion, 429 (rate limit) and 401 (auth) error handling retries. It uses a Proxy to dynamically invoke API methods derived from the OpenAPI specification.

Browser and Node.js; code pages have first class support. Find installation instructions and examples on GitHub for quickbase-js.

An open source library to write JavaScript with QuickBase. See the API method documentation website for quickbase-js.

quickbase-codepages

Improved developer experience using QuickBase code pages.

Deploy your Node.js build files into QuickBase code pages from the command line. It handles multiple apps, keeping your project synced across environments.

The root HTML file needed in each app environment is auto generated linking code pages together during the build step.

An open source npm library you can install as a dev dependancy in your projects. Documentation is found on GitHub for quickbase-codepages.

I'm a JavaScript and QuickBase developer.