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

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.