Can a record be locked

[hartmut]

I have made a quiz file. I want the user to be able to add a duplicate of a question they are having a hard time answering. They get that question displayed more often. But if they are getting the answer correctly after a while they can delete the extra duplicates. Some way I need the original questions to remain in the database so at least one copy of the question remains safe. The user can then duplicate or delete a record but not the original. Is this somehow possible or scriptable ? Thanks

[No_access]

It is simple enough to lock a record however to prevent someone from deleting that record, that depends on their permissions, Ideally you would probably want the original questions in their own table, a table they can not edit, modify or delete, you can then pull your questions from their.

 

Of course if they are deleting extra's via a script you can  create a simple lock field that the script checks and if it is say a "1" then it won't let them delete. 

[bcooney]

I would think that you would need 3 tables (Users>Answers<Questions). Answers is a join table and contains, at minimum, QuestionID, UserID and their Answer.

 

New Quiz imports QuestionIDs into the Answer table. They would duplicate a record in the Answer table (not the master Question table).

[comment]

II want the user to be able to add a duplicate of a question they are having a hard time answering. They get that question displayed more often.

 

Getting a question to display more often does not necessarily mean it needs to be duplicated. It would probably be better to look at the way questions are selected and presented to the user.

[hartmut]

Thanks for the answers

I have been trying to get it. But I am having difficulty. I have made a simple quiz file. It has ten questions and has 2 tables (questions and answers) (Answers).

The questions and answers table is the one I don't want to modify. I can make the number of questions I want but if they are not getting the answers they can duplicate the record to increase the number of times they would be quizzed on that question. (add button) . If they are comfortable with the question they can reduce the number of the duplicated records by pressing the reduce button.  I don't know how to keep them from deleting the record when there is only one. 

What I have done in the file I have attached is what I want to do but I am probably doing it in some convoluted way. If you try the file i am uploading. Make sure you are in the "answers" layout and then press random to get a random question.

 Help is needed here to get to this in a less painful way. Thanks

quiz for forum.fmp12.zip

[hartmut]

Thank you Comment

In the example I leave it in the user hands to determine if that question needs more work. They decide then and there to add or subtract. The questions are randomly selected to accommodate newness and consider the duplication.   I am not sure if my example is the best way . I don't know even if I did it correctly...

[comment]

The questions are randomly selected

 

It's possible to rank the questions, so that questions with higher rankings are selected more often. Unlike duplication, ranking allows you to promote a question by any value, not just 1 - so you could set a question to be selected 1.5 times more often than others, for example.

 

See an example of randomly selecting ranked values here:

http://www.briandunning.com/cf/1517

This is a recursive custom function so you'd need the Advanced version to implement it as is; however, since you are selecting via a script you can have the script accomplish the same by looping.

 

Note also that if you have multiple users taking the quiz then each will require their own set of rankings. In such case you will have to add a Rankings join table between Questions and Users.

[hartmut]

Thanks

I just added a ranking table to my sample. 

I am starting there.  I don't understand how to implement multiple users. 

I will not be able to use the advance filemaker making this so I will have to understand the formula much better. 

I am working on that now but 

I am kinda stuck. 

I want to leave it to the user to decide the importance of the questions they are having a hard time with. I want to make it simple for them to use the 2 buttons I provided to increase the probability of REvisiting that question ... but when they have attained mastery over that question they can reduce the revisiting.

So it seems by what you are saying that the ranking would be changed on the new table. 

It must be a larger number but I am not sure how the calculation works to make it appear for revisit more often in the list 

Sorry 

Thick here.

[comment]

Here is a simple file that shows how to script the selection of a random object according to its ranking. Note that ranking can go as low as zero - meaning that the object will never be selected.

DiscreteRandomScript.fp7.zip

[hartmut]

That is wonderful. I think I can get it. I just want to study how it was done.  I am excited to learn how this script was made. 

That means I could ad to the ranking or take away from it and I would not loose my questions and make a small file size. 

This makes my day. Thanks so much for the help.