Hello,
I created a Journal:
with the help of @joost_mineur
This journal has a form that retrieves a random category and a random question from the Questions table. However, I have noticed that after answering the question and submitting it, the answers appear in the Answers table, but they are modified and do not match the question and category displayed in the form at the time of answering, and they update with each edit.
I used these formulas:
Form:
Category –
RandomItem(Questions.Category)
Question – IF(Form.Category.IsNotBlank(),RandomItem(Questions.Filter(Category=thisRow.Category).Question), " ")
Example:
As you can see, the question and category have changed.