Calculate Hours Minutes Sec in Zoho Creator Using Deluge
check_In = "8-Aug-2023 10:00:00".toDateTime().toLong(); checkout = "8-Aug-2023 18:00:00".toDateTime().toLong(); //difference = start.timeBetween(end); check_In = "8-Aug-2023 17:56:50".toDateTime().toLong(); checkout = "8-Aug-2023 18:00:00".toDateTime().toLong();
Customize Sign-out Button
Are there some url parameters I can use to make a form button sign-out the user from the app? The sign-out link on the top right is small. Here's and example of the url for the top right sign-out: https://creator.zoho.com/logoutpage.jsp?sharedBy=niskypto&appID=212085000006568003&appLinkName=MYAPP&signOutUrl=niskypto/MYAPP/view-login/SOMEPAGE Note: In my account, the sign-out is set to redirect users to my website. Can I also override this with some url parameters? John M. Whitney
Disable All
I want to disable all the fields on the form when it loads. I know there is a way to do this by listing all the fields as follows: disable Name; disable Address; disable City; ... I have over 50 fields on my form and i am wondering if there is a single command or way to just disable all fields on load. On load = disable All Thank you for any help.
Live Chat for user
Hi everyone, I’m new to Zoho Creator and wanted to ask if it’s possible to add a live chat option for all logged-in portal users so they can chat internally. I’m trying to create a customer portal similar to a service desk, but for vehicle breakdowns,
bulk edit records and run internal logic
hi there is few logics in manner "it this than that" logics work well when i edit entry openning it one by one (via workflow "on add/edit - on success" , for custom field "on update/on user input") but when i try bulk edit records - logic does not work. how can i turn on logic to work as programmed - for mass editing records via bulk edit?
How do I change (error) display messages
Hi! I would like to edit display messages like "invalid entries" and "enter a value for Nome" and so on into Italian language messages. How can I do that? Already tried on Validate on form submit. Where I am failing? Thanks in advance.
Hide horizontal lines at bottom of form
Hi I have a page with 3 forms embedded in html snippets. On each of the forms I can hide the submit button easily but I am left with the horizontal lines that bound that section and I cannot figure out to remove them (see below for the two sets of horizontal
Turn Decision Box to a button
Dear all, I need your help on CSS to turn a Decision Box to a Button. I have a Decision Box like: Turn on/off to refresh the information. (on User Input, either True or False, will refresh the information) Now I want to simulate to treat it like a Refresh
Figma in Zoho Creator
Hi Team, I’m creating a form using Figma and would like to know how to add workflows like scheduling, custom validation, and other logic to it. Can anyone help me understand how to set this up for a Figma-based Creator UI form?
How to Automate Monthly PDF Reports with Filters in Zoho Creator
Hi everyone, I’m trying to build an automated monthly reporting process in Zoho Creator and would appreciate suggestions or best practices from anyone who has done something similar. What I’m trying to do: I have a form called New_Customer with fields
Limiting search or dependencies with an asterisk "*".
I have a form with several dependency fields with options still developing for each field. Since these options were developing and not yet ready to be a selection in the field, I placed a filter for the dropdown field. In this filter, I selected fields
Auto Capitalize First Letter of Words
Hi I am completely new to ZOHO and am trying to build a database. How can i make it when a address is entered into a form field like this: main st it automatically changes is to show: Main St Thank You
Copy a Record Template from one Form to another
I have a Creator application with several forms. I developed a record template for one of the reports/forms but want to use most of it for another of the form/report combinations in the application. Is there a way to copy the template (code or otherwise) to another form?
DUPLICATING WORKFLOWS IN CREATOR
Hi all, I want to duplicate and slightly amend 3 workflows in Creator so that I don't have to keep typing in all the rules and properties each time. I can see lots of videos on CRM with the 3 dots at the top of the workflow, but nothing like that in Creator.
Publicar Formulário
Obs. Não consigo publicar meus formulários, pesquisei alguns artigos, mas me deixou perdido, fala de campo sensível, não consigo entender o que significa. Segue Imagem do problema. Todo formulário que faço sempre termina assim sem o botão de publicar..
send file to ftp or another external service
i'v created a zoho creator application for take a picture and rename it by phone. Now i need to send Each renamed pictures to my ftp or to specific folder on google drive...then, delete it from creator. (every picture recived it will processed by another program and stored on my Erp) HOW CAN I DO ??
UUIDs
Has anyone coded a Universal Unique Identifier (UUID) generator in Deluge?
Disable Column Freeze in PWA View but Keep It on Desktop — Zoho Creator Reports
Zoho Creator offers a useful feature to freeze up to two columns in a report view, which works well on desktops. However, our users access the app on both laptops and mobile devices, and freezing columns makes reports nearly unusable on smaller screens.
Transform Numeric Values using st, nd, rd, th or Convert Numerals to Ordinal Form - Deluge
Please Use this sample Code This_Day_Date = zoho.currentdate.toString("dd"); value1 = "th"; if(This_Day_Date.right(1) ="1" && This_Day_Date != "11") { This_Day_Date = This_Day_Date+" "+"st"; } else if ( This_Day_Date.right(1) = "2" && This_Day_Date !=
Give Permission for User test in Development/Staging modes
Hi Everyone, I am using Zoho Creator C6. Where there are development and staging modes. Is it possible to give special / temporary permission for users to test directly in development and staging? Or do you have any other ideas? Thank you very much.
Tip: when "\r\n" not working for new-lines when building a file using the .toFile() function
As above, ran into an issue - "\n" was working for newlines, but "\r\n" was not working for newlines and carriage returns. Took me a bit but using hexToText("0D0A") in place of "\r\n" resolved this. Including in the forums to save others any drama.
WhatsApp and Zoho Creator Integration
#Tips of the Day ======================================================================================== How to Connect WhatsApp With Zoho Creator. -> Create an account on WATI API EndPoint https://app-server.wati.io/api/v1/sendTemplateMessages Pass
Access demo forms other than developers in Zoho Creator 6
Can zoho creator 6 users other than developers test forms in the development/stage? just want to see the form view. The current condition of the form is being released, and want to make changes. But the user wants to see the changes first before publishing
Change Background in PDF Template
Background PDF Hi, I want to ask a question. I want to create a background template with my own image. Above is an example that I made, why does the result not fit the A4 format? Like cut off. I used an A4 Portrait image, is there a size error? can you
Parent Form -> Subfrom with Lookup Field - Desync on Parent Form Viewport
I have a Parent Form (Accounts) with a Sub-from (Documents). The Documents form contains a lookup field for Accounts, however when the "Related Account" Lookup Field is updated via the Documents form, the change is not reflected in the Accounts Form's
Attachment Template as PDF from Another Form Zoho Creator
Hi Everyone, have a good day. I have question, below my script for put the attachment into email. But my template PDF from another form ("Form B"). I get errror because template PDF not exist in the form "Alasan Reject". The form name for example "Form
Custom Icon on zoho Creator APP
Is is possible to have a company logo as the APP image rather than the Zoho image? thank you.
pdf export of form data
Hi , I have 10 form pages in one application of CV in zoho , i want to export all these form data in one pdf document with well formatting(resume) , how can i do that ?? Looking froward for your reply soon Pavan
Is there a way to sort report on record template by a specific field like date field
Hi, Is it possible to sort the report on the record template by the date field and not the default Added Time. Please check the example bellow: The records are sorting by the added time I wand to change that by the date field,
Send Zoho Creator Template by Email or sendemail
Hello All Question:- How we can send the Zoho creator email template using the send email by the workflow or using the Function? by the Workflow sendmail [ from: zoho.adminuserid to: "zohodeveloper@yopmail.com" subject: "Test Template" message: "Test
Fiverr is better than Zoho Partners
For anyone out there looking for help with Zoho Creator's confusing Deluge, I highly recommend hiring NON ZOHO PARTNERS on Fiverr. I've had much better experiences with those who are NOT certified by Zoho. Almost every single "certified" zoho partner
Can I use ZOHO calendar to schedule a Youtube video that is already in my youtube account, but listed as private or unlisted?
I am creating Youtube videos and shorts and then uploading them to our Channel so others can view and approve. Once approved I would like to just schedule them over the next few days within Zoho. So far it looks like I have to re-upload the video to Zoho
Hide Weekend and Non Operational Hours
I am creating a Meeting Tracker and using the pre-template Conference Room Booking. I want to display a timeline chart that only shows weekdays and operational hours. Currently, the chart includes Sunday, Saturday and all hours (0 to 24). I have hidden
Tip 33: How to create custom forms and reports using widgets
Hi folks, In this month's tip, we're going to talk about how to use widgets to create custom forms and reports in your Creator application. But, before that, let's cover a few basics. What are widgets? Widgets help you extend the capabilities of your
escape new line character
Hi, I would like to check if a string contains a \ character (backslash) I try this: if ((input.invoer).indexOf("\") > 0) { found = true; } But the I get the error: Error at line xx : Script contains new line character, kindly remove it and try again. I have tried ("\\") but that doesn't work So how do I do this?
Why are Schedules so Limited? (async data pushing)
Are they just that much more computationally expensive for Zoho to run than normal workflows? I thought they were this magic bullet for having a snappy portal experience for my users but then I realized we're limited to 2400 schedules a month . It had
GPS Link Custom Action
Here's a custom action you can use to make a popup window using google maps void GPS(int zID) { query_address = MASTER_FORM[ID == input.zID].ADDRESS_for_GPS; query_address = encodeUrl(query_address); openUrl("http://maps.google.com/?q=" + query_address, "Popup window"); } I prefered the way the old url builder worked. It took me some time to figure out how to set-up the new url builder to work: Cheers, John Whitney
Fetch field information from one form to another.
Another fetch question... I have 2 forms, one is CUSTOMET form, the other is a SUBSCRIPTION form. I use an openurl script to open the SUBSCRIPTION form when the form CUSTOMER form is sumitted, fetching at the same time the customer name in the SUBSCRIPTION
Trick to bulk delete all records
Create an auto number field called TRASH Add the following line of script to your form's Form -> On Edit -> Actions On Success: delete from Your_Form_Name_Here [ TRASH > 0 ];
is it possible to make an input field read only?
is it possible to make an input field read only?
Next Page