• Lukasz Piziak
  • NEWBIE
  • 175 Points
  • Member since 2014
  • Hosetech Ltd

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 43
    Questions
  • 52
    Replies
Hi everyone,

I'm trying to create a very simple formula and have dificulties. Hope you will be able to help me.

On my flow I have 2 screens with radio button choices. I would like to get the formula working on the following criteria.

If Hose_Accessories_Required selected value is "NO" or Accessories_Required11 selected value is "No" formula should use value "00" and for all other combinations result should be value of the following flow formula {!AccXXcode}, 

Please see attached screenshoots
Screen 1Screen2

Many thanks for help
Hi Everynone,

On one hand I have a set of values storred in variables and on another hand I have SCMC_Item__c object were have records with multiple fields.
I want to use my variable values and search in all records belongs to SCMC_Item__c object and get a value of a different field from this object.

I presume Fast Lookup and Sobject Collections and Loop would be required. 

Appriciate any help with this.

Thanks
Hello guys, I'm wondering if you can help me with re-constarcting formula below in relation to the 3.000 bytes compiled size limit. Following formula is based on a user colour selection of the picklist field and is resulting with the proper code. My issue is that I need to add more colour options and unfortunatelly I'm hitting size limit.

!IF( ISPICKVAL(SCMC__Production_Order__c.Label_Band_Colour__c , "Black"), SCMC__Production_Order__c.Large_Label_Black_Band__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Band_Colour__c , "Blue"), SCMC__Production_Order__c.Large_Label_Blue_Band__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Band_Colour__c , "Brown"), SCMC__Production_Order__c.Large_Label_Brown_Band__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Band_Colour__c , "Green (Dark)"), SCMC__Production_Order__c.Large_Label_Green_Dark_Band__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Band_Colour__c , "Green (Light)"), SCMC__Production_Order__c.Large_Label_Green_Light_Band__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Band_Colour__c , "Red"), SCMC__Production_Order__c.Large_Label_Red_Band__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Band_Colour__c , "Yellow"), SCMC__Production_Order__c.Large_Label_Yellow_Band__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Band_Colour__c , "Grey"), SCMC__Production_Order__c.Large_Label_Grey_Band__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Band_Colour__c , "Purple"), SCMC__Production_Order__c.Large_Label_Purple_Band__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Band_Colour__c , "Orange"), SCMC__Production_Order__c.Large_Label_Orange_Band__c , 


IF(ISPICKVAL( SCMC__Production_Order__c.Label_Body_Colour__c , "Black"), SCMC__Production_Order__c.Large_Label_Black_Body__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Body_Colour__c , "Blue"), SCMC__Production_Order__c.Large_Label_Blue_Body__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Body_Colour__c , "Brown"), SCMC__Production_Order__c.Large_Label_Brown_Body__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Body_Colour__c , "Green (Dark)"), SCMC__Production_Order__c.Large_Label_Green_Dark_Body__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Body_Colour__c , "Green (Light)"), SCMC__Production_Order__c.Large_Label_Green_Light_Body__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Body_Colour__c , "Orange"), SCMC__Production_Order__c.Large_Label_Orange_Body__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Body_Colour__c , "Red"), SCMC__Production_Order__c.Large_Label_Red_Body__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Body_Colour__c , "Yellow"), SCMC__Production_Order__c.Large_Label_Yellow_Body__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Label_Body_Colour__c , "Grey"), SCMC__Production_Order__c.Large_Label_Grey_Body__c , 



IF(ISPICKVAL( SCMC__Production_Order__c.Stripped_Band_Colour__c , "Black"), SCMC__Production_Order__c.Large_Black_Stripped_Band_Label__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Stripped_Band_Colour__c , "Blue"), SCMC__Production_Order__c.Large_Blue_Stripped_Band_Label__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Stripped_Band_Colour__c , "Green (Light)"), SCMC__Production_Order__c.Large_Green_Light_Stripped_Band_Label__c , 
IF(ISPICKVAL( SCMC__Production_Order__c.Stripped_Band_Colour__c , "Red"), SCMC__Production_Order__c.Large_Red_Stripped_Band_Label__c , 
SCMC__Production_Order__c.Large_Label_Standard__c )))))))))))))))))))))))

