We are FINALLY getting access to the last login date for users into our community. This has always been there, but is now being logged to Salesforce. How exciting!
Obviously, I want to incorporate this into our Health Scoring scheme as soon as possible. The date itself will be stored in a field on the Contact object. My goal would be to compare the last login date of select Contacts on an account and find the "Most Recent Community Login Date" for that overall Account.
I am guessing this can be done with a Bionic Rule. Has anyone accomplished this, and if so, can you provide guidance?
Thanks!
Page 1 / 1
Ben,
You will need to query the Contacts and set your show fields to Account ID and MAX Most Recent Community Login Date.
This will return a dataset with the MAX date by Account.
Hope this helps.
You will need to query the Contacts and set your show fields to Account ID and MAX Most Recent Community Login Date.
This will return a dataset with the MAX date by Account.
Hope this helps.
MAX, that is genius Rob. Sometimes it is hard to know what these operators due depending on the data set (i.e. MAX of a date = most recent). Thanks for interpreting!
Yep, I've used this with MIN as well to get the earliest of a group of dates. Works well!
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.