To try out AppSheet, I have created a simple quiz for my partner, based on a table in Google Sheets, it creates a list of questions in another table, and the App should just load the new questions when refreshed.
To allow the questions to refresh, they are based on random formulas in the Google Sheets, and I have turned on automatic refresh. Looking at the sheet, it happens as scheduled.
But the problem is that, apparently, it does not refresh the saved version of the sheet, which mean that when I try and sync the app, it always loads the same series of question.
I have looked a bit around to find either a proper solution or a workaround, but I must admit I’m stumped.
Can anyone offer any suggestion ? Thanks in advance…