• JustinWheatley
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 4
    Questions
  • 3
    Replies

Hi,

I have created some fileds which are running formulas in the 'Lead Object', I would like the result of the formula to map over to a field I have specified with the 'Opprotunities Object'. Is there anyway round not being able to map a formula field, or is there anything I can do?

Your help is greatly appreciated!

Regards,
Justin

Hi,

 

Could anyone please tell me how to create an email alert if a lookup field is changed?

 

This is probably a simple one for you guys out there?

 

Thanks again,

Justin

Dear friends,

 

I require a little help! I am working within the Telecoms industry and am using Saleceforce.com to report on customers minutes.

 

I have set up an object named Data which has a lookup relationship to the customer account. I import a daily record which includes the date, minute type, number of calls, and number of minutes.

 

From this I have a roll up summary to show the total number of minutes for the last 7 days. I would like to report on the busiest day from the 7 day role up summary. I need to see the day / date of the busiest day, and number of minutes in that day. Can you please give me some idea's how to do this?

 

Best regards,

Justin

Hi,

 

I hope somebody could make a suggestion for me? I work at a telecoms company and I have created an area within the "Accounts" section in order for me to upload our customers call minutes.

 

In order to do this, I created a couple of objects one being CMM (Customer Month Minutes), and the other being Month.

 

My problem is that when I upload the minutes into salesforce, I have to assign the unique number to each minute record for each customer. Let me give you an example:

 

To create a new month I need to import 2010-08 against every customer UID, eg:

 

Account ID                              Month

xx0011998Uidd00x               2010-08

yy11228866Vl11zz                2010-08

ll661144qq7789yz                2010-08

xx0011998Uidd00x               2010-08

yy11228866Vl11zz                2010-08

ll661144qq7789yz                2010-08

 

This means each month record for each account now has a UID of it's own - example below:

 

Account ID                              Month                  Month ID

xx0011998Uidd00x               2010-08              zzzzzz1111122222

yy11228866Vl11zz                2010-08              zzzzzxxxx22221111

ll661144qq7789yz                2010-08              0000rrrzzz0000111

xx0011998Uidd00x               2010-08             778899qqq999q9q

yy11228866Vl11zz                2010-08             3131313qqqq3333

ll661144qq7789yz                2010-08             161658623858584

 

This means when up loading the minutes onto the customer account, I must map the Month ID, and the Account ID, etc etc etc.

 

What I would like to do is just upload the customer month minutes against a month, rather than a UID which is created per account. EG below:

 

Account ID                                Minute Type                          Day                     Month

11222zzz1100ydu                   Inbound                                01                       August

11222zzz1100ydu                   Inbound                                02                       August

11222zzz1100ydu                   Inbound                                03                       August

11222zzz1100ydu                   Inbound                                04                       August

11222zzz1100ydu                   Inbound                                05                       August

11222zzz1100ydu                   Outbound                             01                       August

11222zzz1100ydu                   Outbound                             02                       August

11222zzz1100ydu                   Outbound                             03                       August

11222zzz1100ydu                   Outbound                             04                       August

11222zzz1100ydu                   Outbound                             05                       August

zzx5574575yyd0o                     Inbound                                01                       August

zzx5574575yyd0o                     Inbound                                02                       August

zzx5574575yyd0o                     Inbound                                03                       August

zzx5574575yyd0o                     Inbound                                04                       August

zzx5574575yyd0o                     Inbound                                05                       August

zzx5574575yyd0o                     Outbound                             01                       August

zzx5574575yyd0o                     Outbound                             02                       August

zzx5574575yyd0o                     Outbound                             03                       August

zzx5574575yyd0o                     Outbound                             04                       August

zzx5574575yyd0o                     Outbound                             05                       August

 

Does anyone have any suggestions please??

 

Thanks for looking , best regards,

Justin

 

 

 

Hi,

 

Could anyone please tell me how to create an email alert if a lookup field is changed?

 

This is probably a simple one for you guys out there?

 

Thanks again,

Justin