How can I identify mandatory columns in my Excel file?

Modified on Mon, 27 Jun, 2022 at 11:10 AM

While Labregister allows you to define ‘mandatory fields’ for very important reagent information that should always be filled, this can on occasion lead to error messages when importing Excel lists. 

Note: In your Excel file it is crucial to have the mandatory fields filled with appriopiate data as set in Labregister.   

Please follow the steps below, to identify mandatory columns in your Excel file:

  1. In Labregister, identify via Options > Category attributes, the mandatory Attributes (marked with an asterisk) of your Category. 
  2. Within the original Excel file, highlight the top row/header of your inventory.
  3. Navigate to Data > Filter to enable a filter for each of the selected columns.
  4. For the respective mandatory Attribute enable the filter for (Blanks).
  5. Fill the mandatory field with appropriate information or remove the mandatory rows.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article