Serious problem

Greetings...

I have a SERIOUS problem...I have worked for several weeks now creating an app in Creator and realize now that I have made a mistake and the app will NOT let me fix it.

I declared an email field as both unique and required and I realize now that I need it to neither of those.

I have tried to change it through the form edit window AND in the script view but I get a SQL error (in the script view...in the form view it just won't save the changes).

I have removed all references to the field in scripts and in views and attempted to delete the field. But it will not let me delete the field either. And since it is required and unique and is part of the foundation form that the app is built on it basically renders the entire app unusable.

PLEASE help me. The app is the only one in my account and is shared for support.

Thanks in advance...

Joel
joelnann1