Adding Subform data to Books Purchase Order Subform using API
Hello, I am trying to add creator forms subforms data to Books purchase Orders Subform but i am not getting any exact format as of how to map the subform data. This is the code i tried mapp = Map(); mapp.put("vendor_id","177093000000077066"); mapp.put("purchaseorder_number",input.PO_No);
Sort data by Date in Collection
Hello, I am fetching data from multiple forms and i am trying to sort the data by date wise.But i am unable to get success in that. Following Eg. is the way i want Invoice No. Invoice Date Purchase Qty Sale Qty 15
Zobot and intro.js
Hello I am a coder, but still new to the zobot's deluge language and zoho in general. I designed a tour using intro.js for my wordpress ecommerce site.... now I need the zobot to run the tour when the customer needs it. Does anyone know how to invoke the command wpIntroJs_StartTour() from the zobot?
HTML Word-Wrap in Richtext Field
Hello All, I am having problem with html, i am saving subforms data in richtext field and then printing in the record template. While the data in subforms field may have large amount of data and it need word wraping in those fields data which apparently i am failing to do so. Following is the code i have used: if(Outward_Type == "Fabric") { table_String = ""; table_String = table_String + "<html><head><style>table {font-size: 12px;vertical-align: top;font-family: arial, sans-serif;border-collapse:
Zoho Invoice - Need Deluge Coding Help
Hello, I would like to write a code for calculating sales commissions after creation of each invoice. I added a custom field for commission percent to CRM Contacts module and synced this module to Zoho Invoice. Custom field for commission percent : cf_commission_percent Custom field for commission amount : cf_sales_commission Formula : Sales Commission = Invoice Total*cf_commission_percent/100 My code is as follows but it is not working. Any help is appreciated. customerID = invoice.get("customer_id");
Creating Zoho project when a deal is won
Hi all, I have used the below to create a new project in Zoho Projects when a deal is closed won in Zoho CRM. createMap = Map(); createMap.put("name",ProjName + " " + "AML/CFT audit"); createMap.put("description",Description); createMap.put("start_date",startdate.subWeek(1).toString("MM-dd-yyyy")); createMap.put("end_date",enddate.addWeek(3).toString("MM-dd-yyyy")); createMap.put("template_id",TemplateID); createMap.put("layout_id",LayoutID); createMap.put("public","yes"); createMap.put("owner_id",UserID);
Creating a CRM task from a Desk ticket...
Hello, I'm currently creating a custom function which is triggered by the update of the Ticket Owner. The CRM tasks is created with the correct content. However for this test, I have to fix in the code the CRM task owner id (i set to mine). That way the task is attributed to me in the CRM. From Desk, it is possible to get the ticket owner, which is a string (I guess the name of the owner), and not an ID. Question : Supposing the Desk ticket owner and the CRM task owner ar the same Zoho user. How
Full name not username
Hi I am hoping there is a better solution than the one listed on these forums for getting the logged in users full name ie Bill Smith, rather than bsmith3. I see the old solution was to creat another database an manually enter in the information... hopefully some improvement has been made in the last 5 years.
Function to change status of shipment after 3 days
Hello! I am trying to make a function that through a workflow, changes the status of the shipment to "delivered" after 3 days. The 3 days time is made with the workflow, but the update function is not working. When I try to debug it always give me this error: Check and update the code in line 13 as there is a Exception : Value is empty and 'getJSON' function cannot be applied This is the code. Can someone tell me what I am doing wrong? salesorderID = salesorder.get("salesorder_id"); organizationID
Custom function connection with Zoho Creator
Hello, I am using a custom function to GET RECORDS on a APP that i have in zoho creator. This function allways worked, but now it gives the error: "No. of arguments mismatch for the integration function 'zoho.creator.getrecords' at line number 3. Resolve the errors and try again" So i fixed by inserting the rest of the params (index, limit and connection name), so my function is like this now: getrecord = zoho.creator.getRecords("roboplan_zoho","planeamento-plano-b","Tasks_Report","Task_ID ==test",1,10,"creator");
Detecting a user closing a form without submitting it.
I probably know the answer to this but I though I'd just ask in case someone has found a way to do this. is there a some kind of on close or on quit event where deluge script can be run when a user cancels or closes a form or quits the window that a form is open without submitting or updating a form.? It would be useful for us to do some data clear up if this happened to one of our forms. Thanks
Add items to groups with Deluge or Workflow
Good morning, I have Zoho CRM and Zoho Inventory in sync one way, so all articles that are created or edited in Zoho CRM are automatically reflected in Zoho Inventory. In Zoho Inventory I have created several groups of articles to be able to organize all the articles that come from Zoho CRM and that each article can go to a specific group. What I would like to know is, how can I schedule each article to go to a specific group? The articles have a text field that specifies the group that should go,
Flow Custom Function: Issues retrieving record from Zoho Creator
I am currently trying to write a custom function in Zoho Flow to get record details from Creator. I am not sure it it is a syntax issues or what. I am using the following code to get the records. string getUnitMembers ( int params ) { response = zoho.creator.getRecords("[MyName]","[AppName]","Members_Details","Unit_Number==params"); info response; return response; } This however gives me this message. [
{
"message": "There is no records match for this condition"
}
] Any ides here? I
fetch zoho desk ticket content
I need to setup a flow that can get the content of a ticket, and extract a string from it and store it in a variable. can't fiigure out how to do this. any help appreciated. I can code if neccissary
Refresh Page Or View After Workflow-Triggered Rule
Hi, I Saw in some discussions from years ago that it is not possible to use deluge to refresh the page after successful run (Some say it is possible when the script is called via a Button but not when called from Workflows). This is very annoying. For Example, We have a custom script that runs every time a Lead Is Created and Pre-Populates some fields with impotent Data (Based on the fields the user is filling out when he creates the record). The Script finishes to run after the new Lead's page view
Multi - Select Lookup Field
Hello, I am trying to add values of Multi-Select Lookup field and store them in another field Value should be updated On User Input Following is the code i used to add values var = 0.0; for each rec in Quantity { if(Quantity.size()>0) { var = var + Quantity.todecimal(); } } input.Total = var; Values inside the Multi-Select lookup field are all decimal values Following is the error i received :
Searching for a value entry in one of my Lead layouts
Hi there, Below i have attached some small screenshots of a code i created where I initiate a search of a record by ID in my "Property_Enquiries" module and also in my "Leads" module. In both of these records I search for a particular field - which is the email field. I verified that these two email entries match by executing a simple conditional function. However, I would like to take this to the next stage and I would really appreciate some assistance as i am a quite a beginner in deluge. What
Barcode
Hello, In a barcode scanner, initially i have set up the scanner like when you scan the barcode it should straight go to the next field below the previous field so it means for the browser we have used enter button and for zoho it means i have submitted the form. So basically unless, Zoho doesnt update their function on enter button this is not possible on zoho. But i think there is a workaround for this like when i scan the barcode On User Input it should straight go the field i point out at using
Buttons - Change Field, and start wizard
Hi all, I am trying to make a few buttons as follows: One button on the deals page that sets a value of a field on that same deal. Eg : status=working Another button on the deal list page, that acts as a "new deal" button, that starts a deal creation wizard I have created. I have searched the forums etc but haven't been able to find a solution, I'm sure its very easy for someone who knows deluge. Thank you in advance! Harry
How To Post to Cliq Using Zoho CRM Deluge
Hi, How Do I Post to chat/user from Zoho CRM? I Need to create a connection. Is There any tutorial on how to do it? I Saw something that is not relevant to the new Zoho Api-Console. And Why isn't it created automatically?
Creator 5 - Edit Record based on Record-ID
What URL pattern can I use in Creator 5 to open a form and edit a specific record using the record ID? I have a list report with an onClick function. OnClick executes a deluge script to open a stateless form using the selected record's ID. Example code is below. All of the variables correctly populate. However, I cannot figure out the correct URL pattern for 'Editing Records via Record-ID.' The form will open, but it is always blank and it does not reference the record. openurl("https://app.zohocreator.com/"
Problem updating new row in SubForm
I have created a form that contains a SubForm. I have actions through a workflow that automatically set field values, for example: Form > Created or Edited > User input of SubForm.Frequency > Calculate Next Date if (SubForm.Frequency == "Annually") { input.SubForm.Next_Date = input.SubForm.Date.addMonth(12); } This works as intended and updates the field value for the first row entered; however, if any additional rows are added, the first row values are updated based on actions in the second row
WFH Tip 12: What are Handlers and how they can help you build a perfect Zobot that can mimic your operators?
Welcome back to Zoho SalesIQ! The previous WFH tip focused on how actions in Zoho SalesIQ' s Zobot can help reduce the workload of your operators. Today's tip will tell you what handlers in the Zobot are and how they can perform all the functions that your operators perform, compensate for them and reduce their workload. If you're building a Zobot for the first time, here are some tips for you to get started. THE HANDLERS The SalesIQ scripts consist of four major handlers inside which all of the
Entry - On Edit
Hello, I have 2 forms "Inward" and "Stock Book", where both the forms stores the details of Shirts which includes Article No., Color No., Type of Garment, and different sizes ranging from Size XS - Size 6XL. Now, when a user enters an entry in Inward data duplicates that entry in Stock Book if the Article No., Color No. and Type of Garment matches then the sizes will just add up to that entry. if not it will create a new entry in Stock Book. This is the workflow of Inward Entry - When Created. Now
Zoho Sign webhooks
I'm trying to get a Zoho Sign webhook to work with a standalon REST API function in Zoho CRM. The webhook set up in Zoho Sign is calling the function, but I don't know what I need to name the argument in order to receive what Sign is sending. I looked at the documentation, but it's not clear what argument to give the name of the function so as to get the object that the webhook is sending. I looked at this help article but it's still not very clear what is sent. Does it send anything? If it does,
Java
Is java supported in zoho creator?
Calling System
Hello, Is it possible to integrate third party application for calling system on Zoho Creator?
Clear subform B particular row when decision-box in subform A is unchecked
Form A has 2 subform's, subform A & B,subform B is copy of subform A except few columns. When successful-EDIT entry is done both have same data.Problem is that when a checkbox in unchecked in subform B onEDIT -> onUSERINPUT , I can't user clear() to remove that particular row in subform B( having same data unchecked in subform A) i tried below example also but it did't work : fetchedRecords = Employees [ Date == today ]; for each rec in fetchedRecords { rec.Job_Experience.clear(); } How can i achieve
SMS Invoice
Hello, Can i send Invoice template which is generated from Zoho creator in sms using a url?
Subform as a pop-up
Hello, is it possible to change the Subform UI ? As my subform contains too many data so it is very inconvenient to drag the data horizontally back and forth.
Few issues with fetch. I've gotten too complicated I think.
Form A records a product description, barcode, price at time of capture and the store it was purchased at. Store Name is a lookup field, then two single line fields and a currency field. Form B is a stateless form that when a barcode is scanned checks to see if a record exists. If so, it displays the highest price recorded, lowest price recorded and product description. I want to add in a fetch for the store where the lowest price was last recorded, as well as a fetch for the store that most often
Page + HTML
Hello, Here's the scenario, Following Table is i am trying to achieve in page using searchString: Design No.: Shade No.: Quantity: 55830 250 100.00 56459 Blue 50.00 But i am getting the result as follows: Design No.: Shade No.: Quantity: 56459 Blue 50.00 55830 250 50.00 55830 250 100.00 Following is the code i used: <%{ Table = "<head><style>table {font-family: arial,sans-serif;border-collapse: collapse;width: 2px;}td, th {border:
getTime function not working
I'm using the 'getTime' function in a Creator app but when I save it I get the error "Not able to find getTime function". I'm trying to use it as a function instead of a method. The latest documentation here states that I can use it as a function. As shown in the code snippet. <variable>=<dateTimeValue>.getTime([<format>], [<show_seconds>]); (OR) <variable>=getTime(<dateTimeValue>,[<format>],[<show_seconds>]); Do you know why it might not be working?
Create a text document that is dynamic based on data inputted into creator by the user.
I'm using Zoho creator to create an Application which analyzes data thats given to it and creates a custom "text report" based on it. My plan was to have several pre determined documents that have dynamic variables within them. Do I also need to use Zoho writer to do this? Or would this be possible with deluge scripts alone? I'm new to Zoho as a whole and deluge. Thanks
Update Record in another forms Report
Hello, I am trying Update status of few records in "Purchase Order" form from "Inventory" form when i tried to code that it said this type of updation is not supported. Records in Purchase Order form are in Subform is there any other way to do it?
Page
Hello, I have created Report Page using page parameter, so my question is can we mail the page report?
Filter
Hello, I have "Purchase Order" form i would like to have a status field where it would filter whether the Ordered product is in stock or went for cutting product wise and it should update on every update in Stock. And the product details is in the subform. Is this possible? If yes, please help me how do i do it?
Overview
Hello All, I am creating management application where everything is managed by Order Nos. I would like to create an Overview wherein i ask the user to enter Order No. and everything is displayed on the page with every data related to that Order No. Thanks & Regards
Functionality Issue in Zoho Creator - Deluge inbuilt function "hoursBetween"
Namaskaram Zoho Creator team, The deluge inbuilt function "hoursBetween()" takes two dates as parameters and return the number of hours between those two dates. But it fails in following scenario. Let us assume the start date is 08-Mar-2020 00:00:00 and end date is 10-Mar-2020 00:00:00. It should returns 47 hours instead of 48 hours. This problem happens, only if the start date is less than 10 and end date is greater than or equal to 10 and if both dates are set for 12 am. This is very
Calling a Zoho Flow from a Deluge script
I wish to call a Zoho Flow from a deluge script (that is attached to a button in Zoho CRM). The deluge code I have been experimenting with is as follows: respondAPI = invokeurl [ url :"https://flow.zoho.com.au/7000000000/flow/webhook/incoming?zapikey=912783139173891798317317932139128123&isdebug=false&InquiryID=" + InquiryID type :POST ]; return ""; (the URL address and zapikey have been replaced with random text - the actual URL comes from Zoho Flow) InquiryID is the id of an inquiry. In Zoho Flow,
Next Page