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
How to link to record summary from within a list report?
I have a very simple list report that is embedded within a Web page. The target audience/customer of the information is generally computerphobic and has zero time or interest in exploring menu options, even the ones as well-defined as they are in Creator. What I need them to see is a simple list of records and have the ability to create a record summary report from within a row without having to think about it. Ideally it would be something like this (and I'm being facetious): Hey you, click
How to get matching record from another form to display in main form
I have 2 forms; One main form (Form1), and one form containing static data (Form2) every time I enter a new record in form1, and physically type in the "postcode", I want the matching "region" pulled in from form2. Please excuse me if this is easy but I have tried a few ways with no success. BTW I am a new user. Thanks in advance for any help Roly I
Any suggestions for this one please
I have 10 staff, within my database I am trying to figure out how to..... 1. allow them to select the days and times they are available to work. 2. allow me to view i diary with them all listed Thanks
Update Date after editing
Hi, Is there a way to show a date field that records the last time that a record was modified/edited? Thanks in advance!!!
Inventory Turnover Form
My Creator experience is very limited, but I have created an Inventory Management database and input data using the form "File Input Form". The important fields for this discussion would be "Warehouse Arrival Date", "Consumed Date" and "Status of Inventory". I am trying to figure out how to get Creator to calculate inventory turnover for me with the data in the database. I would need a form or report that would take 2 user designated fields; "Begin Date" and "End Date" and perform the following.
zoho-migration exe.
Why can I not install zoho-migration exe. I have tried to run as administrator [ which I am ,single user machine] Message reads "Windows cannot access the specified device,path,or file You may not have the appropriate permissions to access them "
Better visual customization.
Hi... I dont know where to put this, it kind of suggestion. Since this apps is drag n drop type, why dont add realtime column resize, customizing button for edit,view etc. Thanks
Fetch and Use not working, no error message
I need help with the following code that i have inserted in 'On user input'. All works except the last one, input.Travel1 . The only thing I can think of is that this field is of different type then the others. It is type (long) in both forms and the others are type (string) in both forms. if (input.Store_Number1 != null) { if (input.Store_Name != null) { dat = Add_a_Store [ID == input.Store_Number1]; input.Store_Name = dat.Store_Name; } if (input.State !=
iframe transparency - white lines
I'm using an iframe for the first time since the parameters were changed to be saved in Zoho rather than specified in the iframe. Ive added the same '=transparent' code I had previously but I'm ending up with a thin white line below the text for each field (see URL). Also when a lookup field is used (dropdown) it appears as transparent rather than white making it unreadable. In my page after the code provided by Zoho I added "/zc_BgClr=transparent&zc_FtrClr=transparent&zc_HdrClr=transparent&zc_BdrClr=transparent'>"
Highlight a field
Is there a way of changing the background colour of individual fields? To help users check certain fields, I would like to highlight them.
website-embedded table header cells changing width during vertical scroll
I have a table that when I embed it on a website page has the mysterious behavior of the header cells changing width when you start to vertically scroll. Upon initial table display (when the vertical scroll involves top-of-table) the header cells display at the correct width; however, if you start scrolling down in the table then the header cells change width and don't match the width of their corresponding column cells below. here's the test table location: http://inorml.com/testo2/
Backup Error -No rows found for the table Form_Component in this DataObject
I have been able to backup my application in the past, but now I get the following error: No rows found for the table Form_Component in this DataObject I've deleted some forms I thought may have been causing this with no luck- same error. What should I be looking for?
Subform Entries into 1 Main Form Field
I have a subform lookup where a user selects a code. I need the string value of the code selected for each row in the subform to post in a main form for printing. I've tried subform variables but either I get duplicate entries of the code or just the value of the last code selected. Sample code that kind of works but stores wrong data if user selects a wrong value...it adds the value for each input: r = ""; for each RCRA_Code in input.Manifest_RCRA_Codes { n = input.RCRA_Codes_Print; r
Invalid Email in Logs - How to troubleshoot?
Hi! I have a couple of questions. Problem: I am getting errors in the logs for an invalid email address. And because of that error, the rest of the script seems like it stops. Error details: Error in executing On Add - On Success script. Error. Error in executing IF rule : Error in executing If block. Error in executing IF rule : Error in executing If block. Error in executing Send Mail task. InValid email Address Found. Possible Solution: 1) how do i get the script to continue even if it finds
Added text suffix to a Number field
I have number fields that are measured in Feet ("ft") and Inches ("in"). Is there a way to add a text suffix so that my number fields will read: 100 ft instead of just 100.
Report Headers
Is there a way to keep my report header on all report pages that I print. Thank you.
Calculate Date field based on number field
I need help to calculate a date field based on the amount of travel days a numeric field displays. My form has these fields: Ex-Factory Date (date field) Onsite Date (date field) Travel Days (numeric field) Travel days is a numeric field set by user or lookup. Onsite date is entered by user. Ex-Factory should be calculated. I need this: Ex-Factory = Onsite date minus Travel Days I'm very new to Zoho so any help is much appreciated.
create an aggregate Total of the number of records in a report, based on groups
Hi, I am new to Creator and have rooted around the forum and can't locate an answer to my question. I have a report that works fine at identifying a subset of records. I have a need to email the total number of records in the report to a manager each day. I can see the total number of records in the report on the view, but it does not print. So I have been looking for a method to add a footer or something to the report that would simply provide an aggregate total of the number of records in a 'group'.
API Question
I have tried a Support request but got no response. I am trying to create a Content Management System for my web site. The content is saved in my Zoho Creator database and includes links to images, tile, desCription text etc. From my web site php or similar script, I need to use an API to get this data. What API choices are there? Which is best for this application (speed)? What is the format of the API call?
Next Page