Share
Report
648Hello out there
"I have two databases today. One is named "APLplaceringar" and the other is called "APLloggain" where the user logs in.
I want the timestamp of the login to be stored in my Collection as both a timestamp and a date.
I've built it, but currently, I'm only getting the timestamp and date when the record in "APLplaceringar" was created, and that's not what I'm looking for.
I want to see when the actual login occurred.
I conducted a walk-around, went through the entire setup, and built a lookup in my Collection.
In the gallery, I've asked when this login happened for the student via a lookup. The problem is I can't sort my list by the latest date or the latest login time."
"How can I create an additional column that takes the value from the timestamp from the APLloggain and add it as a new column without conflicting with the 'created' field in the original table?"
My Collection
;;ClearCollect( InloggadeAPLplaceringar;
AddColumns(
SortByColumns(
Filter(
APLplaceringar;
Enhetsnr = ddkst.Text && Epost_Elev in APLloggain.email
);
"Created";
SortOrder.Descending
);
"APLeleven";
First(
SortByColumns(
Filter(
APLplaceringar;
Enhetsnr = ddkst.Text && Epost_Elev in APLloggain.email
);
"Created";
SortOrder.Descending
)
).Elev
)
)
My Galleri walkaround
LookUp(
LastN(
Filter(studentloggain; email = ThisItem.Epost_Elev);
1
);
true
).Skapad
All responses (
Answers (
