Hi All,
I need help to create a setup for Random Messages when a user of my app submits an action or edits a form. What I mean is instead of a single message like “Done”, it would select a message from an array of message for example and display that instead of the static message. E.g Each time they submit an action a different message is selected randomly.
Thank in advance.
Create a helper table with random answers in each row… add a column with the row number… add the Random Number column. multiply the result by a number of possible answers… make it an integer… relate that result to the row number… you will get your random answer by looking up that reletion
Thanks for the reply, I think i have done it as you instructed. not 100% sure
How will it dynamically change and select a different message each time an action is completed? How do i then use this message in a different table?
Every time you complete an action, you need to trigger the random number… by changing the random number column source (seed), you can use a current date or a unique identifier… then copy that message using a single value column to any table you wish
