Calculating difference between two date-time fields, EXCLUDING weekends
Is it possible to calculate the difference in time between two date-time fields, EXCLUDING weekends? I need this to measure the productivity of one of our departments. At the moment, it includes the weekends, which is not an accurate reflection, since - say, if someone submitted a ticket on Friday late afternoon, it makes it look like it took all weekend plus whatever actual working time to complete the request. Thank you in advance!
Report Summary - Page Layout - Fonts
Hi I am trying to create a letter using a report summary. It seems to work ok apart from the fact that the font seems to scale incorrectly and is very small on the page. Does anyone have any ideas on what I could possibly be doing wrong? Thanks in advance.
Company intranet
I saw a post from 8 years ago on opening up zoho to company intranet but at that time there was no solution. Is this possible now ? If so can you share a link to information around this subject? Thank you
number of unique values in the report total only
I have a standard report with managers and their transactions with clients during a month. What I need is to add a total number of (unique) clients processed this month. It is easy to add such a column using Aggregate formula but I don't need the column, only a total number of unique clients. What is the easiest way to do it? Thanks in advance! Ph
how to display data in page ?
In the form page i have username one field and search one button, enter username xyz it should fetch the username and display details in page as a table data
Problem with Google Apps Integration
I probably created this problem, but now I can't seem to fix it. I had an app with "Google" authentication setup on the General settings page. Since we are a Google apps domain, I went through the steps of enabling Zoho Creator on our apps domain (installed it on our domain and enabled "Google Apps" on the General settings page. After doing this, I discovered an OAuth 2 error when any of our sub-domains try to log in with their google apps credentials (we have a primary domain with some users, and
Date and time difference in Days, Hours, Mins
Hi, I have a formula which calculates the difference between two date and time fields. It works, except I have it set so it only displays difference in hours and minutes. (((((((Task_Completed_Date_Time - Request_Date_Time) / (1000 * 3600))).toLong())) + " Hours ") + (((((((Task_Completed_Date_Time - Request_Date_Time) / (1000 * 3600))).toDecimal() - (((Task_Completed_Date_Time - Request_Date_Time) / (1000 * 3600))).toLong()) * 60)).toLong())) + " Mins" What would I do to have it
Importing data into related tables
I have a csv file with data for three related tables and want to import it but am not sure best to go about it. Curriculum -< Course Course -< Lesson Lesson -< Resource Do I import them all at once or once each for each table?
UI issues with position:fixed headers
Is anyone else having issues with the report headers? For the Zoho Team... I checked out the console and it looks of course like position:fixed is used with a scroll spy event listener to update the top css property. The issue is probably due to the fact that a dialog (with screen mask) jossles the scroll but doesn't fire the listener when closed.
Validating File Uploads and Disappearing Uploads
I want users to be able to submit up to 5 attachments via File Upload and I want to validate those attachments. To do this, I have a Dropdown list called How many Attachments with 1 through 5 This dropdown list will either show or hide the appropriate number of file upload fields. After they upload the files, and click Submit this On_Validate script runs: if (input.How_many_Attachments == "0") { input.Attachment_1 = ""; input.Attachment_2 = ""; input.Attachment_3 = ""; input.Attachment_4
Is there a program available to open/edit .ds files?
Hello, I am trying to import a .ds file to duplicate my application for testing purposes. The application is built on an older version of Zoho Creator, and there are scripts in the .ds file that are no longer supported in new applications. I'd like to edit these out of the file, but I'm not able to do that on import. I have attempted to open the file in WordPad and Notepad, but I believe this corrupts the .ds file. It generates incorrect characters that I believe interfere with the import (in addition
PRD refresh to DEV
I have a Zoho Creator App which I have been using for years. It's PRD and I never had a DEV version of it. Now I want to create a clone of PRD and call the clone DEV, in another Zoho account. In the future all development and coding will be done in DEV, and from DEV I will push incremental changes to PRD.... how this can be done ? this is in a retroactive fashion... usually u create a DEV then do a copy from DEV to PRD and call it system copy... thanks!!!!
Criteria with space and date add time
Hello, Could you help me in two items: I'm trying to make an API via query by using: https://www.zoho.com/creator/help/api/rest-api/rest-api-view-records-in-view.html # 1 - But I can not seek criteria containing space. I can get situation = Cancelled I can not get: situation = Waiting Sale How should I do? # 2 I would seek also to seek the registration date, as I do? Added_Time> = 4-May-2015 11:13:10 It does not work. How should I do? Tanks Tulio
how to calculate days in month
hi how can via function calculate numbers of days in month (current or future)? example - right now is may-2015, and there is 31 days in june-2015 there is 30 days how can i make automatically this type of calculations?
Dialog Helper function
Hello everyone, It's been a long time! Anyways, I'm working on a client application that uses a lot of view actions and dialogs. Just thought I would share a nice helper function to make building dialog's (using openUrl) with complex params much easier. void open.dialog(string resource, string resource_name, map params) { keys = input.params.keys(); str_params = "?zc_LoadIn=dialog"; for each k in keys{ str_params = (str_params + "&" + encodeUrl(k) + "=" + encodeUrl(params.get(k)) ); } url
Creating a function to populate another field
Hi, Working on a small inventory system here and running into bumps along the way. I am importing some 900 entries into this form and trying to populate a unique inventory number for each. The On Add > On Success or On Edit > On Success actions I've setup dont work for bulk edits or imports, so im thinking maybe its an idea to just have a button in the report that says 'Update Inventory Number' for those times that new records are imported which is hardly. But I dont want to go and manually update
How to add placeholder in a Zoho Creator field?
Dear All, I would like to ask you if there is any way to add a placeholder with a message in a field (lets say a multiline field) like the Zoho Invoice. I know that I can write a Tooltip Message but what about placeholders? Is there any hack way with CSS?
Create subform from a different app
Ex Code: Subform ( type=grid values=investigators.Investigator_Registry.ID ) This doesn't work at all now and it was working yesterday. Now everytime I try to add something to it, it says error null (I'm paraphrasing). Also if i try to change a subform value through free-flowing script mode it gives me a error null message again. Really though I want to be able to create a subform from Investigator registry app and implant it into PCRS Project tracking app. Also I'd appreciate a more
Drop down list values
Hello, I am trying to build up an Inventory Number creation script… or at least, a form where some of the values will generate an inventory number in a Function field. I have a drop down with 4 different values for an employee to put in… for example Part Structure Object Value Other I am calling this in the function field however I don't want the word to be generated in the Inventory Number. So if a user selects 'Structure', I would like to have the Function Field show a number instead of the actual
how to count entries with multiple variables?
hi! right now works the next code res = zayavki_form [sold_result.contains("0.1")]; count = res.sold_result.getall().size(); if (count > 0) { alert "Alert"; cancel submit; } this code works fine. it counts all entries from zayavki_form which contains "0.1" in sold_result. how can i count number of entries which in same time contains "0.1" in sold_result AND "zero" in field_A ?
Auto Increment Number based on other field values
I was curious if there was a way to Auto Increment Number based on the values of another field? For example, If Field 1 =A and Field 2 =B then increment by 1 based on the amount of entries containing 'A' and 'B'… So if I have 32 records where Field 1 =A and Field 2 =B, then the next record I add which has A and B will increment to 33 If i then make another record after that one, that has Field 1=J and Field 2=B, and I have no previous records that have those conditions, the auto number will display
Embeded public html views and error 400 (Bad Request)
Hi, i have embeded multiple html views in a website, with public sharing option. When i load the page, the first items are displaying correctly but others are not displayed, i get the zoho creator login page instead of the content i want to publish. Using Developer tools for chrome i can see the errors that are generated : 400 (Bad Request) Unsafe JavaScript attempt to initiate navigation for frame with URL The frame attempting navigation is neither same-origin with the target, nor is it the target's
Looking for Zoho Creator / Developer - remote work --- my client in Dallas, TX
Need 6+ years developer (.net or java or php) along with 2+ years Zoho Developer (Creator / API ) experience - certified Zoho developer or equiv experience. Zoho Code Review / Analysis -- enhancements ..... Contract Role - 3 months and could extend START June 1st 20-40 hrs per week -- flexible on hours jeff.kohnle@correlationpoint.com 214-450-4494
How to add attachments in Zoho Invoice mail using create zoho incoice function
Dear All, With the usage of create zoho invoice I can send an Invoice (as an email) to a user-client with a default text (which is editable through Zoho invoices.). Does anyone know (if there is any way) how can I add an attachment in zoho.invoice.createinvoice ? Because I would like to send an email with an attachment (which I uploaded it in a File upload button). I found this but I do not know how is working.
Cannot adjust manually the width of a radiobutton in a subform
Dear All, I created a form with 2-3 radio buttons. Then I used this form as a subform in another form.As we know in the new form the radiobuttons are shown as dropdowns. My question is, I am trying to adjust the radio buttons width (dropdowns in the subform) manually but they are not shown in the Configuration pop up. Why this happens? Is it a bug or is is something else? Is there any explanation for that?
Double digit number field
Hello, I was curious if there is a way to enforce double digits in the number field? For example, i inserted a Number Field with a starting value of 01, however when it displays the form, it just shows 1. Also if I call it in a formula it returns 1, and ignores the 0. I would like to force the display of the 0 because this is part of a formula I am trying to write to formulate an inventory number… Example JW 01 01 15
Email Dependant on Input
Hello, I am creating a form which will be embedded on my website, On the form we use a "Postcode" field which we expect our clients to input their postcode. Within this field we expect the postcode to begin with either BD or S. We want an email to be sent to a person based on the postcode entry. So any postcodes beginning BD would need to be sent to John Smith and any postcodes beginning S to be sent to Joe Bloggs. Is this possible?
Feature request: show list of CRM fields
Hiya, I'm creating a custom CRM contact modification form. It involves mapping fields from CRM to creator and vice versa. It's quite tedious to switch between tabs to get the field names. It would be great if I could have a field list from CRM as well as the field list from Creator so I could quickly copy/paste field names. cheers -- If you need any help with this or anything else related to Zoho, check out www.nuanced.it or email me at jeremy.nagel@nuanced.it
Mandatory format of a value in a field
Hello, I can't find the following functionallity. A single line field can be filled in like: 12AABB I would like ZoHo Creator automaticlly adjust the value in the field to: 12-AA-BB. Or is it possible to make the punctuations mandatory? Hope to hear from someone soon! Greatings, Erwin
Manipulating text string
Hi, I need a favor. Would yo give me a clue on how to remove the HTML remarks from this text string by using deluge script? I want to leave the red text only... Thanks a lot Luis <span style= 'font-style:italic;'><span style= 'font-style:italic;'><span font-style:italic;>Ideal para MDF, Acrílico, Papel y tela entre otros. Excelente calidad y detalle para su proyecto. Disponible tamaño de hoja completa 1.22 x 2.44m </span></span></span>
Passing parameters to a embedded website view
I have a view embedded in a website and want to filter based on certain input. I tried for hours the Zoho creator examples for passing url parameters and none didn't work. The form is asking me to login. <iframe height='500px' width='100%' name='Form:Copy_of_Reporte_de_Pedidos' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zohopublic.com/jaflores/pedidos/#Form:Copy_of_Reporte_de_Pedidos/?NombreCtaHide='sedyco'></iframe>
Having trouble constraining reports to specific content
Hello, I'm having trouble running reports based on specific criteria in my application: Form (A) collects different Job Types (Help Desk, Services, Development, etc). Form (B) collects Employee Info including Name and Job Type (using a lookup to Form A) Form (C) assigns Office Equipment to different employees I need to run 2 reports on Form (C). The first is a pivot table, and the second is standard report. However, these reports must be limited to employees of just 1 Job Type. How
Integrate SalesIQ into Zoho Creator App
How can I add SalesIQ tracking to my Zoho Creator App? Oliver
Simple text formula field
I want to reference a field from a parent form in the child form. The parent has a lookup field to another form; and I want that field statically represented in the child form. In SFDC it's a simple Text=(Insert field) How is this done in Zoho? Thanks.
How to remove a starting newline?
How would I remove a starting newline from a string, if it exists? Since I created the newlines using "\n" I'm not sure exactly how to check for it and then to exclude it in the revised string. FYI I'm building a string by concatenating multiple values and starting each with a newline. Those with no value are skipped, but the end result can be a starting newline. The logic would be something like this, but I don't know the deluge syntax or best practice, I'd think it involves startsWith, Length,
Creating a Function to edit another record
Hi all, I have a request manager tool I am working on (and constantly improving) and within the tool I have a main table that captures all my requests and I have a second table that captures the asset and serial numbers of the device or devices for each individual request. The device details are captured int he main form as a subform. One of my reports concentrates on the asset details and the report is based on the device table, however what I want to be able to do is search for a specific asset
Can data in a report column be SHOWN for some records and HIDDEN for other records?
Is there a way to configure things so that on Reports, for most Profiles, for a certain field, let's say "Price", data can be shown in the column for some records and hidden in the column for other records? This would be based on another field in the record, say "Internal/External". So, for most users, for the "Price" column, on Reports: for records marked "External", users see the "Price" data for records marked "Internal", although the Price data exists, users see blank (the data is hidden). And,
Aggregate Excluding
Working in Creator on a Pivot Table. The table is an aggregate table of pricing for products across multiple vendors. Col 1; Average price, excluding our listed price. Col 2; Our price. Col 3; % difference between the two.
Validation using forumla field
Hello there Zoho community, I'm a bit stuck and wonder if someone can help me... I have a form with a formula field which generates a customer reference: Form name: Registration form Single line: Last name Date: Date of birth Formula: Customer reference ((((Date_of_birth.getMonth())) + Last_name) + (Date_of_birth.getDay())) + (Date_of_birth.getYear()) I'd like to set it so that if someone tries to fill in the form again (and therefore generates the same customer reference) an error message will show
Script for capitalisation
Hi, I am using the following script in functions in order to make the first letter of text uppercase and the rest of the text lowercase: string getCapitalised(string txt) { if ((input.txt).length() > 0) { input.txt = (((input.txt).subString(0,1)).toUpperCase()) + (input.txt).subString(1,(input.txt).length()); } return input.txt; } Although it works when text is input in all lowercase, it does not work if text is input in all uppercase. Do I need to add a bit of script in order to do this? Thanks
Next Page