Best Of

Re: Google (sheets) connect - This app is blocked

The Google Sheets connector is now back up! You can connect with your Google username and password, without having to add the Domo app as a trusted app, and without using a service key. One thing you'll note is that you now have to provide the URL to the spreadsheet as opposed to being able to select the file from a file picker.

Tasleema

1

Re: HTML Table Conditional Row Formatting

I went with the second option. It works perfectly. Thanks!

pwtm

1

Re: Number of business days in the month

Hi @user060355,

You can create a CASE statement in Beast mode (my 'date' colum name is 'submitted at'):

CASE
WHEN DAYOFWEEK(submitted at) = 1 OR DAYOFWEEK(submitted at) = 7 THEN 0
WHEN DAYOFWEEK(submitted at) = 2 THEN 0.5
WHEN DAYOFWEEK(submitted at) >2 AND DAYOFWEEK(submitted at) < 7 THEN 1
END

Here are the results, enhanced with additional columns for improved visualization:

You can then apply a filter to calculate a single month, etc.

Manasi_Panov

1

Re: Alleviate the jumping cursor causing BeastModes and SQL queries to be overwritten

I randomly run into this issue as well. Glad you are bringing attention to it.

MarkSnodgrass

2

Re: App Studio - Move/Copy Card Functionality

This is super important, I agree.

I've also had to create a Staging Area legacy-style page for my cards for App Studio so it's easy to find, edit, and replicate them. I don't prefer to build cards inside of App Studio, because they don't then seem to "live" anywhere inside my classic Domo instance and that can be a big admin headache.

RobynLinden

4