CubeYogi CubeYogi
CubeYogi
/ update_deal_with_associated_product_values.js
Created
December 1, 2020 06:22
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Validating Deal ID | |
| if(deal_id != null) | |
| { | |
| //Getting Deal entry | |
| deal_entry = zoho.crm.getRecordById("Deals",deal_id); | |
| //Validating Deal entry | |
| if(!deal_entry.isEmpty()) | |
| { | |
| //Getting subform entry | |
| associated_products = deal_entry.get("Product_Details"); |
CubeYogi
/ getting_old_value_of_a_field_on_validation.js
Created
December 1, 2020 06:15
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Replace your field name here | |
| old_value = old.<field_name>; | |
| new_value = input.<field_name>; | |
| //Perform your operations below wih both values |
CubeYogi
/ update_associated_deal_by_custom_module_entry.js
Created
November 25, 2020 07:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Validating Custom Module ID | |
| if(custom_module_id != null) | |
| { | |
| //Getting Custom Module entry | |
| custom_entry = zoho.crm.getRecordById("Benchmarks", custom_module_id); | |
| //Validating Custom Module entry | |
| if(!custom_entry.isEmpty() && custom_entry.containKey("Opportunity")) | |
| { | |
| //Getting Deal entry | |
| deal_map = custom_entry.get("Opportunity"); |
CubeYogi
/ update_associated_contact_email_in_sales_order.js
Created
November 24, 2020 08:41
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Validating SO ID | |
| if(input.sales_order_id != null) | |
| { | |
| //Getting SO entry | |
| so_entry = zoho.crm.getRecordById("Sales_Orders", sales_order_id); | |
| //Validating SO entry | |
| if(!so_entry.isEmpty() && so_entry.containKey("Contact_Name")) | |
| { | |
| get_contact_map = so_entry.get("Contact_Name"); | |
| //Getting Contact ID |
CubeYogi
/ calculate_total_from_subform_rows.js
Created
November 24, 2020 06:18
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Declaring total amount | |
| total_amount = 0; | |
| //Getting subform entry | |
| subform_entry = input.<name ofsubform>; | |
| for each entry in subform_entry | |
| { | |
| //Calculating total | |
| total_amount=total_amount + entry.<field of price>; | |
| } | |
| //Updating total amount |
CubeYogi
/ update_contact_value_by_associated_account_field_value.js
Last active
November 24, 2020 05:59
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Validating account ID | |
| if(account_id != null) | |
| { | |
| //Getting Account entry | |
| account_entry = zoho.crm.getRecordById("Accounts",account_id); | |
| //Validating account response | |
| if(!account_entry.isEmpty() && account_entry.containKey("Membership_status")) | |
| { | |
| //Getting Account Owner entry | |
| account_value = account_entry.get("Membership_status"); |
CubeYogi
/ creator_page_with_height_specified_for_embedded_report.js
Created
November 19, 2020 08:06
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <%{%> | |
| <iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/<app _owner_name>/<app_link_name>/view-embed/<report_link_name>/<key>'></iframe> | |
| <%}%> |
CubeYogi
/ showing_record_summary_on_add_notes_field.js
Last active
November 19, 2020 08:02
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| if(input.Accession_Number != null) | |
| { | |
| table_style = "<html><head><style>table, th, td {border: 1px solid black;border-collapse:collapse;</style></head><body><table style="width:100%"><tr><th>Nursery Name</th><th>Action Date</th><th>Action Field</th><th>Qty</th><th>Size</th><th>Bench</th></tr>"; | |
| for each daily_log in Daily_Nursery_Log[ID == input.Accession_Number] sort by Action_Date desc range from 1 to 3 | |
| { | |
| table_style += "<tr><td>"+daily_log.Nursery_Name+"</td><td>"+daily_log.Action_Date+"</td><td>"+daily_log.Action_field+"</td><td>"+daily_log.Number_Containers+"</td><td>"+daily_log.Container_Size+"</td><td>"+daily_log.Bench_Location+"</td></tr>"; | |
| } | |
| input.Rec = table_style; | |
| } | |
| else |
CubeYogi
/ sample_validation_function.js
Created
November 18, 2020 07:37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Showing alert | |
| alert "Hello"; | |
| cancel Submit; |
CubeYogi
/ update_custom_module_entry.js
Created
November 18, 2020 07:36
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //Validating custom module ID | |
| if(record_id != null) | |
| { | |
| //Getting custom module entry | |
| //Replace your custom module link name if needed | |
| custom_module_entry = zoho.crm.getRecordById("Listings",record_id); | |
| //Validating custom module entry | |
| if(!custom_module_entry.isEmpty()) | |
| { | |
| custom_module_map = Map(); |
NewerOlder