Airtable single status dropdown colors show in Softr?

strupek · March 21, 2024, 3:19pm

Aaaaaand I’ve actually solved it with the help of ChatGPT! So I wanted to share here

I used a SWITCH formula that outputs HTML which we then have appear as Rich Text in Softr:

SWITCH(
  {Posting Status},
  "Scheduled", "<div style='background-color: #CFF5D1; padding: 5px 15px;'>Scheduled</div>",
  "Ready to be Scheduled", "<div style='background-color: #FFEAB6; padding: 5px 15px;'>Ready to be Scheduled</div>",
  "Waiting on Approvals", "<div style='background-color: #FFD4E0; padding: 5px 15px;'>Waiting on Approvals</div>",
  "In Drafting", "<div style='background-color: #C4C7CD; padding: 5px 15px;'>In Drafting</div>",
  "Stalled/Waiting on Client", "<div style='background-color: #DC043B; color: #FFFFFF; padding: 5px 15px;'>Stalled/Waiting on Client</div>"
)

And walla - it works!