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 !
Multiple Conditional If Statements
I am having trouble writing a script for "On User Input" for field_2. Here is what I am trying to do. IF field_1 IS NOT = null or 0 AND IF field_2 IS NOT = null or 0 Then set the value for field_3 = ((field_1 * field_2) / 12)) All of these field are in the same form.
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.
How can I delete customers?
Hello, I've been building a web app for my company and while testing it I sent out some test invitations to users This can been seen in my App here However these customers are nowhere to be seen in the list of users in the admin site How can I delete this fake user/customer accounts? Thanks
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
Error: You are not allowed to access this application
Shared users with Zoho accounts cannot access my application (forms/views). Only the admin account can access applications. Users show up under Account Settings - Manage Users. Accounts are active, and set as users. (Setting to Developer had no affect) Under Edit This Application - Share Tab - Users have All Forms and Views. Green checks on all forms/views when clicked. Under Edit This Application - Views Tab - xxxxx View - Actions/Set Permissions - users have Add/Edit rights. Applications and Forms/Views
New calendar view options
I have a couple of questions about the new look of the calendar view: Is it possible to change the label color of the events on the calendar? Right now they are all blue. Can the text being shown on the calendar events word wrap so that I can see the entire text of a longer entry?
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
export data from Contact Manager?
It appears that Zoho CRM is better supported. I'd like to export data from Contact Manager to Zoho CRM. Any suggestions about how to do this? Thank you in advance for your consideration.
Where is the filter list-box?
The help feature says "When you access the report, the filters will be displayed in the Filter list-box as shown below." The box is shown in the example, but I don't see on my screen where that shows up. I have created a custom filter but don't know how to display it. Thanks. William D. Chapman
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.
Dynamic Picklist Based on multi-select lookup
I am trying to use a multi-select lookup field as a filter criteria to create a dynamic look-up in another field. Is this possible? It does not seem to be working correctly. Thank you, and please let me know if I need to clarify anything. Jonah
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
Formula Field
I created a Reservation Database. I have Rate Column . So i want to auto update like this Company_Name=="aaa" Rate is 2500 Company_Name=="bbb" Rate is 1500 Company_Name=="ccc" Rate is 2000, so my report like this Company Name Guest Name Check in Check out Amount aaa xxx 12-Jan-2014 14-Jan-2014 2500 Please help me. Thank You.
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?
Pivot Table column with
Hi, I started to use the Pivot Table and I have some problems in the column size, I used the pdf export with automatic size and with A4 and this below the result. The first problem I saw is the column size that seems to e random "carico" is two time "scarico" The alignment is sometime to left and sometime to right Is it possible to adapt it in some way? Thank you Giovanni
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
Bundled product module
Hi, I'm trying to adapt Zoho CRM as my Delivery Pizza manager. I do not have available a module for a products combo or bundled products. Have you ever heard about a solution regarding this issue? Maybe an app has been already developped in Zoho creator Thanks Edu Pawliska
Permission error in iOS app
I have a creator app that I can access find on the desktop and mobile web but when I try to access using the iOS Creator app, I get a permission error. I am running iOS 7.0.2 Anyone have similar problem?
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?
Problem with errorMsg : Sharing failed for michael@braunstein.dk
Why can't I share apps
ZC embedded forms do not display in FireFox 11
All of our embedded forms have this problem: In Firefox 11, the page with the embedded form loads, and the title of the form is displayed in blue, with nothing beneath it - just white space. No data can be entered, and no part of the form other than the title can be viewed. This is causing significant errors for us. I have checked to see if the embed code has been updated in some way, but the current embed code is what I am using for our embedded forms. All display without a problem in Chrome and
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
Email addresses listed
I need to have email addresses listed on a page, but to protect these email address I scramble them. However, I do not know how to use that code within Zoho creator. Basically I want the display to look like: Email so and so: Click Here How do I do that? I the URL field but of course it did not work because that is not its purpose. Any ideas?
Printing Creator forms
I love the Creator program, I put together a quick little program to create purchase order requests. The only problem I'm having is in being able to print the form correctly. The only way to print is to go into edit mode. As I add more records, the printed output becomes less usable, as other records appear above the record I want to print. Could you create a "print this record" function? kiefabeb
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?
Inventory Turnover Calculation
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.
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
HTML view to PDF conversion slowdown
Hi! We are using Zoho Creator's HTML view to PDF conversion functionality in a daily basis, but in the last week or so we have noticed, that it slowed down a lot. For debugging reasons I created a simple TestPage, that contains only 10 character and it took 70 seconds (!!!) to download it through direct URL. We desperately need it to be fast as it was before (2-3 seconds). Please, let us know, what is the reason behind the slowdown! Thanks in advance!
Formula field showing up as text field in pivot table report
Hi, I created a form that has formula fields in a previous application and generated a pivot table report which displayed those fields as sum fields. When I copied the application and added another formula field, it shows up as a text field instead of a number field as the other formula fields do. How can I correct this?
Next Page