Best Of
Re: Click to Call?
Yep!
- Create a beastmode:
- CONCAT('<a href="tel:', `yourPhoneNumberField`, '">,`yourAnchorText`,'</a>')
- Use it as a field in a table card
Re: Getting "Domo is ready, but the requested file does not exist." for Excel file
Do you have a shared files master list dataset for onedrive that shows every file that has been shared? This has helped us many times in troubleshooting these types of errors. Use the OneDrive for business connector and select the Shared Items report type. Then look through the data and see if your file is there. If not, it has not been shared properly. If it is, copy and paste the name directly from the data table into the "Shared File Name" box in your other OneDrive connector.
Re: Workbench SFTP Filename Changes
Currently there isn’t an option to have workbench do this do your script is still needed. I’d recommend adding an idea to the idea exchange to add this enhancement to workbench
Re: Exception: Error retrieving a Domo API Access Token
Seems like an error with your id and secret. Can you create a new pair and try with those?
Re: ability to control the colors in a Lat/long map for a series of values
You can create multiple color rules, not just one. If you use a BeastMode to label your "New" and "Existing" values, use that for your "series for color", open up the color rules, you should be able to create a color rule for "New" and a color rule for "Existing". Alternatively, you can create a color rule for the whole series "always" and second color rule for "new" that overwrites the "always" when the series equals new.
Re: Use of Pivot Table When a Column Contains Many Variables
You would use the pivot tile in Magic ETL to do this. However, it requires you to manually name the columns and doesn't dynamically name the column based on the data.
For example, the Pivot tile converts data in this format...
... to data in this format...
... using this configuration:
Here's the KB article about it.
This will require you to update the ETL when new descriptions are created that you haven't yet accounted for. A way to manage this would be to create a card that has all the combinations and then alerts you when a new description is added.
