Best Of
Re: How to Join two Group By without matching pair column
Did exactly what I was thinking with the ETL, and it works perfectly:
PJG
Re: Stop DOMO SSO user creation
Yes, you can still create users, they just won't get automatically created when the login through SSO the first time.
Automatically push data from DOMO to Excel (.xlsx)
What's the best way to automatically push the data from DOMO to Excel (.xlsx)?
FYI: I tried writeback connector (only work for .csv) and Excel plug-in (Can't automate it).
Thank you in advance for any help.
yli_2596
Re: Resizing cards within App Studio
Completely agree with this. Everytime I make changes to contents of a new tab I have to go back and resize the cards of the other tabs and there's no point of reference across tabs, so when you tried to resize it back you may also unintentionally resized down the card sizes from the first tab which has more contents.
Re: How can I get rid of extra characters in attributes
Thank you @Sean_Tully @MarkSnodgrass @GrantSmith !
Your answers are very insightful and helpful. I will definitely add them to my toolkit. I ended up using Mark's SPLIT_PART function as that was easiest and fit my criteria.
levi_kim
Re: How can I get rid of extra characters in attributes
Here's a REGEXP version:
REGEXP_REPLACE(`field`, '^\d+-([^_]+).*$', '$1')
But as @MarkSnodgrass mentioned if your format is consistent where values are after the first underscore with a following underscore then SPLIT_PART is an easier option.
The REGEX version will handle cases where there's no following underscore
Re: How can I get rid of extra characters in attributes
If it is always between the first and second underscore, you can do this:
SPLIT_PART(fieldname,'_',2)
Re: How can I get rid of extra characters in attributes
Try something like this, replacing the field with your actual field name:
SUBSTRING(SUBSTRING(`FIeld`, INSTR(`FIeld`, '_')+1), 1, INSTR(SUBSTRING(`FIeld`, INSTR(`FIeld`, '_')+1), '_')-1)
Re: How can I reach out to to the publisher of the Cloudability V3 Connector?
I think you are going to need to contact Domo Support. I don't see any information for the publisher nor links. Please don't click this as correct answer…someone from Domo may have the information to supply here.
https://domo-support.domo.com/s/article/4409676591127?language=en_US
Video for Page Filters with Forms
Could you refer a video that shows how to create a form that will populate based on lookup values from a filtered card? Also the steps to ensure any pre-requisites are set up.
I was trying to use this article.
Thank you!
nknight