I am redesigning an old greenhouse gas emissions regulatory application that has a common design pattern where data tables include "Not Applicable" marked as N/A as the first column. When the user marks a row as N/A they are essentially saying that the particular emission does not apply and the system will not use the information in that row to perform different calculations and it also is useful for data extraction purposes. This approach does not seem intuitive and I've been trying to think of alternatives.

The obvious solution that comes to mind is to make it an opt-in approach vs an opt-out (what it is currently). So remove the N/A and only if the user deems it applicable, they will click on the checkbox marking that it applies. This approach might not be the best because we want the use to consciously read through each emission and mark it as N/A. It's an extra layer of validation. If we don't force the user to do this, they might not make the effort to mark relevant emission as applicable.

Another option we have thought about is to make the user enter a zero instead of an N/A checkbox, but zero and N/A serve different purposes. Zero would mean it is still applicable but the emission is zero.

Screenshots attached.

Is the N/A approach they way to go or is there a better solution?

enter image description here enter image description here enter image description here

  • 1
    Interesting. First question: how many possible options/rows/items are there that the user can select from (or designate as N/A)? Second question - what are the steps just before and just after this, for some context?
    – Mattynabib
    Nov 17 at 18:17
  • Would it be an option to let users remove the non-applicable rows, with the option to add them again from a dropdown menu?
    – jazZRo
    Nov 20 at 9:14
  • #1 It depends. Some tables have 3...some can have 20. #2 no "steps" before these pages. There is a main dashboard page, and then you click into a page that can have multiple data tables like these.
    – user170002
    Nov 20 at 15:22
  • I think we could but some of these tables are large. Not sure if that would make dropdowns really long.
    – user170002
    Nov 20 at 15:30
  • Do users always make changes to all applicable substances? Can making no changes mean the substance is N/A?
    – moot
    Nov 20 at 16:21


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.