Tag: search formula

Formula(HTML) progress bar

First test: On my first test, I’ve replicated your concern with simpler values: ‘<progress style=”accent-color:red;” value=”‘||55-5||’” max=”100″></progress>’ Results: Which is to be expected based on your concern. Second Test: I followed your advise wherein if I change the arithmethic symbol to * or /: ‘<progress style=”accent-color:red;” value=”‘||10*5||’” max=”100″></progress>’ Results: With this, it shows the correct progress bar as… Continue reading Formula(HTML) progress bar

Using a Custom Formula Field in a Search

On an advanced or saved search page, on the Criteria or Results subtab, select the previously defined custom field and set criteria as for any other custom field. Click OK. Click Submit to view your search results. If the searches are returning static values for a custom formula field instead of recalculating when new data is entered into the system, the field… Continue reading Using a Custom Formula Field in a Search

Search formula to find the latest date among the three dates

Scenario: If we need to find the latest date/the recent date among the three dates in a saved search, use the following formula in the search criteria. Formula(Date): CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_second_expiry_date},{custrecord_project_first_expiry_date})) THEN (CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_third_expiry_date},{custrecord_project_first_expiry_date})) THEN {custrecord_project_first_expiry_date} ELSE {custrecord_project_third_expiry_date} END) ELSE (CASE WHEN ({custrecord_project_second_expiry_date}>= NVL({custrecord_project_third_expiry_date},{custrecord_project_second_expiry_date})) THEN {custrecord_project_second_expiry_date} ELSE {custrecord_project_third_expiry_date}END )END