How do I show result of an API call on the same Form?
Hi, I am able to use getURL deluge task to call a 3rd party API to do lookup from a Page and dispaly result as HTML. However, I wanted to know if i can use the deluge task getURL from a Form and display result in a table after the successfully response from 3rd party API call? Please advise if this is achievable.
How to create form by using Deluge in Zoho creator.
I have a requirement to create a form using Deluge. It would be possible? If yes then, what is the steps to follow? Please suggest syntax as well.
Deluge function statement limit (nested functions)
Hi, I need to write a deluge custom function that takes the records from one module (around 10,000), process them one by one and then insert them in another module (api v2). If I'd do it in one function it looks like I'd immediately hit the 5,000 statements limit but what will happen if I: - start a loop in the main function - get the records 100 per time (the maximum is 200 but the insert has a limit of 100 so using the same size is simpler); I will fetch only the relevant fields from a view - send
The Slash Command Series - Command suggestions - The power of choosing!
Command suggestions are a cluster of simple inputs given by the system to the user. Simply put, a suggestion list displays options for the command input. The idea behind using command suggestions is to make it easy for the end user, by showing the inputs while executing a command. Most often we find ourselves in a quintessential position where we're looking for a file or a folder packed away in a corner! Think about situations where your Manager and your Mentor ask you to share two different files?
Getrecords and sort order on more than one field
In the getrecords function I can optionally specify the sort by field. Is it possible to sort the records on more the one field (e.g. zip code + city?). If so how? It looks like the function accept just one field. Regards
POST request to attach file
Calling on ZOHO Creator gurus! Can anyone tell me if it's possible to post file attachment using Deluge? I'm developing app that works with ZOHO Books sales orders module. When client 'accepts' quote, application generates PDF file and attaches it back to a Sales Order record in ZOHO Books using API: https://www.zoho.com/books/api/v3/#Sales-Order_Add_attachment_to_a_sales_order
Send Mail on a set day of the week from Zoho CRM
I want to have an email with an embed Zoho Survey sent on a set day of the week say 8am on Saturday From a set of my Zoho CRM Leads So every Saturday at 8am those leads flagged to be Surveyed will automatically have a templated email (with survey link) sent to them. About 200 every week. What I have Tried. 1) Using the Automation Schedules in Zoho CRM I have a deluge script that will fire at 8am on Saturday. The Script will query the flagged Leads enter a For each loop and set a field "Send Survey"
Zoho Creator - Special field 'Integration' with CRM Potentials - How to get record ID and use to update other fields
Hi, I have used the Zoho Creator - built in special field 'Integration' to lookup CRM Potentials in a Form. Field name: 'Potential' Field link name: 'Potential' Im trying to get a deluge workflow right that will find the Record Id (Potential ID) from the Potential field as integrated already in the form. This would then allow updating other fields in the Zoho Creator form by populating the data from CRM record. So, this deluge scrip works in a workflow if specifying the potential ID: crmResp =
Criteria Setting Via Deluge
I have a form that has a radio button named 'Filter'. There are two choices namely '2 years' and 'Custom Filter'. If 2 years is selected a table filled with number of students in each department. If Custom Filter is selected, two Date fields namely 'Start Date' and 'End Date' appear. When a user enters a date for each date field, the table should contain the number of students in each department within those dates. Problem: If I select 2 years, nothing happens to the table, it only displays all of
Map fields between modules with deluge script/custom function
I'm trying to map fields from contacts module into a custom module but having trouble cause I'm probably not setting it up properly. Can someone show sample code to do this? Example Fields in Contacts module are: Last Name, Date of Birth, Phone Fields to map into custom module: Client Last Name, Date of Birth, Phone
Sending Data from CRM to Books
I'm trying to send a date field from CRM to Books but I keep getting an error saying its an improper statement. I can't see any issues with the below. Below is the custom function in CRM designed to update a date field on a sales order when a potential is edited in CRM Date = input.LiveDate; organizationID = input.OrgID; salesorderID = input.SalesOrderID; OrdRSP = zoho.books.updateRecord("Salesorders", organizationID.toString(), salesorderID.toString(), {"custom_fields":{{"customfield_id":"95687000003461005",
Not able to find 'addMonth' function when creating custom function for buttons
Not able to find 'addMonth' function Hi, I'm getting this error when trying to use the addMonth function when creting a custom function for a button in potentials. Anyone come across this before? Regards Michael Not able to find 'addMonth' function
Where To Insert Deluge Code
Hello... I am brand new to Zoho and I've been handed a project. I am the sole IT Director and IT person at my company so I'm expected to take on any and all IT related projects. They had someone with coding experience in our building engineering department start on a project but they recommended ZoHo and they turned over his work in progress to me. So beyond learning ZoHo and Deluge, I also have to figure out where he left off and where to go from here. He started a project in ZoHo Creator where
How can I control the display permission of report with Deluge Script, Zoho Creator
Hi, When displaying a Report with Zoho Creator, I want to use Deluge Script to control the report's visibility by the department of the user who is logged in: display permission user's IP Address restriction dynamic filter criteria setting to the report On Form, I understand we can run Deluge on OnLoad. If there is no OnLoad functionality to Report, please let me know the workaround to achieve the above requirement. Thanks, Junya rashiku corp.
Message Actions: Do more than just Forward, Reply on your chat messages by creating custom actions
Message actions are user actions or interactions performed on a message. Usually, when a message is sent or received, a user is likely to perform some task after the message has been sent/received. All chat interfaces come with a default set of message actions such as Reply, Forward, Delete, Share and so on. But what if these options do not satisfy your requirements? Cliq solves this shortcoming by providing an option to create custom message actions! Let us consider a situation where the #design
Report using a script to calculate Subform data
Hi Experts, I would have liked to be able to add a button to my form so that we can automatically add multiple entries to a subform but a search of the forum indicates it's not possible. Please tell me if I am wrong :-) (Add a start date & number of weeks to the main form, press button and then it then adds an entry for each week [on a Monday] to the subform) On the strong assumption that it's not possible I have a requirement to create a report showing bookings by week/month but that detail is not
Add a related record using deluge?
Hi, I would like to add records using deluge so they appear in a subform. For example, if I have a company form with a subform relating to a contacts form, I would like to programmatically create contact records so they show up in the correct parent record's subform. I can create records with deluge OK, but can't work out how to create the relationship. I saw a similar post to this from 2013, but nothing since. Thanks, Andrew
Creating a SMS Sender ID for zoho messaging.
We are looking at using sms to notifiy external users on the progress of their on-line application forms. I have created a test function which can send an sms to a designated phone. In real live I will take the phone number off a form and pass that to the SMS send function. However we would like a sender ID to appear instead of the default sender phone number with the sms message so the recipient knows it's from our company. Is this possible with the ZOHO Creator default sms facility? if so where
Use Workflow to select a layout
Hi there. I have a situation where based on the value of a picklist, I want to set they layout for a contact. I know I can't do this directly in zoho (which is bizarre), and I know I can't use layout rules to hide related lists (equally bizarre). What I am wondering is if (using a custom function?) if it is possible to assign a layout based on a field value using a triggered workflow. I don't know the scripting language well enough (at all :) ) to know if this is possible. Any thoughts from the
Copying a Lead to a new Custom Module
Hi there, I found a deluge script in this forum from another user who wanted to take a lead and move that lead to a custom module. However, the user wanted to list the copied lead as a dead lead. We do not want to do that. I have edited the deluge script to match our needs more or less, I think. However, when I "Save & Execute Script" the compiler finds an error on line 3. Please see below for the deluge script we are using. The issue starts with "{" If I remove lines 1 and 2 another issue comes
Spaces within Zoho DELUGE Script / Workflow (CRM)
Hello, I'm using a workflow in CRM to update a text field. Below is the line of the code that matters: orderedLength = shoulder + "__________(TRY: "+tryOnLength+" ADJ: "+lengthAdjustment+")";To be clear, I've added an arbitrary 10 underscore "_" characters into the string before the word "(TRY" and I also added an arbitrary 10 blank spaces before the word "ADJ" My problem is that the spaces are being ignored such that output looks like below: 20__________(TRY: 21 ADJ: -1) The 10 space characters
Creator not allowing me to create a crm potential
Accounts, Contacts, etc. are all working within my code, but when I try to add potential I get the check required field is entered correctly error. Not sure why Potentials is the only module that is having this issue but it needs to be resolved
How to pull Client Email address into a Task?
Activities are the least customisable of all the Modules within CRM. Why? I need to pull the Contact Email field contents from a Contact Record into a Task when I create it. I want to use Actions or Workflows to send an email template to the Contact associated with a Task when I mark it, change its Status to, "Complete" As in Dear Client, We have shipped your widget, etc., etc., etc. Any ideas how this might be done, I am prepared to create a Custom Module that looks and acts like a Task in order
Count the Value within a Anniversary Period
Hi, I have a table contains the attendance records of all customers, I want to count the no. of times a Customer_ID attended the class (Date) within each Anniversary Period (based on the Join_In_Date), and return the value to another report like below format, is there any way I can do so? Thanks a lot! Customer ID Range Count ================================================================ 8888 Year 1-
Fetch Value from dropdown within Subform
Hi, I am new to zoho creator and not sure about how to do the following with deluge script . In the Point of Sale application and I want to auto calculate the "Expiry Date" of each item added within the subform based on the invoice date. Expiry Date = Invoice Date + X months In Add_Product Form, i have added a field called Validity Product Name Validity(Months) 4 Lessons 3 5 Lessons 4 8 Lessons 5 Thank you for your suggestion!
Download a CSV file but with semicolon as separator
Zoho offers a built-in CSV Download, but unfortunately it uses only "commas" as separator. Some systems requires a "semicolon ;" as row separator. Does anyone knows a solution for that ? e.g. programming the download based on a list from deluge ? Or does it Zoho has any plans to offer the "semicolon" version of the CSV Download as well? Thanks Alex
Update Subform with field from Parent Form
I am looking for deluge script to update multiple subform entries with the date of the parent form. The purpose of this is to allow me to run more detailed pivot reports with the subform data.
Desk to CRM data transfer
Hello Dear Colleagues! I have complicated situation when one exemplar of module "Contacts" could be associated with more than one exemplars of "Accounts". In this case comes up problem with correct matching tickets with Account. So we created custom field in Ticket form, which is manually filled with correct account name. Is there any work around to parse tickets by ZDeluge, and, if text in custom field check with Account name in CRM, script gets ticketID and add it in custom Multi-line field
Will a record with incomplete mandatory fields be saved if created or updated by delute script?
I am trying to modfy some existing code in an application to add two more fields to a function for updating a record from another or create a new record. However I have found that the record that is being written to or created (destination) has three fields that are mandatory whilst the record used to supply the data (source) does not have these three fields mandatory. So my question is, will I be able to save the record if any of the mandatory fields on the destination form are incomplete.
Workflow Rules and Read Only Fields
Hi All, I'm running a workflow rule to update a particular field on one of my modules. The field, ideally, would be read-only (user can read the value that the workflow rule sets the field to, but cannot change the value). Is the workflow rule able to set the value of that field even though the field is read-only, or do I have to make it editable? Any other way to accomplish a similar end goal? This script is a workaround in lieu of Zoho having formula fields that could display a value from a parent
Deluge script for maximum(added_time) functionality changed (timezone??)
Hello, In my form I have a script which until yesterday worked fine. But now it returns wrong data. It reads last record by added time. It returns time 9 hours back, it is really strange, because the seconds and minutes are OK, just the hours are 9 hours back, as if the code would work in different timezone? In below case, - l_last_day variable returns the wrong time. Please help!!! Code: l_akt = Visits[ID != 0 && Added_User = zoho.loginuser] sort by Added_Time desc; if(l_akt.maximum(Added_Time)
Master Zoho Creator @ Zoholics Developers '17
This August, Zoho is hosting its annual app development conference, Zoholics Developers. This event is a three-day workshop designed specifically for anyone who wants to learn about, build, and improve their skills with Zoho Creator. We'll lead interactive workshop sessions where you can refine your skills, one-on-one sessions where you can chat with an expert, and showcase Creator's new features. You should come if: you want to learn more about building custom applications with Zoho Creator. Whether
Enable and disable the “Enable Payment” checkbox in the “Payment” form settings from within Deluge
Hi, Can I enable and disable the “Enable Payment” checkbox in the “Payment” form settings from within Deluge? I need to do this so I don’t need to create duplicate forms with the only difference being to accept PayPal payments vs payments by cheques. Thanks. Truly, Emad
Catching failed lookups from zoho.crm.getRecordById
I’m using Zoho Creator to pull record information from Zoho CRM, using the method zoho.crm.getRecordById, as such: potential = zoho.crm.getRecordById("Potentials", My_Zoho_CRM_ID);
When My_Zoho_CRM_ID is an ID that exists in the CRM, everything works fine. However, when My_Zoho_CRM_ID does not exist in the CRM, I’m given the following error: Error in executing Set Variable task. Unable to update template variable potential.
Error evaluating MAP expression :
Is there any way to catch this
Count records based on certain criteria
Hi Everyone, Background: I'm brand new to Zoho and have very limited programming experience. I need to count some records based on if they meet certain criteria. What I would like to know is: is this possible to accomplish without learning DELUGE (which would be time-consuming)? I can't see anything obvious myself and a look through the user guide does not show anything obvious either. We have some trainees but I only want to count them if they have completed trainings A, B, C and D from one category
Run Deluge Script Periodically W/O User Input
Hi, I currently need to identify the most recent child record, I do this by flagging the child record with the most recent date field as relevant (all other children are flagged as unrelevant). This works great when all data is entered through the App's Forms, however, when data is imported the relevant deluge scripts don't fire. This being said, is there anyway to run a script like a daemon script in the background to fix data integrity issues such as this periodically? Essentially, all scripts
How to add attachments/uploads to a different record?
We created a multi-page application that updates records in a 'master' record. Each form collects different information and adds it to the master record by passing an ID between the forms. One of those forms allows users to upload documents. How can we create a form that allows the user to upload attachments and add those attachments to the 'master' record by ID? Is this possible? Thanks, John
Custom function to copy info from Potential to Accounts
Hi, So I have in my Deals (previously named potential) two fields, both are Picklist type. During the conversion stage, my people are updating those two Picklist, one is named ''DMS Service'' the second ''DMS Sales''. By default they are set with ''-'' value. I'd like a custom function that when, the picklist is updated with one of the 10 others choice available, it's update another picklist named the same ("DMS Service" and "DMS Sales") but in the Account module. Note that in my Deals, the ''Account
Calling Zoho Creator function from CRM Custom Function
Hello, Is it possible to call a function created in Zoho Creator from a Zoho CRM Custom Function? Here is problem this is trying to solve: I have several CRM modules where tasks are created. There is some processing before the tasks are created. I would rather not create x separate functions to handle this (because they're very easy to generalize given the right parameters and because code duplication is a terrible programming practice) and so I have created a general function in Zoho Creator
Deluge Map From Zoho Books to Dropdown List in Creator
Hey guys, In Deluge, I'm getting all my items from Zoho Books into a map. And now I want to insert all Item Names into a dropdown list in the form onLoad(). How can I do that? I know I can add stuff to my dropdown list doing this: Dropdown:ui.add("Item_name"); I'm getting the items likes this: myMap = zoho.books.getRecords("Items", "123456789", "name"); I'm doing info myMap and it returns this: {"code":0,"message":"success","page_context":"{\"per_page\":200,\"sort_column\":\"name\",\"custom_fields\":\"[]\",\"applied_filter\":\"Status.All\",\"has_more_page\":false,\"page\":1,\"report_name\":\"Itens\",\"sort_order\":\"A\"}","items":"[{\"created_time\":\"2017-02-21T11:52:03+0000\",\"reorder_level\":\"\",\"last_modified_time\":\"2017-02-21T11:52:03+0000\",\"item_id\":\"571662000000056054\",\"item_type\":\"sales_and_purchases\",\"tax_name\":\"\",\"is_linked_with_zohocrm\":false,\"purchase_rate\":1.23,\"description\":\"\",\"item_name\":\"Farinha
Next Page