Hello all !
I face some issue, this is about filtering and sorting. Maybe I’ll find someone to help.
I’ve a table “Users” and a table “calls”. Users are unique. There’re 1 or more calls for 1 user.
Each call have a “max date”, and a field for the user. Each user has a field for all his calls.
I need to display a list of calls, sorted by max date, but only the first one for each user (the next one, in term of dates), means if USER A have 2 calls, one on next monday and one in one month, I need to diplay only the call for monday.
I spent hours and hours without success.
If someone has an idea, it will be very nice to me !!! thanks
To display the first item by date, you’d
do a search for callswith the relevant user as a constraint And
:sort bythe max date field (assuming it’s a time stamp) and you’d specify
Have you tried this already?
Thanks for trying to help @jared.gibb
With this method, I can only display one call. What I need to do is displaying a list of calls, but just the first one for each user, and then sorting them by max date as:
User A Call on august, 17th
User B Call on august, 20th
User C Call on august, 30th
If there’s a call for User A on august, 21th, I will not display it
A RG eith all calls, sorted by max date
Each cel has a group with a conditional
If RG’s list of calls: through item number: this cells index contains this cells user, hide
This would sort them by date, and only show the earliest in the list for each user.
I try but I don’t understand the "through item number: " what means throught there?
I can do
RG’list of Calls:item#Current cell’s index // but can’t add contains after it.
Sorry… hope you can clarify
This made me think about a trick I used in the past, creatin an hidden input (integrer) with initial content currentcell’sindex-1, so i can set up the conditionnal as
If current cell’s call’user is RG List of calls’ :item#HiddenInput’value’user then HIde this group
You made me think about this solution, by hiding instead of filtering the list in source !!! thanks you’re an angel @jared.gibb
I see that I cannot count the element of the RG, it counts the hidden elements
You can tho still maybe.
Could you count the RG: lists’ users:unique elements
something like this
oh yes it is ok that way ! thanks for the learning @jared.gibb
This topic was automatically closed after 70 days. New replies are no longer allowed.