Skip to main content

Hello everyone!

This thread is for our upcoming Tuesday Admin Office Hours session on Tuesday, August 22, 2023 at 1pm PT / 2pm MT / 3pm CT / 4pm ET.

Please submit your questions below as replies to this post in advance if you can, and we'll address them during the session (or if there’s a quick answer available, we’ll post as replies to the questions).

There is no need to register for these sessions - you can join at any time. Once the session is underway, I will go in order of questions posted below first, then field questions from anybody else who has joined as well. Look forward to talking with you!

Conference Details (Zoom):

Tuesday, August 22, 2023 at 1pm PT / 2pm MT / 3pm CT / 4pm ET

 

Join Zoom Meeting:

https://gainsight.zoom.us/j/92587328600?pwd=WS9TVDJWOTZpOTFxVFlxeGZwblJKUT09

 

Meeting ID: 925 8732 8600

Password: 970938

 

For dial-in info by your location, find your local number: 

https://gainsight.zoom.us/u/aetAGucgRy

What is the schedule for Office hours? I want to add it to my calendar :) 


Need help modifying a Tab on 360 layout. 


Hi Scott,

Is there a way to suspend/postpone ALL rule and data designer job schedules say for a day or 2 without removing the scheduled events?

Thanks,

Sean

 

 


I have a rule that is populating a Date diff formula into a field in the Relationship object-- I’m trying to convert days somehow to Weeks, and I’m having some trouble doing that. Need a little bit of guidance. 


Can a CTA be triggered based of a survey submission using Event framework, rather than rule that runs every 2 hours.

Use case: A survey form that has questions, once submitted can trigger CTA’s.

I have successfully created a survey, that can trigger CTA’s but was hoping there is an efficient way to create CTA rather than rules engine. 


Hello @tiffany_hui -- actually had a chance to test a little bit on using Date Diff formula field in Advanced Formula field and it does work . . . . the syntax for this is in my example below with the DateDiff function in bold.

In my case, I have a CASE statement that says if my “CSM End Date” is null, just return 0, otherwise, calculate the DateDiff in weeks.  You could do the same building out a case statement to decide which “end” field to use if I’m remembering correctly (can’t remember if you are pulling the dates via rule from a different table or not) - but this is how it would look:

case when CSM_End_Date__gc is null then 0 else gsdateDiff( CSM_Start_Date__gc , CSM_End_Date__gc , 'WEEK' ) end

Also useful - I created a simple DateDiff formula, then clicked Advanced Formula and it translated into the Advanced Formula syntax for that function (that’s the part I have in bold - then I added the Case around it).

Don’t know if you’ve already gone another route but wanted to give you the option for this if it comes up again down the road as well as for the current use case.


Reply