Protect fields on Edit Form

Hi,

I'm using 3.1 and I think this should help. Go to step 6 of 12, it should be the step where you can choose the fields you want to show in the tables. Uncheck the ones that you want to protect under the Edit column. That should work. Good Luck!

The other option is go to the edit form in visual and make those fields read only.

Thanks Graeme for your reply!

1. When I uncheck a field in step 6, This field does not display on the edit form. I want the field displayed and the mode to be protected.
   
2. If I make the field readonly under the visual attributes then this very same attribute of
   
   readonly is replicated to the add form. I want the field to be input on the add form.
   Any help will be greatly appreciated.
   Regards
   
   Kes

Thanks Graeme for your reply!

1. When I uncheck a field in step 6, This field does not display on the edit form. I want the field displayed and the mode to be protected.
   
2. If I make the field readonly under the visual attributes then this very same attribute of
   
   readonly is replicated to the add form. I want the field to be input on the add form.
   Any help will be greatly appreciated.
   Regards
   
   Kes

You can set different attributes on the add form. Use visual editor to change them. They can be different on different pages you need to set them separately in visual editor.

Kes,
you can do the following:

1. edit your SQL query on the Edit SQL query tab.
   
   Here is a sample:
   

   select Field1,
   

   
   Field1 as Field1Readonly,
   
   ...
   
   from TableName

2. check off Field1 on the Add page, Field1Readonly on the Edit page on the Choose fields tab.

3. set up Field1 as text field, Field1Readonly as readonly field on the "Edit as" settings dialog on the Visual Editor tab.

Thank You Jane,
Your solution is brilliant!
Regards

Kes