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
Suggestion: Modernize UI Themes
Dear Zoho, I have been considering Zoho Creator for our business and I wished the UI was more modern and the themes allowed the ability to at least specify the colors. Other low code apps such as Airtable and Retool look fresh and modern. Canvas for CRM
Split list by new line
Hello, How would I be bale to put text into a list and splitting it by a new line? This is what I currently have but it is not working: scan = input.OCR; scanList = scan.toList("/n");
Populate subform from a Multi Select Field
Hi All Hopefully someone can oush me in the right direction. I have the following modules: Accounts Products at client ( Ours and compititions ) Contracts The contracts modules deals with the ocntracts at the cleint, their can be more than one product
Funnel Chart - Custom order
Hi, Is it possible to define a funnel chart order on zoho creator page? for example, i want to use the funnel for leads conversion. the funnel should represent the lead statuses. I would like to have the "Won" status on the funnel bottom. Thanks
Dynamic Filter for Lookup field
Hi all, I have a dynamic Lookup field. Each record in the "Sites" form has an "AMUser", and the current user sees a filtered list based on this. The lookup is configured like this: must have Site1 ( displayname = "Site" type = picklist values = Sites[AMUser == zoho.loginuser].ID displayformat = [ Site_name ] sortorder = ascending searchable = true width = 206px ) However, I'd like to nest this in an If statement so
Save to Google Drive and return shared URL
Hello, I don't know much about the Google API theme, as much as I see it I don't know how to implement it, what I want to do is basically in a zoho creator form to save in an attachment field a file, when saving must enter that file to a specific folder
call back URL for my zoho creator application?
I am a non programmer, trying to build a simple app with zoho creator, i want to do a get api call to google, and record the response in one of my form fields or as variable. i don't know what is my callbackurl where i can ask google to send response, need help. thank you
Widget not loading in Permaview
I created a gantt using node.js widget. it works great. I want it full screen without the Creator navigation sidebad. the only way I could find is to publish and open as permaLink. but, the widget doesn't load when used in permalink. using an external
Summary Page (Record Template or ZOHO creator page) in ZOHO Creator
Hi Team, Good Day! Requirement: Want to create a summary page for a student management app in creator. If the student is passed for a particular exam, the marks / grade needs to be in green color or else it needs to be in red color. I thought that for
Open Report Filtered?
Is there any way to open a report with a user filter applied. Or to just open it on a select subset of data in the same way that a view can be opened on a select subset of data? I have a report with data for employees. Almost always, the user opening the report wants to see only one employee. If I give them a mean of selecting the employee at report open time, is there a way to open the report so it's showing the data for just that employee?
How do I make subform row items appear only once in an HTML table in zoho creator snippet pages?
I have attached a screenshot. Category fields are fetched from a subform rows and rows can contain similar categories. I want to show category only once in this table with its count in head count. For example Engineer - 2 and not as it is currently being
How to make a product page style with variant?
I am trying to figure out how to create a product page with variant? I was thinking creating a product and its subform will be its variant. The problem is I do not know how to display it in a dropdown and change the image upon selecting the dropdown?
Opening a specific record template as pdf on button click via openUrl
If I use a function to email a record template as a pdf I can choose a specific record template ("testRNtemplate") from several I have created using the syntax: sendmail [ from :zoho.adminuserid to :zoho.adminuserid subject :"pdf is attached" message :"pdf is attached" Attachments :template:testRNtemplate as pdf ] Now if I want to download the pdf on button click this sort of function seems to work but I cannot figure out how to specify a particular template. It seems to always download the default
Issues with updating a new Zoho CRM Record
Hello, I have a Zoho Creator form that leads fill out. The information they input is sent to Zoho CRM in the form of a lead. This was working fine as just creating a CRM record, but I wanted to update the newly created CRM record with more information.
Check if url is broken
Hello, I would like to know if there is a way to check if a url is broken when submitting a form, in this case I want to check a permalink of a file hosted on Workdrive. Is it possible and how? Thank you.
sendMail result
Hi, From the deluge documentation i understand there is no "successful" or "unsuccessful" response for the send mail function. Is there any way to get this feedback? Thanks
Subform - Add Rows - First Row Only - Add Information
Hi, I am adding default information to each subrow in a subform, using the delug script below. I'm needing to only add the Paid Invoice information to the first subrow I create instead of each row. I'm not sure sure how to best do that, given my current
User field - Multiple choice and username
Hi, Currently, we cannot select more than one user when using the default User field in ZC. This prevent using the User field for assigning "a task/record" to multiple users. Also, we are still not able to edit the Usernames of the users stored in the
Auto populate subform
Instead of having to retype the information again, I am looking for the proper script to automatically add the userID from the main form, into the subform, when I add a new row.
Next Page