Skip to main content
Nintex Community Menu Bar

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!


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.

Hey David, not sure if just on my side, but i do not see ui fields available on the sort action when choosing model

How are you setting this up, i even tried via XML and it’s not working


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.

Hey David, not sure if just on my side, but i do not see ui fields available on the sort action when choosing model

How are you setting this up, i even tried via XML and it’s not working

David,

Do you have the box checked for “Sort client side” on your sorting action? Because if you don’t, then you won’t be able to select a UI only field as your sort field. You can only do this client side because the UI only field only has a value on the client side. 

 


Reply