@simonechen Awesome question.
This scenario is very familiar to me. Setting the integration to Users where Active = TRUE seems so logical up front, until you realize then your Users can never catch that moment when your users become Inactive.
I’ve solved this issue via automation with a Bionic Rule. In your Rule:
- Fetch all the SFDC Users who are Inactive (bring their SFDC User ID in)
- Fetch all the Gainsight Users who are Active (bring their SFDC User ID in here too)
- Merge the two datasets on the SFDC User ID, using a Common Join. You’ll now have all the Users who are Inactive in SFDC and also Active in Gainsight.
- Set an Action of Load to User, where you set the field Active to FALSE.
You can schedule this rule to run daily or weekly, depending on the volume of changes you have in your SFDC User list.