CRM Custm fields

CRM Custm fields

1. Are Zoho CRM custom fields able to have a function:
Field 1= Y
Field 2= Field 1
OR
Field 1= Y
Field 2= Field 1+2
Or
Field 1= Y
Field 2= If field 1 = Y field 2 is greyed out /made visible
2. Can you use scripting as in Zoho creator to create complex relationships.
3. Is there a manual for the scripting in Zoho creator?
4. when will tie CORM and creator be integrated?