"Medicrea is a company specializing in new surgical technologies for the treatment of spinal pathologies. Its market growing fast all around the world forces Medicrea to invest and develop its IT systems.”

To answer those growing needs, Medicrea is looking for a freelance developer/programmer in NYC.

Position description: On a regular basis you will affected to specific development projects to improve users experience in SF.com.

Job duties include but are not limited to:

-          Developing Medicrea’s Salesforce platform: We recently upgraded from Professional to Enterprise edition. The database needs to be redesigned to take fully advantage of the new possibilities offered by Enterprise. 

Experience & knowledge required:

-          Salesforce experience in Enterprise level environment:

• Coding: custom objects, automated workflows, visual force pages, validation rules, triggered events and Apex
• Custom configuration of Salesforce Enterprise
• Experience using Salesforce.com data tools (data loader, excel connector)

Please send resumes to: tlopez@medicrea.com

"Medicrea is a company specializing in new surgical technologies for the treatment of spinal pathologies. Its market growing fast all around the world forces Medicrea to invest and develop its IT systems.”

To answer those growing needs, Medicrea is looking for a freelance developer/programmer in NYC.

Position description: On a regular basis you will affected to specific development projects to improve users experience in SF.com.

Job duties include but are not limited to:

-          Developing Medicrea’s Salesforce platform: We recently upgraded from Professional to Enterprise edition. The database needs to be redesigned to take fully advantage of the new possibilities offered by Enterprise. 

Experience & knowledge required:

-          Salesforce experience in Enterprise level environment:

• Coding: custom objects, automated workflows, visual force pages, validation rules, triggered events and Apex
• Custom configuration of Salesforce Enterprise
• Experience using Salesforce.com data tools (data loader, excel connector)

Please send resumes to: tlopez@medicrea.com

"Medicrea is a company specializing in new surgical technologies for the treatment of spinal pathologies. Its market growing fast all around the world forces Medicrea to invest and develop its IT systems.”

To answer those growing needs, Medicrea is looking for a freelance developer/programmer in NYC.

Position description:

In the NYC office up to 3 days per week flexible, you will:

1-      Develop Medicrea’s Salesforce platform

2-      Provide technical support to all users onsite and remotely

3-      Update and maintain Access programs

Job duties include but are not limited to:

-          Developing Medicrea’s Salesforce platform: We recently upgraded from Professional to Enterprise edition. The database needs to be redesigned to take fully advantage of the new possibilities offered by Enterprise. 

-          Providing technical support to all users onsite and remotely: We have an agreement with an IT consulting company. Part of your job will be to troubleshoot our sales team and office people’s IT issues and escalate them to our partner if you cannot handle them.

-          Updating and maintaining Access programs: Our operations are run using 2 main softwares – Quickbooks and Fishbowl.  Those softwares don’t have specific reporting capabilities. We use custom reports and Access to complete them. You will have to update and maintain those reporting capabilities.

Experience & knowledge required:

-          Salesforce experience in Enterprise level environment:

• Coding: custom objects, automated workflows, visual force pages, validation rules, triggered events and Apex
• Custom configuration of Salesforce Enterprise
• Experience using Salesforce.com data tools (data loader, excel connector)

-          Troubleshooting Windows and Mac environments

-          Access programming

Please send resumes to: tlopez@medicrea.com

Hi community, I am new in Apex language, I am trying to create a simple trigger to update a contact field but when I try to put a condition with the method NOW() or TODAY() it returns this error : Method does not exist or incorrect signature: NOW(). Do you know why? Here is my code :

trigger UpdtConAct on Event (after insert, after update) {
   
// create a set for related contact ids
 Set<ID> contactids = new Set<ID>();
 
// iterate through the events
    for ( Event status : trigger.new){
    // add the event only if the surgery appened less than 30 days ago
        if (status.Subject == 'Surgery'){
         if (    (Status.ActivityDate.daysbetween(NOW())) < 30 )
        {contactids.add(status.WhoId);}

                                                              }

                                                         }
        
// use SOQL to query for the relevant contact
        List <Contact> contactlist = [SELECT id ,Surgeon_Status__c from Contact where id in : contactids];
 // iterate through the contacts
        for (Contact con : contactlist){
            con.Surgeon_Status__c='Active';}
        update contactlist;
    }

Thanks for your answer.

Pierre

Hi community, I am new in Apex language, I am trying to create a simple trigger to update a contact field but when I try to put a condition with the method NOW() or TODAY() it returns this error : Method does not exist or incorrect signature: NOW(). Do you know why? Here is my code :

trigger UpdtConAct on Event (after insert, after update) {
   
// create a set for related contact ids
 Set<ID> contactids = new Set<ID>();
 
// iterate through the events
    for ( Event status : trigger.new){
    // add the event only if the surgery appened less than 30 days ago
        if (status.Subject == 'Surgery'){
         if (    (Status.ActivityDate.daysbetween(NOW())) < 30 )
        {contactids.add(status.WhoId);}

                                                              }

                                                         }
        
// use SOQL to query for the relevant contact
        List <Contact> contactlist = [SELECT id ,Surgeon_Status__c from Contact where id in : contactids];
 // iterate through the contacts
        for (Contact con : contactlist){
            con.Surgeon_Status__c='Active';}
        update contactlist;
    }

Thanks for your answer.

Pierre