I want to show custom message instead of “no items”. But the show is not happening here.
IF(
CONTEXT(“View”) = “Pendency”, "Great
",
IF(
CONTEXT(“View”) = “Same-day Report”, “Awaiting for Scanning”,
IF(
CONTEXT(“View”) = “bad stock”, “Today No Scan Data Found”,
“No Items”
)
)
)
1 Like
The expression looks okay to me, have you tried to use SWITCH() to see if resolves ?
SWITCH(
CONTEXT(“View”),
“Pendency”, “Great”,
“Same-day Report”, “Awaiting for Scanning”,
“bad stock”, “Today No Scan Data Found”,
“No Items”)
Sometimes when I use IF(IF()) or IFS() the AppSheet doesn’t show any error in the formula, but it doesn’t usually work correctly either
https://support.google.com/appsheet/answer/10107700?hl=en
1 Like
Vielleicht hilft dieses kurze Video weiter: How to Create a Pop Up Help Info
Thank you so much for your Response @Tommy62 @mattlops .
Here expression are not doing proper work. Always show No items
I want that if “Pendency” has no data then show “Great” and when “Same-day Report” has no data then show “Waiting for Scanning”
1 Like
Working here but there is a problem. In the dashboard slices only No items are visible. And when I make the slice view full, it looks correct.
Have you solved this?
I think it’s a “bug”. I try to put two different values to translate text in my apps, and the same issue occurs. Maybe it’s not possible yet?