Can someone help me with this calculation :

I have defined the following fields :

Field VN text (input string of max. 30 characters)

Field VN1 text (cal. Field showing one char. of VN on position 6)

Field VN2 text (cal. Field showing one char. of VN on position 7)

Field VN3 text (cal. Field showing one char. of VN on position 8)

/

Field VN25 text (cal. Field showing one char. of VN on position 30)

Field Nr_options number (count of possible VN numbers)

Field Error text (cal. See description below)

In field Error in want to show the user a warring of a incorrect input in field VN by using a calculation.

For example :

If field Nr_options = 4 > Error field must show “Option 5 now not possible !!” by typing a char. in VN on position 10. If the user typing too more characters the Error field must show “Option 5,6,7 now not possible !!”

How can I put above in a calculation…..?

PL help me out !!!

Perhaps you can make use of repeating calculation fields here.

bad_time.zip

Thanks mr_vodka, (I owe your one!)

Its exactly where I was looking for.! Normally I am a little bit afraid to use repeating fields, but this is a useful application for repeating fields.

@rjen