Creating record in Zoho CRM and upload file
Hi, I'm stuck on this issue, and I don't find the problem. i have a Zoho creator form with several fields : This application is linked to Zoho CRM, it creating a ticket in Zoho CRM. Everything works fine, but I can't upload document to Zoho CRM. Here my code : //create the CRM vs Creator fields map to push data to the CRM module. myFieldMap = Map(); //add values to the map. CRM fields first and then Creator fields ( without the quotes ). Creator field’s deluge name is used here. myFieldMap = Map();
How to use Java script in HTML Snippet (or on a page?)
Want to add some java script to a page. Any way to do this? Basically need to drag one image to another spot. Will also need to update a field in the record... but that will be the next step (and extra credit if you provide pointers on that!). For now, just need to get the drag and drop to work. <style> #div1, #div2, #div3 { float: left; width: 100px; height: 35px; margin: 10px; padding: 10px; border: 1px solid black; } </style> <script> function allowDrop(ev) { ev.preventDefault();
Publishing a page with a widget in it causes the widget interface to error
I've just done a test publish of a page that contains a widget, however in the console log it tells me that the authorisation token has expired. What is the correct way to publish a page with a widget? What we want to do is allow a customer to review
Sample angular service for zoho widget api
After a week of frustration getting this to work (granted I'm still a newbie at web development) I thought that I should share the fruits of my development. Below you should have the basics of an Angular service written in Typescript that you'll be able
How should i Remove starting space using deluge ?
How could i Remove starting space using deluge ? like if a = " ABC DEF"; then output should be ->ABC DEF , remove starting space only if available how ? Remove all spaces from starting before first text. Thanks and Regards, Sidhant A.
Looking for Zoho Creator Mentor.
Hello, I am looking for a Zoho Creator mentor that can guide me to what I needed. I want to learn it myself so I prefer a mentor rather than a person who will build it. I am also paying for mentorship if that is how it works. Our project is to create
Get a URL parameter inside a widget
I've written a widget that will use a URL parameter to search for a booking, however at the moment this doesn't seem to be translating through to the widget on the form. How can I make this work?
Conditional Formatting bug
Hi, Conditional formatting does not appear to be working in reports. In the example below, i have created two conditional formatting criteria to highlight a record either red or green based on its value. However, when running the report it simply applies the formatting from the last criteria to all records. (It is as if there is no criteria at all and it is simply applying the formatting to all records). Further to this, when i create a conditional format with a criteria, save it, and then edit
Showing Subform Field based on Subform Dropdown
Hi, on my main form "Contact Info" I have some dropdowns that will show a single line field based on what is selected in the dropdown. i.e. In the "Distribution Method" dropdown, I select "FedEx", and a "Tracking #" field appears. I have tried to do this same thing within a subform, but the subform just displays all of the fields and won't use the rules/logic I've setup in the form ("Contact Info Subform"). Do subforms not use the logic that are specified in them? Is there another way to have a subform
How can i update the value using deluge (dynamically) ?
How can i update the value using deluge (dynamically) ? The thing is we had already did insert task; but as we added 2 new fields later , so we wants to update these 2 fields into other report and there are lots of data there. How ? Thanks and Regards,
Is this code right ? Because only fnsku, sku and asin values are not updateing
Here is the code, lstv = input.FNSKU_SKU_ASIN; if(lstv != null) { lstV = lstv.toList(" "); info lstV.size(); info lstV; if(lstV.size() == 3) { a = lstV.get(0); info a; b = lstV.get(1); info b; c = lstV.get(2); info c; } if(lstV.size() == 2) { a = lstV.get(0);
get values differ and store in variable
Hi, For example , we have a text as - abc def ghe in that , i want to store - as a = abc b=def c=ghe like this , based on space. because only space is common for all the texts . How can i do this ?? Thanks and Regards, Sidhant A.
How to Fetch report of Subforms with a Lookup field in form 2
I have created an app, due to field limitations, I have to divide my app in 2 forms. My First form also contains a subform to add data according to the user requirements, but that subform fields are not accessible in the report of 2nd form with the lookup
Error
Hi, Getting this error as attached .. Please check asap Code - fet = Form[ID != 0]; if(fet.WEEK != null) { for each rec in fet { // info rec.WEEK + " :: " +rec.ID; sat = rec.WEEK.addDay(5); if(zoho.currentdate > sat) { rec.WEEK=zoho.currentdate.toStartOfWeek().addDay(1).addDay(7);
Automatically moves to next Blueprint Section
Hi, I created a blueprint where I have a Stage A, in the After section I'm executing a set of actions and depending of the result of these actions I want that the blueprint moves to Stage B if success or Stage C otherwise. I noticed that I can´t update
Set Custom Function to Open "Detail View" of a record
This may be an easy solution, however, I am looking to create a custom function button that will directly access the "Detail View" of the same record I'm viewing in another report. I assume this will be some variation of an Open Url script? i know how to create the function, just not the particular code needed to access the record detail view. Any help would be greatly appreciated.
How to show/hide fields depending on their values from another field
I have a Products form I use to insert products to my custom application (built with Creator). There are 8 checkboxes for each product... we manually mark the checkboxes (or leave them empty) during input. Then I have a "WorkOrder" form which also has
for loop of widget - API.getAllRecords
Hi, so i have a widget and i need to get all the records of my report - more than 200. so i can call getAllRecords twice, because each time i get a 200-records page. if i don't know how many records i have, i need to use a for loop of records and loop
Angular support in widgets
Has anyone successfully used angular in their widgets? Is it possible? This is what it looks like in local debug - ng serve This is what it looks like in zoho creator
How to create serial number in sub-form without using if condition
hi.... How to create s_no on deletion of rows without using if condition (or) using auto number fields. Thanks in advance for your help. Raja
Line break code assistance
Hi Could anyone advise how I could code the below to add a line break between each: This is the code: input.Trial_Class_Booked = input.Trial_Class_Options.Class.Class_Name_for_Customer_Enrolment1; This is the workflow: https://creator.zoho.com.au/appbuilder/laura_shireelite/shire-elite/workflowbuilder/Input_Trial_Class_Booked_/edit
Developing widget with real data
Is it possible to configure zet to connect to the app that we're going to be attaching a widget to. I want to be able to develop this without needing to keep packing, uploading and refreshing the page with the widget in it.
Add Record To Form A in Application A when Form B in Application B is submitted.
Problem: I'm not able to select any forms in ApplicationA in the insert record task I'm adding to FormB in ApplicationB On Success action? I know it is more complicated to lookup a record in another application than it is to lookup a record in another form in the same application which i was able to figure out but I can't seem to find any information on "adding" a record from a form one application to a form in another application and I'm not able to select any forms in ApplicationA in the insert
"\t" is not working
Char syntax "\t" is not working since new year, is there anyone with the same problem?
Can i get a zml snippet to show a value that is generated by a function
Hi All, Any help would be appreciated, i am trying to show the last record of data on a dashboard page and below is my code used but i don't think it will allow me. Before you say i know the text value is incorrect, but i was trying different methods. <%{ last_record = Digester_Data[ID>0] sort by Date_field desc; a = last_record.Water_Temp; {%> <panel> <pr height='fill' width='fill'> <pc width='100%' bgColor='#FFFFFF' padding='20px' hAlign='center' vAlign='middle'> <pr height='auto' width='auto'>
Deluge - Quarter Inches - Remove Leading Zero
Hi, I am taking an API reading that is in total inches. I am converting to Feet, Inches, and Quarter Inches. I'm using the following code to round the quarter inches to (.25, .50, and .75) // Routine to Check for Quarter Inches vNumber2 = vTotalInches
Branding
Hi All, How do i remove links and branding of zoho from the template i print?
Changing the standard "Invalid entries found. Rectify and submit again" message?
Is there a way I can change the "Invalid entries found. Rectify and submit again" message? I HATE THIS MESSAGE! It is VERY unclear and users are usually lost with it. Thanks
Open URL with POST
The OpenURL task allows us to open any website, however any parameters have to be encoded in the url. Is there any way to do the same thing with a POST request. I'm asking as I send JSON data to a third party for debugging purposes by using it as a beautifier.
Duplicate app *with data*
I created a copy of my app to allow an external developer to access it and do some tests. However the copy has no data. How can I create a copy with data included, or how can I move some data from my live app in a single export (not having to go to each and every form to export data)?
Print
Hi All, I have written a code to print a page and content is feeded from a particular form but when i print something is overflowing and going to second page and i dont know what please help me here. I have attached the issue png as well. Style Code
May i know the links of material of learning zoho creator from beginner to expert .. it may be books, links of codes , Youtube links ..
May i know the links of material of learning zoho creator from beginner to expert .. it may be books, links of codes , Youtube links ... Thank you, Sidhant A.
Embedding Tableau Dashboard into Zoho Creator
Could anyone please help I'm trying to embed tableau dashboard into my website?
Sendmail with Attachment in Function
Hi Gurus, I'm trying to set up a function that utilizes sendmail with an attachment. I have created an html view to display a record, and my function to 'show pdf' works well. I'd like to be able to trigger a function to send an email with said pdf attachment, but I get a generic "Error in executing SendMail task" error. If I remove the code for the attachment, it works. Can anybody help? void BEO.sendBEO(Events thisEventID) { thisEvent = Events [ID == thisEventID.ID.toLong()]; Title =
Display list of images in form
I have a requirement to attach one or more pictures to a form record. The form view must then show all pictures attached to the form. The images need to show, not the filenames. At first I thought a subform would be the answer, but I cannot get the pictures
Successful Form Submission - Another Deluge Script
Just to verify ... If I create a new record in another table (form1), under another a seperate deluge script (form2, deluge workflow 1), it will not run the delug script attached to Form1, after Form2 executes it deluge script.
500 error when requesting mail API for messages
I'm following the search email documentation. I made a request for http://mail.zoho.com/api/accounts/724572269/messages/search?searchKey=subject:meeting and I'm getting: { "status": { "code": 500, "description": "Internal Error" }, "data": {} } What could
API OAuth 2.0: Request failed with status code 400
I'm using the Zoho Mail API trying to follow these instructions for OAuth2.0. 1. I called the Authorization URI GET request in the browser address bar: https://accounts.zoho.com/oauth/v2/auth?scope=ZohoMail.folders.READ&client_id=1000.23UUJK43IAZY4NK9BOSL47RVJYUY6T&response_type=code&redirect_uri=http://localhost:4000/zoho_callback&state=87654677676321
Sort a Picklist
I have a form with two lookup fields. The fields are: Client - a lookup from form Clients; Project - a lookup from form Projects. On load I want to filter Client so that it contains only those clients that have a project and sort the resulting Client list. I can filter correctly but not sort. Code for On Add - On Load is as follows: clientList = Projects [(Client is not null)] sort by Client ; // alert(Projects.Client); clear Client; Client:ui.add(clientList.Client.getall()); Help appreciated.
Minutes between Midnight
Hi, I am needing to determine time from one record to midnight of the same day. I found hoursBetween rounds and there is no minutesBetween. dateString = vPreviousDate +" 23:59:59"; result = dateString.toDateTime(); info tempRecordsYesterday.Gauge_Date_Time.hoursBetween(result);
Next Page