We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Table format

Hello everybody,
I need a CRF like the attached one!
Instead of "val" I need a specific value directly inserted in the Excel file!
So I need a "Grid" format but specifying the field names. Each row should have labels ("Test" names for example) and input text fields!

Do you have any suggestion?

Thank you
img.png 96.3K


  • GerbenRienkGerbenRienk Posts: 838 ✭✭✭

    Hello Antonio,

    Have a look at http://www.trialdatasolutions.com/tds/howto/defaultrepeatingitems.jsp : is that what you're looking for?

    Kind regards,


    Gerben Rienk

  • kristiakkristiak Posts: 1,339 ✭✭✭
    One way of doing this is to have the normal ranges  in the validation collumn. The you create a warnig message when a value is entered outside of the normal range that you can then specify in the message that pops up. This is the cleanest way. You can read more about it in the instuctions section on the spread sheet. Alternativelly by creating a rule, see this link, http://www.trialdatasolutions.com/tds/howto/warning.jsp 
  • antonio89antonio89 Posts: 5
    Thank you for your fast answer but I need to specify a single value into a specific row and not by mean of a select (for example "lower limit" and "upper limit"). 
    Can you help me?

  • kristiakkristiak Posts: 1,339 ✭✭✭
    via Email
    For such functionality I would use the validation possibilities where you can set validation ranges and have popo up messages if the value is outside of the normal range! You can find further details on Gerben's site, e.g. how o do the same using a rule!


  • antonio89antonio89 Posts: 5
    Ok, thank you.

  • haenselhaensel Posts: 602 ✭✭✭

    Hi Antonio

    For the given example I would consider to use for seperate questions. Would be much easier.

This discussion has been closed.