i'm new to Zoho Creator and i want to build a form/app witch wil used by my employee.

He will fill this form at the job site.

Now i've manage to build the app for 80 % only i have a few issue's

We have ± 20 customers and each costumer has ± 4 contacts.

Now i made a drop down wit the costumers name and mad a rule "when customer field = "customers name"" then show the subform of costumer "costumers name". This subform has 2 drop downs with "sent quote to" "sent .dwg file to".

This is working only when i sent the mail is shows all of my fields in this form even when there empty.

Now i was wondering do i have to do this with lookup fields? i've created a lookup field and it works fine. but when i make a rule like, "when the lookup field = costumers name the add a sub form "ContactSubForm "costumers name". But it seems that it is not possible to make a rule like this. So i was thinking to load the field on entry, so i used in the costumers name field in the script builder on user input "var = Contact[ID == input.Contact_01];" to load the field but this does not work.

i think this is an simple function but i'm not able to pull it of at this moment, any one a hint to get me in the right direction?

The main problem is that i don't want all of my fields in the mail but only the field witch are used or selected.

Regards Jos