Assuming I have a way to do survey by pushing a button which does a count with a timestamp. I want to get the records list by their attempt time which might be in their chronological order of attempt. The max I do attempt is 3. I understand I can use summary field to get the first and last attempt using the Minimum and Maximum but now the value in the middle is what am struggling to get. Anyone with an idea how to go about it? I will appreciate.
Solved
Getting an index value from a record
+9Best answer by AD47471
Roy, try this out: Building off of Kelly's input, finding the "middle" by using the summary field filters where the child record is the one that is not equal to the MAX and the MIN? Summary Field = [Attempt Date/Time] is NOT equal to [Maximum Attempt Date/Time] and [Attempt Date/Time] is NOT equal to [Minimum Attempt Date/Time]. Of course this should only work when there are 3 attempts per participant since the MAX and MIN will be consuming 2 out of 3 records here. If there are records with < 3 attempts, this won't work.
+3Assuming that your the field you are summarizing is called [Attempt Date/Time] and your min/max summary fields are called [Minimum Attempt Date/Time] and [Maximum Attempt Date/Time], create a new summary field:
Summarize Maximum [Attempt Date/Time] where:
[Attempt Date/Time] is NOT equal to [Maximum Attempt Date/Time]
This should give you the second most recent attempt date/time.
+9Hey Kelly. Hope you're doing well.
Thanks for the insight. Apparently this doesn't work as you can't be able to view the summary fields while creating another summary field. Also comparing the [Attempt Date/Time] which I assume is a field in the summary doesn't give you access to the summary fields. There is a lot of limitations.
+9I want to get the second record assuming I have three attempts. The first and last I can get using the minimum and maximum but now the second one is where I have the challenge.
+2Roy, try this out: Building off of Kelly's input, finding the "middle" by using the summary field filters where the child record is the one that is not equal to the MAX and the MIN? Summary Field = [Attempt Date/Time] is NOT equal to [Maximum Attempt Date/Time] and [Attempt Date/Time] is NOT equal to [Minimum Attempt Date/Time]. Of course this should only work when there are 3 attempts per participant since the MAX and MIN will be consuming 2 out of 3 records here. If there are records with < 3 attempts, this won't work.
+9Thanks for the solution. This works perfect. Appreciate you guys.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.