Demonstrating DB Drawing on Two Excel Spreadsheets
Properly structured, an Excel spreadsheet can approach the functionality of a database when using DB
In today's data-driven world, businesses and individuals alike are inundated with information. However, few have the tools to effectively harness that data. Doxserå® DB empowers users to take control of their data, transforming it into valuable insights with ease.
In this demonstration, we’re not going to overwhelm you with every feature inherited from the Form Tool and Doxserå®. Instead, we’ll focus on Doxserå® DB’s remarkable ability to integrate and leverage multiple external data sources effortlessly. This will be an illustration of Doxserå®
DB being used at its most basic level, designed to show you what it can do and how simple it is to operate.
Today, we’ll use two data sources. The first is a library’s Excel workbook with worksheets listing authors, books, and borrowers, including their addresses. The second is a single worksheet listing the branches of the library.
We start by demonstrating a simple form that pulls specific information from the data sources. Let’s say we want information on a particular author—Herman Melville—and one of his books, Moby Dick. With just a click, Doxserå® DB pulls detailed, readable data from multiple worksheets, compiling it into a clear, customized format.
But the power of Doxserå® DB doesn't stop there. We also show how you can create documents for multiple borrowers at once, generating personalized letters for each. In this example, we create four letters—each customized to a borrower and referencing the specific book they checked out, the author of that book, and their local library branch.
Finally, with Doxserå® DB’s direct access feature, you can customize data retrieval and formatting. Whether you want to filter books by century, gender of the author, or even a specific author like Mark Twain, Doxserå® DB instantly compiles the information you need into any format you desire.
This demonstration highlights the true power of Doxserá DB: transforming your existing data into useful, customized documents with a few clicks—saving time, reducing complexity, and increasing efficiency.
5:17