• beener
  • NEWBIE
  • 60 Points
  • Member since 2008

  • Chatter
    Feed
  • 2
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 42
    Questions
  • 38
    Replies
Hello Guys,

I have joined the forum today. I have been tryig to find a good Project for my MSc in Salesforce,but was unable to find anything.

I am not sure if this is the correct place to post this:



I am hoping to find a company that would be able to suggest a possible project - something that would be useful to the company. Previously, I worked on Salesforce so possible ideas would be Quality of Service or located news item about company.
Quality of Service (My knowledge says):
Opportunity Product Objects
Lead
1 Trigger and 1 Class
(of course more will be done according to what the company’s requirements)

Located news item about company (rough idea):
What kind of products the company contains.
What products is the company releasing?
What is the company developing?
How customers come into that company?
How is the staff work going?
Who is the Owner?

Background: on my MSc programme I have been studying Telecommunication Systems. As part of the programme, I have to complete a project. The first stage, on which I spend only a small part of my time, starts in January and the aim is clarify the project aims. The second stage, which is full time, runs for 3 months from June. I have a supervisor at the University but would be happy to work as closely with a company as necessary.
If there are no requirements; what if I create a requirement list and if you could pass them onto the department for approval?

My idea is mainly programming based; if some networking could be included it would be great.

Kind regards,

Anika

HI,

 

I have written a controller, and a page that uses it. This method catches an exception, I am trying to pass the error to the apex : messages visualforce page .

 

Clicking Running this method, I get an "An unexpected error has occurred.  " page. what's wrong with my exception catching?

 

 

