Automatically add record

Automatically add record

Hello,

I would like to know how could I do build a script that automatically adds the zoho.loginuser into a field (lets call USER field) of a form (lets call it form 2) of a user that has generated data into another form (lets call it form 1) when a record from another field that has imported data from the form 1 is selected. Example:

FORM 1

Fields: 

- Product (text field)
- Add User (zoho.loginuser)

FORM 2

Fields:

- Product List (Imported data from all the records of FORM 1 - Product Field)
- USER (automatically add the user that inserted the record in the FORM 1 when his product is selected in the field above)

Is there any solution for that?

Thanks.