i have performed calculation of some status staying in grid and that is changing on everyday basis i am not storing that value in any database .
and that status calculation is happening and dependent on many field . how can i apply sorting when dependency of that data is not on any particular field.
Discussion posts and replies are publicly visible
Sort works only on fields not on logical value. My suggestion is create a custom field with this logic within your record and then you can use that field directly here and apply sort.
docs.appian.com/.../custom-record-fields.html
can we create custom record field in view based record
Hi Himanshu,
As venky said Implement the same logic at the view level, then the sorting will work as sorting will not work on logical values. You must be having all the data for a row at the view just modify the logic for status column .
Sure Manish will try to implement by view level that
venky is there any substitute for now() function in appian becz custom record field does not support now() function . This function i have used for calculation.