Hi, I'm trying to prefill a single choice question based on a numeric response. See below.
Q2. How old are you? (Numeric)
Q2Equation: {Q2Quota=if(Q2<=39 AND Q2>=18, 1, if(Q2<=49 AND Q2>=40, 2, if(Q2<=99 AND Q2>=50, 3, "")))}
Q2Quota: Contains the 3 bracket ranges with answer codes 1, 2 and 3. This is on a new page.
When testing, Q2Equation shows the correct result but doesn't insert it into Q2Quota, but there is no syntax error displayed.
If I change Q2Quota to a multiple choice and update Q2Equation to:
{Q2Quota_1=if(Q2<=39 AND Q2>=18, "Y", "")}
{Q2Quota_2=if(Q2<=49 AND Q2>=40, "Y", "")}
{Q2Quota_3=if(Q2<=99 AND Q2>=50, "Y", "")}
Then it works, and is prefilling correctly.
Am I doing something wrong here, to prefill into a single choice?