public void deleteOldInvoices() {

//this method is in the controller. it is run from the page try { //some code here. } } catch (Exception e) { Apexpages.addMessages(e); } }

 

 Thanks

Ben 

 

Hi,

 

I am attempting to query the number of rows I have for a particular object, so that if there are 0 objects, I don't operate.

 

I have tried the following line (this is the first line of code, which is called from an VisualForce ActionButton):

 

Integer Total_size = [select COUNT() from invoice__c where Week__c = :Current_Week_Ending.id];

I get the following error:

System.NullPointerException: Attempt to de-reference a null object

 
Any ideas why this happens? how can I verify that there are no objects before I work on it? for now, I will get the list and check it's size, but I think it's less efficient.

 

Thanks,

 

Ben 

 

Hi,

 

I need to create Apex code that manipulates over 200 records. Where can I find instructions on how to do this as simply as possible. I am aware that once can work with a SOQL query in a loop, which allows you to breat the 200 Barrier for one of the objects, but if you have to work with several sets of objects, it becomes difficult.

 

I would appreciate any sources of info.

 

Thanks

 

Ben 

Hi, 

 

until now, I had some validation rules for record types. It was hard coded: here's an example:

 

 

Staff_Member__r.RecordTypeId <> "01220000000BGkB"

This Validation rule limits the type of record allowed in this reference.

 

However, hard coding anything is offcourse bad practice, and leads to much work when working with the sandbox, because (I think) all new record Type ID numbers are generated.

 

I was attempting to replace this rule with a sandbox sensitive formula.

 

I've tried different variations of the following :

Staff_Member__r.RecordTypeId <> VLOOKUP($SobjectType.id , $SobjectType.name, "Client")

 

 

but I could not get it to work. Any ideas?

 

Thanks,

 

Ben 

 

Hi,

 

My Save button doesn't work 

I am attempting to mimic web-to-lead and (later web-to-case) functionality using the following:

 

  • visualforce. 
  • partner portal (which is free, but doesn't allow self registration)
  • standard controller for lead.

 

 

Here's what I've come up with:

 

My Problem: 

SAVE doesn't work.

 

In case you are curious, The reason I'm not using the standard webform is:

 

  • I get the visual design for free
  • I don't have to modify the form every time I modify a pick list (which is very annoying).
  • (Later on. I can use apex code after the submission.)
Any ideas?

Thanks in advance.
 
Comments:
  • I tried to use the same page from salesforce (rather than from the site, so we have authentication).
    I still CAN'T Save, BUT if there is an ?id=XXXXXXXXXX in the URL, I can make a change, and save. this works.
  • I'm attaching the outer part of my VF page, just so you see I'm using standarrd functionality, apex: inputfield and no special tricks.

<apex:page standardController="Lead">

<apex:form > <apex:pageBlock title="Initial Agreement" mode="edit">

 

<apex:pageBlockButtons >

<apex:commandButton action="{!save}" value="Save"/>

</apex:pageBlockButtons><apex:pageBlockSection title="Title" columns="1">

<apex:outputText ><br/>Welcome to My Application form.<br/>Please fill in the form below. </apex:outputText>

<apex:inputfield value="{!Lead.Agreement__c}" />

<!-- more input fields here -->

<!-- more input fields here -->

<!-- more input fields here -->

<!-- more input fields here -->

</apex:pageblocksection></apex:pageBlock></apex:form></apex:page>

 



 

Message Edited by beener on 11-12-2009 01:47 PM
Message Edited by beener on 11-12-2009 01:48 PM

I am trying to find a way to export out a salesforce database schema into a report.

 

Ideally I would like something that list all of the standard and custom objects with every field.

 

Additional data such as field type and description would also be helpful.

 

And of course any relationship data would also be good.

 

I have both Mac and Windows and currently using Soql Xplorer for mac which is excellent but does not allow you to export as a above. 

Hi,

 

I'm attempting to bind a String into a SOQL query.

 

I get the following Error. expecting a left parentheses, found ':' (The line number refers to the SOQL query)

 

Any thoughts?

 

Thanks 

 

 

public List<Contact> getPeople_In_Category(){ String Category_selected_str = "Translator"; people_list = [select c.id, c.name, c.phone, c.mobilePhone, c.email, c.title, c.account.name FROM Contact c WHERE c.Category__c INCLUDES :Category_selected_str LIMIT 100]; return people_list;

}

 

 

 

Hi,
I've written a very simple Apex Trigger (My first).
it aims to count the number of Timesheet__c records with a given date, and update these to another object called Week__c.

I cannot seem to deploy this trigger. due to Test coverage being insufficiet (0%). and due to average Apex test coverage, which i is 50% (as opposed to the required 75%).
  1. Please help me understand what would be a test method for this trigger.
  2. Where would I write this method (in the apex trigger code? after the closing bracket?


Code:
trigger Timesheets_Count on Week__c (after insert, after update, after delete, after undelete) {
 Date weekending = Trigger.new[0].Week_Ending__c;
 Week__c my_week = [select w.id, w.Number_Of_Timesheets__c from Week__c w WHERE w.Week_Ending__c = :weekending limit 1];
 Integer number_of_sheets = [select COUNT() from Timesheet__c t where t.Week_Ending__c =:weekending];
 my_week.Number_Of_Timesheets__c = number_of_sheets;
 //update My_week;// is this Line needed at all
 }

Thanks so much.

Ben

Hi,

I would like to create a table of data but it must be editable (think Excel)

Each row would be an entry in the object.

is this something that can be done in VF?

Thanks
Note : Same Post can be found in VisualForce Category too, Apologies for Duplicate Post
http://community.salesforce.com/sforce/board/message?board.id=Visualforce&thread.id=7900

Hi Friends,

I need to submit HTML Form's in Inline Frame(which are hidden). The forms are submitted programatically using form.submit() syntax.

Before submitting the forms I set the form target to be the inline frame, so when the submit is triggered the forms get posted in the hidden iframes. This entire process is working **bleep** fine with firefox, but the same is not working in IE as desired.

Instead of posting data in those inline frames, IE opens a new window where in it submits or posts the form.

Would really appreciate any help or light on above stated issue.
Hi,

I'm trying to limit Record Type to be of a certain kind for one of my objects. the rule is very simple, but it doesn't work:

Validation Rule:
Staff_Member__r.RecordTypeId <> "01220000000DGbBAAW"

 
In other words, I only allow Staff Members to be of record type "012...AAW" . I did check that this is the correct record type ID.

My rule fails in the following way. it disallows membership of any kind. in other words, it always evaluates to True.

Any ideas?

Thanks so much
hi
 
i want to retrieve the Server URL in trigger or in APEX class?
 
Actual my requirement is:
 
i had an object RelatedAttachement. in that Hyperlink field is of URL type. in that i am saving the URL like /servlet/servlet.FileDownload?file=00PR0000000MqVH. For this i want to retrieve the server URL and concatenate that Server URL to this field and updating this field.  in one server it looks like http://cs2.salesforce.com/servlet/servlet.Download?file=00PR0000000MqVH and in another server it looks like http://na2.salesforce.com/servlet/servlet.Download?file=00PR0000000MqVH so for this one i want to retrieve the server URL and i want to concatenate that URL to that field.
 
So please tell me how to retrieve the Server URL in trigger or in APEX class? 
I finally got Validation/Triggers enabled for Lead Conversion, but now I can't figure out how to code a trigger for it.  I've tried

Code:
trigger test on Lead (after convert) {
}

but I get an Invalid Token error.  There are no hints in the documentation.

thanks
David
Hola,

I'm trying to do a simple query that compares two DATETIME fields on the same record. Here's the query:

SELECT Id FROM Lead WHERE AddressUpdated__c > AccountManagerUpdated__c

Both of these are custom fields (obviously) but I always get this error and for the life of me I can't figure out why:

MALFORMED_QUERY: ... unexpected token: AccountManagerUpdated__c

After much searching and doc flipping I can't seem to find anything that points at what I'm doing wrong...

Message Edited by ccrawford on 06-01-2007 09:30 PM