Custom Properties Lookup Table
I want to thank everyone for providing help with my problem. The support of the Rev community is what makes Rev even more special! I hope that as I progress in Rev that I can in turn help others. Charles Szasz [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Custom Properties Lookup Table
Sorry - the following line should have been deleted from the example; put the scaledScore[memory] of field data1 into theMatch2 ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Custom Properties Lookup Table
Hi Charles, Others have posted solutions, so I'll focus on what happened. I could be wrong, but I believe Rev looked at this part of your script: if item 1 of theMatch and item 2 of theMatch and item 3 of theMatch = item 1 of theMatch2 and item 2 of theMatch2 and item 3 of theMatch2 then put item 4 of theMatch2 into field ssFld end if .. and thought this is what you meant (weird spacing added to improve readability): if ( (item 1 of theMatch = true) \ and (item 2 of theMatch = true) \ and (item 3 of theMatch = true) ) \ = ( (item 1 of theMatch2 = true) \ and (item 2 of theMatch2 = true) \ and (item 3 of theMatch2 = true) ) then put item 4 of theMatch2 into field ssFld end if So everything before the = resolves to 'false', as does the entire part after the =. So the conditions ultimately resolve to: if (false) = (false) then put item 4 of theMatch2 into field ssFld end if So item 4 of theMatch2 would be put into field ssFld every time. Is that consistent with the results you were getting? Thanks - Phil Davis Charles Szasz wrote: I have set up a custom property set (scaledScore) for a field (data1), with custom properties (memory) and property contents listed below: 51,1,0,4,2 51,1,1,5,5 51,1,2,6,9 51,1,3,7,16 51,1,4,7,16 51,1,5,7,16 51,1,6,8,25 51,1,7,8,25 51,1,8,8,25 The first row of the 51,1,0,4,2 above represents: age (51), followed by the number of the subtest (1), raw score (0), scaled score (4), percentile (2) I have been working on a handler to take input from the user for age (tage), subtest field (field subFld, raw score (field rsFld). After the user enters the age, subtest number, raw score, the scaled score appears in the field ssFld after it is look up in the custom properties. on mouseUp put 51 into tage put tAge,field subFld,field rsFld into theMatch put the scaledScore[memory] of field data1 into theMatch2 if item 1 of theMatch and item 2 of theMatch and item 3 of theMatch = item 1 of theMatch2 and item 2 of theMatch2 and item 3 of theMatch2 then put item 4 of theMatch2 into field ssFld end if end mouseUp This script does not work and no errors appear in Rev IDE. Can anyone help me with this problem? Charles Szasz [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Custom Properties Lookup Table
This is using the FILTER command and a wild card pattern on mouseUp put 51 into tage put comma into c put * tAge c fld subFld c fld rsFld c * into pattn get (the scaledScore[memory] of field data1) filter it with pattn -- put item 4 of it into field ssFld (not yet) --now check the result if the number of lines in it 1 then answer multiple hits of cr \ it cr cr \ using pattn else if the number of lines in it 1 then answer Nothing matches cr pattn else put item 4 of it into field ssFld end if end mouseUp Jim Ault Las Vegas Charles Szasz wrote: I have set up a custom property set (scaledScore) for a field (data1), with custom properties (memory) and property contents listed below: 51,1,0,4,2 51,1,1,5,5 51,1,2,6,9 51,1,3,7,16 51,1,4,7,16 51,1,5,7,16 51,1,6,8,25 51,1,7,8,25 51,1,8,8,25 The first row of the 51,1,0,4,2 above represents: age (51), followed by the number of the subtest (1), raw score (0), scaled score (4), percentile (2) I have been working on a handler to take input from the user for age (tage), subtest field (field subFld, raw score (field rsFld). After the user enters the age, subtest number, raw score, the scaled score appears in the field ssFld after it is look up in the custom properties. on mouseUp put 51 into tage put tAge,field subFld,field rsFld into theMatch put the scaledScore[memory] of field data1 into theMatch2 if item 1 of theMatch and item 2 of theMatch and item 3 of theMatch = item 1 of theMatch2 and item 2 of theMatch2 and item 3 of theMatch2 then put item 4 of theMatch2 into field ssFld end if end mouseUp This script does not work and no errors appear in Rev IDE. Can anyone help me with this problem? Charles Szasz [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
