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:
- If the last entry for a school is inserted, I want the status of the school to change to “Inactive.”
- 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!