top of page
Search
Writer's pictureDave Parrish

Fun with Conditional Rules #3 (fix a corrupt field) with a Knack Database App

Updated: Jun 23



How I Fixed a Corrupt Field Using Conditional Rules

Hey everyone, Dave Parish here from Knack Builders, back with another video for you today. If you enjoy these tutorials, don't forget to like and subscribe to our YouTube channel! Today, I want to delve into one of my favorite topics: conditional rules.


Dealing with the Headache of Corrupt Fields

Imagine this: you've built a sophisticated system, let's say for managing a swimming school. It handles everything from class schedules to student registrations and instructor assignments. However, occasionally, things break. One day, a crucial equation in your database—let's call it SK final—just stops working. This equation calculates cumulative ratings for classes, determining whether students pass to the next level.


The Problem with SK final

SK final was essential, used across various parts of the application—from admin tools to instructor interfaces. Suddenly, it started outputting zeros instead of correct scores. Manually fixing it everywhere would be a nightmare. This doesn't happen very often in Knack, but it does sometimes.


My Solution: Conditional Rules to the Rescue

I didn't want to rewrite SK final everywhere it was used. Instead, I opted for a smarter approach using conditional rules.


Step-by-Step Fix

  1. Identifying the Issue: First, I duplicated the problematic SK final field to isolate the corruption.

  2. Creating a Functional Equivalent: Next, I created a new field with a working version of the equation, which we'll call 'fix'.

  3. Implementing the Conditional Rule: Here's the magic—instead of manually updating every instance of SK final, I set up a conditional rule. This rule instructed the application to use the 'fix' field's value wherever SK final was supposed to appear.

  4. Execution and Testing: After setting up the conditional rule, I tested it extensively to ensure SK final now displayed the correct scores derived from 'fix'.


Benefits of the Conditional Rule Approach

  • Efficiency: By leveraging a conditional rule, I avoided the tedious task of manually updating numerous instances of SK final.

  • Maintainability: It's now easier to manage because any changes to the equation can be made in one place ('fix'), propagating automatically to SK final.

  • Risk Reduction: The conditional rule minimized the risk of human error that often accompanies manual updates.


Conclusion

In conclusion, dealing with corrupt fields doesn't have to be a nightmare. By strategically using conditional rules, you can efficiently resolve issues without resorting to extensive rewrites or risking application stability.


That's all for today, folks! I hope you found this tutorial helpful. If you have any questions or want more tutorials like this, let me know in the comments. Don't forget to like and subscribe for more content like this. Thanks for watching!


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



14 views0 comments

Comentarios


bottom of page