How to Test for (deactivated) User?

Question

When a deactivated user is in a user field, "(deactivated)" shows up visibly in the field when viewing the record.

I would like to test for the value but have had no success.

Example: If(Right(ToText([UserField]),13)="(deactivated)","Deactivated")

It seems QuickBase displays the deactivated but it is not an actual value.

In ideas how I can test for deactivated users in a formula field?

laurathacker · Answer

Look in your Users table to see users who are Denied, Deactivated etc.

davidhawe · Answer

Thanks, I can do that manually but I am trying use this to filter a report showing who is active and who is deactivated.&nbsp;&nbsp;This is due to how the pricing structure is changing for us so we need to be minutely focused on who is active in QuickBase vs. active as an employee.&nbsp;&nbsp;We have users that are seasonal.

laurathacker · Answer

Since this information will come from the Account Level Users tab; you should really be looking there for this information.&nbsp;&nbsp;Furthermore, it will tell you when the last time was that they used an application.&nbsp;&nbsp;You can easily export this list of Users to csv and then compare with your HR lists for seasonal users.&nbsp;&nbsp;You can then add these seasonal users to your Deny-list to remove them from the User-count.&nbsp;&nbsp;Next season you can easily un-deny them.&nbsp;&nbsp;To my knowledge, you cannot ascertain this information via a formula field

lorisiegerman · Answer

I also have a need to run a report that shows all records that are owned by "Deactivated" users so i can delete their record.&nbsp; I can't view it in my user list because they are part of a domain group of over 46000 members.&nbsp; Any way to view a report that shows records owned by "deactivated" users?

evanmartinez · Answer

Hi Lori,Within your specific application you are auditing one thing that might be a good starting place is to go into your users table and use the dynamic filter for Status. One option is to pull all the users in that user table who are deactivated. That would help to narrow down to just the users listed in your users table who are marked as deactivated. Ideally that would give you a smaller pool to then search for in the application. You wouldn't be checking a user list at the Account level. I hope that suggestion is helpful.&nbsp;Currently there is not a formula function to ascertain a users status within the Account or a reporting filter for user status.&nbsp;

Forum Discussion

How to Test for (deactivated) User?

Related Content

Testing for Empty Forms

Impersonate User Permissions - Test as another user

Get the role of a user in a user field

Notification to EOTI user

Let's Test the Email Notifications