Update a lookup field in CRM from Creator using deluge
I have a Creator form that creates a new account. When it creates the new account in the Accounts Module, I need it to also populate the Parent Account, which is a lookup field coming from the Module Parent Accounts, field Parent Account Name. I have
For Each Loop only returns 1st result of List, not the whole list?
I have a custom function that collects event data from Google calendar using invokeURL. I want to create meetings in CRM from this URL response. The invokeURL response contains over 100 records and works perfectly (code line 2). Then I'm using a For Each
Associate all "Active" users to a newly created project... (Zoho Projects API Documentation lacking)
Today I spent almost 3 hours trying to do something which I discovered has been asked for for over 14 years in Zoho Projects, that is when a new project is created to assign all active users to the project. My first thought was, okay this should be fairly
Validation rules for fields used in blueprints
Dear community, I'm designing a blueprint for me leads nurturing process and I've noticed an issue with the validation rules applied for fields. I've applied a validation rule for the "PHONE" field and it's working just fine when I insert a new phone
Automatically update date field based on the pick-list value of another field
Hello everyone, I've been trying to find a way where a date field gets automatically updated according to the value of a different pick-list field. The pick-list field can have the value "3 months from now" or "6 months from now". The logic is that we
How to use an output from a function as a criteria on a decision path on Kiosk
Dear community, Is it possible to use the result of a function executed in a Kiosk flow as a criteria in a decision step in Kiosk studio? Let's supose I have a function that makes an API request. Is it possible to define the next step of the Kiosk flow
Identify if fields used in function
We're doing a lot of tidy up on our Zoho CRM modules but have 100s of functions. We need a way of identifying if these fields are used in any functions before deleting them. Is there a way to do this? Is there a way to search Deluge scripts on mass for
Is there a way to programatically schedule a function call?
I wrote a function that creates a record in a custom module that I need to trigger 30 days after a field in another custom module is set to a specific value. The issue is that I need to have it triggered every time the record is edited, not just the first
Barcode
Hello All, how do i generate barcode in zoho Creator?
Missing record from multiple record creation
I have made a deluge to create multiple records based on date as below z = input.Total_Number_of_Sessions; x = z - 1; y = input.Interval_between; var = input.Start_Date_Time.daysBetween(input.End_Date_Time); iterationString = "".leftPad(x).replaceAll("
Add expiration_date and request_user_data to external share link creation in Deluge
Background I deliver files to my clients via Workdrive external share links. I create the folder, add the files, create the external share link, then add the link to the invoice in Zoho Books. I am in the process of simplifying this process with the following
Update Task API Limit Issue
I am running into issues with the API limit for update task in Zoho Projects. In a typical Project, we have 120-130 Tasks and I would like a field change made to the Project to propagate down to all Tasks that belong to the Project. (In this case "Territory).
How to generate AWS Signature through Deluge task
Hello Everyone, How to generate AWS Signature key through Zoho Deluge Task. Is there possible in Zoho? Else please do it... Thank You !!! Regards, Subash S | CubeYogi
COQL or deluge API, how to get the total count that match criteria?
This is a simple count, but given the 200 record limit, and the fact that I don't need any of the results, just the count, why do I have to page through and perform such an expensive operation. The following shows how I successfully used deluge and COQL
On User Input - Display Image in Subform
Hello All, I am creating a Form for Creating multiple product orders I need assistance in displaying the Image of the Product on Lookup Input of Product Name Field
How do we get the tags that are attached to a record with Deluge?
I am writing scripts and need to get all the tags associated with a Contact record (or Account, or Lead). I know how to get all tags associated with the whole module, how to add and delete tags on a record but I can't find an example of how to target
Help with pagination and getRecords
I need to list the unpaid invoices, it works like this: search_map = {"status":"unpaid"}; invoices = zoho.books.getRecords("Invoices",organization.get("organization_id"),search_map,"conn"); The problem is when there is more than 200 results, in the results
Creator Simplified #4: Modifying the app structure using the Application IDE
Hey Creators, Here’s this week’s Creator Simplified post with a tip to enhance your app development skills. Objective Modifying the app structure using the Application IDE. Use Case Assume a scenario where you have to make trivial changes to your application
Improper statement line 31 (Highlighted in red) pls help
// Fetch the current record from the AMER form previous_record = AMER[ID == input.ID]; info "Previous Record: " + previous_record; // Fetch the record from the AMER form by its unique ID previous_status = previous_record.Status; // Get the old status
Is there any way to fetch records in ascending order by Name Field?
for each userItem in User [ ID != null ] sort by Name.first_name { }
Change User Portal Picture
Hi, Question: How can a portal user change the profile picture? (see Attachment) Use Case: Portal User can change his picture via a settings form Solution: Create a stateless form with a image field Create workflow When button trigger save image in portal user profile via deluge script Problem: There is no Miscellaneous in deluge for the portal user image How to solve this? Best Regards Marcus
Lend me a hand with Zoho Vault Deluge Script
Has anyone out there used Deluge to read passwords stored in Zoho Vault? If so, I'd be thrilled to get a little sample code on getting started. How does the OAuth stuff work? Once I get that, I think I can make headway...maybe.
How can I compare a button's action to a value?
I am new to zoho books so I am trying to understand how api, custom functions work?I want to know whether I can compare button action to a value and change status? Here's the thing. I am trying to create a custom function to change the customer status(values
Zoho Creator - Zoho Sign Integration
Hi, I'm creating an order form that allows clients to submit requests for new products or changes to their existing ones, modelled after the Sales Order module in the CRM. When a record is submitted I want to generate a PDF using the record template I've created and upload it to Zoho Sign to be sent for signing, all through Deluge. Zoho Sign isn't a problem, however I can't see in Deluge if it is possible to generate the PDF through a URL. The documentation here provides a URL but it seems to be
Using Client Script to change Canvas ID
In my deals module, I have created two difference canvas. One for personal insurance and one for Commercial insurance. I have a field in Deals called "Customer Type" that is a drop down with two choices, "Commercial" and "Personal". I am trying to set
Zoho Vertical Deluge internal_zohocrm Connection Missing
Recently and unexpectedly, all new subscribers added to my organization's Vertical are unable to execute the Deluge functions published by the Vertical. Any `zoho.crm.*` record operations are failing for what appears to be a missing `internal_zohocrm`
How to delete a record in Zoho Creator from a Deluge function in CRM
Hello, I've got a Deluge function in the Zoho CRM triggered by workflow with this code, trying to delete a record containing a product code. creatorApiUpdateUrl = "https://www.zohoapis.eu/creator/v2.1/data/xxxxxxxx/yyyyyyyy/report/All_Courses"; payload.put("criteria","(Course_Code==\""
How to filter report with two level of filters and getting a count of values entered?
I have a form with the following fields Company name department survey question 1 - a radio field with 4 options; A,B,C,D How to fetch all records submitted in the above form based on company and department and get a count of how many records answered
Creator Simplified #1: Optimizing Data Retrieval for Large Datasets
Hey Creators, Welcome to the first post of Creator Simplified—a learning series designed to enhance your app development skills. In this post, we'll explore how using specific criteria can streamline and quicken the data retrieving process, especially
How to get message by id? Preferably with all formatting
I want to create function that updates pinned message in cliq's chat (changes mentioned users in message). In documentation there is code: response = zoho.cliq.editMessage("22306xxxxxxxxxx6126","159xxxxxxxx97_3354xxxxxxxx396","Hello", "cliq_connection");
Populating a user pick list failing if user is not an admin or portal owner
I have a function that, until recently worked fine. The function essentially copies another project. One aspect of this copying was to take the value of a UDF that is a User Pick List, find the correct user id for that user, and populate the corresponding
Search for Zoho WorkDrive Team Folder using API
I'm trying to create a function that uploads a PDF to Zoho WorkDrive Team Folder. Each Zoho Project has a unique Team Folder, so before uploading the PDF, I have to search for the Team Folder. I used this function (https://workdrive.zoho.com/apidocs/v1/search/searchteamfiles)
Add New Values to a Drop Down Field in a form using deluge.
Hi, Here is what I am trying to do. I have an API that returns a list of names. This API is triggered when An Input Field is Created or Edited. Upon calling the API, I want to display the names as a drop down list on the form. Is there a way to do this
map fields directly from the task that triggered the workflow?
Is there a way to map fields directly from the task that triggered the workflow? like function(arg1) field1 = arg1; I see this when I hover over the function: "It is not possible to map Zoho CRM fields because there are no arguments available in the
Automation of Tags on Tasks
I have written a deluge custom function endPoint = "https://projects.zoho.com/api/v3/portal/"; tagsParam = Map(); tagsParam.put("tag_id","2342963000000148480"); tagsParam.put("entity_id",taskid); tagsParam.put("entityType",5); url1 = endPoint + portalId
InvokeUrl API Call failing from Deluge Script in ZOHO Flow
Hello, I have been wrestling with an API call placed from a ZOHO Flow via a Deluge Script. For some reason, only calls that contain nested JSON structures seem to be failing. When I say fail, I get a response saying that API parameters are missing when
Transfer Zobot to another Zobot
I have a situation winch i have two bots configured, have a Action using deluge or other options to i transfer the bot to another? they will trigger another zobot. The Customer will select a specific option and will then be redirected to the start of
Deprecation of Google Drive and Sheets connections in Scripts (Deluge)
Hello Everyone, We have an important update for those using the Script (Deluge) platform to build chatbots, widgets, and forms. Google has alerted us about sensitive scopes within the Google Drive and Google Sheets default connections in Deluge. As a
Associate Zoho Projects With Zoho CRM Help of Deluge
Hello Team, if you wants to connect your Zoho Projects with the Specific Deal, Please follow the code may be it can helps to you. dealId = "4655606000010751004"; //.....Deal ID..... projid = "1688514000000448005"; //.......Project ID........ projname
Update Subform record into another form
Hello All, I am trying to update the subform record into another form Following is the code i have used: for each rec in Accessories_Inward { fetRecFrom = Stock[Record_ID == Record_ID]; fetRecFrom.Item_No=rec.Item_No; fetRecFrom.Quantity=rec.Quantity; } whereas, Record_ID = Unique Identification code to recognize the rec i want to update Accessories_Inward = Subform of the Main form (not linked with any other form) Stock = Form where record is to be updated. Now the Problem is When there are multiple
Next Page