Best Of
Re: Setting up alerts for a card that groups orders by sending one alert per order
No, a SQL workflow cannot send emails. That's for transforming and writing data.
To send emails, I would use Domo Workflows - which is an automation feature that supports things like sending emails, AI integration, etc.
On the black ribbon bar at the top of this forum, there is a link that says Community Forums. Hover over it and a menu appears that has Events. Under Events you will see Event Recordings. I suggest you look through the event recordings for anything indicating workflows. The ones that start with "AI Academy" are mainly to show AI, but they do work with Domo Workflows.
Google John Le, Dashboard Dudes, he should have some great tutorials on workflows. @MarkSnodgrass may have some as well and jump in to comment.
Formula Editor Scrolling
Early last year, I reported an issue with the Magic ETL formula editor where it fails to function correctly once the amount of text requires scrolling. Because my data is healthcare-related, I’m unable to provide a screenshot.
When the editor scrolls, it no longer accurately tracks cursor position or properly highlights selected text. This behavior makes it extremely difficult—and unreliable—to work with complex formulas, such as those involving multiple CASE conditions or code translations.
Please address and resolve this issue.
Re: Remove row from dataset
Hello @Sean_Tully I think you may have a malformed csv or it may be in an encoding that is causing the issue you are describing. Likely there is a character that is not correctly escaped somewhere in the data. Would strongly recommend using a text editor like Notepad++ or a tool like reCSV if it is a large csv file to investigate what data is causing the issue.
IF the dataset is upsert enabled, the delete-rows command can be used, but would delete all rows associated with the upsert keys provided. This sounds like it may be problematic based on how you stated the dataset was showing up.
If the dataset is not upsert enabled, I do not think there is any command in the Domo CLI v3.32.97 to do what you are requesting. The only option would be to fix the file as I have recommended, then full replace the data with the clean version. You can use clear-data to remove everything but the schema/headers, and then upload-dataset with no -a to do the full replace.
Example:
clear-data -i 3a8f6ba5-a937-41a3-ac14-adb3f52e9639
upload-dataset -f store_sales_dataset.csv -i 3a8f6ba5-a937-41a3-ac14-adb3f52e9639
Re: Sharing custom themes in App Studio
While the ability to import/export custom themes into Apps has been added, there is still a gap in functionality in the ability to share themes more easily with a group of users (or the whole business). When creating a new app, there is a tab to select Custom Themes but it's always empty!
It would be great to be able to have this screen populated with pre-built custom apps for users to select. It would also be great to then have these custom themes to be able to be adjusted/updated and have them roll through onto all Apps that use them. This will allow updates to corporate themes/colours to be rolled out quickly and easily. At present, an update to a custom theme would require users to individually go into each App and upload the new version of theme in order to update the Apps.
MartyR
Re: Creating an HMAC and pushing data to a JSON Webhook connector with a secret applied
For me to get this to work I had to add the "data=" parameter in the request:
response = requests.post(url, headers={'X-Hub-Signature': hashed.hexdigest(), 'Content-Type': 'application/json'}, data=jsonStr)
Jamien
Re: Beast Mode for Rank
As @ellibot stated, you don't need a date column to rank. You just need a column to order by.
RANK() OVER (ORDER BY Value 1 DESC)
If you want something like top five:
CASE WHEN RANK() OVER (ORDER BY `Value 1` DESC) <= 5 THEN 'Top 5' ELSE 'Other' END
In an ETL use a Rank & Window tile, partition by your group (such as Account), order by Value1 descending.
Re: "I Just want the numbers" - Accomodating Domo detractors
After reading through all the answers and thinking through it more, I like the idea of a Scheduled Report out of App Studio. This way people are still engaging with Domo, albeit in a more simple and user-friendly way.
I was originally leaning towards doing a Google Sheet, but I like the idea of staying within Domo and sticking to my guns :)
Y'all agree? Give me that thumbs up
Re: best way to share outside of Domo
@James_Lord it might be an issue with whitelisting. When you look at your Domo Everywhere settings, are you listing specific domains that Domo can be embedded?
https://{instance}.domo.com/admin/domo-everywhere/settings
ellibot
Re: best way to share outside of Domo
Domo Private Embed requires the viewer to authenticate into your Domo instance.
- Through the single SSO provider configured for your Domo tenant
- Through a native Domo username/password account
There is no separate authentication flow for Private Embed, and Domo does not support multiple SSO providers per tenant. Because of that, Private Embed generally does not work for external clients unless you are willing to create and manage Domo user accounts for them.
Two possible paths:
- Public Embed, and rely on SharePoint permissions, VPN, or network controls to restrict access
- Domo Everywhere, which is designed specifically for securely sharing dashboards with external clients and supports multi‑tenant access models
Re: best way to share outside of Domo
The private emebed will expect the user to have been authenticated via SSO or direct login. If they aren't then the login screen will appear for the embedded content and after the login it will appear. Each person who is shared the dashboard will have access to the private embed.
