Has anyone ever used an absurdly long class list? ...
# administrationk
KevinJ of Kansas
04/12/2023, 5:34 PMHas anyone ever used an absurdly long class list? Talking thousands and thousands of records. Original design was custom records - but we don't have support for those on a couple key integrations.
s
Sam-I-Am
04/12/2023, 5:42 PMare they crazy. Why not categorize them into parent child relationship - at least will be easier to handle
j
James Morris
04/12/2023, 7:29 PMI remember having performance issues with a client that had thousands of locations way back when, but I think there's a lot more hooked into locations than class/departments.
k
KevinJ of Kansas
04/12/2023, 8:07 PMTrying to do an integration with some banks/credit cards - and they don't have the ability to add custom fields. They have the class field. We're doing Expense approval codes, like "CLIENTNAME1235Trip3.11" - then we're doing some reports on budget vs actual using the codes.
s
Sam-I-Am
04/12/2023, 8:08 PMwhy not use GL impacting custom segment?
k
KevinJ of Kansas
04/12/2023, 9:54 PMbecause the integrations don't allow it
KevinJ of Kansas
04/12/2023, 9:55 PMMy option not using class is to create a script and have them record text.
KevinJ of Kansas
04/12/2023, 9:55 PMWhich is not great.
s
Sam-I-Am
04/12/2023, 9:55 PMwow
k
KevinJ of Kansas
04/12/2023, 9:56 PMcause someone will type "ClientName12354Trip3.11" instead of the first name haha
KevinJ of Kansas
04/12/2023, 9:57 PMIt's an expense management process - where their customers have a "budget" for certain actions like trips or company parties, etc and so then the expenses need to be recorded against that budget
KevinJ of Kansas
04/12/2023, 9:57 PMso they will charge them on credit cards/bills/etc.
KevinJ of Kansas
04/12/2023, 9:58 PMI just hate to waste such a good field as the class field on this though
s
Sam-I-Am
04/12/2023, 9:58 PMnightmarish situation - no way to stop them from messing up unless have naming convention check some how
k
KevinJ of Kansas
04/12/2023, 9:58 PMWell, was going to script the lookup and do error handling, but yeah. Not a huge fan.
KevinJ of Kansas
04/12/2023, 9:59 PMI think I am just going to bite the bullet and use Class in sandbox and see how they like it.
KevinJ of Kansas
04/12/2023, 10:01 PMI did find out there's no limit on the number of records except for performance. And I'll have them inactivate the records over time.