Andy in the Cloud

From BBC Basic to and beyond…


I started this blog to share some thoughts, ideas and opinions around my main passion in life computing, or more specifically these days Cloud computing. Who knows maybe I’ll go stray now and again into some of my others as well!

I am currently working for as CTO. Enjoying working and at times coding hard with everyone to make this new startup company a raging success! Along with our friends at and UNIT4. I am pleased to have been selected as a MVP!

I am a Salesforce MVP. For more information on the Salesforce MVP community, visit: Salesforce, Force,, Chatter, and others are trademarks of, inc. and are used here with permission.

Any views expressed on this blog are entirely my own.


139 thoughts on “About

  1. Hello, I’m having trouble using Declarative Lookup on salesforce. How could I get in touch?

  2. The Declarative Rollup looks great, is it free to use?

  3. Hi Andrew, I have a requirement where i need to develop a VF page through which i am able to create queue. So i can have functionality where user can create queue without having access to access to setup area and other permissions.

    Is there anyway to create custom queue page. Can you provide me some directions on same and if there is any other useful info related to it.

  4. I’m trying to download Declarative Lookup but am getting message that the package has been deprecated and can no longer be installed. Saying I should try installing a newer version or contact the package owner. Is there another version available and if so, how do I get a copy?

  5. that should have said- from app exchange, not – for app exchange

  6. I keep getting an error in my Relationship Criteria. I’m trying to calculate the AMOUNT of closed won opportunities YTD and for previous years (i,e., 01-01-2016 to 12-31-2016). FOr YTD, my criteria: StageName = Closed Won AND CloseDate >= 01-01-2017

    The error: Error: Relationship Criteria ‘StageName = Closed Won, CloseDate >= 01-01-2017’ is not valid, see SOQL documentation, error is ‘expecting a colon, found ‘Closed”

  7. Hi Andrew , I want to automate a report generation process :

    Report : we need to create a report containing Notes created for each lead in a month.

    What we do Manually:

    We query the data in two way : First we query all the required filed from the the Lead object . Secondly, we query notes record using lead Id as parent Id. Then we consolidate the data in Excel sheet . there is one row per Notes. Means Same lead can have 10 row in Excel if the 10 Notes have been created in a Month.

    For Automating :

    1. Created Custom controller.
    2. Fetch the record using inner query.
    3. Created a wrapper class according to the fields of Notes and Lead required in each row .
    4 Populated the data in wrapper class list.
    5. Then I created a visualforce page ( that will call the action in controller returning the list .
    6. Finally I am calling this Visualforce in a scheduler which return the data .

    But rows can be more 10000 or more . So I am getting String too large or more than 60k ..

    • I used this in page attribute : contenttype=”application/{!fileName}.xls” Page Name : AgentDealerFollowup

      I am using below code in scheduler :

      Datetime myDatetime =;
      String myDatetimeStr = myDatetime.format(‘ MMMM,yyyy’);
      EmailTemplate et = [SELECT id FROM EmailTemplate WHERE name = ‘Monthly Dealer Report Template’];
      Messaging.EmailFileAttachment attachment = new Messaging.EmailFileAttachment();
      ApexPages.PageReference report = new ApexPages.PageReference(‘/apex/AgentDealerFollowup’);
      attachment.setFileName(‘Agent Dealer Follow up’+ myDatetimeStr + ‘.xls’);
      Messaging.SingleEmailMessage message = new Messaging.SingleEmailMessage();
      message.setFileAttachments(new Messaging.EmailFileAttachment[] { attachment } );
      // message.setSubject(‘Report’);

    • Try readOnly mode for your Visualforce page, it’s an attribute

  8. Hi Andrew, I’m trying to deploy DouglasCAyers/sfdc-reloadable-visualforce-lightning-component to my salesforce sandbox and I’m getting the following error: “Failures: pages/ specified Package Version number does not exist for that Package: dlrs, 2.8.” It says deployment complete but I don’t see the custom component. Any help would be useful I’m anxious to get this working in my org and it would help a lot. P.S I’m not familiar with the processes in Github Thanks!

  9. Him Andrew, I bought your book and I think is amazing. Just to tell you that on page 59, indicates that Data Replication is a REST API, and I think it is just SOAP.
    Again, thanks a million for writing such an amazing book.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s