Lookup field, odd issue
So I tried creating and app that has the names of engineers so I can use that for a lookup in the other apps that are being created . I add the look up in a new app, launch the app and when I try to fill out the form its just blank in the drop down menu
Date Range Field
Hi Guys Does anyone know how I can create a date range field on a form? Cheers Chris
Calendar Overflow in Open URL popup
Hi everyone, When Opening a form which has a date field in openurl popup, this happens. Is there any way I can change the calendar width and height or is there any other possible way this can be changed? Thanks.
Assistance with Code to send email on subform data
I am trying to trigger an action off the successful submission of a form that emails the details of the subform to a distinct email. This subform is setup as another form in the app and I can get the below code to work: for each subrow in input.New_Payment_Subform
Link Images to a Excel Report
When I export to a spreadsheet. How do I get it to create a link that goes to my image. Right now it shows up in Excel as: /sharedBy/appLinkName/viewLinkName/fieldName/image/1510098844838_Image_07-Nov-2017_18_54_03.jpg
Emailing lookup field but placing this as an ID or number rather than text
Hi there, First time poster and have been a user of Zoho Creator for approx 6weeks so forgive my ignorance as I learn to code. We have a need to send an email to a specific email address with some of the fields triggered by the submission of a form. In
Update Multi select field values to another form table as individual record
Hi, I am new to coding and do basics within deluge. I need help with the deluge script to meet the following requirement. Form Student Attendance The fields are : Attendance Date Course (Lookup to Course Form) Class (Lookup to Class Form) Students (Multi
How to call a Creator function which is in a different Creator application?
How to call a Creator function which is in a different Creator application?
Creator Subform to CRM Subform
Hello all, Has anyone successfully written data from a Creator Subform into CRM subform? I have a Creator form that once submitted creates a new Location in the CRM. Inside a Location there is a subform for hours of operation. I collect those hours in
Multiple date selection
Hello, we want create app for our company. We need create tasks for our employers. For example - 1 employer have task every Friday the whole year. Second have task every Monday for 6 months. For simple way create Multiple date selection in date form
How to find the number that appears most often in a list (the Mode of a list)
I have a list that contains a list of 5 string values. I want to find which value is repeated most often and place that value into a single line text field Example List1 = Learning,Learning,Shaping,Leading,Learning In List1 the value “Learning” appears
For each loop with available time slots
I am very new to Deluge, and this question was unable to be answered by Zoho Creator tech support upon request. Task at hand: I have a Form with 4 fields: - Date Start - Date End - Dropdown: Time Start: contains time slots (12:00PM, 12:15PM, etc) - Dropdown:
Can the code in my "Successful form submission" WF be invoked from a function?
Can "Successful form submission" be invoked from a function? Data gets into a form manually and programatically. My code in "successful form submission" is good and I want to reuse it/call it, from another function which does Insert Into How to achieve
Load form in iframe without header
I am trying to load a form into an iframe without the header, but I am not having any luck. I am using openUrl() to load the iframe with the form URL and zc_Header set to false, e.g. #Form:Add_Case?zc_Header=false but it is still loading the header. Any
Zoho Creator - Install app from Gallery takes too long
I'm trying to install the 'Volunteer Portal' from the app Gallery of Zoho Creator. It has been busy installing the app for over 2 hours now. It might be okay, but how long is something like that supposed to take? I never installed anything from that Gallery
Formulae field(Sum) not updating when a sub form entry is deleted
Hi there, I was facing this issue wherein I have a main form called 'Work_order_Form' and in that main form I have a sub form called 'Items' and in that items I have a field called 'Print_Charges'. So in my main form I have a formulae field which calculates
How do I go to new form after using deluge button?
I have (Form1) - [Report1] (Form2) - [Report2] I have created a button which appears on [Report1] which creates a new record for [Form2] using data from [Form1]. I have the script working well, it pulls the needed information from Form1 and builds a new
Connecting Zoho Creator app with Zoho Sites
I created a custom domain on Zoho Creator for my app (and it is verified), but when I click the link for my custom domain, it redirects me to my website. I want to link my portal to my website so that customers don't have to sign in to multiple locations.
Exporting Records from an Embedded View ...
@support: In one of my Applications for a Customer, I have an HTML View ... part of whose content looks like ... //variables in iframe tag iframeName = "zoho-Case_Law_View"; iframeSrc = ((("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/view-embed/Case_Law_View/";%> <p class="zc-viewtitle"><%=Current_Expert_Info%></p> <iframe height='800px' width='100%' name='<%=iframeName%>' frameborder='0' scrolling='auto' src='<%=iframeSrc%>/Expert_Info=<%=Encoded_Expert_Info%>'></iframe>...
Create list dropdown of all form names
Hi everyone, Can i create dropdown list by all form names? Thank you
pages over forms
Is it possible to build pages and have custom css /design and backend forms on C6?
Hide panel shadow in zoho creator
Hello, I was wondering if I could hide the shadow that appears around panels in Zoho creator stateless pages.
Assistance Required: Merging Applications in Zoho Creator
Hello, everyone, We are planning to use Zoho Creator for one of our projects. The project includes two modules: Hotel Management and Fleet Hub Management, which are both listed on this page. Currently, we need to merge these two applications into a single
Zoho Shifts Connection
I'm having an issue with Zoho Creator Custom Connector not refreshing its tokens. I have a function that pulls data from Zoho Shifts nightly. However, every night the connector access token expires and the only way to fix it is to go and revoke it anywhere
Bulk export of uploaded files
I've seen a few very old questions about this in the forum, but I'm wondering if Creator offers a solution that allows users to bulk export the contents (or at least the url) of an "upload file" field in a report. It's tedious to have to export/download
Video streaming on Zoho Creator
I used the video upload field in my form for my public users. Upon recording and uploading their video, I am able to view the videos in my apps. The issue I am currently facing is that the playback of the video is very slow. Every few secs, the playback video would pause and a circular image would appear suggesting that the video is still being downloaded. My video file is only 1 min long and is about 20MB. My connection to the internet at the point of testing is around 32Mbps (download speed).
CTRL+Space open Smartchat window instead of Show hint
Dears, Is anyone facing the same issue as me, when using Deluge Editor, it always opens the Smart Chat instead of showing a hint when I press Ctrl + Space. This just happened recently to me and this is frustrating.
Can we use our own icons in the sidebar menu?
We want to customize our look further. Can we use our own icons in the sidebar menu instead of the ones there currently? If not, can we disable those icons or somehow not have them show up and just use words? Thank you, Katie
Meeting Room Booking Software - Zoho Creator
I am trying to create a Meeting Room Booking software in Zoho Creator. I am exploring the default Conference Room Booking which is already there in Zoho Creator. I am trying to replicate the same, but I need the option to get data from the Zoho People
replace all
I would like to be able to replace the quotes in a string. For example if the input for Description is 4" cap I would like to on success replace the " with (in) I have tried <variable>=Description.replaceAll(""","in") ; and receive the error Improper statement. Is there a way to replace the "
Paste Image instead of uploading
Is there a way in Zoho Creator to accept pasted images from clipboard instead of uploading individually?
How do I get a hot link to and an updated field to be send via email
So when I new record is created there is a url shortcut to the new added record, thanks :)
How do add more than three columns In creator.
Hi there, I am recreating an Excel quote form in creator, and part of that form has multiple columns that are needed how do I do this in creator, thanks :)
Popup / Expand option not showing for Subform with less than 20 rows in Zoho Creator
Hi Folks, I am working on a project. Where there is a subform with around 15 Columns. In order to see other columns, we need to scroll to the right. We have a popup option for Subform, with which we can view the subform data in a popup view. But the issue
Fetch Records within a Date Range
This seems like it should be an easy thing to do, but I can't get the syntax right. I want to fetch all the records in a form that are within a certain date range, say the last six months. I have seen syntax like this rec = Contact [ID != 0] sort by Added_Time range from 1 to 5; referenced here: https://www.zoho.com/creator/help/script/fetch-records-within-range.html I do not understand, however, how a range for Added _Time can be an integer like 1 to 5. I would think if it as a date-time field.
{"4834":"Invalid Ticket Id"} as response of ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials");
Today all fetchs to zoho crm give me the error {"4834":"Invalid Ticket Id"} All calls that I made are of the style ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials"); crmResp = zoho.crm.getRecordById(("Accounts"), input.Cuenta_ID); etc. I have found some post with this issue and it seems that it's related with the auth token.... but i don't know what i need to do to fix this issue. Could you help me?
Formula field not working properly
I have an input field "Basic" and some other fields and one formula field "Total" in a form. When I input data into "Basic", then an workflow runs (on user input). The workflow populates some values and puts those into other fields. The formula field
Boolean operators
Why can't I use != (not equal to) when comparing 2 booleans?
Zoho Creator | Panel not saving after editing keeps on loading.
Use Zoho Analytics tables as data sources for Creator apps
I am currently using Zoho Analytics to create reports using data generated from a 3rd party web-based case management system. It would be very helpful if users in my organization could create applications/forms using data from the Analytics tables and
Next Page