Help building a Random Task Generator

[Christianha]

I want to build a random task generator using Google Appsheet.

I have a list of random tasks that are in a Google Sheet column.
I want the App to:
- identify the logged in user
- have a button which, when pressed, retrieves a task randomly from the Google Sheet list
- the task is presented to the user below the ‘Generate Random Task’ button 
- have a 'completed' button
- when the 'completed' button is pressed, the user, time, date, and task are added to another spreadsheet
- it should have a running tally of how many tasks have been completed for the week (for example: 3 out of 5 tasks completed). This should reset to 0 at the start of every week.

I’m fairly proficient with Google Sheets, and have been able to build basic Appsheet forms, but the biggest difficulty is the ‘Generate Random Task’ button that picks a random task from a spreadsheet.

Any help would be greatly appreciated!

Thanks, Christian

[Aurelien]

Hi @Christianha 

"but the biggest difficulty is the ‘Generate Random Task’ button that picks a random task from a spreadsheet."

What about an expression like this ?

INDEX(
  TaskTable[keyColumn],
  RANDBETWEEN(1,COUNT(TaskTable[keyColumn])
)