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?
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
Next Page