Hi! I have an application with a Household Survey that has a form counter variable called form_count with the following syntax: coalesce(#user/form_count, 0) + 1.
I have noticed that the counter works such that the form count increases by one each time the same user fills out the form. If someone with another username fills out the form, the counter starts at 1 again. Is there a way to get the counter to increase incrementally by one regardless of which user is filling out the form? For example, if a user, RIK001, for example, fills out the form, the counter would be 1. When RIK002 fills out the form, the counter would be at 2.
Any input regarding this would be much appreciated!