Prevent NULL in repeat group

[karlis]

Hello! I have some a repeat group in a form I'm having problems with.
The form is for Persons and the repeat group is Person_responsibility. Person_responsibility is a list that contains Person_id, Responsibility_id.
My problem is such -- not everyone in the db has a responsibility in the secretariat, and when editing a person's record, who has no responsibility in the secretariat, a NULL record is stored in Person_responsibility.
Is there a way to prevent this?
The group for secretariat responsibility is hidden by a yes/no field. Bet regardless, every person who gets edited gets a NULL record (unless they already have a responsibility, as in the screenshot).

 

[cheesegrits]

Do you have the "Min Repeat" set to 0 for that group?

-- hugh

 

[karlis]

No. I guess I should set it to 0.

 

[cheesegrits]

Yup. If you don't, and the repeat group renders an instance in the new form, when the form submits, we have no way of knowing if it's "null" or not. It's just a repeat group with one repeat, that has its default values.

The only way to avoid that is to set min repeats to 0, so there's no instance of the repeat rendered when the form loads, and if the user wants to add one, they add one.

-- hugh

 

[karlis]

Thanks. It worked (of course).

 

[troester]

You can close solved threads by unchecking "open" in Thread Tools.

 

[karlis]

Ok