Any news on "Deluge NG" ?
This post from the man behind ZohoCreator mentionned about a new version of the Deluge language called "Deluge NG". Now what is ahead over the next few years? I am personally working on what I call Deluge NG - the next generation of Deluge that I hope would offer much more expressive power, while at the same time being as accessible as Deluge today. My goal is to empower the "casual programmer" or even power user to get a lot more done, without having to get a Computer Science degree. It is still
Task Assignment in Custom Function
Hello, I have this Custom Function, where I fill some fields. I also need to fill in the "Task Owner" field with the Potential Owner. My code: mp.put("Task Owner",PotOwner); Does not work, because it assigns the task to the user running the Function. How could I set the Task Owner as the Potential Owner properly? Thanks! PotentialsList = zoho.crm.searchRecords("Potentials","(RunWorkFlow|=|True)",0,100); for each rec in PotentialsList { pId=rec.get("POTENTIALID"); TaskClosingDate=(rec.get("Closing
Fail to update URL field Deluge script
Hi there, i need your help. i'm trying to update through custom function script a field called website which is of a URL type. Not only it fails, but while debugging it i see that some fields doesnt exist in the map object returns when i call the zoho.crm.getRecordById function. one of them is the Website field, other is the State and City fields. Why it happens and how do i handle it? Thanks!
How do you show / hide fields based on a group
Hi Could you please help I have some control fields that are used by admin staff to control a users permissions. Such as setting the type of user in the portal, business user, general user, etc. I cannot let the portal user see this information or edit it. I do need the admin logged in users to be able to change it. As field permissions only all "Everyone" or "Admin" (I would have loved this to be a user group - but I cannot find it) I am using a method of show and hide. I can turn on access for
change the display name of a field via script
Hello Zoho creator developpers, I want to know if there is a possibility to change the display name of a field depending on a condition. Something like: If (expression) { // set the display name of input.fieldDelugeName to "company adress" } else { // set the display name of input.fieldDelugeName to "contact adress" } That will save me having a lot of field that do the same and use theme everywhere other script with conditions. Thank you
Problems with Charset and Picklists
I have the following problem with picklists and using the data in deluge script> I have a custom field in my vendors that is a multiple picklist. All works fine within ZOHO. However the data stored in the custom field is not the correctly formatted text. To explain. I have a customModule with a field "Location Name" Location Name contains the following correctly encoded charset text: "Chambéry Airport" When I pick the same name from my Custom filed lookup in the Vendor Record the data is held
Delete Alert Box Confirmation
I have a delete record button in one of my stateless forms so that can delete a record. The button works fine but I really need a confirmation button so that users don't accidentally delete a record. My Code currently looks like this: if(input.Account_ID != null) { delete from Account[ID == input.Account_ID]; openUrl(("#View:Accounts"),"same window"); } the above script runs when a form button is clicked. I need it first to ask a confirmation with the options confirm or cancel. Again, I just
Need a BUTTON that will increase the value of a number by 1. How do I code this in deluge?
Any assistance would be greatly appreciated. Say I have a shopping cart line item with a count value of 0. I would like a button to the right that increases the count by increments of 1. Is this possible in deluge? Thank you
Zoholics: Developers 2016 Details!
Hi everyone, Join us for Zoho Creator's 3rd annual conference at our headquarters in Pleasanton, CA. The event consists of a two-day (Apr 27-28) application building workshop where you'll learn how to plan, build, and automate a Creator app from scratch. On April 29th, we'll have our annual Zoholics: Developers event. Product specialists will demonstrate Zoho Creator's advanced features, and reveal what's in store for the future. More details below 1a. End User Workshop (April 27 & 28): Going over
Display Multi-Select Field in HTML page
Hello there, I'm trying to show/display a multi-select field in a HTML page. Below is the code i'm currently using. <%for each task in job.Task {%> <h4><%=job.Task%></h4> <%} This is how it ends up displaying: <h4>3094299000000125003,3094299000000125007</h4>But I need it to display like this: <h4>3094299000000125003</h4> <h4>3094299000000125007</h4> If anyone could point me in the right direction that would be smashing. Thanks, Giles.
Shedules Settings Issue in Zoho Creator
I'm using Zoho Creator and want to add rules to trigger an email notification whenever one of these criteria is met: 1. It's 7th day after the date recorded in death_date field, which is Date-Time type field 2. The 40th day, respectively 3. And one year past after that date I want the system to send reminders in form of email notification 2 days before those specified dates. I've created some schedules (see screenshot): But the Form and Field fields are inactive, so I can't edit them. And here is
How to detect maximum number of executable statements per deluge action
How do I detect if one of my users has reached the maximum number of deluge statements limit so I can have them contact me so I can manually update ranges of records for them? What's the best way to notify the user and log the event? Is there a way to test a function prior to execution to determine the number of deluge statements it will consume? If I call a function that has 2 statements, would that count as 3 statements? This is the case I am trying to solve for: I have an application that groups
Setting a numeric variable.
I need to set a number or currency field based on another value. My if condition is working perfectly fine but I cannot get the correct syntax to set a numeric field using the script. I can set the text fields perfectly fine. I've tried the following: number_field = 14; input.number_field = 14; set number_field = 14; set input_number_field = 14; I've set the number_field as a currency field and tried 14.0 as well but didn't work. I have a radio buttons and based on the selection I want to populate
Open published form in iframe using recLinkID criteria
Hi clever people, I am trying to open a form using the recLinkID from another form which is embedded in an iframe and published (not requiring a user to be logged in). I have managed to get the form to open from a previous embedded form using: myURL = "https://creator.zohopublic.com/<username>/<appname>/form-perma/typesfrm/<encryptioncode>/recLinkID=" + thisID + "&viewLinkName=typesfrm_Report"; openUrl(myURL, "iframe", "formEmbed"); ...but the update button in the form does not work to update the
Records not really being deleted
I have developed an event reservation form for teachers and staff at my school, to incorporate some location conflict checking. When scheduling an event, the user enters the Start DateTime and End DateTime; at that point, deluge scripting searches the database of events, looks for any overlaps in the times for existing events vs. the requested event, and then updates a dropdown menu of available locations. Thus, if a location is already booked, it is unavailable for future reservations during that
fetch data from subform in page
Bit of newbie question here: I'm working on an app where there are two forms: form name: section_builder field1: letterTitle field2: textSnippets There is a subform: form_name: text_snippets field1: snippetTitle field2: snippetContents Field 2 in form 1 is a multi-value selector which corresponds to field 1 in form 2. What I want to do is create a deluge script in a page which will simply output a list of all the text snippets that correspond to a single letterTitle. I have read the article https://www.zoho.com/creator/help/script/fetch-records.html,
Zoho Creator - onEdit previous values
Hello, can I somehow access previous values of fields in form in action "On Edit" - in "Validate" and "On Success"? The form creates record that can be moved in Calendar View - "On Load" is not invoked when moving block in Calendar. It's only invoked when I explicitly click paticular record and choose "Edit".
Show/Hide Fields Based on Checkbox Selection
So I've created a form with a Checkbox containing 3 options. I would like different fields to be hidden/shown based on what selection the user made. Thus, I created a deluge script similar to the one described here: https://help.zoho.com/portal/en/community/topic/hide-or-show-multiple-fields. While this method has worked in many ways, I've encountered some problems. First, when a user tries to select more than one option from the checkbox, none of the hidden fields that should be revealed are shown.
import - disable deluge controls
Hi, I have a form with a lot of deluge controls in on load, on validate, etc. Sometime I need to export the Table (using the report-export), elaborate it in Excell and import again. When I try to import the import wizard gives me a lot of errors due to the deluge controls. I have to delete deluge controls in on load, on validate, import the table and load again the deluge controls. Is there a smarter and quick way to do it? tks, Pippo
Web hook related list
Hi, Is there a way to trigger a web hook when a related list (Products) has a new record added to it from the Leads module? Thanks
No split function in string methods?
Hello, i would like to have a confirm that there is no split function in string methods in Deluge. I have written a custom function that use getUrl function to get data from an external service, the response can be very long (each value on a different row) and it would be really useful to have the capability to split the response string in an arryay for each single row.
Zoho CRM Contacts Lead qualification function
Hi guys, I'm trying to build a custom function in zoho crm to determine the qualification score of my leads. So I have a number of picklist fields within the contacts module: What do you want to achieve? How much of a priority is it? What will happen if you do nothing? If these fields have a value they will add to the qualification score, If they do not have a value they won't add to the qualification score. Different fields will have different scores. e.g. if "what do you want to achieve is" has
Switch statments
HI I am in need of using Switch statement in deluge script for an application which i build. by switch i refer to this statement in PHP: $i switch $i { case 0: Do something case 1: Do something else } Is there such a statement in deluge? if not, can you add this functionality? Thank you Tal
Inserting Comments into Free Flow Scripting
Can't find an answer to this, so hoping it hasn't been raised before. Whenever I attempt to add a comment in free flow, like this: //comment text I get a "null" error. It works in script builder, but I want to be able to do it within form definitions and so forth.
Complex "Duplicate" warnings in Forms
Hi all and thanks for your understanding. i try to setup a Duplicate record warning when user input data in a form. I have three fields : "Item référence" : a no duplicate filed "Start date" : date of use of the item "End date" : date of end of use of the item. If I select for a second record a period inside the period allready selected for the same item, an alert prevent me of saving the record. Exemple : Row 1 Item1 - 01/01/2015 - 31/01/2015 : input accepted Row 2 Item1 - 01/02/2015 - 28/02/2015
How to import into a table in ZCreator from an external REST API source
Would be VERY glad if anyone could share a simple deluge script (.ds file) with an example of how to import data and put it in a table in ZCreator. The data are picked up from an external source with a REST API. In my case I want to import data from from Zoho Books, so if anyone have an example of how this is set up, it would be even greater. I know the REST API works, tested with curl, but need an .ds example to be able to get this into ZCreator. Thank you.
Dynamically Update Subform via Deluge
Currently I have a main form for Orders, a subform for the Model information and a Product form for each individual asset. The order form has the Model Form as a subform and the Model form has a serial number field which is multiline. I have a script, that works properly, to create an entry into the Product form for each serial entry. On the model form I have a sub form linked to the Product Form. After the script runs the subform in model form never updates. In my script I have assigned a lookup
Using "clear" on a picklist in s subform results in invalidTaskInSubForm
According to the doc https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html I should be able to use "clear" to clear the current values in a subform picklist on the On User Input. but it does not work. list = Member_Rep_Shift [ID == Appointment_Details.Shift_Picked]; clear Appointment_Details.Time_Picked; Appointment_Details.Time_Picked:ui.append(list.Available_Hours.getall());
Issues dynamically populating a SubForm at the OnAdd.OnLoad event
I want to know how to populate a subform at the OnAdd.OnLoad event of a form. I already know the ID of the fields I want to populate it with, as they already exist in the subform and I simply want to replicate them. I am having issues with the dynamic creation of the rows in my SubForm. For context, I am building a feature that allows the user to create multiple versions of the same record, with minor changes, and so I built a custom action that redirects the user to the onAdd of the form, with a
Add Button to a Page
I have a Page which pulls and summarises data. At the bottom of the page I would like a button which once the user is happy the summary is correct can click to load data into ZCRM. I have created the data load to ZCRM using a button on a stateless form but would like to do it from a Page. Is this possible? Thanks Gordon
Can a Form in Application A be referenced in a Zoho Page in Application B
I have a set of forms (tables) that are common and needed in a number of applications within a Zoho account. I would like to avoid duplicating the forms and its data in every application. These tables reside in Application A. Now when I am creating forms in Application B, I can reference these tables of Application A in Look ups without any issue. However, if I try to write Deluge code in HTML pages in Application B, it does now seem to work. Here is how I am referencing form of Application A in
Comma-delimited list in Deliuge
Child form has fields for State, City: Example Ohio | Akron Ohio | Toledo Ohio | Youngstown I want parent form to show: State, CityList Ohio | Akron, Toledo, Youngstown Can I script that with deluge and how?
SubForm Limitations
I understand that a sub-form's deluge scripting don't happen when data is posted. I'm finding this problematic, but surely there are work arounds.... 1. Can a script run separately to do the necessary updating (eg, updating fields with related values) 2. Can data in a sub-form be shown in View Only? So that the data is posted by other reports, but I can still see a master form with its related sub-form information? 3. Do you create buttons from the parent form, that open up child forms? It's
Deluge Script - syntax needed for reaching to another application
In the script below, how do I indicate that the Companies form is in a different application? if (Companies[ID == input.Company_Code].count() >0) { temp = Companies [ID == input.Company_Code]; input.CoCodeFetch = temp.Code; }
Why does this deluge script not work?
The script below hangs, and doesn't work. How do I fix this? I think the script is saying: show all rows from Groups where Group_Members.UserRecrodD contains (zoho.loginuserid) I want it to say: show all rows from Groups where Group_Members.UserRecordID contains (User.RecordID) list Copy_of_Groups_Report { displayname = "Groups I belong to" show all rows from Groups [Group_Members.User.contains(zoho.loginuserid)] ( Company CompanyViaFetch Group_Name as
Action when decision box is unchecked
Hello- I have written an action on a decision box that adds a value to a currency field if the box is checked: if (input.Timestamps) { input.Rate_per_minute = (input.Rate_per_minute + 0.25); } What I cannot figure out is now to remove the value (i.e. 0.25) if the box is then unchecked by the user. Note that this is different than doing input.Timestamps == false because I only want to subtract that amount in instances where the box was checked and the user unchecked it, as opposed to situations
Manually empty an upload field via script?
I have a file upload field that is hidden or shown depending on whether a radio button is checked as "yes" or "no". That is simple enough to do: if (Radio.contains("Yes")) { show File_upload; } else { hide File_upload; } But, along with hiding the field, I also want to flush it of any files the user may have uploaded, since he could possibly be doing that by accident, and after realizing it, chooses not to click the "[remove]" option next to the field, and instead
Accessing user profile fields in a Deluge script
I would like to be able to retrieve the following fields for the logged-in user in my Deluge scripts: User's first name User's last name User's phone number Is there a way to do this please? I need to use them in SendMail functions to populate the message body and/or subject. Thanks very much
Add the data of a subform with deluge script
Hello Zoho developers, Finding the answer of this question will help me in many projects. I have 3 forms: MainForm1, MainForm2 and Subform. MainForm1 and MainForm2 both contain a subform of Subform. When creating MainForm1 (in its On Validate or on success), I want to automatically create a record of MainForm2: Form2_ID = insert into MainForm2 [ Added_User = zoho.loginuser ... ];and then to have the same data of the subform Subform in MainForm1 attached to the newly created record of MainForm2. Thank
Using CRM to BUY Products from Potentials ....put your thinking caps on! need your help
We use ZoHo CRM in a way that makes standard functionality a problem when we want to move past potential. The issue: Seems ZoHo CRM is created for SELLING products or services Our company gets leads, turns them into potential to BUY products from VENDORS. Because we BUY products from our leads/potentials, we do NOT have functionality to link and connect the PURCHASE ORDER and VENDOR modules to the POTENTIAL. *Note - We need functionality of products module or customized solution outside of this
Next Page