Sign Up ›
  • Melissa Parker 17
  • NEWBIE
  • 0 Points
  • Member since 2015
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 7
    Replies
12 replies

Invalid field for SObject when building a table of data in a Visualforce page

I am attempting to create a Visualforce Email template that basically emails the contact and shows its related list of Assignments__c in the template.

I am following the document here: https://developer.salesforce.com/page/VisualForceEmailTemplates_sample

However I am receiving an error: Error: Invalid field Contact for SObject Assignments__c

<messaging:emailTemplate subject="Tomorrow's Inspections and Homeowner Closing Appointments" 
recipientType="Contact" 
relatedToType="Assignments__c">

<messaging:htmlEmailBody >
 <html>
            <body>

            <p>Dear {!recipient.name},</p>
            <p>Attached is your inspection schedule for tomorrow. Please review it to make sure there is enough time allowed between inspections. 
            Call Rick Werts (863) 207-6550 with any changes that are necessary to make sure we are making every appointment on time. 
            Thank you for all of your hard work out there.

            Thank you,

            Bill Todd
            V.P. of Sales
</p>
            <table border="0" >
                <tr>
<th>Policyholder Name</th><th>Risk Street</th>
                    <th>Risk City</th><th>Risk State</th>
                    <th>Risk Zip Code</th><th>Inspection Date and time</th>
                    <th>Homeowner Closing Appt</th>
                </tr>
                <apex:repeat var="cx" value="{!relatedTo.Contact.Assignments__c}">
                <tr>
                    <td><a href = 
                        "https://cs50.salesforce.com/{!cx.id}">{!cx.Assignments.Name}
</a></td>
                    <td>{!cx.Assignments.Risk_Street_Address__c}</td>
                    <td>{!cx.Assignments.Risk_State_Address__c}</td>
                    <td>{!cx.Assignments.Risk_City__c}</td>
                    <td>{!cx.Assignments.Risk_Zip_Code_Address__c}</td>
                    <td>{!cx.Assignments.Inspection_Date_and_Time__c}</td>
                    <td>{!cx.Assignments.Homeowner_Closing_Appt__c}</td>
                </tr>
                </apex:repeat> 
            </table>
            <p/>
            <center>
                <apex:outputLink value="http://www.salesforce.com">
                    For more detailed information login to Salesforce.com
                </apex:outputLink>
            </center>
            </body>
        </html>
    </messaging:htmlEmailBody>
</messaging:emailTemplate>
3 replies

Error Occurred During Flow "Other_Trades_Update": geopointe:Too many SOQL queries: 201

hello,

I am receiving this error during a Process Builder. This particular Process has many updates that timestamps fields when each fields associated checkbox is checked. This is very lengthy, however, at the end of the report the results are: Failed to update records that meet the criteria. 

An error occurred at element myRule_1_A2 (FlowRecordUpdate).
geopointe:Too many SOQL queries: 201

Flow Details
Flow Name: Other_Trades_Update
Type: Workflow
Version: 4
Status: Active

Flow Interview Details
Interview Label: 
Current User: MadSky Admin (00561000000ZrJo)
Start time: 3/6/2016 12:17 PM
Duration: 0 seconds

How the Interview Started
MadSky Admin (00561000000ZrJo) started the flow interview.
Some of this flow's variables were set when the interview started.
myVariable_old = a0M61000001zAAFEA2
myVariable_current = a0M61000001zAAFEA2

ASSIGNMENT: myVariable_waitStartTimeAssignment
{!myVariable_waitStartTimeVariable} Equals {!Flow.CurrentDateTime}
Result
{!myVariable_waitStartTimeVariable} = "3/6/2016 12:17 PM"

DECISION: myDecision
Executed this outcome: myRule_1
Outcome conditions: and
1. {!formula_myRule_1} (true) Equals true
Logic: All conditions must be true (AND)

RECORD UPDATE: myRule_1_A1
Find all Assignments__c records where:
Siding_Started_Time__c Is null true
Siding_Status__c Equals Started
Id Equals {!myVariable_current.Id} (a0M61000001zAAFEA2)
Update the records’ field values.
Siding_Started_Time__c = {!formula_21_myRule_1_A1_Siding_Started_Time_c} (3/6/2016 12:17 PM)
Siding_Started__c = true
Result
All records that meet the filter criteria are ready to be updated when the next Screen or Wait element is executed or when the interview finishes.

RECORD UPDATE: myRule_1_A2
Find all Assignments__c records where:
Siding_Completed_Time__c Is null true
Siding_Status__c Equals Complete
Id Equals {!myVariable_current.Id} (a0M61000001zAAFEA2)
Update the records’ field values.
Siding_Completed_Time__c = {!formula_20_myRule_1_A2_Siding_Completed_Time_c} (3/6/2016 12:17 PM)
Siding_Completed__c = true
Result
Failed to update records that meet the filter criteria.

 
6 replies

Update lookup field with login user

Hi All,

Is it possible to update a lookup field to the User object of the person who is creating that record? We have a custom object with a Lookup field (to user) called "Sales Rep". We would like to 'default' this field to the person who is creating that record at that time (current logged in user).

