Skip to main content
V
vinodt0001
June 28, 2021
Question

Adding Custom Record Field to New Record

  • June 28, 2021
  • 4 replies
  • 0 views

Hi All,

Does anyone knows how to add custom record field in new record 21.2 with below scenario?

Custom field need to add on single DueDate record field. 

1. Groups based on Date difference does not work here since it required to two date fields.(Start and End date)

2. Own expression having limited functions to use(Why there is limitation on using functions while creating custom record field? Will it be changed in next upgrade?)

My scenario would be like this.(Below is SQL statement)

IF(
TO_DAYS(`CASE`.`DUE_DATE`) - TO_DAYS(CURDATE()) > 0,
'Before Due Date',
IF(
TO_DAYS(`CASE`.`DUE_DATE`) - TO_DAYS(CURDATE()) = 0,
'Due Today',
IF(
TO_DAYS(`CASE`.`DUE_DATE`) - TO_DAYS(CURDATE()) < 0,
'Missed Due Date',
'N/A')
))

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 28, 2021

    Why do want to do that as a record field. It would be easier to create the strings in display layer e.g. in the record list.

    V
    vinodt0001Author
    June 28, 2021

    Agree! but dont want to display this in grid or anywhere, want to create some charts based out of this custom field. 

    Earlier i was using View for this calculation but since new records has capability to do this in records itself hence want to utilize this rather than creating views and entity.

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 28, 2021

    Custom record fields need to evaluate at sync or refresh time. Not at the moment you look at it. This is why this is not supported.

    Terms & ConditionsAccessibility statement