Is there a way salesforce can run an outer join query report, for e.g.: List All Accounts and their opportunities (even if the accounts do not have any opportunities)?
How can we format a custom number or text field to pad zeros (0) on the left of a 5-digit number. For e.g: If user enters 346, then it should be saved and displayed as "00346".
I have tried to add Products to Opportunities via the Excel connector, but the Pricebook and Pricebook Entry IDs are system generated and I can't seem to be able to add.
