Skip to main content
Question

How to Test for (deactivated) User?

  • October 15, 2014
  • 0 replies
  • 46 views

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?

This topic has been closed for replies.

Forum|alt.badge.img+12
  • LauraThacker
  • Registered
  • October 17, 2014
Look in your Users table to see users who are Denied, Deactivated etc.
Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
  • DavidHawe
  • Author
  • Registered
  • October 25, 2014
Thanks, I can do that manually but I am trying use this to filter a report showing who is active and who is deactivated.  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.  We have users that are seasonal.
Forum|alt.badge.img+12
  • LauraThacker
  • Registered
  • October 27, 2014
Since this information will come from the Account Level Users tab; you should really be looking there for this information.  Furthermore, it will tell you when the last time was that they used an application.  You can easily export this list of Users to csv and then compare with your HR lists for seasonal users.  You can then add these seasonal users to your Deny-list to remove them from the User-count.  Next season you can easily un-deny them.  To my knowledge, you cannot ascertain this information via a formula field
Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
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.  I can't view it in my user list because they are part of a domain group of over 46000 members.  Any way to view a report that shows records owned by "deactivated" users?
Terms & ConditionsAccessibility statement