Many Thanks for help
Hi,
I have a formula below which is working fine.

IF(
    AND(
         CONTAINS({!Matching_Hose_Records}, "POLYSIL PFA"),
         CONTAINS({!Fitt1Selection}, "POLYSIL")
        ),
"POLYSIL", 
NULL)

I would like to add another condition to this formula
IF(
    AND(
         CONTAINS({!Matching_Hose_Records}, "POLYSIL PFA"),
         CONTAINS({!Fitt1Selection}, "BRITELOK")
        ),
"BRITELOK", 
NULL)

Code should look like like this below:
IF(
    AND(
              OR(
         CONTAINS({!Matching_Hose_Records}, "POLYSIL PFA"),
         CONTAINS({!Fitt1Selection}, "POLYSIL")
        ), "POLYSIL", 
IF(
    AND(
        OR(
         CONTAINS({!Matching_Hose_Records}, "POLYSIL PFA"),
         CONTAINS({!Fitt1Selection}, "BRITELOK")
        ), "BRITELOK", NULL))

I'm getting error message in my flow. Please advise the proper form of this formula.

Many thanks for any help.
Regards
Lukasz
Hi All,
I'm wondering if someone can help me with creating formula to convert field input to the 3digit code. In my application user is providing a length in mm. eg value of 1000mm for 1 meter. My code structure is as follow:
 Code   Value
0           0
1           1
2           2
3           3
4           4
5           5
6           6
7            7
8            8
9            9
A         10
B          11
 So for the following length of 11.5MT code should be B50
                                         for 10.85MT code should be A85
I can have two seperate field input, first for meters only and second for cm if that would help with converting to the required code.

Many thanks for any ideas.
Regards
Lukasz
Hi, 
I'm looking for help with creating CASE formula to work with two criterias:
Below formula is working fine,
CASE( SCMC__Production_Order__c.Label_Band_Colour__c ,'Red', Red Band ,'Black', Black Band, N/A)

What if I would like to add another criteria to formula above? e.g
CASE( SCMC__Production_Order__c.Label_Band_Colour__c ,'Red', Red Band ,'Black', Black Band, N/A)
OR
CASE( SCMC__Production_Order__c.Body_Colour__c ,'Red', Red Body ,'Black', Black Body, N/A)

Thanks for any help with this

Regards
Lukasz
Hi, 
The following code is aligning all my text fields on the PDF as a one string, 
<apex:page standardController="Short_Length_Piece__c" extensions="ShortLengthPieceController" renderAs="PDF" showHeader="false" sidebar="false">
<apex:styleSheet value="{!URLFOR($Resource.Label29)}" />  
<body>     
        <left style="font-size:20px; font-weight:600; font-family:sans-serif;"> {!shortlength.Name} </left>
        <left style="font-size:20px; font-weight:600; font-family:sans-serif;"> {!shortlength.Piece_Length__c} MT </left>
       <left style="font-style:italic; font-size:15px; font-family:sans-serif;"> {!shortlength.Item_Number__c} </left>
       <left style="font-style:italic; font-size:15px; font-family:sans-serif;"> {!shortlength.Item_Description__c} </left>
       
       
</body>
</apex:page>

My question is if its possible to align each line individually one under the other instead of having one long text stream?
I have used the following CSS fomrating:
@page { size: 3.93in 1.14in; margin-top: 0.5px; margin-bottom: 1px; margin-right: 5px; margin-left: 5px; }

Can you advise?
Best regards
Lukasz
Hello,

I'm looking for help with creation the Validation Rule based on Status field (Picklist) and Roll-Up Summary field. Basically I would like to avoid user approving the record when the SCMC__Total_Value_of_PO__c is equal zero. I have creatwd the following formula, but system is allowing me to approve the record, please see below:

AND(
    ISPICKVAL(SCMC__Status__c,"Approved"),
    ISNULL( SCMC__Total_Value_of_PO__c)
)

When there is no value on Roll-Up Summary field the following data is displayed; EUR 0.00.
Thanks for any advise.

Regards
Lukasz
 
Hello,

I need asistance with creation workflow rule formula for the following scenario:

Formula should return TRUE only when Status field (picklist) was changed from value "Placed on Purchase Order" to value "Approved"
My question: Is it possible to create a formula which will work only with these specific status values?

Thank you for any advise.
Regards
Lukasz
Hi,
I have requirement to create a simple VF page rendered as PDF with two text lines only. So far I was able to create VF page + controller + custom button. My question is how I can controll my text lines separeatelly in sense of text alligment, font size and font colour? I have produced a css style sheet which actually is controlling the whle page behaviour. Please see below my VF Page and CSS style sheet.

VF
<apex:page standardController="SCMC__Receipt_Line__c" extensions="ReceiptLineController" renderAs="PDF" showHeader="false" sidebar="false"> 
<apex:styleSheet value="{!URLFOR($Resource.Label)}" />  
    <apex:panelGrid columns="1">
        <apex:outputField value="{!receipt.SCMC__Item_Number__c}"/> 
        <apex:outputField value="{!receipt.SCMC__Item_Description__c}"/> 
    </apex:panelGrid> 
</apex:page>

CSS Style Sheets

@page {
    size: 3.93in 1.14in;
    margin:8px 8px 8px 8px;
}
body {
    font-family: sans-serif;
    font-size: 125%;
    text-align: left;
}

Thanks for any help.
I will appreciate any help with exact explannation as I'm very new to the VF.
Regards,
Lukasz
Hi,
Does any one maybe came a cross of using the Visual Workflow as a assembly product configurator? My assembly product would be build from the components and each selection is depended from the previous selection. Below are my questions?
  1. On the first screen user will be typing the assembly product name and if there is already existing record shoudl be notified, if assembly is not existng should be taken through the configuration process of composing components as assembly product. Is it possible to achieve this functionality with Visual Workflow?
  2. When user is prompted to create new assembly product, the individual selections can be based on the previous one? e.g if selected blue colour should only get as an option to select only blue components?
  3. Each component record will include an individual component code, Is it possible to use formula that when the assembly product is configured formule will show all codes of the single components as a one long code?
I will appreciate any ideas or suggestions of how the similar functionality  was achieved.

Thanks
 
Hi, 
I have made a custom report and custom button on custom object, when click on the button system is opening report page on the new window.
I had given the following functionality on the button:
Display Type: Detail Page Button
Behaviour: Display in new window
Content Source: URL

my link https://eu2.salesforce.com/00Ob0000004Z1nF?pv0={!SCMC__Item__c.Name}

Is there a way of configuring the button to display the report in the new tab window rather than new window?

Thanks for any help.
I have tried to follow the solution provided https://developer.salesforce.com/forums/?id=906F0000000AfExIAK but getting some errors.
Hello,

I'm looking for help with creaing formula field (text type) based on 3 checkbox fields. E.g

1. if checkbox 1 is true and checkbox 2 is false and Checkbox 3 is false, formula should populate 'A',
​2. if checkbox 1 is false and checkbox 2 is true and Checkbox 3 is false, formula should populate 'B', 
​1. if checkbox 1 is false and checkbox 2 is false and Checkbox 3 is true, formula should populate 'C', 

Thanks for any help
Regards,
Lukasz
Hi,
I'm looking for help with creating a formula field which will display a user name who changed value on the specific date/time type field. I can not use last modified by because record can be edited by many other users. All what I'm trying to acheve is to display user name who changed date/time on my particular field.

Thanks for any ideas.
Lukas
Hi,

I'm just wondering if somoene can help us with the following task.
We would like to create a warning pop up window when some certain cruteria are met. 
User should see this window pop up when the status field value is 'Partially Allocated' with the warning text and then after clicking 'OK' on this window shoudl be back to the record page to complete job.

Thanks for any suggestions.
Hi,

I have created an extension for my VF page where I'm sorting data by SCMC__Start_Date__c. My question is if its possible also to group by Sales_Order_No__c so system is dispalying valuse groupped together by Sales Order Number and Start date. 
How should I create my code to achieve that?
Below is code I'm using currently:

objlist = [SELECT Name, Sales_Order_No__c,Customer__c, Assembly_Name__c, SCMC__Start_Date__c, SCMC__Planned_Completion_Date__c, 
    SCMC__Production_Status__c FROM SCMC__Production_Order__c Where SCMC__Production_Status__c = 'Pending Pulling All Items'
    ORDER by SCMC__Start_Date__c];

Thank you for any ideas.
Regards,
Lukasz
Hi,

Does anyone came across of having to transfer or profile settings from salesforce custom profile to salesforce platform profile?
Unfortunately when cloning profiles in salesforce when this profile is salesforce license can only be cloned as salesforce license profile nor e.g cloned as salesforce platform license profile.

Maybe by using dataloader or similar?

Regards,
Lukasz
Hi,

I'm looking for help with creating WHERE query.
My current query:
 salesOrderList = [SELECT Name, SCMC__Customer_Account__c, Type__c, SCMC__Current_Promise__c, SCMC__Shipment_Status__c 
    From SCMC__Sales_Order__c Where Type__c='Production_Sales_Order' Order by SCMC__Current_Promise__c];
I would like to add another filter condition
Where Type__c='Production_Sales_Order'  
AND 
SCMC__Shipment_Status__c='Pending Pulling All Items' 
AND
SCMC__Shipment_Status__c='Pending Pulling Partial Items Ordered' 

Thank you for any help.
Help please, 

public class TestExtension {
    public List<SCMC__Production_Order__c> objlist{get;set;}
    public List<SCMC__Sales_Order__c> salesOrderList{get;set;}
    public TestExtension(ApexPages.StandardSetController controller) {
    objlist = [SELECT Name, Sales_Order_No__c,Customer__c, Assembly_Name__c, SCMC__Start_Date__c, SCMC__Planned_Completion_Date__c, SCMC__Production_Status__c
FROM SCMC__Production_Order__c Where SCMC__Production_Status__c = 'Pending Pulling All Items'ORDER by SCMC__Planned_Completion_Date__c];

    salesOrderList = [SELECT Name, SCMC__Customer_Account__c, Type__c, SCMC__Current_Promise__c Where Type__c = 'Production Sales Order' Order by SCMC__Current_Promise__c];
    }
}
HELP PLEASE!!!!!!


public class TestExtension {
    public List<SCMC__Production_Order__c> objlist{get;set;}
    public List<SCMC__Sales_Order__c> salesOrderList{get;set;}
    public TestExtension(ApexPages.StandardSetController controller) {
    objlist = [SELECT Name, Sales_Order_No__c,Customer__c, Assembly_Name__c, SCMC__Start_Date__c, SCMC__Planned_Completion_Date__c, SCMC__Production_Status__c
FROM SCMC__Production_Order__c Where SCMC__Production_Status__c = 'Pending Pulling All Items'ORDER by SCMC__Planned_Completion_Date__c];

    salesOrderList = [SELECT Name, SCMC__Customer_Account__c, Type__c, SCMC__Current_Promise__c Where Type__c = 'Production Sales Order' Order by SCMC__Current_Promise__c];
    }
}
 
During deploying my App from sandbox to production environment I have got 1 error message that there is a duplication of Workflow field update data type ( see attached screenshot).

What I should do next? Delete this Change set in production environment and the same on sandbox and start again from the scrutch without adding this one field update? Or is there a way to remowe this component from change sets component list and try again?

Thanks for any help.

LukaszDeployment failure details view.

Hi, 
I'm looking for help with creating CASE formula to work with two criterias:
Below formula is working fine,
CASE( SCMC__Production_Order__c.Label_Band_Colour__c ,'Red', Red Band ,'Black', Black Band, N/A)

What if I would like to add another criteria to formula above? e.g
CASE( SCMC__Production_Order__c.Label_Band_Colour__c ,'Red', Red Band ,'Black', Black Band, N/A)
OR
CASE( SCMC__Production_Order__c.Body_Colour__c ,'Red', Red Body ,'Black', Black Body, N/A)

Thanks for any help with this

Regards
Lukasz
Hello,

I need asistance with creation workflow rule formula for the following scenario:

Formula should return TRUE only when Status field (picklist) was changed from value "Placed on Purchase Order" to value "Approved"
My question: Is it possible to create a formula which will work only with these specific status values?

Thank you for any advise.
Regards
Lukasz
Hi,
I have requirement to create a simple VF page rendered as PDF with two text lines only. So far I was able to create VF page + controller + custom button. My question is how I can controll my text lines separeatelly in sense of text alligment, font size and font colour? I have produced a css style sheet which actually is controlling the whle page behaviour. Please see below my VF Page and CSS style sheet.

VF
<apex:page standardController="SCMC__Receipt_Line__c" extensions="ReceiptLineController" renderAs="PDF" showHeader="false" sidebar="false"> 
<apex:styleSheet value="{!URLFOR($Resource.Label)}" />  
    <apex:panelGrid columns="1">
        <apex:outputField value="{!receipt.SCMC__Item_Number__c}"/> 
        <apex:outputField value="{!receipt.SCMC__Item_Description__c}"/> 
    </apex:panelGrid> 
</apex:page>

CSS Style Sheets

@page {
    size: 3.93in 1.14in;
    margin:8px 8px 8px 8px;
}
body {
    font-family: sans-serif;
    font-size: 125%;
    text-align: left;
}

Thanks for any help.
I will appreciate any help with exact explannation as I'm very new to the VF.
Regards,
Lukasz
Hi,
I'm looking for help with creating a formula field which will display a user name who changed value on the specific date/time type field. I can not use last modified by because record can be edited by many other users. All what I'm trying to acheve is to display user name who changed date/time on my particular field.

Thanks for any ideas.
Lukas
Hi,

I'm just wondering if somoene can help us with the following task.
We would like to create a warning pop up window when some certain cruteria are met. 
User should see this window pop up when the status field value is 'Partially Allocated' with the warning text and then after clicking 'OK' on this window shoudl be back to the record page to complete job.

Thanks for any suggestions.
Hi,

I'm looking for help with creating WHERE query.
My current query:
 salesOrderList = [SELECT Name, SCMC__Customer_Account__c, Type__c, SCMC__Current_Promise__c, SCMC__Shipment_Status__c 
    From SCMC__Sales_Order__c Where Type__c='Production_Sales_Order' Order by SCMC__Current_Promise__c];
I would like to add another filter condition
Where Type__c='Production_Sales_Order'  
AND 
SCMC__Shipment_Status__c='Pending Pulling All Items' 
AND
SCMC__Shipment_Status__c='Pending Pulling Partial Items Ordered' 

Thank you for any help.
Help please, 

public class TestExtension {
    public List<SCMC__Production_Order__c> objlist{get;set;}
    public List<SCMC__Sales_Order__c> salesOrderList{get;set;}
    public TestExtension(ApexPages.StandardSetController controller) {
    objlist = [SELECT Name, Sales_Order_No__c,Customer__c, Assembly_Name__c, SCMC__Start_Date__c, SCMC__Planned_Completion_Date__c, SCMC__Production_Status__c
FROM SCMC__Production_Order__c Where SCMC__Production_Status__c = 'Pending Pulling All Items'ORDER by SCMC__Planned_Completion_Date__c];

    salesOrderList = [SELECT Name, SCMC__Customer_Account__c, Type__c, SCMC__Current_Promise__c Where Type__c = 'Production Sales Order' Order by SCMC__Current_Promise__c];
    }
}
Hi,

We have created a VF page to display records from 'Production Order' object as a pageBlock with pageBlockSections.
Is it possible to display on anothre pageBlock section within the same VF page records from different object? In my case 'Sales Orders'? I'm new to APex and Visualforce page and I will appreciate any help.

Below is my VF page Code
<apex:page standardController="SCMC__Production_Order__c" sidebar="false" showheader="true" recordSetVar="SCMC__Production_Order__c" extensions="TestExtension,TestExtension2">

<html>
<head>
<META http-equiv="refresh" content="60"/>
</head>
</html>

<apex:form >
<apex:pageBlock rendered="True" title="Production Work Orders">
<apex:pageBlockSection title="Production Orders to Fill">
<apex:pageBlockTable value="{!objlist}" style="width:1220px" var="item">
<apex:column style="width:100px" headerValue="Production Order No.">
<apex:outputLink value="/{!item.id}" target="_blank">
{!item.Name}
</apex:outputLink>
</apex:column>
<apex:column style="width:100px" value="{!item.Sales_Order_No__c}"/>
<apex:column style="width:100px" value="{!item.Customer__c}" headerValue="Customer Name"/>
<apex:column style="width:200px" value="{!item.Assembly_Name__c}" headerValue="Hose Description"/>
<apex:column style="width:100px" value="{!item.SCMC__Start_Date__c}" headerValue="Production Start Date"/>
<apex:column style="width:100px" value="{!item.SCMC__Planned_Completion_Date__c}" headerValue="Planned Completion Date"/>
<apex:column style="width:100px" value="{!item.SCMC__Production_Status__c}"/>
</apex:pageBlockTable>
</apex:pageBlockSection>

<apex:pageBlockSection title="Production Order in Progress">
<apex:pageBlockTable value="{!objlist2}" style="width:1220px" var="item">
<apex:column style="width:100px" headerValue="Production Order No.">
<apex:outputLink value="/{!item.id}" target="_blank">
{!item.Name}
</apex:outputLink>
</apex:column>
<apex:column style="width:100px" value="{!item.Sales_Order_No__c}"/>
<apex:column style="width:100px" value="{!item.Customer__c}" headerValue="Customer Name"/>
<apex:column style="width:200px" value="{!item.Assembly_Name__c}" headerValue="Hose Description"/>
<apex:column style="width:100px" value="{!item.Hose_Assembly_By__c}" headerValue="Technician"/>
<apex:column style="width:100px" value="{!item.SCMC__Planned_Completion_Date__c}" headerValue="Planned Completion Date"/>
<apex:column style="width:100px" value="{!item.SCMC__Production_Status__c}"/>
</apex:pageBlockTable>

</apex:pageBlockSection>
</apex:pageBlock>

</apex:form>
<apex:pageBlock rendered="True" title="Production Sales Orders">
<apex:pageBlockSection title="Production Sales Orders to Fill">
</apex:pageBlockSection>
</apex:pageBlock>

</apex:page>

Controller 1
public class TestExtension {
    public List<SCMC__Production_Order__c> objlist{get;set;}
    public TestExtension(ApexPages.StandardSetController controller) {
    objlist = [SELECT Name, Sales_Order_No__c,Customer__c, Assembly_Name__c, SCMC__Start_Date__c, SCMC__Planned_Completion_Date__c, SCMC__Production_Status__c
FROM SCMC__Production_Order__c Where SCMC__Production_Status__c = 'Pending Pulling All Items'ORDER by SCMC__Planned_Completion_Date__c];
    }
}

Controller 2
public class TestExtension2 {
    public List<SCMC__Production_Order__c> objlist2{get;set;}
    public TestExtension2(ApexPages.StandardSetController controller) {
    objlist2 = [SELECT Name, Sales_Order_No__c, Customer__c, Assembly_Name__c,Hose_Assembly_By__c, SCMC__Planned_Completion_Date__c, SCMC__Production_Status__c
FROM SCMC__Production_Order__c Where SCMC__Production_Status__c = 'Pulled All Items'ORDER by SCMC__Planned_Completion_Date__c];
    }
}
Hi,

I'm looking for solution of having as default sorting my records in VF column by date field {!item.SCMC__Planned_Completion_Date__c} in ascending order. i will appreciate any help. Thanks. 

VF page
<apex:pageBlock rendered="True" title="Production Orders">
<apex:pageBlockSection title="Production Orders to Fill">
<apex:pageBlockTable value="{!objlist}" style="width:1220px" var="item">
<apex:column style="width:100px" headerValue="Production Order No.">
<apex:outputLink value="/{!item.id}" target="_blank">
{!item.Name}
</apex:outputLink>
</apex:column>
<apex:column style="width:100px" value="{!item.Sales_Order_No__c}"/>
<apex:column style="width:100px" value="{!item.Customer__c}" headerValue="Customer Name"/>
<apex:column style="width:200px" value="{!item.Assembly_Name__c}" headerValue="Hose Description"/>
<apex:column style="width:100px" value="{!item.SCMC__Start_Date__c}" headerValue="Production Start Date"/>
<apex:column style="width:100px" value="{!item.SCMC__Planned_Completion_Date__c}" headerValue="Planned Completion Date"/>
<apex:column style="width:100px" value="{!item.SCMC__Production_Status__c}"/>
</apex:pageBlockTable>
</apex:pageBlockSection>

Controller

public class TestExtension {
    public List<SCMC__Production_Order__c> objlist{get;set;}
    public TestExtension(ApexPages.StandardSetController controller) {
    objlist = [SELECT Name, Sales_Order_No__c,Customer__c, Assembly_Name__c, SCMC__Start_Date__c, SCMC__Planned_Completion_Date__c, SCMC__Production_Status__c
FROM SCMC__Production_Order__c Where SCMC__Production_Status__c = 'Pending Pulling All Items'];
    }
}
Hi,

How I can change my record name PRO-00139 as a hyperlink on my pageBlockTable to be able to click on this name and open record?
I'm really new to the Visualforce page and any help would be appreciated.

Screenshot
Hi,
We have created VF page with two tables related to our Production Order object. Each table is dispalying the production orders depended by the status. My Production Order record name is something like this: PRO-000203. My issue is that I would like to be able to click on this record and open it. Unfortunately there is only name displayed without underscore line suggesting that this is like link.

Thanks for any help.
Below is a screen capture
User-added image 
Hi All,

Is there a way of populating a list of records in the PageBlockTable Section based on a filter criteria? Basically I have a records with different production status value. Let say I have 20 records with status = open and 45 records with status value = complete,
I woudl like  to dispaly records with satus open only. 

Thank you for any suggestions and help.

Below is my code for my table:

<apex:page standardController="SCMC__Production_Order__c" sidebar="false" showheader="false" recordSetVar="SCMC__Production_Order__c">

<apex:form >
<apex:pageBlock rendered="True" title="Production Orders">
<apex:pageBlockSection title="Production Orders to Fill">
<apex:pageBlockTable value="{!SCMC__Production_Order__c}" style="width:1220px" var="item">
<apex:column style="width:100px" headerValue="Production Order No." value="{!item.name}" />
<apex:column style="width:100px" value="{!item.Sales_Order_No__c}"/>
<apex:column style="width:100px" value="{!item.Customer__c}" headerValue="Customer Name"/>
<apex:column style="width:200px" value="{!item.Assembly_Name__c}" headerValue="Hose Description"/>
<apex:column style="width:150px" value="{!item.SCMC__Start_Date__c}" headerValue="Production Start Date"/>
<apex:column style="width:150px" value="{!item.SCMC__Planned_Completion_Date__c}" headerValue="Planned Completion Date"/>
<apex:column style="width:150px" value="{!item.SCMC__Production_Status__c}"/>
</apex:pageBlockTable>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>
 
Hi

I assume this is simple enough, but don't want to waste time figuring it out.  I'm trying to render the Name of a Record as a link to the Record in a column of a pageBlockTable.

I'm using this syntax currently:

Code:
<apex:column headerValue="Name">
      <apex:outputLink value="{!lead.Id}">{!lead.Name}</apex:outputLink>
</apex:column>

 Supposing I'm on a na2.salesforce.com, this will output the link as https://na2.salesforce.com/apex/00Q4000000HA9xUEAT.  Obviously I don't want the /apex/ in the URL.  I know I want to use the current server as the value in outputLink and the Record ID as a param, but how do I merge in the URL of the current server?

Thanks!