Apex Code Development You need to sign in to do that
Don't have an account?
nksf Submit for Approval Trigger
Hi I need a trigger on Account to automatically submit for approval process. I have a custom checkbox field name Usage Exclusion. My approval process criteria is if Usage Exclusion checkbox is checked then user can send it for approval request and once it is submitted then I have another custom checkbox field as Requested and it will be checked. If approved then custom checkbox field as Approved will be checked.
So I am looking for a trigger if user check the Usage Exclusion checkbox field and save the record it should automatically send for approval.
Please help me asap.
So I am looking for a trigger if user check the Usage Exclusion checkbox field and save the record it should automatically send for approval.
Please help me asap.
You can use the code below
trigger accountApprovalSubmit on Account (after insert, after update) {
for(Account acc : trigger.new){
{
request.setComments('Submitting request for approval.');
request.setObjectId(acc.Id);
recordsToBeSubmitted.add(request);
if(!recordsToBeSubmitted.isEmpty())
Approval.ProcessResult[] results = Approval.process(recordsToBeSubmitted, False);
//You can loop over the above results list and debug the result if you want.
All Answers
You can use the code below
trigger accountApprovalSubmit on Account (after insert, after update) {
for(Account acc : trigger.new){
{
request.setComments('Submitting request for approval.');
request.setObjectId(acc.Id);
recordsToBeSubmitted.add(request);
if(!recordsToBeSubmitted.isEmpty())
Approval.ProcessResult[] results = Approval.process(recordsToBeSubmitted, False);
//You can loop over the above results list and debug the result if you want.
I just tested it and it is working fine. Thanks I really appreciate. I am not a developer but I believe I need a test class for this because it is showing code coverage 0. Can you please also help me with the test class.
Here is your test class....
---------------------------------------------------------------------------------------------------
@isTest
private class Test_accountApprovalSubmitTrigger {
acc.Name = 'Test Account';
//You'll also need to populate other required fields for Account Object
acc.Usage_Exclusion__c = True;
//This will cause the statements in trigger to execute
insert acc;
//Checking if the account record is submitted for approval request
List<ProcessInstance> approvalRequest = [Select Id From ProcessInstance where TargetObjectId = :acc.id];
System.assert(approvalRequest.size() > 0);
I need your help once again. No one else replied me with my this question so I though let me bother you one more time.
I am looking for color background for a custom field value.
I have custom object Usage Data and I have a custom formula text field YTD Average Usage.
If YTD Average Usage is less than 25% color backgroud should be Red and if YTD Average Usage is between 26% to 75% then color background should be Yellow and if YTD Average Usage is more than 75% then color background should be Green.
I am not sure if we have any standard functionality in salesforce for color background. So I have created another Image formula field with Red, Green and Yellow but I am not able to export Report with image in excel sheet. In Excel sheet it is only showing Image URL instead of Image.
Can you please help me with the alternative or Visualforce Page Report for this kind of report.
If Visualforce Page Report is the only solution then Please help me with the sample of it and I should be able to export report to excel sheet with either color background which is the first priority if not then image should be fine.
I am looking for VF page, Apex Class and Test Class. Here is the sample it should look like in VF Page.
Usage Data is Custom Object. Usage Number is Standard Auto Number Field. School Name is Custom Text Field. YTD Average Usage is Custom Formula Text Field.
Usage Number School Name YTD Average Usage
1111 ABC 24% User-added image (First Priority will be if we can get color background instead of image)
1112 XYZ 65% User-added image
1113 MNO 85% User-added image
Looking at your requirement, I don't see that there is a need for Visualforce Page Report (Even if we had to do one, I don't see there is an easy way to exporting that data with color fomatting).
In your case what you need to do is to Create a Summary Report and use Conditional Highlighting where you'll specify the range for "YTD Average Usage" field to show in certain color depending on what its value is. And by export the report via clicking on 'Printable View' button on report screen after you run it and you'll retain the formatting.
For more info on Conditional Highlighting Refer : http://help.salesforce.com/HTViewHelpDoc?id=reports_builder_highlighting.htm&language=en_US
You can also watch this webinar on salesforce reporting(https://www.youtube.com/watch?v=O6m0L4FzcB0) where the guy shows Exporting reports at 44:10
Thanks,
Mohammed
anyone can help me for this?
Whenever Auto Approve checkbox is checked, record should be automatically approved.
Once approved, retrieve contacts having the same city with the City Census record that was approved and create and Resident record for each contact retrieved. Create corresponding record type if Contact is Male/Female base on Mr/Ms of Contact Record