Page 1 of 1
Automatic data capture
Posted: November 11th, 2016, 3:41 am
by 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.
Re: Automatic data capture
Posted: November 15th, 2016, 3:09 am
by 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.
Re: Automatic data capture
Posted: November 15th, 2016, 4:51 am
by 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
Re: Automatic data capture
Posted: November 15th, 2016, 5:24 am
by khurshid.arshad
Dear Titus
Please use notappl option in value set and what do you mean vain.
a.
Re: Automatic data capture
Posted: November 15th, 2016, 8:04 am
by 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?
Re: Automatic data capture
Posted: November 15th, 2016, 8:56 am
by khurshid.arshad
exactly
a.
Re: Automatic data capture
Posted: November 15th, 2016, 9:05 am
by 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.