function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
JustinWheatleyJustinWheatley 

Help WIth Objects

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

 

 

 

RDM1961RDM1961

Hi Justin,

I'm a fairly new to this myself but I'm wondering why you would need the month object at  all.  Why not just load the minutes against the account and use a date field instead of separate month and day fields?

 

 

Rick

 

 

forcedotcomforcedotcom

I agree with Rick - what is the requirement for the custom object 'Month'? Can't you just have a minutes custom object which is related directly to your account??