Skip to main content
Nintex Community Menu Bar
Solved

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

  • November 11, 2024
  • 4 replies
  • 57 views
  • Translate
D
Forum|alt.badge.img+1

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

Best answer by david.burns

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.

View original
Did this topic help you find an answer to your question?

david.burns
Nintex Employee
Forum|alt.badge.img+4
  • david.burnsNintex Employee
  • Nintex Employee
  • November 13, 2024

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.

Translate
D
Forum|alt.badge.img+1

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

Translate
david.burns
1 person likes this
  • david.burns
    david.burns
D
Forum|alt.badge.img+13
  • David.A
  • Scholar
  • January 14, 2025
david.burns wrote:

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

Translate
david.burns
Nintex Employee
Forum|alt.badge.img+4
  • david.burnsNintex Employee
  • Nintex Employee
  • January 14, 2025
David.A wrote:
david.burns wrote:

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. 

 

Translate

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings