<<Start: SELECT(GEOFORCE[Newcomputedkey], AND(NOT(CONTAINS([LAST SEEN LOCATION], โVictoriaโ)), [location] = โ59-01โ,[VC Item Status] = โreadyโ,ISNOTBLANK([GPS TAG])) TRUE)>><<[Asset ID]>>
The column I need ordered is [Type]
Thanks
Solved! Go to Solution.
Hi @Tiger1
<<Start: ORDERBY(SELECT(GEOFORCE[Newcomputedkey], AND(NOT(CONTAINS([LAST SEEN LOCATION], โVictoriaโ)), [location] = โ59-01โ,[VC Item Status] = โreadyโ,ISNOTBLANK([GPS TAG])) TRUE),[columnName],FALSE)>><<[Asset ID]>>
For reference:
Use Start expressions in template (section: Control the record order)
Hi @Tiger1
<<Start: ORDERBY(SELECT(GEOFORCE[Newcomputedkey], AND(NOT(CONTAINS([LAST SEEN LOCATION], โVictoriaโ)), [location] = โ59-01โ,[VC Item Status] = โreadyโ,ISNOTBLANK([GPS TAG])) TRUE),[columnName],FALSE)>><<[Asset ID]>>
For reference:
Use Start expressions in template (section: Control the record order)
Worked PERFECTLY!
Thanks
I meant to also ask - can you order within an order?
In other words - I want order by [Type] then within the [type] I want [Item_description] ordered?
You may want to have a look to the documentation ๐
...but the short answer is yes
User | Count |
---|---|
40 | |
32 | |
30 | |
17 | |
16 |