Zoho Deluge script : From Deluge Sheet to Deluge List
Budget: $30 – $250 USD
I need an example script for a function when a new contact is being made in CRM. The script is quite easy for a Deluge developer. The script should get the contents of a Zoho Sheet and put the values in a list/array.
The Zoho sheet with 3 columns (screenshot1.png):
* Type
* String
* Value
I want to have these values as an array in a Deluge List to be able to make calculations based on the values. So the contact score will be based on the the contacts Country, Channel Origin and Job Role and value stated in the sheet.
We for example have a BIM Engineer from Brazil. The sheet states that the job role is worth 50 points and the country 150. So the total score for this contact = list.JobTitleValue + list.CountryValue.
Who can quickly draft the example code for me? This is easy money for the one who can help.
For example we have a contact from Brazil from the Channel Organic. The sheet states that the Country Brazil has the value of 150 points and the Channel Organic the value of 1 point.
So what needs to be done:
1. Retrieve the sheet data
2. Put the sheet data in a list
3. Example query which states that the total value
The Zoho sheet with 3 columns (screenshot1.png):
* Type
* String
* Value
I want to have these values as an array in a Deluge List to be able to make calculations based on the values. So the contact score will be based on the the contacts Country, Channel Origin and Job Role and value stated in the sheet.
We for example have a BIM Engineer from Brazil. The sheet states that the job role is worth 50 points and the country 150. So the total score for this contact = list.JobTitleValue + list.CountryValue.
Who can quickly draft the example code for me? This is easy money for the one who can help.
For example we have a contact from Brazil from the Channel Organic. The sheet states that the Country Brazil has the value of 150 points and the Channel Organic the value of 1 point.
So what needs to be done:
1. Retrieve the sheet data
2. Put the sheet data in a list
3. Example query which states that the total value