Best Of

Re: Use an existing dataflow as a template???

I think we've settled on providing (configured) JSON string via an automated email as part of a workflow connected to an Intake form, with instructions only how to paste directly into a new Magic ETL and create it themselves. The new workflow capabilities in Domo are making this possible, with realatively easy setup.

JustPat4now

2

Re: Left Join

I'm experiencing exactly what you've described in my Magic ETL 2.0 flow.

Left Outer Join only keeping matches. Which is incorrect.

CR-eSobylak

1

Re: When will the new MSOffice Plugin be available for download directly from Domo?

I asked the same question to my AE the other day. It seems odd that there is not a link to it from the Tool Downloads section in the Admin Center of the Domo instance where the old Excel and PowerPoint Plug-ins are currently located.

Here is a link that will take you to the MS Appstore and filtered to the new Domo add-ins.
https://appsource.microsoft.com/en-us/marketplace/apps?exp=ubp8&search=domo&page=1&product=excel%3Bofficemetaos%3Boutlook%3Bonenote%3Bpowerpoint%3Bproject%3Bsharepoint%3Bteams%3Bviva%3Bword

But it seems like Domo should have it included in the Tool Downloads section to make it easier to get to.

MarkSnodgrass

1

Re: WriteBack duplicating datasets

i managed to figure this out just remove the original output dataset and use the copy dataset created by the writeback tile

AnwarBham

1

Re: Google Sheets - Date Format issue

Hi Joeri,

Is there any update? I'm facing the same issue.

Thanks!

beatricetan21

1

Re: Programmatic Filters Implementation Help

@ekishab, thanks for your question!

Context:

With programmatic filters and dashboard / card embed, your web page will have a dashboard / cards embedded into it by way of an iFrame.

Depending on who is logged into your Web portal / page they may see a sales dashboard / card in the first iFrame and an marketing dashboard / card in a second iFrame - each of the dashboards in DOMO will have it's own associated Embed ID.

For user Mike - viz 1 may be the Sales with its own set of filters and viz 2 the marketing with its own set of filters.

For user Suzanne viz 1 may be the Sales with a different set of filters to Mike and viz 2 the marketing with its own set of filters.

etc.

Code

Looking at the sample.html that came with the code:

The source is pointing to the first vizualization in the Users.js file for this user (item/1).

This is handled in the express.js file with the Item/1 passed in from the iFrame:

app.get('/embed/items/:itemId', passport.authenticationMiddleware(), (req, res, next) => { const config = req.user.config['visualization'+req.params.itemId]; if (config.embedId) { embed.handleRequest(req, res, next, req.user.config['visualization'+req.params.itemId]); } else { next(`The EMBED_ID${req.params.itemId} environment variable in your .env file is not set. Please set this in order to view content here.`); }});

Conclusion

For mike, the iFrame will return the Sales dashboard / card with a set of filters applied.

For Suzanne, the Sales dashboard / card will be returned with a different set of filters applied.

You need to ensure that the Users.js file is populated with the correct embed Ids, filters & credentials for the iFrame to be able to retreive the correct visulization for the specific user.

nikky

1