Mika Hakkinen
03/16/2021, 2:54 PMRyan Price
03/16/2021, 3:24 PMEdgar Valdés
03/16/2021, 3:38 PMPaulJ
03/16/2021, 3:59 PMJacob D
03/16/2021, 4:05 PMMicah
03/16/2021, 4:57 PMjen
03/16/2021, 5:35 PMFormula (Text)
and my formula is sysdate - {custrecord_my_datetime_field} || ''
, which gives me something that looks like +000000000 01:34:12.000000
. Ideally, I want something formatted as follows 0 day(s), 0 hour(s), 1 minute(s), 34 second(s)
or similar. I’ve tried using TRUNC to extract even just the days (e.g. TRUNC(sysdate - {custrecord_my_datetime_field}) || ''
but that just results in an Unexpected Error page when I try to run the search. Any suggestions on how to achieve this?Mike
03/16/2021, 6:55 PMlaurend
03/16/2021, 8:12 PMjen
03/16/2021, 8:58 PMWording
that has “include name field” unticked. It uses autonumbering to make records with names using the prefix WD (e.g. WD0172). In addition, this record type has a field called “title” that is usually, but not always, the same as the name. Title has Global Search enabled. I’m finding that when the name
and the title
differ, and I search by the name
(e.g. WD0172) the result is not returned. For example if I do Wording:172
in my global search I get no results (this Wording has a title that differs from WD0172). Global searching for WD0172
returns the record. How can I enable searching both on the name
field and on the custom field title
?Raj Konds
03/16/2021, 9:20 PMSandii
03/16/2021, 9:36 PMSandii
03/16/2021, 9:37 PMmichoel
03/16/2021, 10:15 PMmartha
03/16/2021, 10:17 PMLuis
03/17/2021, 1:12 AMLuis
03/17/2021, 1:51 AMJBL
03/17/2021, 4:33 AM7px
03/17/2021, 5:53 AMNetsuite Tragic
03/17/2021, 6:24 AMCasey Rotach
03/17/2021, 9:34 AMMika Hakkinen
03/17/2021, 11:52 AMMathewTREW
03/17/2021, 1:33 PMted_p
03/17/2021, 1:36 PMOgabeg
03/17/2021, 2:53 PMPhillip
03/17/2021, 5:47 PMMike
03/17/2021, 5:59 PMJC
03/17/2021, 6:27 PMAlan Fitch
03/17/2021, 8:19 PMScruffy
03/17/2021, 8:39 PM