Skip to main content

I have a model in which I created a UI only field (Display type = Formula / Formula Return Type = Number)

The field is working as intended and returning a numerical value in my Table

Now I would like the table to be automatically sorted with this UI only field → use the UI only field in the model’s “Fields to order records by” is this possible?

My Field Id is SortValue(UI) / Unique ID SortValue

when I try I keep on getting “Error:No such column 'SortValue' on entity 'OrderItem'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.” making me think that UI only fields can’t be used, but is there a way

 

Thank you

This is an order of operations issue. The UI only field doesn’t have a value until the model has already queried the information, so you can’t sort it with a field that doesn’t exist yet.

What I would suggest is creating a model action with an event “Model requeried”. In the actions tab add a Sort model action, select your model, UI only field and your sort behavior. That way you’ve waited for the model to query it’s data, the UI only field should have a value, then it can be sorted.


Thank you David, I found what you were suggesting and it worked well!


Reply