Is it possible to create this?
Is it possible to make a calculator like this? To help determine the freight class of your LTL shipment, enter your pallet dimensions and weight below for an accurate density calculation. Length (in) Width (in) Height (in) Cubic Feet Weight (lbs) Pallet #1 Pallet #2 Pallet #3 Pallet #4 Pallet #5 Pallet #6 Pallet #7 Pallet #8 Totals TOTAL DENSITY 0 lbs/cu ft FREIGHT CLASS N/A
Change date field to date-time
I would like to change the data type of a field from a date to a date-time data type. When I look at "field type" (located in appearance section), that option is greyed out. I have several hundred records saved so don't want to delete the field altogether. How can I go about making this change without wiping out the field?
marie.ange.occelas@gmail.com
Hello, I am a new user of zoho creator and I have basic knowledge of the app. I have a question regarding the reports. I just created a form from an admin account but I want to make it visible for all users of the database. I tried but failed every time I tried. I can only see the report on the admin account. What should I do now (step by step process) to make my form accessible for all the users?
Way to format currency in reports?
Currency in reports in creator defaults to USD even though in the form it is set to another currency
Problem in inserting Records
Hi, Please see the screen shot attached. Here R is a set of records, which I am iterating thru using "rec" as collection variable and inserting into another table (form Depreciation Details). Even though there is no apparent syntax error, please see the error thrown up. Please help if you can spot the mistake. Thanks, Milind Manohar
External customers
Hi, Is it possible that with Creator create an application that people can use by creating their own identities by using for example Hotmail, Gmail accounts and so on?
Loading a form with fields populated with report values
Hi all, My application has a report in which I created a custom action (for each record) to open a form called "Add_Job". This form has, among others, a field called "Project_Number" which needs to be loaded with a value coming from the report. The custom action in the report is something like this: void project.add_new_job(int project_number) { openUrl("#Form:Add_Job?Project_Number=" + input.project_number + "", "same window"); } When the field "Project_Number" is of type single line, it works
Http request from an external site to Zoho Creator
Hello Experts! I'm trying to make a http request from an external site to Zoho Creator. I can only write on Javascript. Please, what is the most direct way to make this request? I was trying to use the XMLHttpRequest with a getURL (), but it returns "No 'Access-Control-Allow-Origin' header is present on the requested resource." I think CORS is not supported on Creator. A lot of thanks in advance. Best regards. José.
Creating a Pivot Chart just defaults to a Pivot Table
Whenever I create a new report and select Pivot Chart, I just get the screen for pivot tables. I have tried on two different browsers, with no change. I can no longer create a pivot chart unless I duplicate a report that is already a pivot chart, but then I cannot change the form that it is referencing. I can only make pivot tables.
How to convert string to number
Hi, How do I convert String to Number. Which function should I use ? Pls. help Thanks, Milind
Get Invoices From Zoho Books To Zoho Creator
I need create a lookup field in Zoho Creator to locate all invoces with a balance due in Zoho Books. I currently have: invoiceslist = zoho.books.getRecords("invoices", "936496201", "invoice_number"); Invoice:ui.add(invoiceslist.get("invoices")); under the 'on add' 'on load' and I'm getting a drop down that includes all invoice details in the lookup field ({"date":"2016-12-4","Zcrm_potential..... etc, etc.). I just want INV-XXXX to show up in the field then populate "Client Name" and "Amount Due"
Reports generate 1 row and 1 column title "-No Value-"
Hello Zoho Creator forum..... I have created a report based upon data from a Form. The report should have 3 columns (one for each business-unit) and rows based upon months of the year. Under each of the 3 business-unit columns there are 2 sub-columns showing 2 types of sales data. The report works properly except for the following problem...... PROBLEM: The report generates an additional row and column titled "-No Value-'". So instead of having 3 columns (one for each business-unit) there are 4.
zoho creator string field - search for multiple criteria
I saw this a a limitation in the api, but can I do it within a report? For example if I have a form that asks for the first name and I have multiple submissions, can I then run a search on first name for more than one name? Like to show me all records that have he first name "John" and/or "Bob"? If so, how do I do that?
Apps getting added as "Shared"
When I press New Application and add the Support Desk app it is not showing up in the "Owned by Me" section... it is showing up in the "Shared with me" section. I want to remove the apps but i don't have access.
Trial User
I'm new to Zoho Creator, and before I dive in and start learning how it all works, can anyone fill me in on whether Zoho Creator is capable of doing the following: My app is accessed by my users who create new records. Online customers search those records via our website, and are able to submit a payment to that record. Do customers need to be "users" for this purpose? As I was hoping anyone can view and make payments on the records without being a "user".
I need a dialogue box with Yes No response
Hi, How do I prompt a user with a Dialogue Box with Yes/ No response. If answer is Yes do something if No then do something else. Thanks for your help in advance. Milind Manohar
AddedTime not available in Pivot Chart?
I noticed none of the system fields are available in the Pivot Chart. Why is that? I just want the AddedTime to go on my x-axis of my chart. See screenshot: http://screencast.com/t/OM6irV9A
zoho creator calendar showing date ranges not discrete dates?
I created a form that allows a user to enter a date and then also shows additional dates some # of days after that. So the form may have multiple dates in that record. That all works fine. However when I view the Calendar report the entry shows up as a range across those dates. Is there any way to have them just show as discrete entries on each date in the form and not including all the dates in between?
Creator embed report size
Hi There, I have been searching hi and low and need the best way to do this. i have a report that i want to embed into a page in creator. when i Embed the report. It doesn't take the formatting that the report has. and only shows it in a half page window. Can someone help me get around this Cheers
cant edit load function
Hi, I am new in zoho creator. I am not able to edit onAdd -> onLoad. I have written some record fetches on onload.When I open this, the entire page got stuck. While I can open other sections after reloading. Problem is with onLoad. How can i get back old codes from onLoad. Any idea as to why this happens? How do I fix it?
why changes are permanent when grouping a column of emended report?
hi, i have created a embed report to a html view page . i am not writing any code for grouping and not done any settings at report group & sort section of the report . now the problem is: i group a column as "Group by Asc" and this changes permanently .it's not changing to it's normal page view when refresh the page .? why it is happened ? waiting for reply ... Thanks, Suresh Kareti
Problem fetching record when using lookup fields as criteria.
I will appreciate your help in directing me to a solution. I have spent hours with no success. I have four forms: frmClients - stores the ClientName and SocialSecurity of clients. frmProperty - stores the PropertyName, address, phone, etc. of properties. frmContract - consists of a Lookup field TenantName based on the frmClients, a Lookup field PropertyName based on the frmProperties, and other fields like amount, initialdate, taxrate, deposit, etc. frmInvoices - consist of a Lookup field UnitName
Get Record by ID: Variable 'Product_ID' is not defined
I am making an app that uses the following code to record products from the Products module in CRM But I get this error: Error at line number : 1 Variable 'Product_ID' is not defined crmResp = zoho.crm.getRecordById("Products", input.Product_ID); input.Unit_Price = (crmResp.get("Unit Price")).toDecimal(); input.Quantity_Available = (crmResp.get("Qty in Stock")).toLong();
Pivot chart based on views?
With the new form builder, I'm only able to make pivot charts from forms. In the old version I was able to make charts from Views. I want to make charts that include data on added time which I have in Views, but not in forms. Have I missed something? G
Pivot chart based on views
Hi. Can a pivot chart be based on view or multiple forms, rather than a single form. I am sure it was previously available. Thanks.
Auto Fill URL with Field
Hello, I am developing an order management system that requires each individidual record to have a barcode/QR code so that they can be scanned to bring up information at certain points along our manufacturing cycle. I have created a 13 digit autofill number for each record, and I would like to retrieve a QR code using that autofill number from an external website, however I don't know how to input the field name into the URL so that it automatically fills this part of the URL with the records Autonumber?
Report hang when scrolling
Hi, I noticed the new enhanced feature on reports, there is no paging any more, but when user's scrolling down to the end of the screen, the report fetches more records. However, this ALWAYS causes screen hang. I have a report with around 40 columns and less than 3000 records, every time when users scrolling fast, the screen will be frozen, and IE will prompt that "the scripts takes long time, stop it?". Moving back to the paging style shall be helpful. Or, please help to fix this defective. Thank
Creating relationship between form and subform
Hi all, Please excuse my ignorance as I am very new to Zoho and while for the most part the user interface is very intuitive, the deeper possibilities with coding remain a bit obscure to me as my knowledge in that field is quite limited. Essentially what I am trying to do is create a database for storing information about lectures. This database is very simple and I have designed it using only two forms: talk and excerpt. Whereas a talk can exist without any excerpts, every excerpt is part of a talk
Zoho Creator EU edition
I started using Zoho Creator in zoho.com domain, but due to regulatory reasons opted to move to zoho.eu domain. A lot of functions we see in zoho.com are not yet available in .eu account, almost a beta version of .com. Is there a time line when the full functionalities of .com will be available in .eu domian? Thomas
Many to many relationship with note field for each relation
I'm trying to create a many to many relationship while storing some information about that particular relation. For example: A SurveyQuestion has many AuthoritativeSources. When an authoritative source is chosen for a question, the rationale (or justification) for the selection should be documented in a note. An AuthoritativeSource can be used in many SurveyQuestions. In a database this would be represented as: SurveyQuestion >-< AuthoritativeSource SurveyQuestion - ID - QuestionText AuthoritativeSource
view-perma view conditioning Add button
Im loading a view via view-perma link w/ url parameters. I also need to limit the Add button to only add records which are preloaded with the url parameters so like records can be created. I tried to interrogate the url parameter via the onAdd/onLoad event but I could not access the views params. How do I modifiy the view's Add button on a view-perma screen? Thanks :)
Creating a page to display record counts by field criteria
Greetings all, I did my best to find the answer on my own.. here's what I've got: I have a Creator application with a bunch of records with different "Statuses" by field. I want to create a simple page in the application for my users which would provide a summary of record counts by "Status" Example: Status field values: Pending, Paid, Cancelled Page/Report desired: Pending: 37 (records) Paid: 31 (records) Cancelled: 12 (records) From what I'm gathering, this can be done
Can table names be programmatically referred to?
Hi, I would like to store zoho creator table names in another table and then uses those field entries to access specific tables. Is this possible? Thank you.
Zoho Creator iOS app Offline access of forms
I am trying to access an app through iOS Zoho Creator and work in offline mode. No matter what I try, I am only able to get 1 or two forms in offline mode, rest won't appear. Following the instruction, I opened each data entry form and submitted a record each from the mobile device in wifi or 3G but when I tuen off the wifi or 3G not all these forms are visible. Is there anything / any steps I missed? Is there a form which addresses these issues in Zoho Creator mobile app? Is the App fully functional
For Each Record - need help with criteria
Hi guys, Could you please help with this? BACKGROUND ---------------------------------- We have a form called "New Claim". The form has a field called "Today_Field". It also has a field called "Status". SCHEDULE ---------------------------------- We have a daily schedule set up which updates "Today_Filed" with current date. The code is below: for each r in New_Claims { r.Today_Field=zoho.currentdate; } THE PROBLEM ---------------------------------- Right now, the schedule iterates for all records
Access desktop ip cam or webcam
Does anyone know how can I access the desktop IP cam or web cam with Zoho? Thanks in advance, Mauro.
How to display auto number field?
How do I display an "Auto Number" field I created in a form? Can I generate this auto number at time the form is loading instead of on Success of completing the form? Is this why the Auto Number field can not be displayed to the user? Sorry I am new to this, any help greatly appreciated.
Error at line number : 1 Mismatch data type for function zoho.crm.updateRecord at argument index 2 expected data type STRING found dataType BIGINT
I'm trying to make my inventory update able and editable through an app. What I've written: resp = zoho.crm.updateRecord("Products" , input.Products_ID , {"Product Owner":input.First_Name,"Unit Price":input.Unit_Price,"Usage Unit" : input.Lead_Email}); Error Message: Error at line number : 1 Mismatch data type for function zoho.crm.updateRecord at argument index 2 expected data type STRING found dataType BIGINT I don't understand what I've done wrong. I've matched all the field types and I've
Auto Update of Form
I have a form in a Zoho application that is only used for information i.e. no updates are done in Zoho. The data is kept in another application. I have had the application export a .tsv file of the data needed in Zoho, and when I delete all records and import the .tsv file, it works perfectly. The client wants to automate this. Is there any way to have a Deluge script that runs say at midnight to delete data in the form, then import from a file? Maany thanks
CRM custom functions: Update fields cross module based on look-up field type
Hi there, We are linking our products records with our contacts records using a look-up field between products and contacts module. Is it possible to (via a custom function and workflow automation) update a field in the product record based on a value from the contact record associated to the product record via the lookup field? Kind regards, Bo Thygesen
Next Page