Return a Random Entry in Confiform

Question

I have a Confiform form which contains entries for people within my organization (sort of "who am I in 5" data set with an Image, Name, Role, Overview, etc.).

Is there a way to pull out 1 random record from the form for display each time I come to the page (sort of a random showcase of someone from the table)?

Chris Iacovelli_s0j9ah · Answer

@Alex Medved _ConfiForms_ - apologies for the delayed response - as always your knowledge and insights are amazing regarding the inner workings of Confiforms and Confluence.

Yes, I do have a unique id (uniqID) in the table definition and the values are from 2-5 (records can be deleted as staff moves in and out of the group).

my filter -> uniqID:[entry._func.queryCount(teamEntry:2897007829;*).randomInt(1)]

This solved my question a part of the way as I do see random colleagues showing in the hero spot of the page.

However, it does not show the last entry/row of the form, uniqID = 5 (or the randomInt function did not render 5 in the 100 or so refreshes).

Alex Medved _ConfiForms_ · Answer

Do you also have some field that assigns a sequence number for each record?

If you do (or can add it) then you can have something like this in the "The filter to apply on entries dataset" parameter

(assuming this autonumber field is named "seq" and my form is named "ConceptForm")

seq:[entry._func.queryCount(ConceptForm:@self;*).randomInt(1)]