Question: Setting Conditional Status Field Based on Multiple Entries for a School

Hello
I’m working on a survey where I have multiple entries for a single school. I would like to add a “Status” field that automatically updates based on the following conditions:

  1. If the last entry for a school is inserted, I want the status of the school to change to “Inactive.”
  2. For all other entries, the status should remain “Deactive.”

Could someone guide me on how to set up this conditional logic in KoboToolbox? Any tips or examples would be greatly appreciated!

Welcome to the community, @sandeelo! Could you kindly share with the community a sample dummy question (max 1 to 2) so that the community can understand your requirement pictorially?