We have a number of complex saved searches that check for text in case statements eg case when {employeefield} = 'contractor' then 1 end
The word 'contractor' recently changed to something else and I need to change it to the new word in at least 10 saved searches and in about 15 places in each one - so lots of manual work.
I'd much prefer to reference that word somewhere so I can change it in one place if needed.
Instead of hard-coding the word 'contractor' I'd like to store all these variables somewhere??
My ideas were to either create a custom record and store it in there then access that (not sure how to reference a custom record field? is it custrecordid.fieldname?) OR
I'm doing a time search, I was wondering if I stored the values on a record linked to the time record eg project - In a saved search can I access field values on a particular project if I know it's id number? eg instead of for project fields using job.fieldname can I use job754.fieldname where 754 is the id number of a project record? - that way I could store variables on a project record and pull them into the saved search.