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
Multiple date fields in Calendar
I would like to be able to have different events (read: date fields) to appear in a calendar view. Even fields across different forms. An extra cool feature would be if each field could get it's own color for the multi-field-calendar.
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.
Integrate Google Maps with ZOHO Creator / ZOHO CRM / ZOHO Reports Data
HI all , On another forum discussion I told there is a workaround to integrate ZOHO Data with Google Maps . then I am getting lots of email but I could not help enough b/c of my work pressure. so I thought It would be good if I could post the process then other developers can help ZOHO users. However before proceed you might want to watch video that I posted on Youtube.com so you can see what can do ? Video link : https://www.youtube.com/watch?v=_kW1DJAf1x8&lc=z23wvvbxjkngvjf0lacdp434r453uiuqfzv0qcgb4ypw03c010c
autonumber displays "null" instead of the number
I have a formula that refs an autonumber field, the result is fine but when I thereafter edit a record the autonumber part of my result changes to display "null". Any ideas?? if((Legacy_Project_Number == ""),"LP."+ Project_autonumber ,Legacy_Project_Number)
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?
Lookup Fields need to show Image fields
Please add images selection to a lookup field. I have spent much time trying to piece together information from knowledge base articles dating back as much as 8 years ago, however, I am not clear on the interesting workarounds that were offered. What
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)?
Alphabetize column
Why doesn't one column give the option to alphabetize the entire column? It used to do that, but after making a small change it no longer gives me that option. All I have in the drop down menu is Search.
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
File upload thumbnail preview.
We would like to be able to have a thumbnail preview of the image files we upload. For now what we do is to upload a file, go to the list view, copy the URL and paste it on the Image Field, but this doesn't work for different views because the link has a reference to the view and not to the file itself. :( Very disappointing!!! Today all programs have previews for image files. Its ridiculous that we have to do all this work to get a thumbnail up.:( Florencia
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
Sample code for passing parameters to a form from a view
Can someone please point me to sample code for how to pass a parameter when opening a form from a custom action in a view? I've created a function with an openURL statement for the form I want to open, which works. However, I can't figure out the syntax for passing the function parameter through to the On Load action in the form. The error msg says that the input.RefVar is null in the On Load action. Thanks.
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);
On Success scripts not working for imported data
I have an application that has worked for years executing on success scripts for imported data. Everything worked fine Monday and now the scripts do not run when I import data. Does anyone know why this is or have a work around? Many thanks, Dave
Connecting Zoho Analytics of another Zoho Account
In attempting to create an Analytics connection/data source, when I try to authenticate it automatically looks to the signed in account. If I sign out to sign into the analytics account I want to access, it also cancels the original Creator session.
Is it safe to give out your client id and client secret?
I created a self client api via the API console for my sandbox account. Took me a while to work everything out and then I managed to generate tokens and refresh tokens for my developers to use. I had to step away from my computer for half a day this
Creating Two Column WebForm with Sliders
Hello Creator Community- Thank you in advance for your assistance. I'm trying to create a pretty simple web form that: - Contains 1 sliders - Has 1 calculations field - Has 3 text entry fields - Can be formatted into two columns (So I don't have a 1 page
Count characters in multi line text / Creator
Good afternoon. I want to count the character/letters in a multi line text box to avoid having more than 140 characters into this box. Is there a way to show how many characters are in a text box? I use "on validate" to tell users to stay below 140, but it's never clear how many letters have be deleted to match the maximum. I'd like to display the total of characters used in a separate (formular) box. Thank you for suggestions! Oliver
Widget development settings
This is probably a silly question. But is there any way to connect a widget to an app during development so that we don't need to keep packing it and seeing if it works? The documentation for widget development doesn't seem to be very clear on just how
Same link goes to different Creator databases
I have several Creator databases. All act the same. I MUST go to my dashboard https://creator.zoho.com/userhome/jimdwest/dashboard to get the working link for the database. The IDENTICAL link that I have on my desktop takes me to a different place in
Bug found in zoho api for widget pageSize=200 multiple pages
Hi I think i found a bug in zoho api. when I fetch more than 1 page with pageSize==200 than page1 and page2 will have a duplicate record and an omitted record if pageSize<200 it will be ok. here is an example code ZOHO.CREATOR.init() .then(function(data)
Developer Users don't have access to the Sandbox
I recently found that although my clients are subscribed to an edition of Creator that includes the Sandbox, only the Super-Admin can create/access the sandbox, whereas the Developer User cannot. The Sandbox is a feature specifically for assisting app developers, and my clients are hiring me to do the development and are not doing it themselves, so this limitation seems to defeat the purpose of the sandbox. Because of this limitation, I have two options when working on an existing app: Log in as
Upcoming Updates - November 2021
Hi all, Greetings from the Zoho Creator team! There are a few technical enhancements being introduced in Creator this month—improvements that will take the overall performance of your applications to the next level. This update will elaborate on: the
Next Page