Forum Discussion

CarolannLiberon's avatar
CarolannLiberon
Qrew Member
16 hours ago

Making a checkbox field editable in a report?

Hi! I was wondering if someone could help with a possible formula question?

I have in an app an employee master list. In that list the previous designer has a checkbox field called "Active" - If the employee is active it is check if not unchecked etc.

My question is the default report that lists all of the employees shows a column that is the active field but I have to go into each individual employee record to uncheck active.

Is there a way to be able to go down the list and uncheck all who are inactive right from that report?

Thank you in advance!

reports

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    16 hours ago

    Yes, the name for the feature that you want to use is Grid Edit.  It changes the behavior of a table report to be more like Excel where you can edit the cells.  The icon for that is near the top right of the report in New Style table report or in Old Style table reports it's actually called Grid Edit.

    Similar to Excel, it does not actually commit your changes to the database until you save and also similar to Excel you can use copy and paste with CTRL C and CTRL V and also right click on a cell to copy paste.  There is also Fill Down.

     

    https://helpv2.quickbase.com/hc/en-us/articles/4570328849812-Grid-edit