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 🙂
Solved! Go to Solution.
@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"
})
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.