Calculate hours
Looking for the following function. Example, Employee worked from 3p to 7a whats the total hours between 11p to 4a
Functions : Can I pass a value from a page parameter to a function ?
I have pageparameters that set "startDate" and "endDate" example : https://creatorapp.zoho.eu/MYCOMPANY/MYAPP/#Page:Home_Generic?startDate=01-Jan-2021&endDate=31-Dec-2021 I would like to use a series of functions in panels in that same page - can I read
getDate from String ? Should be easy
This should be so simple, yet I'm having issues. I'm passing a date to a page parameter and then want to pick the value up for some labelling. The URL is passing : ...#Page:Dev_Home_Generic?startDate=01-Jan-2022&endDate=31-Dec-2022 and I'm trying to get
How to cancel On Add Row event?
Is there a "cancel Add Row" type syntax in the On Add Row subform event that can be fired? My use case is this, I want the screen to send out an Alert saying that some fields are not filled out in the master/main form when the user clicks on the "Add" link in the subform and then remove the new row in the subform. So in my On Add Row action, I have checked the condition say: if (input.Field1 == null) { alert "Field 1 in the main form needs to be filled out."; cancel Add Row; <===== Of course
Please make SPLIT FIELD LAYOUTS more web-responsive on desktop
I find that whenever I split fields into 2 or 3 columns (within the form design view of Zoho Creator), the live form never looks good on a desktop browser. Some fields in each column are spaced appropriately so that everything is in view, while others
check info before Syncing two Subforms
Hi i have a secondary form that dumps its info into a master report. The secondary form has a subform and there is a corresponding subform in the main report CASE: Main form alreayd has ONE SAMPLE_ID listed on it User submits on secondary form adding
Dynamically adding rows to a sub-form. Problem with populating drop-down list
Hello, I need help on the following code. Here I am inserting rows in a sub-form called Period_Info1 (which is in main form Create_Time_Table) from another sub-form AA.Period_info. The fields Period_no, Fr_Time and To_Time are inserted correctly but field Course, which is a drop-down list is not getting populated with List L_S. If the number of rows in the sub-from are predefined then the drop-down gets populated correctly from the list L_S. The drop-down is not populated when it is part of the
UTMs Forwarding in Embeded Forms
Is there a way to forward any URL UTMs when embedding a form in a website and redirecting the user after a successful submit? We would like to be able to track campaigns to the conversion of a form submit.
Zoho Creator Developer
Hi, I started using Zoho Creator and believe that we can use this to develop applications for our company but I am having second thoughts as I cannot find the correct resources. We are looking for an experienced expert Zoho Creator developer for our office in Gurgaon. We are also willing to take someone on that wants to work remotely but still we cannot find the right person. All the proposals we get are from companies or freelancers or from candidates that have very little experience. We are looking
Looking for a Zoho Creator Developer
Hi, I'm looking for someone to help edit, improve and add new features to an existing Zoho Creator application. It was built by a developer who is no longer available for freelance work so I'm looking for someone new to work with - most likely for semi-regular updates. Please list your previous work with Zoho Creator, your timezone and general availability both short and long term. Thanks, Andrew
Update zoho CRM deal stage on form field update
We found the way to create a deal in CRM everytime someone submission the form. Now we are looking for a way to update the stage once we approve that submission. Basicly we have a button that sends the response on the form submission and would like to
Is it possible to add options to a multi-select through deluge
I am trying to update a multi-select field with a value not called out on the form, I am trying to do this through deluge, not in form. So for example a multi-select that has options {"A","B","C"} but through a script I want to be able to do something like this: field.add("D"); Is this possible?
Sales Order Line Items into Zoho Creator
Hello, I am trying to integrate the information of a sales order into a Zoho Creator Form so we can attach certain items to each individual line item. This is needed because it is unique to each order and is not available in sales orders currentl y. So far the only items I am not able to pull in is the product details. Can someone please help me do this using Zoho Creator? Shaun
Access preview link for pdf instead of direct download link within widget using Zoho Creator API
Is there a way to access a file within the Creator file system and preview the file instead of direct file download? I understand the files are hosted on the Creator server, and that the previews are made possible most likely to finding the file and embedding
Using "If Condition/Statement" with two forms
Form A: Used to select email notification preferences (Multi-Select Field) Form B: Used to add and manage work orders SCENARIO First, the user submits Form A, setting their notification preferences. Then, the user submits Form B to create a work order
how to add current date and time in date-time field on load of the form
Hi, how to add current date and time in date-time field on load of the form date = zoho.currentdate; time = zoho.currenttime; this is the code i have tried; but either date or time i am getting in different variables, so how can i store both into one
Upcoming Updates - May-June 2022
Hi all, Greetings from the Zoho Creator team! We're looking forward to delivering on all the exciting updates we previously announced for you. In this update, we'll be going over: Revising developer permissions API limitations on workflow looping Standardizing
Cascading Dropdowns w/ Add New, etc., etc.
I have 3 record types: Company Branch Contact Where Contacts belong to Branches which belong to Companies. Question 1: On the form for Contact, I want to be able to choose which Company and Branch the Contact is being created for. I got this working by
Renaming
How do I change the name "Sheet1" to "Customers" in the figure below?
Email data to form
Hello, I’ve a couple problems while trying to send an email to a form. While I don’t think it’s a zoho problem, I’m gonna ask you anyway, maybe you have a solution. Sometimes when a user sends an email to the form, the content won’t be captured by ZC_Content.
Zoho Developer "Custom Solution" Question
I've made a few basic applications within Zoho Creator for my company's own internal usage. I want to recreate one of these applications within Zoho Developer as a Custom Solution, so that I can sell it to other companies. I'm not quite grasping the Pricing
Syncing data between the environments
Is there a way to sync the data from the production environment to the development? Everytime I publish and update I lose all the data in the production version
Hide empty fields in summary report
In the summary report view, how do i hide the fields that are null?
Panel filter not working
Hi, I am trying to construct a panel filter like below: But it seems does not work, only one of the conditions is fulfilled. Any way I can achieve what I need to do?
Forms to enter data and retrieve data
Hi, I am very new to Zoho Creator. I am looking for a really simple sample application so I can learn from it. I want a simple form to enter an employee personal data. That I have figured it out. Next I want to search for an employee by name, or by email,
increment a number field
I don't want to use the autonumber field in this case and would like to add my own. I've create a number field called Client_Code, how do I go about incrementing this field by +1 in deluge? Form Name = Customers Field Deluge Name = Client_Code thanks
Zoho Deluge (Creator App)
I need help understanding how to automatically populate and add rows to a subform. I'm using a dropdown field as the "trigger". I made a 1 minute video hopefully someone can point me in the right direction? Thanks for your help and time. Chris https
Import subform data into one form and push to another form
Hi. We have a user portal where: the client receives spreadsheet template download after submitting details client enters subform data into the spreadsheet, then imports the spreadsheet back into the same form's report. We need the imported record and
Paged data from Inventory using Creator api: how to get?
According to Get Records from Zoho Inventory, data from Inventory is paged and has a default page size of 200 matching the behaviour seen in Get Records from Zoho CRM but where as the call for CRM allows you to supply paging information to get subsequent
Changing Field Name value
Hi, Is it possible to change the field name on a form base on the value passed in runtime using deluge? I have 100+ elements in a form I want the user to write the name of the element who wanted and change the field name base on the user input in another
Creator : Formatting help - ZML to HTML
I need some assistance with making a HTML panel look the same as a ZML panel, however my HTML skills are severely lacking and I can't get it to look the same. This is visually how the two panels look side by side : And this is the ZML code for the panel
Add Related List from Zoho Creator App To CRM Module
I'm very new to zoho. I have an simple creator app that contains a simple form: A name and an integrated source to the Deals component. There could be a hundred items associated with this "deal". How could bring this associated items as a related list
how to change the name instead of info we want shipmydeal
Hi, Please check attached file .. as in the name i am trying to change the from 'info' to 'shipmydeal' ... how should i change ? and this is the code i have written sendmail [ from :zoho.adminuserid to :input.email subject :"Registration" message :"Thank
Missing backup data for the entire month of April.
My biggest app is missing backup data for the month of April. I have had a weekly backup scheduled since inception. I went back to look through some historic data and learned that all of my backup data is missing for the month of April. Has this happened
Restrict Previous Date Calendar Booking
Hi All. I am facing diffculty in implementing the functionality. When User click on Previous Date on calendar , System should Alert "Booking Not Allowed in Previous Dates" and system should not open Booking form for previous dates. Same functionality
Creator.. How to get the next Friday date?
Work week is Monday through Sunday. Settlement pay is paid every Friday for what was completed the previous work week. I need a function that will display in Creator form what that next Friday Settlement Date is expected to be based on the Delivery Date
How to add up pay based on several entered factors
I need help entering Driver Pay and Dispatcher Pay based on their pay rate and load amount. I have a "Contacts" form where the driver and dispatcher name and pay % live, and a "Loads" form where the load information, load pay, driver is selected and dispatcher
Restrict Previous Date Calendar Booking
I am facing difficulty in implementing the functionality in ZOHO Creator. When the user clicks on the Previous Date on the calendar, the System should Alert "Booking Not Allowed in Previous Dates" and the system should not open the Booking form for previous
Is it possible to create an announcement bar in Creator app?
Hello guys, I would like to ask you if there is any way inside a Creator app to have an announcement bar like the one we receive sometimes from the Creator platform Did you ever implement something like this or is it impossible at all? I do not really
Repeating or recurring calendar events
Hey Everyone, I have been searching the forums for a couple of weeks now and have not found a definitive answer to this question. I know this question has been asked many times but there never seems to be an actual answer in the thread. I have created an employee schedule for and a calendar report. I have a Start Date and an End Date and the entries show up on the calendar report successfully. BUT, how do we make events/tasks on a calendar repeat or recurring? Example, if I create a schedule for
Next Page