Populate values list from report
A few weeks ago I asked if there was a way to make the key of a cross referenced field viewable without actually granting access to the record. The use case is inheriting controls. We want to be able to show what it's inheriting from without actually granting access to that record.
The workaround I came up with is to use a values list, but I don't want to have to manually populate the values list. Is there a way to populate the values of a values list from a report via a data feed or something else without an actual record to update?
There is no way to do so, AFAIK, without granting access to the record.
I used 3 ways to remediate it:
1. I used Private Fields, and allowed access only to some generic fields.
2. Calculation do not care about access rights, so you can calculate some context data or create calculated deep link for any user to any record for context.
3. Created intermediate ODA with all generic info needed and synced with main record I did not want to give access to.
And surely, API could possibly do it, but with elevated access session, or DF, but DF needs to update record still.
I considered calculations, but the cross reference will sometimes have multiple values.
What I'd like to do is instead is have a values list available with all possible records from that application. I'm not sure what the best way is to populate the values list without manually updating it periodically. Is there a way to, for example, have a report of all the records and populate a values list with those record names to be used?
Unless you invent some sort of a trigger for launching DF based on some condition, you would have to rely on frequency.
E.g. you can use DF Monitor Tool, but it still would require some trigger condition, like, count of record changed. Or upon DF execution all record used up will be marked, and then unmarked upon any change. Then DF Monitor can be used.
That's ok, I'm just not sure how to populate values list selections without an actual record to update, or if it's possible. Ex.
Application has records square, circle, triangle
Run a datafeed (or something else) to update values list possible selections to be square, circle, triangle
Record called rectangle is added to the application. The next time the feed (or whatever mechanism) runs, rectangle is added to the values list selection field.
Can a global values list be populated with a data feed?
I may have just thought of a way. Authorization Package uses workflow, and as part of our final datafeed, I can have a values list field where it just populates it with itself, thereby updating the global values list. It's a little clunky but should work.
That's actually what I ultimately need it for, use in another application.
In this particular case, I can make it work. When an Authorization Package is completed, it runs a data feed to create POA&Ms, so the record is being updated with those xrefs anyway. Updating a values list field with it's own name wouldn't add an additional step. It's not ideal, but could be worse.