You need to sign in to do that
Don't have an account?
GRStevenBrookes
Help with VF Page
I have created the following page:
<apex:page standardController="Lead" recordSetVar="Lead" tabStyle="Lead" sidebar="false" showHeader="false"> <br/> <apex:image url="http://www.goresponse.co.uk/wp-content/themes/goresponse/images/go-response-logo-landing.png" /> <br/> <br/> <apex:pageBlock title="GoResponse - Inbound Leads (Current Month)"> <apex:pageBlockTable value="{!Lead}" var="l"> <apex:column value="{!l.Id}" headerValue="Lead Id" rendered="{!IF(l.VFPage__c <>'No',true,false)}"/> <apex:column value="{!l.Name}" headerValue="Contact Name" rendered="{!IF(l.VFPage__c <>'No',true,false)}"/> <apex:column value="{!l.Company}" headerValue="Company Name" rendered="{!IF(l.VFPage__c <>'No',true,false)}"/> <apex:column value="{!l.LeadSource}" headerValue="Source" rendered="{!IF(l.VFPage__c <>'No',true,false)}"/> <apex:column value="{!l.Status}" headerValue="Status" rendered="{!IF(l.VFPage__c <>'No',true,false)}"/> <apex:column value="{!l.Disqual_Reason__c}" headerValue="Reason Declined" rendered="{!IF(l.VFPage__c <>'No',true,false)}"/> <apex:column value="{!l.Time_Created__c}" headerValue="Date/Time Created" rendered="{!IF(l.VFPage__c <>'No',true,false)}"/> <apex:column value="{!l.OwnerId}" headerValue="Lead Owner" rendered="{!IF(l.VFPage__c <>'No',true,false)}"/> </apex:pageBlockTable> </apex:pageBlock> </apex:page>
the problem i have is that the page never shows any data in public view as VFPage__c is a formula field which ofcourse is read only.....i guess that becuase of this its not rendering (although dosnt totally make sense!) is there a workaround?
Effectivly the forumla works out if the record should be displayed, the formula is:
IF( AND( MONTH(DATEVALUE( CreatedDate)) = MONTH(TODAY()), BEGINS(TEXT( LeadSource), "IB")), "Yes", "No")