Constraint to "empty text answers" and IF/OR-Constraints

KaiBehncke

Dear all,

the possibilities in Survey123 Connect are really great.
Unfortunately sometimes the syntax is not easy.
In my form I have the following challenge.

People have to fill out EITHER the text-field "tax-id"
or the text-field "Company-tax-id".

I try to solve it via constraints.

My question is:
Is it possible to create "IF" or "OR" constraints?
So far I have an regular-expression-constraint for the tax_id-field (regex(., '^\d{11}$'))...
but I need a constraint-solutions that checks:

a) Are the fields "tax-id" AND "Company-tax-id" empty? (not allowed, if they both are empty a constraint-message should appear)
AND
b) Is the syntax of a tax-id correct (regex(., '^\d{11}$')) (ok, for that I have a solution)
AND
c) allows the text-string "Not existing" (but only for ONE of the two fields)

Could anybody give me a hint how to solve that? If a) + b) +c) is too difficult I would be happy also about a solution for a) + b) 🙂

Thank you very much, Kai

KaiBehncke

If found a solution now. I work with different note-sections and calculations:

 

Note for tax_id_field:

Calculation: if((regex(${steuer_id} , '^\d{11}$') or ${steuer_id}='Nicht vorhanden'), 'OK', 'FALSCH')

Note for company_tax_id_field:

Calculation: if((regex(${wirtschaftlichkeitsnummer} , '^DE\d{9}$') or ${wirtschaftlichkeitsnummer}='Nicht vorhanden'), 'OK', 'FALSCH')

extra note that checkes circumstances:

Calculation:

if(((${wirtschaftlichkeitsnummer}='' and ${steuer_id}='' and ${plz}!='')or (${wirtschaftlichkeitsnummer}='Nicht vorhanden' and ${steuer_id}='Nicht vorhanden' and ${plz}!='') or (${wirtschaftlichkeitsnummer}='Nicht vorhanden' and (not(regex(${steuer_id} , '^\d{11}$')))and ${steuer_id}!='Nicht vorhanden') or (${steuer_id}='Nicht vorhanden' and (not(regex(${wirtschaftlichkeitsnummer} , '^DE\d{9}$')))and ${wirtschaftlichkeitsnummer}!='Nicht vorhanden')),'WRONG','OK')

 

And then I putted constraints to the tax_id_field:

${eingabe_steuer_wirtschaft}=‘OK’ and (${testfeld_a}=‘OK’ or ${testfeld_b}=‘OK’)

and the same constraint for the company_id_field:

${eingabe_steuer_wirtschaft}=‘OK’ and (${testfeld_a}=‘OK’ or ${testfeld_b}=‘OK’)

 

Everything fine 🙂