Good Morning,
Currently we have a link on a customer record that we click and it opens a search and generates a large advanced pdf with a price list for the selected customer. This will then get downloaded and sent manually to the customer.
We would like to do this via a script as for example we may want to send these out on a schedule etc.
We have attempted to do this using the same search in script, but with the amount of results it is running out of governance. We then tried a second approach, using a formula in the search to shorten the results down (put multiple results in each search result).
This worked fine, the only problem then being that formula fields on searches have a limit which we were easily reaching.
Are there any suggestions for a way we generate this price list via script as these two attempts were unsuccessful?
Thank you.