Roman Numeral

Hi, is there a formula to set a form so that a user only enter roman numeral only? Thank you for your share

You can simply construct a Valid_if like:

AND(
	CONTAINS(
		{"I" , "V" , "X" , "L" , "C" , "D" , "M"},
		[_THIS]
	),
	NOT(
		CONTAINS(
			{"A" , "B" , "E" , "F" , "G" , "H" , "J" , "K" , "N" , "O" , "P" , "Q" , "R" , "S" , "T" , "U" , "W" , "Y" , "Z"},
			[_THIS]
		)
	)
)

This ensures that only letters associated with Roman Numerals can be entered into the field. Provided you want to verify the validty of the roman numerals entered in the field and/or need to convert it to an integer later to use in a calculation, that will be a whole different story.

1 Like