getDayOfYear() with leading 0's
I am trying to use getDayOfYear() to generate a date code for orders, but would like the output of the Day of Year to always have three digits. For example, I would like Jan 1st to be 001 instead of 1. Feb. 3rd would be 034 instead of 34. Here is how I am using it: if (((input.Wash_Date != null) && (input.Washpack_Step != null)) && (input.Batch != null)) { year = ((input.Wash_Date.getYear()).toString().getSuffix("20")).toLong(); step = Washpack_Step[ID == input.Washpack_Step].Number;
Question about making data publicly available
I have a report from a private application that is embedded in a Web site. My understanding is that using the permalink feature allows the private view to be shared publicly. Now I want to add a custom action to that report that will allow the viewer to generate a record summary report with one click. Here's the custom action: openUrl("record-summary/Force_Player_Profile_Report/" + input.id, "Same window"); It works when I am logged into Creator. However when I execute it through the embedded
Hours Worked Time Sheet
I put together this script for calculating for my time sheet. All hours worked are during the day. Start_Time and End_Time are Date-Time fields. Break_1, Break_2, and Time_Taken are decimal fields. This appears to calculate correctly, and meet my needs, but I want to check before implementing it. Does anyone see any reason why this wont work? startmin = (input.Start_Time.getHour() * 60 + input.Start_Time.getMinutes()); endmin = (input.End_Time.getHour() * 60 + input.End_Time.getMinutes());
Change Report Script to show Totals not all records
Hi Guys, I have the current script to generate a report: spreadsheet Hours_Report_for_Wages_II { displayname = "Hours Report for Wages (II)" show all rows from Employee_Time_Sheet ( Name Hours ) filters ( Date_field "Last Week Hours Only" : Date_field in last 7 days ) group by ( Name ascending ) } Can anyone help me with how I edit this script to the report only shows one row per Name and the total number of
Custom action to send veiw/ report via e-mail
Hi, I'm having trouble understanding how to configure a custom action that would allow me to send a PDF or plain text copy of a Form report/view. I followed the instructions on the How to , however I am still not able to send the report via the custom action The custom actions sends the report but it does not send the report (PDF file) I have a work assignment form which consists of a an Employee field. The employee field is a look up filed back to my Employee tble. My Employees tbl consists of
Users And Permissions
Dear Sir I would like to set permissions for some fields But i can not do that In the notes it says some old accounts can not do this I have to solve this please help What i want is easy I want to create roles and i want to set some fields to be shown some groups and some other other fields What i see now Show field to Admin or Everyone.I need to create some Other goups such as Account Department or Exporting etc Thanks
Zoho Creator Won't Take Pictures on iPhone 5C
We noticed on our iPhone 5C that we can't take a picture while in the mobile app. Everything else works great. When we hit the camera option all that pulls up is a blank screen. The camera will not work. Is this something that just occurs for the iPhone 5C and is there a fix? Thanks!
Date Time problem
Dear Sir, I already try Many Date, only 2/11/2014 return Wrong Result.. Why same formula return two different result ??? (((End_Time - Start_Date_Time) / 1000 / 60 / 60)).toLong()
Tooltip not working
Hello, I configured a tooltip message as indicated here: https://www.zoho.com/creator/help/fields/configuring-tooltip-for-a-field.html but is not working. The field is numeric and I've tested in Chrome Version 38.0.2125.111, Safari Version 8.0 and Firefox version 33.0 Thanks!
if (First time user input)
Is there a way to only execute a function if a user has not inputted into a field? For example, I have a form with a Start_Time and End_Time. I would like that if "On Edit", the End_Time will be set to now, but only if it has not been previously inputted by a user.
Email Address
I've created a web form that's embedded in our website to enable clients to register support requests. I want to be able to automatically send an email confirmation back to the client for each request. However, at the moment if I send an email automatically, it shows my personal email address, martynhale@vct.uk.net as the sender. I want to be able to use something like support@vct.uk.net. How would I do this? Thanks, Martyn martynhale
Create an upload button as Custom Actions in a report
As we know with the custom Actions in the reports we can create buttons with call functions. I would like to ask you if there is any way to create an upload button in the reports in which I can upload files from my PC. Like the upload button in the form creation.
Sub forms on iPad
Any news on greater functionality for sub-forms on the iPad? I cannot get any forms with sub-forms to appear. My sub-forms do not have image or file upload fields. Zoho creator support lists the limitations as such: Zoho CRM field] is not supported. Charts and Pivot table in reports are not supported. Limited support for Pages (HTML View). Subforms with file upload and image upload fields are not supported. Forms with Rules are not supported. According to these limitations, my form should
problems using a lookup in a stateless form
I have a table <MyTable> which has a lookup to another table <Data Table>- so far so good. I have a stateless form which receives the ID of the row in <MyTable> via a function. I can then pull the row in <MyTable> and populate the stateless form. I need to be able to populate the Lookup with an existing value from <MyTable> and allow the user to change the lookup value in the stateless form - eventually to save back to <MyTable>. Currently the stateless form has a lookup defined in a similar way
Formula Field return with dollar symbol
Hi, Create this formula (Pago_Total - Pago_Total * Porciento_de_Descuento / 100).round(2) and work great but I need the return value with the dollar symbol ($) in the formula field and in the column total.
My schedule doesn't work
Hi there, I have a problem with my schedules. I tried both custom and form ones, set the right timezone (CET) and they don't seem to be working. Even though the right time, set in "When to do" passes, no activity is reported in Usage Logs neither the e-mail is sent. Can you help me please? Thanks in advance, Stan
Fetch records from Zoho CRM and update picklist
Is it possible to fetch the values stored in a Zoho CRM picklist and add them to a Zoho Creator picklist. i.e. I have a field in the CRM called 'Roofing Type' in which I have about 10 different types of roofs which I select depending on the job. Can I have zoho creator pull this list onto a picklist in zoho creator. That way I only need to add different roofing types into crm and it synchronises with creator.
Retrieve all related data based on lookup field selection
Hi, I have a form and which has several fields but two fields are TV station and Market ( Market is the lookup field of market Form). below is the data format. I am trying to update this form data by using another stainless form.What I am trying to do is put a Market field drop down above on the stainless form and when user select the market name from drop down then a script will run to retrieve the related TV station name in the next tv station drop down field. For instance , if user select
IOS linked record searching
Hi, I am using zoho creator on ios devices now, after using it primarily on android before. One thing that I have noticed is that when searching a linked record in a form on ios, the full list is not populated, only the first portion. This is fine for me as the list (typically) loads more results as I scroll down. The problem I have been having is that when swiping up to reveal the search box, the search will only return the results that are already loaded, which kind of makes the search useless.
New User field being assigned a value unintentionally
In an application we are using the new User field. It is being assigned a value when a user changes to a record by a function. The field is not referenced in the function. Is this normal behavior. My understanding is this field works like a normal dropdown and is not changed unless selected by a user on the screen or is explicitly set with a script command. .
Error in REST API call
I am testing the REST API call in command line with curl. I have a problem and I can't find what I am doing wrong. The following call works fine : curl https://creator.zoho.com/api/json/applications?authtoken=********&scope=creatorapi It gives me the list of applications. But this one does not work : curl https://creator.zoho.com/api/json/chouette/forms?authtoken=******&scope=creatorapi&zc_ownername=aaa.bbb I have the following error: {"errorlist":[{"error":[2892,"Specified application name is not
Postal Code input mask
I was wondering what the code is to mask a input to canadian postal code format.
how to make regular report in plain text from creator?
hi just use creator.zoho.com and reports.zoho.com all works well i need every night report in plain text from creator. Zoho Reports can send report only as attached pdf file. how can i make and send report from Creator in plain text by email? what report? there is report1, in this report i need - total summ of entries - total summ of entries with fields field1="id1" - for all entries with field field1="id1" - total summ of numbers from field2
Date field without day
Hello, Is there any way to insert a date field in a form that lets you select month and year without the day? So, for example the options would be November 2014 December 2014 January 2015 February 2015 etc. Thanks, Matt
How to reference Sub-Fields in the URL Field via script ...
Hi: Is there any way I can automatically set the "target" component of a URL field via script ? I am working on an Application where the requirement is to enable the user to enter the URL Address (like www.zoho.com) ... but not be given the option to specify the "target" (Same Window, New Window) ; instead, the "target" should be set to New Window ... so when the same field (column) is clicked in the Form's View, the specified web page is displayed in a New Window. I thought that I would force the
how to make - filtering entries in view for different users?
hi just made new view there is 2 users - user1 and user2 entries in view contains data "data1" and "data2" how can i make in view so that - user1 can view entries that contains "data1" - user2 can view entries that contains "data2" ? thank you!
Simple Question: Fetch Records based on Date Function
Hello all! Thanks in advance for your insight. I'm having trouble trying to fetch records based on date. Here's what I'm trying to accomplish: Given Activity_Date(date field), month(int), and year(int). list = Booking[Activity_Date.getMonth() == month && Activity_Date.getYear() == year]; The error message says "Invalid Criteria." This is probably something simple I missed in documentation. What am I missing?
Filemaker migration crashing
Hello, I am testing a migration and come up with this error. I have deleted all calculation fields in the export file.
Problem with Lookup ID, BIGINT and STRING == not valid
Dear Sir, I am not a programmer and have been trying hard to work with Zoho creator. I am working on an app to calculate a total process cost for a work. Form 1 : Work_Order Work Order # (single line) Work Completed? (decision) - if this is "true" then run script below: Total Process Cost (number) - wish to calculate and return a total based on related values in Production Form if input.Completed = true // { Total_Process_Cost = 0; for each r in Production [ID == input.Work_Order] { Total_Process_Cost
Share Option setting is not available in Another Person's Account
i am using an enterprise edition in creator and i need to get an application via sharing from an another person's creator account and he want to assign some permission for me but he can't able to assign permission for me because the option "users & permissions" option is not available in that account then he too using an enterprise edition plan. is there any way to do it for assign such option ? then i attached that accounts screenshot below.
Creator Can't Handle Several Formula Fields?
Dear Sir/Madam, I tried to create a form with several formula fields, there are 4 formula fields that calculate based on an input value as below. Input field - Duration Formula fields - Production Efficiency - Machine Cost - Labour Cost - Process Cost When I tried to input and update "Duration", I got a refresh icon, and the form just froze there, and I did not get any result from the formula fields which depends on the input value. I have tried it over and over, it still froze after keying "Duration"
Problemas com contas de e-mails
Olá! Boa noite, Além do e-mail principal adicionei mais dois, sendo que o primeiro funciona perfeitamente envio e recebo mensagens, porém os dois últimos não funcionam, ou seja, não envia e nem recebe mensagens. O que fiz de errado? Se puderem me ajudar fico muito grato. Atenciosamente: Adilson M.
Sub forms
Hi i have subform , fields are food name no.of plates,price food name is drop down if user select food name and enter no.of plates and automatic calculate price i want set criteria ,user don't select previous row selected food name please check attachment Thanks Satya NHM
How to create a lookup field after the two forms are already established?
Hi. I have imported Excel data to create one form. I would like to import data for a second form, where one data field contains data which is identical to a field in form one. Is it possible to create a lookup field after I establish the second form, with its data? Also, I see that there is an Excel Migration tool for Windows users. Is there something comparable for Mac users? Thank you.
Fetch Records and print on Page
I created a form that allows me to input data, which is saved in a Zoho relational database, then I created a report to view this data. All of this works perfect. Then I tried to create a page, so the data can be exported in custom layout, but I have been unable to fetch (access) this data and print it out in my page. Can someone help me with the structure and syntax. I am familiar with PHP/SQL, so here is my code below: <% firstname = BasicInformation_Information[ID !=0].First_Name; lastname = BasicInformation_Information[ID
fetch records and display on page
Hello, I have created a form, where I made one entry. Then I created a report to show the data entered. All works perfectly. But, then I tried to create a page, so I could design a customized report, but I am unable to retrieve the data from the database and display in on my page. Here is my code below, could someone help me with the syntax. Thank you, Collin <% firstname = BasicInformation_Information [ID ! = 0].First_Name; lastname = BasicInformation_Information[ID ! = 0].Last_Name; %> <table width="200"
Formula field displayed on form does not round
I have a formula field (a/b).round that displays correctly on the View and when clicking on view tot he left of the record. However when I edit the record it shows all the decimal places.
how to check which last user who changed entry?
hi, community! there is app in creator 2 sales users - user_1 and user_2 1 admin user - user_admin each user can open and modify entry in creator's app how can i check which of user_1 or user_2 has at last modified entry? for example, i can make field in which username will be filled (how?) and how can make, so that field will be filled only with user_1 or user_2 usernames, but not with user_admin username?
Add multiple Records from Stateless Form
Is there a way to add multiple records to one form using a stateless form? For example: Stateless_Form field_1: "Number of Times To Add Record" field _2: "Category" //Is there a script to repeat insert based on the input of field 2 (""Number of Times To Add Record")? insert into form_1 [ Category = input.field_2 ]
Problem filtering a lookup field
Hi, I have a problem trying to filter a lookup field ad I need some help. Let's say I have a form called Form1 with just one lookup field called Lookup which "points" to a second form called Form2 which has a numeric field (Form1_ID) and a text field (Text). When I edit a record based on Form1, I want to filter Lookup with this criteria Form1_ID == input.ID. I don't understand why it doesn't work (the dropdown list is always empty). If the criteria is something like Form1_ID == xyz (where xyz is
Next Page