A rule in open clinica

Dear Users.

I have two questions Q1,Q2 both have choice, 1, 2 ( 1=Yes and 2=No)

how to put a validation in Excel CRF, or make a rule which checks, when user slick on save.

Both Q1 and Q2 can not be 1
Both Q1 and Q2 can not be 2
If Q1 is 1 then Q2 must be 2

if Q1 is 2 then Q2 must be 1.

In nutshell, Either Q1 or Q2 should be 1

Thanks for the help.
Regards
--
Manoj

Comments

  • Manoj SoniManoj Soni Posts: 163
    Dear Developers.

    I have two questions Q1,Q2 both have choice, 1, 2 ( 1=Yes and 2=No)

    how to put a validation in Excel CRF, or make a rule which checks, when user click on save.

    Both Q1 and Q2 can not be 1
    Both Q1 and Q2 can not be 2
    If Q1 is 1 then Q2 must be 2

    if Q1 is 2 then Q2 must be 1.

    In nutshell, Either Q1 or Q2 should be 1

    Thanks for the help.
    Regards
    --
    Manoj
    --
    Manoj Kumar Soni
    Database Administrator
    Indian Institute of Public Health-Delhi.
    [email protected]
    09654650596
    [email protected]
    09166256915
  • Manoj SoniManoj Soni Posts: 163
    Dear Developers and Users

    I have two questions Q1,Q2 both have choice, 1, 2 ( 1=Yes and 2=No)

    how to put a validation in Excel CRF, or make a rule which checks, when user slick on save.

    Both Q1 and Q2 can not be 1
    Both Q1 and Q2 can not be 2
    If Q1 is 1 then Q2 must be 2

    if Q1 is 2 then Q2 must be 1.

    In nutshell, Either Q1 or Q2 should be 1

    Thanks for the help.
    Regards
    --
    Manoj
    --
    Manoj Kumar Soni
    Database Administrator
    Indian Institute of Public Health-Delhi.
    [email protected]
    09654650596
    [email protected]
    09166256915
  • Manoj SoniManoj Soni Posts: 163
    Dear Developers and Users

    I have two questions Q1,Q2 both have choice, 1, 2 ( 1=Yes and 2=No)

    how to put a validation in Excel CRF, or make a rule which checks, when user slick on save.

    Both Q1 and Q2 can not be 1
    Both Q1 and Q2 can not be 2
    If Q1 is 1 then Q2 must be 2

    if Q1 is 2 then Q2 must be 1.

    In nutshell, Either Q1 or Q2 should be 1

    Thanks for the help.
    Regards
    --
    Manoj
    --
    Manoj Kumar Soni
    Database Administrator
    Indian Institute of Public Health-Delhi.
    [email protected]
    09654650596
    [email protected]
    09166256915
This discussion has been closed.