I can do that … But is there a way to make template to hide that particular row if all cells of that row are empty?
My current situation is this. I have an audit sheet which will be a “set” of
( 1 yes/no question , more details , an image ) repeated for each work area.
So each row will have a bunch of columns which are YES / NO type and other columns for other details, photos etc.,
In my email report , I want to send an email for each new row in my appsheet form.
My report will have a table where I will show the results of each “set” as a row.
I know how to do this in the google doc template. Just put in all column names in corresponding cell and bam! But i don’t want to show all “Sets” in the same manner.
I want to only highlight those “sets” for which the answer is NO.
I can do this in 2 ways :
- Make the corresponding rows in my table highlighted in a nice blood red color to draw attention. 2. Show only the “Sets” for which the answer is NO.
Is there any way to do these types of displays in my report table?