The question of how to add a checkbox to a table view has come up before:
The answer (attaching an action to a blank virtual column) was provided but as I donโt think the implementation is completely self evident, I thought Iโd provide a little example and explain the steps one needs to follow to implement it.
First, hereโs an image to illustrate the goal:
The empty checkbox and the checked checkbox are the same action. When the action is invoked it changes a column called โCheckโ from either โFALSEโ to โTRUEโ or โTRUEโ to โFALSEโ.
The action uses the following expression:
if([Check]=TRUE,FALSE,TRUE)
It has been attached the an empty text column (a virtual column). In this case, I called the column โBlankโ but the name could be anything because the name of the column will not be shown in the table.
Next, attach the action to the blank column as follows:
To get the action to appear to be an empty checkbox when the column โCheckโ is โFALSEโ or blank, choose the following icon for the action:
Now, go to UX โ Format rules and make the following format rule:
This way, when the action does itโs work and changes the โCheckโ column value to โTRUEโ, the icon will change to a box with a check in it. It will revert back to an empty box (and the โCheckโ column value will go to โFALSEโ) if you tap on the action again.
Now, how do we place the action within the table? Hereโs the column view for the table view (UX โ Views):
This places the check after the โNameโ column. If the โBlankโ column is placed after the โNumberโ column, it will look like this:
Well, thatโs about it. The only thing I couldnโt figure out how to do is to give the blank action column a header. The action will โattach,โ in a sense, to the column that precedes it but I canโt figure out any way to avoid having blank space in the header position above the action.
P.S. This is one of several tips I have put together about how to work with table view. Hereโs a link to the rest:
Awesome @Kirk_Masden Thank you very much.
I think your column [Blank] is of Type Yes/No ?
Thanks for your support and encouragement, @Fabian! To be honest, Iโm having trouble remembering how I set that column and I seem to have erased this little test app.
In another app of mine (the main one I have been working on for some time), I make it a โThumbnailโ virtual column that displays images based on the combination of two checkboxes as follows:
This is accomplished with the following expression:
ifs(
and([Cram]=TRUE,[Cram only]=TRUE),
โhttp://www2.kumagaku.ac.jp/teacher/~masden/2017/ICS/cram/Cram01a.pngโ,
[Cram]=TRUE,
โhttp://www2.kumagaku.ac.jp/teacher/~masden/2017/ICS/cram/Cram02a.pngโ,
[Cram only]=TRUE,
โhttp://www2.kumagaku.ac.jp/teacher/~masden/2017/ICS/cram/Cram03a.pngโ,
1=1,โhttp://www2.kumagaku.ac.jp/teacher/~masden/2017/ICS/cram/Cram%20thumbnail%20blank.pngโ)
Iโm not sure if I did this the right way, but the last โ1=1โ means that if none of the other IFS are true than use the transparent blank thumbnail.
I havenโt checked but I think the column to which the checkmarks are attached can be almost any kind of column.
1=1
is really a cool idea . I didnโt know that this would work.
I think you could wrap it also in an If statement like:
if(
and([Cram]=TRUE,[Cram only]=TRUE),
โhttp://www2.kumagaku.ac.jp/teacher/~masden/2017/ICS/cram/Cram01a.pngโ,
ifs(
[Cram]=TRUE,
โhttp://www2.kumagaku.ac.jp/teacher/~masden/2017/ICS/cram/Cram02a.pngโ,
[Cram only]=TRUE,
โhttp://www2.kumagaku.ac.jp/teacher/~masden/2017/ICS/cram/Cram03a.pngโ),
โhttp://www2.kumagaku.ac.jp/teacher/~masden/2017/ICS/cram/Cram%20thumbnail%20blank.pngโ)
In this case you say: take the blank thumbnail as the ELSE.
Now I will explain how to use check boxes in Table view.
Thanks for the explanation @Kirk_Masden, I tried the way and I got it successful.
My excel has columns Name No and Check, make Check as Yes/No
Goto Behaviour and click on Add New Action
set the column to Check and provide formula if([Check]=TRUE,FALSE,TRUE)
In appearance make action icon to square and make prominence as Display Inline
Now click Attach To Column and provide our column Check and as you can see we got a check box
Now goto UX -> Format Rules and create new format rule
in formula tab write [Check] = TRUE
next provide our newly created action to it
for icon use check-square
we can check and un check now
App Link: https://www.appsheet.com/start/960ce629-97dd-4265-a01b-680a3a280045
@Kirk_Masden Thanks for your work on this. Is this still the best way to do this? Seems like it should be native to AppSheet but I guess itโs not.
Thanks Lucinda! I agree that there should be a native function. Please vote for the following and checkout other workarounds discussed on this page:
Voted. I saw Thieryโs response that itโs being worked one. Looking forward to it.
I cannot upvote any feature requests for some reason unbeknownst to me. Does one have to have a paid Appsheet account to be able to vote?
Could you share the example app link again? I am trying to enter this link ( https://www.appsheet.com/start/960ce629-97dd-4265-a01b-680a3a280045 ) but it does not allow me.
Thank you
You could always do a quick edit table with yes noโฆ Itโs a checkboxโฆ
I see. Itโs a great checkbox, but you need to tap on the edit icon first. Thatโs one difference.
By the way, I couldnโt figure out what caused the horizontal dots to be shown instead of Y or N. I tried โSave & Verifyโ but to no avail.
It looks bug to meโฆ
By the way, the action icon at the upper right corner to enable the quick edit to table view you are on is not really recognizable to my end user and clients. I always need to guide them and explain to them hit it !!! Then you are able to get the exprerience like you are on the spreadsheet.
To make this action icon action stand out, I place the action icon in the overlay position.
The action is simple enough. Go to another view but actually return to the same view.
The deeplink expression is
LINKTOVIEW(โYourTableViewYourAreOnโ)&"&quickedit=true"
Awesome input @tsuji_koichi thank you.
Excellent idea @Kirk_Masden. Thatโs ingenuity!
Thanks!