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') ))
Discussion posts and replies are publicly visible
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.
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.
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.
Ok, Thanks Stefan for you inputs.
I had seen in Appian videos where they were showing creating custom record field for SLA status(SLA met/Missed) and used later in charts with grouping only thing my use case is little different.