I'm building a dashboard view for sorting TCM (transitional care management) patients. I currently have two views nested inside that are built on slices to help sort patients into different TCM categories. The two views are/slices are called "TCM Patients - Red" and "TCM Patients - Yellow", with the dashboard viewing being called "TCM - DONOTUSE" for the time being...
I know that I can assign format rules based on CONTEXT("VIew") = "Insert View Name Here" but i am having a bit of trouble thinking outside the box at the moment. I want to color the [Full Name] column of the patient red if they are in the "TCM Patients - Red" slice, with similar formatting to follow as i add more color coded staged.
Does the CONTEXT() expression have the ability to target slices, and if so, what's the proper syntax? I would like for the formatting to take place within the "TCM - DONOTUSE" view, but of course separated based on the slices. I am finding that filtering by CONTEXT("View") = "TCP Patients - Red" does not work, presumably because that is a view that is nested inside of TCM - DONOTUSE, and that parent view is what is exposed to AppSheet when looking at the dashboard.
LinkedIn
Twitter
