The FileMaker function FieldType currently give limited information about the field index: Indexed or Unindexed. Why so limited?
I like to have a function FieldIndexType ( FileName; FieldName ) that returns: None | Word | Value | Full or None | WordIndex | ValueIndex | FullIndex
I just realized, the function should also return a value (true/false) of the option "Automatically create indexes as needed".
This product idea is an addition to all the other ideas regarding index like