I am experiencing something weird on Collect and I could not find a solution in existing messages. Using a series of calculate and concatenate functions, works perfectly on Enketo and on Kobo platform, but it does not work in Collect.
In one of my forms, I need to make Kobo create an id number based on the input of a date question previously provided by enumerator. The id number should be composed, among others, by a time range of 4 cifres, indicating the starting and the ending month (number) of a given activity. E.i. If the date was 1 January, I want kobo to calculate the month range equal to ‘0102’ , indicating January (01) as starting month and February (02) as ending month.
I used a series of calculations to assess the conditions and I used concatenate function to pull together the calculation results and obtain the id number.
When using Collect app, while calculating the starting month goes well, the calculate function does not to work and the in the id number, it appear simply an empty space.
All formulas work well in Enketo and on KoboToolbox platform, but it does not work in C0llect.
I attach the XLSForm, for your reference.
Any idea of what is wrong with Kobo Collect?
Thanks a million times for your suggestions and workaround (if any)!
Form_03_v3.xlsx (13.2 KB)