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 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?
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
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?
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
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.
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 !=
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?
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'.
Zoho Creator - Deluge Validation Script Error on Imported data
HI Guys, I have a zoho creator application with a deluge validation script that works perfectly when entering data via the form: dat = Add_Redbook_Income_Columns [ID == input.Redbook_Income]; if ((dat.Redbook_Income_Column_Type = "Invoice") && (((((input.Date_Invoiced == null) || (input.Invoiced_From == null)) || (input.Invoice_Number == null)) || (input.Invoiced_To == null)) || (input.Invoice_Total == null))) { alert "Please note you have tried to record an invoice with
New to Zoho & lot of questions
Before I start sorry for my English, I'm spanish spoken. This is the scenario: I just started my own business a few months ago managing corporate aircraft. I have more than 12 years of experience in the industry. I developed a MS Access database for this purpose and is working really good, the problem is, as everybody knows, sharing and collaboration. The application has more than 80 related tables for different tasks (flight planning, flight scheduling, aircraft and crew logbooks, passenger information
need to create a new project via export & import
Initially i created a new application and i export the data and i need to create the same application for my friend using in his creator account when he imported the data , it's not created the fulfilled project? how can we do it ? is there any other way to do except share !
SELECT AND DESELECT
Hi, I used select and deselect script, i want to give two conditions in same script, but this is take only one condition\ So two or more condition possible in this script? if(input.Company_Name=="aaa") &&(input.Occupancy_Type="Single") { fieldname.deselectall(); fieldname.select("3000"); } Please reply me!!! Thank You.
left expression is of type BIGINT and right expression is of type STRING ---------- AGGREGATE RECORDS
i have a error when i specify a criteria in AGGREGATE RECORDS function that is: <%=SaidasRomaneio[Loja_Vendedora = "Uruguai"].sum(Valor)%> I receive this error ---- In Criteria left expression is of type BIGINT and right expression is of type STRING and the operator = is not valid Form: SaidasRomaneio Field: Loja_Vendedora is a Lookup Field Field: Valor is the Sum field
Is it possible to manage webhook reques body in json?
I'm trying to get chargebee's webhook in a zoho creator form, the webhook is received and a new record is correctly created in creator, but i don't know how can i manage the webook's body containing a json object : this is the webhook request sent to zoho creator api: Headers POST HTTP/1.1 Host:creator.zoho.com Content-Type: application/json; charset=utf-8 User-Agent: ChargeBee Body { "id": "ev_KyVpvWOe1m2RF6", "occurred_at": 1341125192, "source": "admin_console", "object": "event",
open URLs when selecting a record in a view/report
I'd like to launch two URLs from other sites in separate windows when selecting a record. Something like this: 1. in view, user clicks a row or a field(column value) in a row 2. the click doesn't change the current view details 3. rather, the on click event opens two URLs from external sites in different windows - http://www.amazon.com/s/ref=nb_sb_noss_1?url=search-alias=aps&field-keywords=TEST where TEST is a field value from the record selected in the view - http://pricegrabber.com/new/TEST
HTML Page Count Month
I'm trying to count all products sent in January Working Code - This just counts products sent on 01-01-2014 jan_prods_sent = Sales[(Prod_Sent_Date = "01-01-2014" && Prod_Status_ == "Product Sent")].count(); However I need a date range or a way to indicate a month to count the number of products sent in January. Any ideas? Thank you
Insert Lookup Field Issues
Hello all: I am using a stateless form to add new contacts. I have a lookup field Company1 in my stateless form that I am trying to insert into my Contacts form. I started by inserting company_list = input.Company1 but when I view the record in the contacts report, it shows the ID field, not the company name. I revised the code to fetch the company name based on the ID and attempted to insert it as company_list = clist.Company. This results in an error when attempting to insert the record. The
Creator Calendar Datefield not working
I have a datefield and it is showing a wrong calendar for this month. The 24/11 is showing as Saturday! This is insane! How come you own calendar script does not work???
Add two Currency values
Hi , I have two field one is currency field(extra charge),other one is lookup field(Rate) , so i want to add these two field, that values stored in revised Rate(formula field).So directly update,when entering a form 'My Result is Rate is n 2000 and Extra Charge is 200 so result is 2200 ' but my result show like this : 2042688000000087568 I dont know how to solve it. Please reply me.
Zoho Form
Hi, My application is Reservation System, I want to auto update a values, when entering a form.Exact my pblm is I have a field company Name, Occupancy Type and Rate.So i entering Companyname,ocuupancy type when automatically enter a Rate Company Name Occupancy_Type Rate aaa Single 3000 I want to edit that field also.Please help me immediately,
Schedule for each record in Form and Subform
Hello! We are developing an app (very similar to the "Order Management 2.0" app in Marketplace). I'm trying to create (using Schedules) a new CRM Invoice for each record (client), but every Invoice must contain all Items added with the subform. I'm using the next code (in Schedules), but the Items are not added correctly: for each record in Order_Form { Grand_Total=0.0; Products=List:Map(); for each Item_Subform in Order_Form { Total= Item_Subform.Price * Item_Subform.Quantity;
Calculating totals across a main form and subforms
Hi, I would like to be able to access items on a Form and its Subforms from within a separate Function before the Form is saved . I cannot work out how to access the current new record Form Fields and Sub From Fields from a separate Function before the Form data is saved. Could you provide me with some sample code which shows how to do this? More detail: I am trying to to access data as it is entered into a Form from within a separate Function to avoid duplicating code across a series 'on user
Calculating sum of numeric values in a subform
Hi, I'm having difficulties calculating the sum and average of numeric values in a subform. I have a subform named Assessment_Scores and want to average all of the scores in the subform to be viewed on the main form. I've tried using a formula field, however, my expression isn't working. I tried using Assessment_Scores.sum(Assessment_Score) and that didn't work. Any suggestions?
How Do I update the data between two form
1. Form 1 = Planning, Field - Job NO I Plan QTY I Actual output 01 I 300000 I * (5000+7500) 2. Form 2 = Daily output performance Field - Job No I Date I Actual QTY 01 I 12/9/2014 I 5000 01 I 13/9/2014 I 7500 How do I update automatically to 'form 1- actual output' , when I key-in
REST API
I wish to use my Zoho Creator database to deliver data for a content management system (CMS) web site. So, I wish to use an API to get data from the database and I'm writing the web side of things using PHP (or similar). Apparently, there were speed issues with the REST API. So: 1) What API should I use for my CMS system? 2) How do I make API calls from PHP scripts (the documented API calls don't work)? 3) Have the speed issues with the REST API been sorted?
IOS Creator Issues
GREAT october 12 update, its fixed lots of issues! I found three issues so far. 1. You cannot disable a lookup field, it still lets me edit the data in it even though its disabled via "On add" or "On Edit" 2. The Users field type shows up as a signature field on IOS. 3. If an app is shared and then unshared and then reshared, the users sees two links to the same app on their iphone
REST API
I have tried and tried to get the REST API to produce something (JSON or XML). For example, what is wrong with the following? https://creator.zoho.com/api/json/BBNI/Products/fields/ This is driving me nuts!
Stateless form infinite loop
I have a stateless form with a lookup field. When I choose an item from the lookup the corresponding record is fetched and some other fields on the form are populated with the fetched data. This works correctly. However if I set a value for the lookup in the On Load section it then goes into an infinite loop. As an experiment I added a radio button that selects a value for the lookup. This also works correctly. It is just when the lookup is selected in the on Load section that causes the infinite
check records on import for duplicates
I want to make sure when I import from an external file or from another form that i do not duplicate records. I do not want it to stop the import, i just want it to skip the ones that are duplicates, does that make sense?
Script for preventing duplicate entries when uploading from spreadsheet
Hi, newbie/free user here -- This seems like a popular question, but I can't find a solution that quite matches what I need. Still confused, hoping for help. I want to use Zoho to manage my contacts, and keep an equivalent/periodically updated .xls on my desktop. This way, I can update contacts even when I'm not online (while on a flight, for example) and load them in as soon as it's convenient. I can't figure out a way to do this without reuploading a lot of duplicates every time. The answer is
Next Page