Automatic data capture

[Titus]

dear forum

iam working on a survey questionare , with household I'd (unique I'd), county and sub county. I want the household I'd to pick the codes for county and subcounty automatically once I enter these fields. kindly assist.

thanks titus.

[khurshid.arshad]

Dear Titus

string AlphaQID ;
AlphaQID =Concat (Strip(Maketext("%01d",Q_1_1)), //"%01d" variable lenght is 1
Strip(Maketext("%01d",Q_1_2)), //"%01d" variable lenght is 1
Strip(Maketext("%02d",Q_1_4)), //"%02d" variable lenght is 2 with zero fill
Strip(Maketext("%02d",Q_1_6))); //"%01d" variable lenght is 2 with zero fill

UniqueId=tonumber(AlphaQID);


a.

[Titus]

Thanks Khurshid, let me try the command and see if it will work though iam new to cspro, mean while am trying to set some rooster numeric fields to allow a blank but in vain, kindly assist me please in case you have an idea.

thanks Titus

[khurshid.arshad]

Dear Titus

Please use notappl option in value set and what do you mean vain.
a.

[Titus]

thanks khurshid for the quick response," in vain" means I did not succeed, so do I go to dictionary and add value set with label notappl? kindly advise?

[khurshid.arshad]

exactly
a.

[Titus]

Thanks khurshid, have tried that but I still get the error message, " out of range, please enter a valid value" please what cud be the issue.