Simple Calculator with Zoho

Simple Calculator with Zoho

Hey there,

I have created with Excel a simple calculator. The topic is a plastic specification called MFI. There are three different kinds of MFI: MFI 2, MFI 5 and MFI 21

I have created the calculation between these three. The aim of the calculator is to calculate the other MFI´s if you have got one of them. I.E.

you have got MFI 2 and you want MFI 5 / MFI 21. 



MFI 2 MFI 5 MFI 21
Input 1

Output 1 4,5 100





As I said I have got all the calculations in all directions, but I can't implement this into Zoho Creator.

Is it possible to do this without a view - that if you type in the given MFI in the conform field - the other fields will filled out automatically ? Or does I need a report for this? 

Can someone explain me the way how to realize this? I am a little bit confused of the "Form Action", "On Add", "Validate", Field action and so on.

My actual conclusion for the first field (MFI 2)  is (here should be created a report.... ):


  2. {if(input.MFI_i2 == 0)
  3. {
  4. if(input.MFI_i5 == 0)
  5. {
  6. insert into Rechner
  7. [
  8. Added_User = zoho.loginuser
  9. MFI_i2 = input.MFI_i21 / 100
  10. ]
  11. else
  12. {
  13. insert into Rechner
  14. [
  15. Added_User = zoho.loginuser
  16. MFI_i2 = input.MFI_i5 / 4.5
  17. ]
  18. }
  19. }
  20. else
  21. {
  22. insert into Rechner
  23. [
  24. Added_User = zoho.loginuser
  25. MFI_i2 = input.MFI_i2
  26. ]
  27. }
  28. }
  29. }

It would be awesome if someone could help me :) 

ps. you can find the Excel Calculation here http://www36.zippyshare.com/v/2126219/file.html(Ignore the German Tutorial, "Eingabe" means Input and "Ausgabe" output - it should be self explaining!)