31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!

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.