Adding points to a total only one time

Hi guys,

I’m trying to create an inspection form where you can select violations, and they would increment a point value and also increment a boolean of critical or not.

The issue is that I would like to be able to mark the same violation multiple times (for different areas) but only add points the first time. Despite this, if the same violation occurs three times, it would become a critical.

I’m not sure how to do this on Adalo if anyone might offer some advice about how I would work this out it would be greatly appreciated.

Thank you!

You could have a violation collection with relationship to users. Then have conditional logic on the button that adds the violation.

Update violation is critical, sometimes, if user violation count > 2.

And different conditional logic on same button for different scenarios.