How can I sort a table using UI only field (Salesforce Basic Model with UI only field "Formula")

Question

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

david.burns · Accepted Answer

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.

Dominique Bastien · Answer

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

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded