I have an update action, where I need to update a varying number of objects (these can be created as a view, report, csv file, excel file, simple paste into window).
I want that my users will get a visual form, where they can select the report/view/paste values, enter the desired new data to update, and click submit.
- If I use a dynamic Choice list, than this is hardcoded, and can't be changed by users.
- I don't mind the report/view will only show ID's (If that can make any difference) -
This way, all 'returned' id's, will get the new fields values.
Another option I had in mind, is to be able to paste in the selected ID's of the objects to update (even with a limit of rows - say 50)
So, the user will have to do some tweaks, and get the list of ID's to update
That requires scrapping/looping over the 'long text area' - not sure if this is at all possible.
- Pasting the SOQL seems the worst of options, since I can't have my users learn SOQL ;-)
Any thoughts on the direction to take here?
The task should be accessible by 15% of my users, so it's widely spread. And I need it to be easy to use/handle.