Formatting Values in Calendar Card
I'm using a beastmode conactenating two text fields as the value in the calendar. See attached screenshot. I want to place the second value, after the " / " on the next line rather than under the first. Is that possible? It seems writing any html or a break statement isn't working.
Comments
-
Hi mfaas,
I am getting the same issue with HTML and break. When you hover it actually shows the line break but in the calendar you actually see the <br> text.
My only thought is to pull the data into R using the DomoR package and split the string on "/" then use sapply to split the names into separate rows. The end results would look something like
Date Name
10/8/18 Anand, Mike
10/8/18 Chad Pim(rest of name here)
Then when you upload the dataset back to Domo you will be able to use those fields in the calendar. use name in the sorting, and they should show on separate lines within the same date.
R Sample Code
#splits the strings into different columns
s <- strsplit(yourtablename$name, split = "/")
#splits the different names into rows with the corresponding date
yournewdf <- data.frame(name = rep(yourtablename$date, sapply(s, length)), name = unlist(s))Hope this helps,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2 -
I don't think HTML will work in calendar cards. New lines appear to be restricted to new records, not different columns on the same record.
You might have to break apart your values into individual records in a dataflow, if that's possible.
Let me know if my assumption about your data is incorrect.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Hey Aaron thanks, I see what you mean. I think that may cause other issues with this data, but I see what you mean. I was hoping there was some sort of series feature or text wrapping feature I could use.
1 -
Thanks Brian, I may try this.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive