"Time Of Day" fields are stored as DATE fields. Thanks, Yang ....So I cannot get a duration value between 2 TOD fields? as a Time duration? I must say I was expecting that a TOD would be a TOD. Can I get an "Enh" for the field to be as "advertised"?

for duration use formula decimal, is that what you want? ({custrecord_end}-{custrecord_start})*24

We need time to be time, is it possible? Day is not enough. TOD to be "time" - not day? I have been trying to get an ER but am having to argue the point with support, still no ER given after a few interactions. For us the standard timesheet page is not very user friendly once start and end is added to it (duration can…

Bring it ON!!! :D

I am trying something like this, but it's not working sofar, any advise? or I am barking up the wrong tree? Hopefully there is a way :) function calcDuration() {

You may need to create a custom centre, or if you can remove any permissions that relate to things under the prospects tab, then maybe the tab will also be removed, not sure...

OK Elham, Thanks for your help so far. I found that preference in my settings and applied it, however for my vendor bill form this did not seem to help, still top down, not bottom up... Should this have worked :confused: .

Obviously NetSuite programmers don't double as data entry clerks :rolleyes: . Thanks for your advice.

Sound exciting, would love more details...!

I cannot locate this; Customer Center Tab > Custom Header > Click SuiteSource We have "Basic" support login - any ideas what this means? or where else to get the sample script list?

Not sure how hidden you really want that information; users can still view that information using search....

NetSuite, so far as I can tell will not let you do that. It has a security model only on transactions, weird huh! - Money matters most here ;) . Your best bet (IMHO) would be custom records - which do have permissions. Hope that's useful, Krishnan

Bring on 12!

Thanks Tim, The way we are "creating?/allowing a view of" the Customer Entity is by giving Customer access to the Employee, rather than actually creating a new Customer record, so I am not sure that automated solution would work? We have the following potential views of the same entity; Employee,Contact,Customer but no way…

OK Tim, So we create an Employee (+ we show Employee as Contact) and then give them Customer access. We then have an (1) entity which is viewable as any of; Employee:Contact:Customer We then create activities, cases etc from the Customer view of that Entity We have those activities, cases etc shown in searches. This works…

OK say your center already has the (for example) 'transactions' tab, go and create a custom 'transactions' tab for that center, then on that new tab just put in the links you want. If that is not working for you, create a new tab for that center 'my custom tab name' put the links to your custom records etc on it. Have…

OK try; create new task select "new field" set label etc, type "list/record" where that list is your custom record plus any other option you need that should do it! EDIT; don't forget mark record as parent..

totally agree.. when using Sale***rce they have a "Show Activities" checkbox on custom records... which does just that.

this works ;) https://usergroup.netsuite.com/users/showthread.php?t=19873&highlight=events+custom+records just use task instead of event in evans instructions

Thanks Steve - appreciate your help!

(I have done the UE defect for number 2 -thanks Evan) I am close to giving up on this :( . (number 1) If I create a new custom record type, with a long text field, then the customized email alert works just fine. However I try for 3 days now and for all my old custom record which have long text fields in the customized…

OK I am having 2 seperate troubles. 1. Long text fields don't seem to work on the customized email alerts, they come through as "oracle.sql.CLOB@f33510" or similar. This looks like a problem to me, can anyone confirm? 2. The alerts will send to me for custom records I create/edit, but not when other users create/edit (even…

Thanks Evan. There are no scripts, I will defect as you suggest.

Here is a screenshot You can see the Total Cash at the top as $403.00 Then in the system notes you can see it was entered as $403.25 The only change made was to the checkbox value....

RE: Long text fields don't seem to work on the customized email alerts This still does not work, however I have gotten around it by using TEXT AREA fields instead of LONG TEXT they work fine in the customized emails. So this is no problemo! :)

I don't quite agree that there is "no" support for activities This never really worked out for me. I just want to be able to create a new activity record from my custom record (which would be related to it). Despite your help it went over my head.:o I also want the checkbox as Steve says -thats how it was in SF and it was…

OK, I am getting a bit confused here. So I can set the supervisor as the recipient no problem (not dynamically though?). But any user can go and setup alerts themselves (due to the public setting) and so get alerts to records which they should not be able to view according to our permissions. If this is the situation then…

Thanks for input :) Been a bit stuck in other areas... I am going to get in and nut it out (or go nuts) soon! Cheers

Nice one! will do. Thank you :)

It is especially in the sensitive area of HR where these things crop up (for us anyways). I don't understand why the software lacks this sophistication.