US Admin Office Hours (Tuesday session) - 05/09/23 - 1 pm PT / 2pm MT / 3pm CT / 4pm ET - Pre-session Thread

1. Account Scorecard History object. How to query for "accounts [a] currently in red status but [b] were not red yesterday"? We believe we have [a] covered in the below filter screen print (Company Id → Current Score -> Label = Red), we're struggling with [b].
2. Options for getting Gainsight data into Power BI (Data Designer > S3, what else is available?)
3. Sending XLSX reports as email attachments via JO has a 1K record limit per file. According to online docs there is a CSV option with unlimited records but we can't find how to choose CSV instead of XLSX.
4. How to add content from multiple Company records into the body of a JO email? For example, if a CSM is to receive the same notification regarding 10 accounts, I’d rather send one email with the 10 account names in the body, rather than 10 separate emails to the same CSM.

Hi @sdrostgainsightcom  - Were you able to find the documentation on creating a Rich Text hyperlink field? Also, have a question on Success Plans.

Here’s the details for using Concat to create a hyperlink that you write to a Rich Text field @ACT and @justo.casablanca 

@sdrostgainsightcom - how are you today? I missed the office hours unfortunately, however I had a question. We are trying to automate the Gainsight user deprovisioning as part of our offboarding process. In order to make progress with it, we need help from you or another team member to confirm if Gainsight supports SCIM or has an Open API endpoint for managing user status/ deactivating users. Is this something you can help us with?

Hello @justo.casablanca  -- glad we were able to cover so much during the session!

On pushing data to Power BI, yes, the drop-to-S3 is the best way to push data there for daily or weekly large dataloads.  If you are needing to push, say, survey results as they come in, you can use External Actions to allow the Rules Engine to call the PowerBI API directly, but that’s for a handful of records at a time.

And although building it in Data Designer is fine, I’d recommend NOT publishing the Data Designer, but instead saving it as a template and then fetching that same design into a Horizon Rule, which basically runs form the DD engine -- and you can now save designs when it makes sense and then copy them into new rules or DDs and tweak as needed.

When you do it that way, you don’t end up with the DD creating another object in your instance -the rule just runs and then drops the file to S3.

Thank you so much, @sdrostgainsightcom! Will share with the team here and circle back or join the next office hours if more questions arise. Have a lovely day & week!

@sdrostgainsightcom thank you so much for helping us think through this one! The options for snapshot date include “First Day of Previous Week” - So would we be able to use that directly, or do we need to set it as greater or equal to ‘First Day of Previous Week’ and less than ‘FIrst Day of Current Week’?

Hello @ACT -- two things going on here I think but Support will confirm:

• I don’t know that there is any way to show the live hyperlink with the way we display Rich Text. There is now always the 3 ellipses there inviting a click-to-open the full rich text field.  So even if functioning as wanted, I think they users will have to click to open the field first, then click on the rendered hyperlink.  You used to be able to show the full Rich Text field (there was an “unwrap/wrap” checkbox or something similar) in a tabular report - I’m not seeing that now and will ask internally.
• AS for the link not opening onto a new tab -- I had that working in my test org a while back and now I am seeing the same behavior as you.  The issue may be the rel=”noreferrer” attribute -- which I’m using because it was recommended to help make the new tab more secure -- I will re-check, as I’m sure someone will on the Support side will as well - there may be a different attribute needed, but I”m not sure.

I will keep an eye out on the ticket as well . . .