Form as PopUp Box
I am having a difficult time successfully displaying a Form in a popup window. Deluge Script - On load: thisapp.PopUpForms.PopUpAddEvent(); Function: void PopUpForms.PopUpAddEvent() { openUrl("#Form:Add_Event","popup window","height=600,width=1200"); } Problems/Issues: The purpose here is to allow our Users to submit an "Add Event" form while on another page/form/etc. The popup displays with the code above, however the background/main window also changes to the "Add Event" form and the popup
How to simulate a Quick Filter on Single Line field in List view?
How to simulate a Quick Filter on Single Line field in List view?
Autonumber subform rows through deluge script
Hi all, Ive been trying to create a numbering system for each new subform row added. The problem ive come to is on add row, it doesnt show show the value Im trying to display Here is the code ive tried: on Add row: linecount = 1; for each item in Items_Ordered { //This will autonumber each new line added in items ordered items.Line_Number = linecount; linecount = (linecount + 1); } The output I'm looking for is to have each new row added contain a row number, starting at 1 and increasing
Simple Photo Gallery in Creator
I'm wondering if anyone has ever created a simple photo gallery in Creator. I'm envisioning an HTML view that has a list of links dynamically created from a separate Photo_Upload form. The form includes a title from the photo, a caption, and the upload field, with a possible option to denote a default photo to show on the HTML view. The HTML view shows the default photo with a set of links above, possibly a dropdown menu. Using the iframe refresh method, if a link is selected the picture changes.
Is it best practice to use the exact same if statement in two different places?
I'm using the following if statement: // Display Writer Rate field if Position contains "Writer" and Type is "Freelancer"; hide otherwise. hide Writer_Rate; if ((input.Type == "Freelancer") && input.Position_s.contains("Writer")) { show Writer_Rate; } I've included this statement within the On User Input section of two different fields: Position and Type. Is that best practice? It feels messy to me (e.g. if you wanted to amend the if statement, you'd need to remember to do it in the two different
Dose ZOHO Creator Support a True JSON POST ?
I want to make POST Request to Google Calender API and its Content Type is in JSON Format for example look image1. see its content type is in JSON Format and i am Writing code which will make POST Request to Google Calender API but ZOHO is not sending the JSON format to Google Calender API. what should i do to force it to change in JSON Format. here is something i am geeting look image2= So how i force ZOHO to Change its Content Type to JSON and i Want to Send Actual JSON From ZOHO to Google API
Custom layouts not working
Something has happened with the custom layouts in the last updates. I have custom mobile layouts but they have stopped applying in the last few days. Does anyone have information on this and how it can be fixed? It happens to me in several reports.
How to hide/show a section in Zoho creator 5?
Ho can I hide/show an entire section in Zoho creator 5. I searched for the solution but every says go to Application Settings<Sections. But I don't find sections page in settings. Here's how my section page looks.
Record Template - MICR Font
Please add MICR font to Record Templates. This will enable users to issue checks from Zoho Creator.
Tip 4: How to dynamically display images in a live form.
Hi everyone, We hope our previous tip was useful to many of you here. We are back with a new tip that would help enhance the user experience of your app. Yes, that's right. Today, we will look at how to display an image in a live form that is already uploaded using another Zoho Creator form. That is, we will auto-populate the image within the Add Notes field based on input in another field. The logic behind this is pretty simple — just store, fetch, and display. To get a better understanding, let's
Multiple modal forms for one record with prev/next buttons
Hi, I've made multiple modal forms with prev/next buttons for data entry for one record. The modal forms are opened as a pop-up. The one problem I have is that I can't close the modal form that is open when clicking the next or previous button. So that
Invalid Entries Found on Hidden Required Fields
When I submit a new record a warning appears that says "Invalid Entries Found" on a hidden required field. When a required field is hidden an error should not appear. And it hasn't for me in the past. How can I fix this problem?
Duo Two factor authentication
Hello, Do you support the integration two factor authentication (duo.com) within an App Developed Zoho Creator? I need to be able to insert the two factor authentication within the login form in certain circumstances (e.g. based on the user IP location). Please advise, Regards, Edson.
Sort Lookup field by frequency of usage when table is in another application
I have a list of items in App1,->Form1->TextField1, w/ an additional number field "Count" which will ideally collect the number of times each item in TextField1 is used in App2->Form2->Lookup. I think I know how to sort the Lookup in App2 once I have
Possible to Filter a Zoho CRM Lookup Field
Is it possible to filter a CRM lookup field onload? If not possible, is their a good workaround? I'm basically trying to pull all cases with status of "New" from the CRM so a user can select one for updating. We have about 5000 cases but only ever have
Get User Language
Hi, Question: How can I get the User Language via Deluge Script. Use Case: The user set up the language to A. Then the user opens a form. In this form is a Note field in language A. When the user change the language settings to B the Note field change to language B. Solution: Set up localization settings with language A and B Create a Workflow when opening the form Create a If/else deluge script depending on the user language settings when opening the form Change the input.note value to whatever
Create a Capacity Schedule in ZOHO
I want to create a capacity heat map in ZOHO. The first step was to develop this query (below) to determine the "Capacity Start Date" , "Hours p/Day Remaining", and "Scheduled End Date." Now that I have all that, I want to create a new query that will
Export Limit
Hi, I am trying to export report to XLS but there is a limit saying it's limit to 1000 records. Is this intentional? As I saw from the Known Limitation, export to PDF is limit to 5000 but it seems that everything is now limited to 1000 rows? May I know
FYI: how to show/hide subform delete entry for specific users
Create a hidden (admin only) field in your main form, e.g. Current_User Create a workflow for your form: Form > Edited (or Created or Edited) > Field Rules > name of workflow Add two actions: Action #1: Execute without condition, Set value of [Current_User]
How to download multiple files in Creator?
I'm trying to download multiple files from a creator report using a for loop but it only seems to be downloading one file. It seems like no more code can be run after downloading this one file. Is there a way to download multiple files? I'm currently
Drag and drop blocks in details preview
When putting together the details view for records, it would be nice if we could easily drag and drop the boxes into the order we want. It is such a pain to have several blocks arranged just how you want them, only to realize you need to move (or add) a block to display in a different order. Mind you, the drag-drop might prove to be cumbersome (especially if they are large blocks containing many fields), so perhaps an up/down arrow set to allow you to sift the block up or down as needed. Also,
How to update conditional dropdown in a deluge script?
I have a conditional dropdown in my forms (Single select drop down buttons configured as described here: https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html) and need to be able select their values in a script. Script is called
Integreat 04: Integrating Zoho Creator with Zoho Desk - Part 1
Hi folks, We're back with a new post in our InteGreat series, and this time we're going to walk you through how to integrate your Zoho Creator application with Zoho Desk. Before we dive into this integration, let's quickly look at what Zoho Desk is and how you can use it in your organization. What is Zoho Desk? It's a cloud-based platform that helps businesses assign, track, and manage customer support tickets efficiently. Integrating with Zoho Desk With this integration you can push data automatically
Facing issue on file upload using Creator api v2
When I'm trying to upload a file using creator api that time I'm getting authentication error, but when I have tried to create new records within creator using api that time record creating successfully and the authentication error is not showing. Please
Mail Merge export as excel file
I have created a mail merge template that grabs certain client criteria from successful deals to simplify adding a new client in our software. The mail merge template grabs all the data perfectly (it is currently formatted as a table). I want to be able
Weekly inspections - reports for done vs. outstanding/remaining
Hi all, Probably a really obvious one here. I'm a Zoho Creator newbie. I've created a Fleet Management app in Creator (see attached dashboard screenshot) so that our team can manage our fleet vehicles. It has the following two key reports based on
Form to search a lookup and then open another form
Hi all, Coming from an Access background here so a few kinks to iron out. I have an application with Form 1 that is: Initials (Autocapitalise) Postcode (Checks details are correct) UniqueID (Initials+Postcode) updated on form submission I then have Form
How to create a payment payment projection in Zoho Creator?
Hey there! I'm new to Zoho Creator. I want to create an app that lets me register loans. That way, when I enter some information like the amount loaned, interest rate and time, it will create a table containing the amount to be paid by the user, for example
zoho creator QR code not work
Hello, I follow this guidance to create 2 fields with QR code input in a form, like this it should looks like this: however, QR icons don't show and it works as a normal manual input fields, like this: Can you help investigate this? Best,
Comments on records
1. Can a user write and view comments on records on mobile app ? 2. When writing new comments is there a way to use them and send email notifications ? 3. Can someone atach file in comments ?
How do I get more than 200 records from CRM
I want to populate a lookup field in a Creator Form with the Account Name from the Accounts module in our CRM. I will be creating a quote in our CRM later in the process and I don't want the users to mistype the clients name and then have to have multiple
Print template in list view.
Hi, is there any special way to use a template when printing in list view? I have followed the online examples, but can only get it to work in summary view so far
Integrating Data from Zoho Mail in Creator JS Widget
I have an HTML page in creator app that pulls emails from Zoho Mail. I'm recreating this page as a JS Widget. Is there an easy way to connect to the Zoho Mail Api to pull the same data through to the widget? Thanks
Row spacing in template report
Hi all, Where can I find the documentations to configure the spacing between line/rows in the report template? The spacing on each rows using the templates is too huge, I don't know what parameters to adjust, any pointer is highly appreciated. T
pop up reminder
HI there Hope someone will be able to help me I have a schedule set up for Birthdays. Is it possible to create a pop up (instead of sending an email) with all the schedules for that day Regards
Importing data (form and subform) from external platform to ZC
Hello, Could anyone help please, how I could automate data import from excel or csv (which is more reliable) to Creator? I have a sales form with a subform of sales details ( and there is a main form behind the subform). Currently sales invoices are entered
Apply Quick View Custom Layout on Custom Filters On Mobile Apps
Hi, I've created a reports with Custom Filters, but when I switch from the main reports to the filtered reports, the custom template did not applied on the Custom Filters UI. I don't seems to find away to apply the custom template on the filtered
Login to Customer Portal collects data not used (GDPR)
I have just made the Customer Portal Public to showcase our GDPR compliance portal and noticed that it collects Name of the user wanting to register, but there is no way of grabbing this data afterwards. I am working together with a Creator Partner Developer.
Tip 28 : How to auto-assign profiles to portal users
Hello everyone! This tip will talk about our most popular feature—Customer Portals and how you can auto-assign profiles to your portal users. But before we deep dive into this tip, let's run through some basics: About Customer Portals Portals are web
How to implement the @Mention capability of Notes CRM in a Creator app?
Is there a way to implement the @Mention capability of Notes CRM in a Creator app?
Next Page