ArborRose Coach

Hizzah! Glad to hear it.

Thanks, that means a lot — but honestly, I’m just doing my part. The real credit goes to those who set the bar long before I got here. I'm not concerned about always having the ‘right’ answer or posting my own questions — the aim is to be helpful or get help. If it leads to a solution, adds insight, or sparks discussion,…

Hmm…its been more than a decade since I touched SalesForce and Apex. Try this code for a button, which does not use an iframe and opens a new tab: <apex:page standardController="Account"><script> window.open(…

Congratulations @erikjamesmason!

Apparently the Chrome 142 patch was introduced to combat a lot of security vulnerabilities. One article mentioned it blocking public websites like Salesforce or Domo from initiating requests to private IP address such as 192, 10.x.x.x. Your history, cache, and cookies aren't the issue. It's apparently something related to…

To restrict dataset and card access to specific users and selected admins—you could try using Personalized Data Permissions (PDP) combined with a custom role and sharing. PDP would allow you to filter the dataset access by user or group, and the custom role would let you limit admin privileges by removing “Manage Datasets”…

I think you need to make the workflow trigger an action like a dataset update. I don't think it can response back to the brick / app directly. I think that bricks and pro code apps run in some type of client side host or sandbox. And the behavior is to assure security to the Domo APIs. The API would be secured with OAuth…

After creating what I think is a sample csv file, I've modified the code to this: import pandas as pd import re # 1 Read raw CSV as text lines with open(r'C:\Users\username\Projects\raw_events.csv', 'r', encoding='utf-8') as f: raw_lines = [line.strip() for line in f.readlines() if line.strip()] # 2 Group lines into…

You can create an ETL that starts by splitting each comma-separated value into columns (Split Column). That would give you each label/value in it own column but not aligned. You would have to iterate over all the columns to find the patterns. Label: Value —> Label and Value. With Label: in one column and value in the next…

[Edit] I've reviewed code that I have tested and modified to different variations. It doesn't appear that looking at the API directly provides the values needed to show which datasets will produce the warning. I thought we could use the lastUsed value…but that does not appear to be updated for every type of query. I tried…

You are showing us the name of the ETL, but not the flow itself. Assuming this is a Magic ETL. Can you confirm there is an output tile that was given a proper name for the dataset? If its not a Magic ETL, a SQL tile should have an output dataset. Is there anything special about the workspaces used?

I can't find any reference to whether child properties can be set to NULL. The documentation says you can have multiple child properties but it does not say whether NULL can be set. The system will probably treat it as undefined. It may be ignored or raise a validation error.…

There is a SQL connector that gives the ability to pull SQL tables or views into Domo. Migrating the stored procedures as ETLs would be more difficult and probably require manual translation.

You can create a beast mode formula to convert month wording or abbreviations into datetime, or into month numbers. When I create ETLs, I typically have a value for numeric month such as month(`transaction_date`) and the alphabetic monthname such as monthname(`transaction_date1). I use the wording for display and the…

UNIX_TIMESTAMP() in Domo converts a date-and-time value (like "2024-11-04 15:26:00") into the number of seconds since January 1, 1970 00:00 UTC — a continuous numeric timestamp. We use it because Domo can’t directly subtract two datetime fields and get a difference in seconds. By turning both Created Time and Responded…

Here's what I came up with. Starting with sample data. ID Created Time Responded Time 1 2024-11-04 15:26:00 2024-11-05 08:11:00 2 2024-11-05 10:15:00 2024-11-05 16:45:00 3 2024-11-06 08:50:00 2024-11-06 17:10:00 4 2024-11-07 14:30:00 2024-11-08 11:20:00 5 2024-11-09 09:00:00 2024-11-11 12:00:00 6 2024-11-10 16:00:00…

Here's Python code (use in Domo Jupyter Workspace), to loop through the dataflow ids, extract JSON, and stores to csv. Modify if you want to store to a Domo dataset. End result of this code is shown below: # -------------------------------------------------------------------------------- # Author : Arbor Rose # Date :…

import os import requests from getpass import getpass import json import sys DOMO_INSTANCE = os.getenv("DOMO_INSTANCE", "YOUR_INSTANCE") # <-- set this or export DOMO_INSTANCE DATAFLOW_ID = "PUT_YOUR_DATAFLOW_ID_HERE" # <-- Replace with a real dataflow id (uuid-ish string) # Token: either set DOMO_DEV_TOKEN env var or…

Very nice. Give the man a point. Here's python code to hit that endpoint. Note - a single data flow as described in that curl. Domo instance value would be the company name that appears before ".domo.com". In my example output I am calling dataflow id 564. # Domo Dataflow schedule fetcher for Domo Jupyter Workspaces #…

Just in case you ever want to try it out - a brick is just an html page with a stylesheet and JavaScript (search 'blank brick' in AppStore). You copy each code type (html, css, or JavaScript) into the provided sections. If you want the brick to interact with a dataset, you can change the sample datasets to point to your…

I submitted a request for scheduling information to be added - quite a while ago. I'd love to be able to automate a visual. I ended up creating a brick to plot a type of Gannt chart so I could visibly see when things kick off. But it's a manual process of editing the values in the code: dataset name, type, and quarter…

@GrantSmith - I'd just to highlight (pun intended) what a useful calculation this is for setting an alternating row color. Thank you. Sorry, I can't click the "Accept as a solution" button.

I don't understand how these rumors get started. I look nothing like that guy.

If that does not work, I suggest reporting the issue to Domo Support. It doesn't sound like the AWS has affected this. There were Office updates in 2025 that could affect it. But that doesn't appear to be the issue if you were able to access just two days prior. Especially if you have uninstalled and reinstalled the add-in.

There was a massive AWS outage that affected many computer systems used by large corporations. It's possible that the outage was not on your company system, but may have affect systems along the route - including Domo. I had trouble getting into Domo's Jupyter workspace. Eventually, the issue resolved and I could access. I…

I don't think so. The actions that bypass cache would be hardcoded to ensure you have the most up-to-date data in critical operations like ETLs and views. Most connectors would prioritize data freshnesss to avoid inconsistencies.

Mom said, "anything is possible if you put your mind to it." Everything in your theory sounds doable. But I think Domo is working on a fix for the Executor function.

See this previous thread: https://community-forums.domo.com/main/discussion/comment/58093#Comment_58093

It's possible you hit a blind spot. The scheduling engine may accept and store the report but the UI might not be able to render it due to pagination or filtering issues. Submit a help ticket. You may be able to audit via admin tools. Check the scheduled reports section under Admin > Content > Scheduled Reports. It might…

Sounds like the pivot is complicating the process. Since every new brand means you have to edit the pivot values. What about a truly flat table? Instead of pivoting the brands to columns, use an html table and slicers. Retailer Brand Sales Attribute Target Nike 120000 Sportswear Walmart Dove 80000 Personal Care Costco…