Best Of
Re: Editable "Form"/Survey Style to Log Interactions
I have built a form very similar to this in App Studio. It has been very successful. However, just recently the end users started receiving the Error Loading Form message that you reported. I don't see the message when I access the form. We have Domo support ticket created and are waiting on the issue to be resolved so that users can start using the form again.
You can definitely make that form in Domo. I would suggest any of your dropdown lists to be driven by a dataset so that you ensure data is entered correctly and you can manage the lists without having to edit the form itself.
Re: Making Users Watch Mandatory Videos
This really isn't a Domo question. Managing training would be something dictated by your HR department using a LMS (Learning Management System). An LMS can help track successful training completion and provide quiz questions with a digital acknowledgment form confirming they understand the material.
You could use Domo to track who has completed training and who hasn't. And setup reminders and notifications for incomplete training. I use an api to call our system and present a report in Domo.
How to calculate Months between two dates with DATEDIFF?
I was trying to use the formula DATEDIFF(month,date1,date2) to calculate the months between two dates based on the function details that shows up in Magic ETL (which I have pasted below).
In the Unit form, the difference is returned in the specified units from the first argument until the second. For example, DATEDIFF(day, '2011-01-01', '2011-01-08') returns 7. Timestamp and string arguments are converted to dates when the unit requires it (day, month, year, etc.), while date and string arguments are converted to timestamps for other units (second, minute, hour, etc.). This form is largely compatible with other SQL dialects, excluding MySQL.
The formula seems to work when I enter some random dates and validate the tile
DATEDIFF (MONTH, '2020-02-08', '2024-02-09') (It shows 48 when I validate my formula).
However when I run preview for the ETL I am getting an error "Column referenced but not found: MONTH"
Any idea why this is happening and how to fix it?
Thanks in advance.
b_rad
Re: How to calculate Months between two dates with DATEDIFF?
Devon,
Thanks for your response but I dont believe what you mentioned is the case. I am using valid columns and actually the formula tile gives an error when I run the ETL or try to "Preview" it even with hardcoded dates. For some reason, its not liking the MONTH parameter in the DATEDIFF function during the Run process.
b_rad
Re: 403 error in custom app calling code engine function
If you are building a Domo app (pro-code or brick), then you will likely need to use one of Domo's SDKs and this authentication hack won't work. But, to use the X-DOMO-Developer-Token header, you simply add a header to your API request key: X-DOMO-Developer-Token, value: <your_access_token>. You can generate an access token inside Domo under Admin > Authentication > Access tokens. For this API, the run code engine endpoint would be <your_instance>.domo.com/api/codeengine/v2/packages/<id>/versions/<version>/<function_name>
I noticed the Product APIs have started being documented in the Domo Developer Documentation. But, if what you need isn't there, you can open up the developer tab on your browser, go to the network console tab, and analyze requests sent using the Domo UI.
brycec
Re: No undefined variables have been added to Variable list
Quick summary of the less intuittive aspects well-explained by Dan:
Data types are configurable in the SQL Query per column
This is how you assert for a "person" (see user id)
The current row object then becomes it's own module so when you select take action see below this then accepts the currentrow.variable rather than result.variable
You can reference different versions of the same workflow, which allows for breaking the workflow down into multiple parts particularly useful for User actions that may require a user's response:
CAVEAT: This means, after deployment, if you need to edit a sequenced step you'll have to create and deploy a new version of every step prior and re-link them within the StartWork function which is a pain (correct me if I'm wrong @DanHendriksen)
@DanHendriksen I've not done this justice so feel free to add anything but also this would be a huge gap-filler as a walk-through on the workflows playlist (Youtube). Thanks for the help!
NateBI
Re: 403 error in custom app calling code engine function
Which API are you using and how are you authenticating? You should be able to use the Product API endpoint for Code Engine and use the X_DOMO_DEVELOPER header to authenticate with an access token.
brycec
Re: Custom Chart from Image
I don't know where Domo posted the Canva Challenge submissions from last year. Mine was a blank brick showing Japanese Cherry Blossom dates, integrated to Domo data. Move your cursor over an image on the map and it would overlay the data for that location.
https://embed.domo.com/embed/pages/wmzPz
If your image is svg in Inkscape, then you have the individual images. Select the layer or objects that make up the component to overlay. Export "selected" to create a png with a transparent background. You can then overlay that object over your original image in the same way I did in my brick.
Re: What does your landing page look like?
@ColemenWilson Here are some of the things we show on our landing page for all users:
- Embedded Domo training videos for general navigation and interacting with cards
- FAQs - What is Domo, why do we use it, how often do our primary data sources refresh, where to go for help, etc.
- Links to the most viewed cards/dashboards from the past 30 days
- General announcements
