• Matt Foster
  • 15 Points
  • Member since 2015
  • Owner, Fostering LLC
  • Fostering, LLC

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 3

Hi all.


Am planning on a basic integration between filemaker pro and salesforce, such that:


Users of filemaker have access, in a dropdown list, to a dynamic list of salesforce accounts where account type = client


Users of filemaker have access, in a dropdown list, to a dynamic list of salesforce contacts where contact type = user


I have customised salesforce out of the box for the last three years, but have no experience in actual code development.


Can anybody advise the basic features thaty I would need to use on the salesforce side?


I have created a Cross object Custom formula field that displays the Address .Here is the format to display the address field.



Account.BillingStreet  & BR() &
Account.BillingCity & ", "
 & Account.BillingState  & " " &
Account.BillingPostalCode  & BR()
& Account.BillingCountry


Now my question is there is a Comma in the formula and it displays, when the BillingStreet,BillingCity,etc., fields are empty.

How to resolve this?



Yesterday I had deployed aan apex trigger from sandbox to production env. The trigger is an "before insert, before update" to check for duplicate account names. The trigger works fine in prodiuction for preventing duplicate Account names.
But today when I tried to mass update Accounts for some other field using Apex Data Loader, I get the following error:

Apex script unhandled trigger exception by user/organization: 00530000000nHi3/00D300000006QZD

Trg_Account_Name_Dedup: execution of BeforeUpdate

caused by: System.Exception: Too many SOQL queries: 21

Trigger.Trg_Account_Name_Dedup: line 1, column 143

Can anyone please advise on how to disable triggers in production env so that I can carry out other mass updates in Account using Apex Data loader tool.

Thanks and regards,

  • February 12, 2008
  • Like
  • 0