How to create a Bulleted List from an EnumList

[MultiTech]

• Have you ever wanted to show data in your app in bullets?
• Maybe you thought about using an Enumlist…
• …but how can I see the items in that list as a bulleted list?

While you can’t natively see your EnumList items in a bullet-styled list, you can however create a DISPLAY of that data that approximates a bulleted list.

Here’s How

---

1. First you need an EnumList of items that you wish to display
2. Next you need a field in which to display that information
   • This could be a Show(text) type - I prefer this one
   • Or it could be a LongText type
     • which allows you to STORE the value that way (vs. just seeing it in the app).

Regardless of which you chose, the method for accomplishing this is the same.

• Create a CONCATENATE() formula similar to the following:

---

CONCATENATE(" - ", 
  SUBSTITUTE([EnumList], " , ", "
 - ")
)

---

• What this formula does is switch out every instance of the separator (“space comma space” - the default separator used by the system when recording the data for a list) and changes those to:
  • “a line break, space dash space”

When combined with the concatenation of the " - " to the front, this gives the aproximation of a bulleted list.

---

I have created a sample app to show what all this looks like inside the app:

• Here’s a link to the Sample App

[Marc_Dillon]

Now that’s how you make a sample app!

[Suvrutt_Gurjar]

True. A creatively crafted, user-friendly sample app by @MultiTech_Visions as usual. It helps the user seamlessly navigate while demonstrating the functionality.

[Fabian_Weller]

Thank you so much for this Tip @MultiTech_Visions
I prefer LongText, instead of Show type, because it saves space.
On the left you see LongText. On the right you see Show type.

We can also create an inline view out of the EnumList with the trick @Bahbus told us.

[Inline Ref Count](https://community.appsheet.com/t/inline-ref-count/24640) Questions

So, this most likely to related to Inline views change? issues, but I specifically have an real EnumList of Refs that I use for editing usage. I have a VC List of Refs with an app formula that just points to the EnumList that I use for display. It works just fine, however, the count that has now moved to the label only shows (1) regardless of the number of entries: [image] [image] This seems to be a bug in which AppSheet is parsing the list incorrectly for counting purposes. I believe it cou…

[anonymous]

This is a great tip.

But one BIG problem is that the list with line breaks simply does not display when using in a PDF report!

[Fabian_Weller]

Hi @PocketSurvey here is a solution

[Substituting line breaks in email template](https://community.appsheet.com/t/substituting-line-breaks-in-email-template/9089/19) Questions

Thank you very much for that hint Marc. This was the solution. I even didn’t need an extra VC. In my template I added a Table and put in the expression: <