Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Please let me know how to make existing scripts automatically apply to new data. Recently went to jmp 17. The file I have is originally from jmp 16 (or earlier). In jmp 16 all the scripts I have would Apply as soon as I added more data. Now in jmp 17 the columns that have scripts only Apply if I open the formula and hit Apply.