Equation Behavior in Knack Forms

Hey there! I’m Dave Parrish, and today I want to dive into a topic that’s been a little hazy to me: equation behavior in forms. Recently, I faced a situation where my app's equations weren’t behaving as expected. It was frustrating, but it led me to some valuable insights that I’d love to share with you.

You Want Your Numbers to Add Up

The issue arose when I was trying to set up a dynamic calculation based on price and quantity inputs. Ideally, I wanted the app to automatically update the total whenever those values changed. However, something wasn’t quite right. I reached out for help, and thankfully, Gary at Knack provided some clarity.

Key Takeaways About Equations

One of the first lessons I learned is that all values involved in the equation need to be present on the form itself. The example I use in the video is pretty simple, A + B = equation. So sure, I have all the equation components. But, things can be a lot more complex, and in terms of all your values, some my not need to be on the page to get what you want done. But, if you want the equation to change in real time as you add values, you must have all the components appearing on the page.

The Importance of Real-Time Updates

In one of my use cases, I had to calculate commission percentages for multiple real estate agents. The total had to equal 100%, which served as a useful validation check. This experience reinforced the idea that every element of the equation must be visible to facilitate real-time updates.

Limitations of Functions

I discovered that certain functions, like count or sum, cannot be incorporated into these equations. For example, if you’re counting child records, those values won’t show up on the form, and therefore the equation won’t work as intended.

Numbers, Not Dates

Another interesting point is that these equations only work with numerical values. Although you can create equations involving dates, they won’t calculate properly. This is something to keep in mind when setting up your forms.

New Record vs. Edit Forms

I also explored the differences between new record forms and edit forms. In a new record form, everything worked smoothly, but I encountered some quirks when testing an edit form. It seems that "displaying calculated fields without an input" (user can view but can't update a value" can lead to confusion.

Checking Display Settings

One thing I learned is that if you want a field to be non-editable while still showing the value, you need to check certain display settings. However, even when checked, the equations may not update as expected unless the display option is unchecked.

Formulas Within Formulas

I tested whether you could use other formulas within a formula. The consensus is no—you can’t nest functions like sum or count. However, you can reference other values as long as they are present on the form.

Inline Editing Limitations

One final point worth noting is that inline editing doesn’t work with equations. This was a revelation for me; it’s crucial to understand where and how these calculations can occur.

Conclusion

Navigating equations in forms can be tricky, but with some exploration and testing, I’ve gained a clearer understanding of how to make them work effectively. If you’re setting up similar dynamic calculations, keep these insights in mind! They might just save you some headaches.

Thanks, and if you have any questions or want to share your experiences with equations in forms, feel free to drop a comment!

Interested in my Knack database services? ... Book a call with me here: https://calendly.com/daveparrish/callwithdave