Best Of
Re: Ability to sort Filter Views
Sorting is a bare minimum but I would like to add the ability to organize filter views in directories. We set filter views for different sale date ranges and I would love to able to sort them into folders by Year>period>filter view etc. to clean up the interface rather than have people scroll through a continuously expanding list.
Re: Get unique records from datasets
you're using confusing language sorry, it's not clear to me if you're asking for an UPSERT scheme which keeps only the most recent version of each row or if you're looking for a partition scheme where you only keep the block of data from the most recent month. OR if you're looking for a way to report if the value changed from one month to the next (slowly changing dimension).
I'm sprinkling in what may sound like jargon b/c they are 'terms-of-art' with 20 years of history each.
If you need UPSERT or Partitioning, you can look at a recursive dataflow pattern. https://www.youtube.com/watch?v=JNQFZCj8JcQ
The difference between UPSERT or Partitioning would just be how you define your RANK partition, do you make it at the granularity of one row, or month or folder_month.
if you need slowly changing dimensions, you still implement the RANK to get the row version number, but then you add a LAG function to get the value last period.
Re: Get rid of filter icons in app studio apps?
If you click on the page layout in an app, page settings will pop up in the right panel where you will see 'Filter Options'. You will be able to access these options after clicking on that option!
Re: Print A Word Document with Domo Data Using Word Template
This is something where you could use workflows to upload the text you want changed and use some simple javascript to modify the text and then download it.
Here is an example:
function downloadAsWordDoc(content, filename) {
const zip = new PizZip();
const doc = new Docxtemplater(zip); doc.loadZip( new PizZip( `<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <w:document xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"> <w:body> <w:p> <w:r> <w:t>${content}</w:t> </w:r> </w:p> </w:body> </w:document>` ) ); const blob = doc.getZip().generate({ type: 'blob', mimeType: 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' }); saveAs(blob, filename); } const template = Hello <USERNAME>!
I wanted to inform you that your <YEAR> <MAKE> <MODEL> vehicle is due for service.
You should contact 801-833-XXXX and plan a date to bring in your vehicle.; const values = {
USERNAME: 'John Doe',
YEAR: '2021',
MAKE: 'Toyota',
MODEL: 'Camry'
}; const result = replacePlaceholders(template, values);
downloadAsWordDoc(result, 'document.docx');
————————
This type of implementation could take just a little bit of custom code to get working in my opinion, but the connecting it up will just take some tweaking.