Demo of Form/Formula Usage

Author: Craig McElroy
Try This App

This application demonstrates how formulas and forms can be used in conjunction to elevate the complexity of your data collection. Use formulas and form rules to control what data is being entered under what conditions. Use formulas to lock data or trigger reports to populate. Use formulas to group records by fiscal periods. Get the data you want, the way you want it.

This is an extensive app that aptly demonstrates how to use formulas and forms when entering data to get exactly the information you need. it includes the Empower 2015 powerpoint on Formulas and Form Rule Use Cases as an attachment which gives the specific formulas needed for each condition. This is an excellent training tool.

The demo app is a sophisticated evaluation solution that can be adapted for other company uses.


Write a review doublechevronCreated with Sketch.

forms and tricks

By over 3 years ago

good stuff - helps to set little tricks - thank you

Overall Rating

614 Installs



Craig McElroy

Craig has served in the database department at J. Lodge for over 6 years. During this time, he has built over 100 applications in Quickbase, managing tens of applications concurrently. In addition to application development, Craig has also provided administrative services to over 1000 users among a variety of clients for J. Lodge. J. Lodge delivers premier contact center services to a variety of industries. The company proudly employs persons with disabilities in over 30 states. This unique employee model allows J. Lodge to access incredible talent throughout the United States, offering clients the highest level of service.