Jump to content
  • 0

Randomly Select 1 Of Many Matching Record



I'm building an application to do the following:


Randomly select an existing profile when the page loads, allow the user to update some information, and submit the information. Each record will be selected by a status, and the status will be changed when the user submits the necessary information.


I know how to do this using PHP, MySQL and Javascript. How would I do this on this platform? I'm using the free version for right now.


I'm struggling with the "randomly select" bit at the moment. I don't think it can be done with a view. Any ideas?


Thanks in advance for your help.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hello frankarchway. 


You could use List or Gallery report with search field. On the " Result Page Options" wizard you should set : 


1) Records per page =1 

2) Default sort order= Random order. 


This will show you only one random record, which you can update on the Details Page. 


I hope this solution helps. 



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...