Has anyone figured this out?

Ask for Help
1

I’m currently working on my Announcements (Screen) tab, and I’ve run into a challenge with conditional logic for headings.

Here’s the context:

  • I’m using Big Number components to show counters for:
    1. New Announcements
    2. Announcements Requesting Approval
    3. Rejected Announcements
  • I also want to display a single heading at the top that changes dynamically depending on these counts.

For example:

  • If both “New Announcements” and “Announcements Requesting Approval” are greater than zero → heading should display “You Have New Items Needing Attention”.
  • If only “New Announcements” > 0 → heading should display “New Announcements”.
  • If only “Announcements Requesting Approval” > 0 → heading should display “New Item Requesting Approval”.
  • If both = 0 → heading should display “You’re All Caught Up!”.

I tried setting this up using an If → Then → Else column inside the Announcements (Screen) table. However, the current editor seems to only let me create single conditions (one IF, one THEN, one ELSE). I cannot easily chain AND logic or multiple else-if conditions in the way I need.

Could you please clarify:

  1. Is there a way to configure If → Then → Else to support multiple conditions (including AND / ELSE IF)?
  2. If not, what would be the recommended Glide-native approach to achieve this single dynamic heading (without needing multiple Text components with visibility conditions)?
  3. Should this logic live in the Announcements (Screen) table, or is there a better place to structure it?

This feature would be really helpful for creating cleaner UI and avoiding multiple overlapping headings.

Thank you so much for your guidance!

1 Like
2

I would probably just do it with a javascript column. Pass in the two numbers and have it return the text you want.

2 Likes
3

I can’t think of a way to do this with only an if-then-else column, but I think it is possible if you combine it with a math column.

  • Create a math column that adds both columns together to get a total of both.
  • Then the if-then-else logic becomes:
    – If Total equals 0, then " You’re All Caught Up!"
    – If New Announcement total equals zero, then "New Item Requesting Approval”
    – If Announcements Requesting Approval total equals 0, then “New Announcements”
    – Else “You Have New Items Needing Attention”
5 Likes