**The problem? **
I'm trying to get away from repeat group in one my forms, but keep the 'integrity' of data as if it were within a single dataset.
I have two relevant fields, call them 'Code' and 'Number'
Each Code has an (unknown) set of 'children' ('Number') in a pattern like
[Code][Number]
A1, A2, A3, A4
B1, B2
C1, C2, C3 etc
In a previous iteration of my form the 'Number' was a repeat-group. Up until now I've just asked enumerators to fill these fields manually, but I'm trying to simplify (but making life more complicated for myself).
So I have used default values (in XLS Form) using ${last-saved# but my IF() statement isn't working - I wonder if anyone can (gently) point out my stupidity:
Code: ${last-saved#Code}
Number: if(${Code}=${last-saved#Code},${last-saved#Number}+1,'1')
I have tried replacing '1' (the else part of the statement) with int('1') and just plain old 1 but I still get a blank in 'Number' if the 'Code' changes. But it then works as expected as the 'Number' increments...
Please note that I've changed the names of records to protect the innocent - they are not really called A B and C!
Hopefully this is a simple one for the sharp of mind, and I'm sorry for posting it if it's really obvious.