Issues with Unique ID code

I need an urgent support for the wonderful community.
I created Unique ID code (10 characters) generated using “Concat” function using the calculate type question and the result is to be displayed using the note type question. The generated code is not displaying the complete 10 character code but only the first 4 characters in the collect application but on the Enketo web form it displays the complete 10 characters.
See the function:

concat(“SC”,substr(now(),8,10),substr(now(),11,13),substr(now(),14,16),substr(now(),17,19))
Please could you please suggest possible solutions?

can you share excel file

1 Like

@azamiqbal , thanks for offering to support, i tried to upload the excel file but its gives a message that new users can’t upload file. Is there any other way to share the file?