The owner field will be changed to someone else in the meantime. Thanks for the help!
12 replies

Invalid field for SObject when building a table of data in a Visualforce page

I am attempting to create a Visualforce Email template that basically emails the contact and shows its related list of Assignments__c in the template.

I am following the document here: https://developer.salesforce.com/page/VisualForceEmailTemplates_sample

However I am receiving an error: Error: Invalid field Contact for SObject Assignments__c

<messaging:emailTemplate subject="Tomorrow's Inspections and Homeowner Closing Appointments" 
recipientType="Contact" 
relatedToType="Assignments__c">

<messaging:htmlEmailBody >
 <html>
            <body>

            <p>Dear {!recipient.name},</p>
            <p>Attached is your inspection schedule for tomorrow. Please review it to make sure there is enough time allowed between inspections. 
            Call Rick Werts (863) 207-6550 with any changes that are necessary to make sure we are making every appointment on time. 
            Thank you for all of your hard work out there.

            Thank you,

            Bill Todd
            V.P. of Sales
</p>
            <table border="0" >
                <tr>
<th>Policyholder Name</th><th>Risk Street</th>
                    <th>Risk City</th><th>Risk State</th>
                    <th>Risk Zip Code</th><th>Inspection Date and time</th>
                    <th>Homeowner Closing Appt</th>
                </tr>
                <apex:repeat var="cx" value="{!relatedTo.Contact.Assignments__c}">
                <tr>
                    <td><a href = 
                        "https://cs50.salesforce.com/{!cx.id}">{!cx.Assignments.Name}
</a></td>
                    <td>{!cx.Assignments.Risk_Street_Address__c}</td>
                    <td>{!cx.Assignments.Risk_State_Address__c}</td>
                    <td>{!cx.Assignments.Risk_City__c}</td>
                    <td>{!cx.Assignments.Risk_Zip_Code_Address__c}</td>
                    <td>{!cx.Assignments.Inspection_Date_and_Time__c}</td>
                    <td>{!cx.Assignments.Homeowner_Closing_Appt__c}</td>
                </tr>
                </apex:repeat> 
            </table>
            <p/>
            <center>
                <apex:outputLink value="http://www.salesforce.com">
                    For more detailed information login to Salesforce.com
                </apex:outputLink>
            </center>
            </body>
        </html>
    </messaging:htmlEmailBody>
</messaging:emailTemplate>
3 replies

Error Occurred During Flow "Other_Trades_Update": geopointe:Too many SOQL queries: 201

hello,

I am receiving this error during a Process Builder. This particular Process has many updates that timestamps fields when each fields associated checkbox is checked. This is very lengthy, however, at the end of the report the results are: Failed to update records that meet the criteria. 

An error occurred at element myRule_1_A2 (FlowRecordUpdate).
geopointe:Too many SOQL queries: 201

Flow Details
Flow Name: Other_Trades_Update
Type: Workflow
Version: 4
Status: Active

Flow Interview Details
Interview Label: 
Current User: MadSky Admin (00561000000ZrJo)
Start time: 3/6/2016 12:17 PM
Duration: 0 seconds

How the Interview Started
MadSky Admin (00561000000ZrJo) started the flow interview.
Some of this flow's variables were set when the interview started.
myVariable_old = a0M61000001zAAFEA2
myVariable_current = a0M61000001zAAFEA2

ASSIGNMENT: myVariable_waitStartTimeAssignment
{!myVariable_waitStartTimeVariable} Equals {!Flow.CurrentDateTime}
Result
{!myVariable_waitStartTimeVariable} = "3/6/2016 12:17 PM"

DECISION: myDecision
Executed this outcome: myRule_1
Outcome conditions: and
1. {!formula_myRule_1} (true) Equals true
Logic: All conditions must be true (AND)

RECORD UPDATE: myRule_1_A1
Find all Assignments__c records where:
Siding_Started_Time__c Is null true
Siding_Status__c Equals Started
Id Equals {!myVariable_current.Id} (a0M61000001zAAFEA2)
Update the records’ field values.
Siding_Started_Time__c = {!formula_21_myRule_1_A1_Siding_Started_Time_c} (3/6/2016 12:17 PM)
Siding_Started__c = true
Result
All records that meet the filter criteria are ready to be updated when the next Screen or Wait element is executed or when the interview finishes.

RECORD UPDATE: myRule_1_A2
Find all Assignments__c records where:
Siding_Completed_Time__c Is null true
Siding_Status__c Equals Complete
Id Equals {!myVariable_current.Id} (a0M61000001zAAFEA2)
Update the records’ field values.
Siding_Completed_Time__c = {!formula_20_myRule_1_A2_Siding_Completed_Time_c} (3/6/2016 12:17 PM)
Siding_Completed__c = true
Result
Failed to update records that meet the filter criteria.

 
6 replies

Update lookup field with login user

Hi All,

Is it possible to update a lookup field to the User object of the person who is creating that record? We have a custom object with a Lookup field (to user) called "Sales Rep". We would like to 'default' this field to the person who is creating that record at that time (current logged in user).

The owner field will be changed to someone else in the meantime. Thanks for the help!