Announcements
The sort button is working but I would like the information to be displayed with the most recent entries first when the user first loads the app. As of now when the user first accesses the app it show's the oldest entries first until you sort. Below is a picture with my code:
Thanks!
@mhgottsc your formular should more look like this
If(!IsBlank(varDateSort),SortByColumns(........),SortByColumns(......))
So the else part of your if is wrong. If you can't get it to work please paste your formular here.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
@mhgottsc
Change your formula to the following:
SortByColumns('Sales Point Tracker Team', "Date", If(Coalesce(varDateSort, true), Descending, Ascending ) )
The Coalesce function will provide a way to "default" a blank variable to whatever value you want - in this case, true.
I hope this is helpful for you.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
