info gallery

[mj7]

hello i have a register that when i upload, it goes to another screen wich is the info that i already register so my question is how i can make that the information i registered goes to the info screen but on top of the gallery i alredy put a sort icon but i rather have the info un top so the user dont have to click the sort icon everytime. Hope you can help 🙂 

[mj7]

@RandyHayes i think my formula is not okay 😞 it marks error

If(!IsBlank(vardatesort),SortByColumns(DOORTRIM,"FECHAYHORA",If(vardatesort=true, Ascending,Descending)),DOORTRIM);

DropColumns(
SortByColumns(
AddColumns(DOORTRIM,
"FECHAYHORA",FECHAYHORA=Formdoort.LastSubmit.CÓDIGO
),
"FECHAYHORA",
Descending
),
"FECHAYHORA"

})

[RandyHayes · Accepted solution]

@mj7 

Yes, that definitely is not going to work.

Use this formula instead:

DropColumns(
    SortByColumns(
       AddColumns(DOORTRIM,
           "FECHAYHORA",FECHAYHORA=Formdoort.LastSubmit.CÓDIGO,
           "NoOrdenar", true
       ),
       If(IsBlank(vardatesort), 
          "NoOrdenar",
          "FECHAYHORA"
       ),
      Descending
    ),
    "FECHAYHORA",
    "NoOrdenar"
)

Since you don't want any sorting if the vardatesort is empty, this formula sets a "dummy" column with true in it and then sort on that if it is blank.  Otherwise it sorts on the date and time added column.