Is it possible to create a column in a database in which some rows have checkboxes and others do not?
I’m currently trying to format a database that allows me to track how much of a collection of items I have completed. Each row is formatted roughly as follows:
Item | Version A | Version B (etc.)
Where Version A and B are formatted as checkbox columns.
If every item has a version A, but only some of the items have a version B, is there any way for me to remove the checkbox from those specific rows? I understand that, as a checkbox column, I’m probably unable to do this, but I’ve been trying to think of alternate formatting solutions and am coming up empty. If anyone has any creative work-arounds, I’d be happy to hear them.
You can achieve something similar to what you want making use of the hidden formula button(). It’s cumbersome to set up and it will scale poorly if you have a lot of versions, but it works.
Feel free to duplicate the doc to look at the formulas under the hood and let me know if you have any questions.
This version does not use the hidden Button() formula, which is unsupported.
Instead I have used the following approach..
Table Columns:
V - Select list for the Version (A or B etc)
Status - (Hidden) a Checkbox to remember if version is Set or Unset
Checked - a button that sets or unsets Check if there is a version
- its label is computed to show the status and versio
- when clicked it flips the status
Symbol - (Hidden) the symbols for set and unset (a formula)
The Symbol Formula:
If(Status, '✔️', '❌') // choses which symbol to use in the button
The Checked Button:
Disabled If
IsBlank(V) // disable button if there is no version
Label Formula:
If(IsBlank(V),"", Symbol+"Version "+V) // no label if V is blank
Button Action:
thisRow.ModifyRows(
thisRow.Status, Not( thisRow.Status) // flip Status when clicked
)
I have also used Conditional Formatting to improve how the table looks.
But that is not essential to the overall approach.