Fetch values of a field from all the records in a collection

Iterating through records in a collection variable

Example

The following code iterates through the records in collection variable employeesJoinedToday, and sends an email to each email address present in the collection. Email is the link name of the email field type.

1. for each employee in employeesJoinedToday
2.   {
3.       sendmail
4.          [
5.            from: zoho.adminuser
6.            to: employee.Email
7.            subject: "Zylker : Offer Letter"
8.            message: "Welcome to Zylker. Please find your offer letter attached with this email."
9.          ]  
10.    }

Updating field value in a collection variable

To update a field value in the first record in a collection, use the following syntax:

1. <collection_variable>.<field link name> = <expression>;

where,

​​To update a field value in every record in a collection, use the below code:

1. for each <record_variable> in <collection_variable>
2. {
3. <record_variable>.<field_link_name> = <expression>;
4. }

where,

Example

The following syntax updates the Batch Sequence("number" field type) field with the value 118 for all the records in the collection variable employeesJoinedToday.

1. for each emp in employeesJoinedToday
2.   {
3.     emp.Batch_Sequence = 118;
4.   }

1. You must specify only the link name of the "Address" field when assigning it a value copied from another "Address" field.
   
2. In all other cases, you have to give values for its sub-fields separately as given below:
   
3. <field>.address_line_1: denotes the "Address Line 1" field.
   
4. <field>.address_line_2: denotes the "Address Line 2" field.
   
5. <field>.district_city: denotes the "City / District" field.
   
6. <field>.state_province: denotes the "State / Province" field.
   
7. <field>.postal_Code: denotes the "Postal Code" field.
   
8. <field>.country: denotes the "Country" field.
   
9. <field>.longitude: denotes the "longitude" field.
   
10. <field>.latitude: denotes the "latitude" field.
    
11. You can add the above mentioned sub-fields even if they are not selected in the field's property.
    

Note:

If more than one address fields are present in the form, the link names of the subsequent address sub fields will be appended by a number starting from 1. So, if we take the example of the subfield <field>.country, the link name of the first such field will be <field>.country, the link name of the second such field will be <field>.country1, the link name of the third such field will be <field>.country2, and so on.

1. You can specify a new choice apart from pre-defined choices even if the "Allow Other Choice" field property is not selected.
   
2. If a new choice is specified as the value, it only gets saved in the record and is not added as a new choice to be selected from the form UI. And that choice cannot be retrieved back if modified.