Best Of
Re: Can we create a custom thank you message for forms in app studio?
Currently this would be a feature request (Post in the Ideas Exchange here in the community, happy to upvote it!)
To accomplish this with current functionality I think you would need to create a custom app that mimics a form, that kicks off a workflow, that would append that row to a dataset.
For example note the Form on the Left here (it is a custom app hooked into a workflow shown on the right):
Then upon submission, the app unhides and displays the Submission message, which could be whatever you want it to be:
For example here I've added 😢 to my Error message and you can see it displaying in the preview:
Re: Week of starting on Monday
@s_f_OTT If the value of your date field is on a Saturday, then the WEEKDAY function will return 7, not 0. So if you change the 0 in the first condition of your case statement it will apply the correct number of days to subtract.
Re: Better date selectors on cards
Hey @oscarfromspain
It's a few steps and if you use publication that adds a complexity.
To summaries:
- 4 date selection variable controls - bottom of dashboard page so users don't see it, all beast modes reference those
- Current Dates (Start & End)
- Comparison Dates (Stat & End)
- Custom DDX Brick that contains bulk javascript code that controls those variables based on the inputs in the brick controls this reference a DOMO Webform, but also builds the the calendar selection.
- DOMO Webform that contains ids of those variable controls mapped to some JS object that DDX brick references.
Thanks
Re: Better date selectors on cards
We had to build a custom date range brick that offered both options that controlled a series of variables.
Re: Why won't my card update?
For the card not to even update in the Analyzer, I would guess that it's not actually being fed by the same dataset, just one with the same name. When you click the down arrow next to the dataset and select "Change Dataset", is there more than one option with that name?
My hypothesis: someone was working on the MagicETL, deleted the output tile, then added a new output tile with the same name. Removing it from the ETL doesn't delete the dataset or any cards associated with it.
Re: Dataset Tags in Workflows Not accessible
@brycec so it is supported in Python as well, I was recommended it by Jace at Domo. I've created a ticket so all good, I'm pretty sure it's a bug.
NateBI
Re: Scheduled Report - Excel Attachement
@Jones01 That is correct. I am able to receive card-based scheduled reports as an .XLSX file, keeping all of the UTF-8 characters. I don't have an option to choose XLSX or CSV. It sends an XLSX file for all card-based scheduled reports.
Re: SQL Tile - not able to reference CTE name in itself when using recursion
You can use Domo’s Magic ETL to simulate recursion if your hierarchy isn't too deep or large.
- Filter rows where ManagerID IS NULL (top-level).
- Join the result to the hierarchy where ManagerID = EmployeeID.
Repeat the above as multiple steps (one per level).Append each level's result together. You’ll be limited by the maximum depth you hardcode in ETL.
Or, if you control source data, process outside Domo. And import the result into Domo.
Re: SQL Tile - not able to reference CTE name in itself when using recursion
I'm going to venture a guess and say you expecting too much from the SQL tile. When it was introduced to us, we were told it would have limits. Having the SQL tile reference itself isn't something I'd expect it to do.
Re: Storing Form Responses Based on Dropdown Selection in App Studio
To my knowledge, if you are wanting your app studio form to have cascading dropdown lists where dropdown list B will show options depending on what was selected in dropdown list A, (i.e. list A contains states, list B contains cities for only the state selected in list A), that is not currently possible in app studio forms. It was possible in the Form Builder app, so it is disappointing it has not made it over as a feature in app studio forms yet.
I would suggest creating it as an Ideas Exchange if it isn't already.
