A Previous admin has these two non-stored fields t...
# general
j
A Previous admin has these two non-stored fields that are updating as lines on a transaction are populated. These are then stored into separate fields VIA workflow. I am trying to find out how the initial two fields are getting their data. I was not able to find a saved search within the field, cannot locate it in a workflow, oddly nothing is pointing me towards where the field could be evaluating the Transaction Line changes that seems logical. Any Ideas what I may be missing?
s
So they are non stored and doesnโ€™t have neither formula and saved search linked to them ๐Ÿค”
j
Yeah, they are evaluating line level changes as lines are entered and populating on the main transaction level so I was thinking script possibly but I can't find anything, and was not under the impression that the previous admin was a dev.
s
But non store fields does not store values unless they are referenced by saved search or formula to copy value in stored field.
j
Its also interesting because these are populated prior to the record being saved which I would imagine eliminates Saved Searches as a possibility
s
As user is making changes these lines get updated in in edit โœ๏ธ of transactions?
j
Yes
one interesting aspect is that certain roles are unable to see the value in the field and others are able to, no access restrictions in the field itself
s
It must be a client script, but then non store field does not make sense.
j
Yeah there's only 4 scripts on the scripted record page for the Vendor Bill and nothing pops out to me. I'm losing my mind haha
s
How about workflow action script?
j
Good thinking, looking at that side now
Nothing, and also then there would need to be a workflow somewhere that I could trace it from
Let me check logs on an example record
e
Check the sourcing values on the custom field definition.
s
Because it is happening as user is editing a record it could be WF action.
j
@Edgar Valdes Inside the field there is no defaulting, formulas, or Saved Search references
I'll double check all transaction workflows now to see if it is stored but the only WF History on record is for the approval flow and its not happening there.
s
WF action script does not show full logs on wf logs you might have to check scripts execution logs.
e
To be sure that we are talking about the same thing, we mean there is nothing here, right?
j
Yeah it is a Transaction Body field, nothing in either.
I messaged the guy to see if he will give us an answer because this is definitely bizarre, I just wanted to dig in to make sure every user could see the value. ๐Ÿคฃ
๐Ÿ‘ 1
t
See if the field is listed in the record catalog and see if that helps you locate the culprit
๐Ÿ‘€ 1
e
I don't use sdf as part of my workflow, but I was in a similar position some weeks ago. I did setup SDF on Visual Studio Code, imported all the objects from the account (workflows, scripts, custom fields, custom forms, etc). Searched for the field ID, found the culprit.
๐Ÿ‘€ 1
j
Yeah these arent in the Record Catalog
t
@Edgar Valdes to you have instructions on how to do that, or a link?
j
Actually, it looks to be triggering After Record Submit or similar
He said he's not sure, doesn't even know if it was his work ๐Ÿ’€
Yeah I was incorrect it is setting the value after the record is saved and after submit, so it very well could be a search, maybe just a private one I wonder
May have found it
e
How are you looking for the scripts and workflows applied to that record? There are easy ways to do that.
j
Yeah figured it out
It was a search, no search was showing in the Validation & Defaulting because the searches were private.
Same kinda thing happens with private searches inside Workflows
Also explains why specific users/roles could not see the data, they couldn't see the saved searches lol