March 1, 201213 yr Hi ! I'm working with a student testing solution. The student gets a certain amount of questions and he has unlimited time to solve them all. When he has done them all it's time for results. But only the last 30 minutes counts. If the student have used 45 minutes to complete all the questions, only the questions answered during last 30 minutes counts. So when the final question is answered FileMaker performs CountResult -script and a Find -function. One script step goes like this: Get ( CurrentTimeStamp ) - Time ( 0;30;0 ) & "…" & Get ( CurrentTimeStamp ) It is inserted in find mode to a TimeStamp field (each answer gets its own timestamp when answered). This Find never returns anything. So where is the problem ?
March 1, 201213 yr Hi ! I'm working with a student testing solution. The student gets a certain amount of questions and he has unlimited time to solve them all. When he has done them all it's time for results. But only the last 30 minutes counts. If the student have used 45 minutes to complete all the questions, only the questions answered during last 30 minutes counts. So when the final question is answered FileMaker performs CountResult -script and a Find -function. One script step goes like this: Get ( CurrentTimeStamp ) - Time ( 0;30;0 ) & "…" & Get ( CurrentTimeStamp ) It is inserted in find mode to a TimeStamp field (each answer gets its own timestamp when answered). This Find never returns anything. So where is the problem ? Change your "Get ( CurrentTimeStamp ) - Time ( 0;30;0 )" to something like this. Time ( Hour ( Get ( CurrentTimeStamp ) ) ; Minute ( Get ( CurrentTimeStamp ) ) -30 ; Seconds ( Get ( CurrentTimeStamp ) ) )
March 1, 201213 yr Author Still no success... Now the search string in the TimeStamp -field look like this: 20:23:17…1.3.2012 20:53:17
March 1, 201213 yr Get ( CurrentTimeStamp ) - Time ( 0;30;0 ) & "…" & Get ( CurrentTimeStamp ) It is inserted in find mode to a TimeStamp field (each answer gets its own timestamp when answered). I don't see why it wouldn't work as expected. Check that the field is indeed of Timestamp type. Also see what are the actual criteria used, by selecting Modify Last Find from the Records menu.
March 1, 201213 yr Author Uuh... Yeah ! Of course ! The field was a "Text" -field. Now it works. Thanks again !!
Create an account or sign in to comment