Change a field value based on logic from a new record

I am creating a consistent parenting app. Each user (parent) has 1 or more children. I created a Child collection and one field is called Current Level. When a child misbehaves the parent will enter a behavior event (into the Event collection) that is assigned a certain level. If that level is lower than the Current Level (in Child collection), then the Current Level should change to the new event level.

How do I configure this in Adalo?

Hi @markhawley ,

You can save the current level in that related users record, and then when asking for new behavior, you can compare them with something like current user>current level.

This will depend on how you set up your screens.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.