Please join your peers on either March 26 (8pm GMT) or March 28 (8am GMT) to watch as user extraordinaire and forum legend @"lindsay.stevens" demonstrates OpenClinica Insight.

See preview and register at https://openclinica.com/insight-webinar

Insight makes it easy to ask questions of ALL of your clinical and operational data and visualize answers via interactive reports and dashboards. The idea is simple, but the results are powerful: ask your questions, choose your visualizations, then return often for updated, interactive results that link you to all of the underlying data.

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.