Umlauts do not work
German Umlauts, e.g. ÄäÜüÖöß do not work in ZoHo Creator. sebastian.schaper
Copy aplication from another environment
Hello, i created a application in a zoho creator instance, but now i want to copy this application to another zoho creator accont. I did and downloaded a backup of my application and tried import the .ds file but the creator returned a lot of errors. Is there another way to copy/import my app?
Developer Needed - Real Estate Matching App
Simple app for internal use to match buyer need to property(s). App will be for one user (me) plus assistant to enter data. Specs: a) Need two main forms, one to enter buyer purchase criteria and one to enter property specifics. Property/buyer data will be pretty simple, 10-20 fields each. (i,e, one picture, name, price, property type, location, numerical fields, text fields, pdf upload, etc) Each buyer and each property to have custom expiration date field. b) Then a daily or real-time search that
Creating a task to assign leads
Is there a way to have all leads go to one user who can then assign them to different members of staff to follow up on? These leads then need to go back to another one user when the first assigned user is finished with them to be reassigned to another staff member. Is this possible?
Calculation based on options selected
Hi there, I have 3 Option Boxes and based on the options selected it needs to give me an amount Ex OPTION BOX 1 : 1. Mamma 2. Pappa 3. Mamma & Pappa OPTION BOX 2 1. Single 2. Family OPTION BOX 3 1. Monthly 2. Yearly Say I choice 1,2.2 It needs to calculate a formula If Mamma and Family and Yearly then R195.00 Hope this can be done Regards
Device Magic for Front-end Offline
Does anyone out there use Device Magic for an offline form solution using creator as the back-end? I am in desperate need of an offline solution for my field evaluators and have found this possible solution. However, I would like to know if it is working for anyone in the creator community before I make the commitment in development time and money. Also, as a paying customer, I would like to know if Zoho has there own solution in the works. I would hate to spend needless time and money on a third
Error Occured while executing on load script.
Multiple records in my application are experiencing an issue when trying to edit the record. Error Details Error Occured while executing on load script. Some (not all) records give this error when editing a record There are no other issues in the logs and the code works for other records. The only way to stop the error is to completely eliminate all code in the on Edit On Load Script. Obviously i cant do this long term. This problem just started out of no where today. Please help!
New to Creator, noodling a raffle generator
Greetings, all. I'm very new to Creator, and have mainly an old-style procedural coding and Access background, so my questions may be a bit...dated! Anyhow, let's say I have a table with Name, Raffle Item, and Entries (for a number of raffle tickets). My old way of generating "tickets" and pulling a random ticket would be to iterate over the number of entries, adding the Name to a new table for each "ticket" and using the autonumber of the table record as the serial number, or perhaps the record
Web page Refresh Causes Fetch values to Change.
I have recorder a video of my problem below: http://screencast.com/t/hJRUOZicfjt Details 1. This is a customer portal page. 2. It is an html page. 3. Has an embedded form with lookup field 4. A for loop running through a series of records. This is what passes the value to the embedded form lookup field. What is happening is the following: On 4th webpage refresh the value passed to an embedded form in the html view changes. If i refresh the page 4 more times the value goes back to the proper value.
bug when print currency EURO
hello, i my form i have a currency field. In, i write 2.50, ok no problem. But when i print in a record summary i have 2,50.00€. With Euro in France, the comma is used to separate number and decimal, we don't separate hundred. Zoho do you fix quickly this bug ? thanks you
Taxes to be added on the zoho website commerce through PayPal
I am using the zoho commerce on my zoho website. When a customer makes a purchase and the PayPal window opens, no taxes are added. Does anyone know how to do this?
How to put data from multiple form in a single html page
Hi, i need to put in a single html page data from specific field of different form. I'm working on a simple EHR, still now no problem. Now i have to put in a single document some data from different users: the doctor1 in formA set the diagnosys, the doctor2 in formB the rehabilitation target, the psycologist in formC evaluate the mental condition of the patient. In other html page i used this: for each r in formA [patientID=input.user] then near Name and Surname i put the deluge references <%=r.Name_and_Surname%>
Dropdowns not listed as User Defined Fields in Lookup
I am a DabbleDB user attempting to rebuild in Zoho. Your Lookup fields are wonderful, and this is a feature that didn't work very well in DabbleDB (which is why I'm rebuilding from scratch rather than importing). But I keep running into the same problem: In Form2, I want to add a Lookup field that refers to a Dropdown field from Form1, but none of the Dropdown fields from Form1 appear in the list of User Defined Fields in the Lookup dialog box. All the other fields from FormA seem to appear just
Importing error
I am trying to import data from a Google Doc. I have 19 records and only 10 are being imported. On the other 9, Zoho is reporting an error like "Row 2 Col 5 - Value '2/27/1964' is not a supported date format". What i cannot figure out is why these particular records are not being imported. The entire column is formatted identically, and yet some records are accepted by Zoho and others are not. If anyone has a solution or explanation, i would be very grateful as I am not stuck! Thanks! David
Password
Hi there, I need to hide certain fields until a password is entered Can this be done Regards
How do I get to the database to create views, stored procedures, etc?
Came across this, which seemed just what we want, but I cannot see how to work directly on the database. Also, I would want picklists to display the description but enter the record id into the table - how do I do that?
Load single record on Zoho Creator Mobile
Hi, Within the Zoho Creator Mobile app, i would like to have a form with a single line field on it, where the user can scan a barcode into this field, and it then loads up the relevant record for view/edit. I suppose i am looking for the equivalent function to "openurl", that will work within the mobile app. openurl("http://creator.zoho.com/" + zoho.adminuser + "/" + zoho.appname + "/Asset/record-edit/Asset_Report/"+rec.ID,"same window"); Thanks Best
Search multi select fields
Is there a way to use the built-in column search (Is, Is Not, Is Empty...Contains, etc.) to return records that contain multiple values? For example, the multi select has options for dog, cat, horse. I want to see all records where the user has selected only dog and cat, but not horse.
New action based on Radio Button Selection
Hi there I have Option Box with Three options 1. Accept 2. Decline 3. Follow up Based on the the option another action should be preformed Option 2 If option 2 is selected then a pre-populated mail should be send to the Broker that is linked to the client (The Broker is also on the form) Also it should select the correct language per-pouplated mail There should also be option to add additional info to the mail Option 3 If option 3 Again pre-populated mail based on language of Broker Set a reminder
Zero disappears in Number Field
Hi there I have a number field where I enter a mobile number which always starts with a zero. But it is dropping the Zero in the report Any suggestions on how to fix this Regards
User interface header glitch
We have had a strange glitch in the User Interface of zoho for quite some time. I will explain it in words then i have provided a video as well. Any one else had this problem is there a fix? Basically if we execute a function that opens a record list in a zoho overlay popup then delete a record we are left with the header of the record view being covered by the one from the popup. The page needs to be refreshed to get the interface back to normal. http://screencast.com/t/2RkzK3YQ5 I have included
Public access to Zoho files in public view - users cant access
Since this morning, my users cannot access public files like this https://creatorexport.zoho.com/DownloadFile.do?filepath=/1435255116505_1_-_Contesta%C3%A7%C3%A3o.pdf&sharedBy=raffbr2&appLinkName=cjuridico&viewLinkName=Arquivos_View_com_parent_ID Now zoho is asking for a password!!! WHY??????????????????????????
Relationships
Hi there I am struggling to create a relationship between two forms 1. My first form has the client details on with a sub form for dependents (which is form 2) 2. On form 1. I have Client ID (AutoNumber) and add it through Lookup on Form 2 3. When I try to link it with Bi-directional relationship on form 2 it does not give me any of the tables in Form 1. Only Tables in Form 2 What am I doing incorrect
Combine to fields to give one name
Hi there I have in Single Line for NAME and Single Line For SURNAME How can I create a output on my form from these that would automatically combine names SURNAME, NAME Hope it makes sense. Regards
Bug with Subform and loading
hello, i have a Form1 with a subform wich is a lookup to Form2. I add many rows in my subform with script deluge, no problem. but i want add a check on the Edit on my Form1. by example i write for each line in subform { alert "in the list"; } even if i have 50 rows in my subform the script don't enter in the for each ? Why ? thanks you
Use Lookup Field in Report - Text Only?
I have a Form A with a decimal field that I am using to create a dropdown list as a lookup in another Form B. Using form B the user can select from a list of available numbers from records in Form A. I need to generate a report that shows the sum of the numbers for each record in form B. When I go to create the report, the lookup field in Form B shows up as text, not the looked up decimal field. I am unable to sum the lookup field even though the field is linked to a decimal. Is this a limitation
Using information captured on another form for dropdown box
HI there, I have two forms, one with referral data and one with broker data On the referral form I have a dropdown box which need to create a list of brokers which I create through the broker form The referral list includes the following fields Broker: (Dropdown) First Name: (Single) Last Name (Sinlge) The broker list includes the following First Name (Single) Last Name (Single) Thus I need the Broker dropdown in form(Referral) to have List of brokers that was created by through the form(broker)
Create log with date and user details for customers
Hi there, I need to add a field (not sure which one) on my form. Every time that I communicate with the client I need to log it. It also need to capture the date and the user that communicated with the client. Hope someone will be able to assist Regards
Zoho Creator backup doesn't backup custom deluge script logic from pages, validations, etc?
I backed up and downloaded my application and looked through the files. It looks like pages and validations, etc (deluge scripts) are not backed up? I am shocked to see this as I invest countless hours into developing these scripts, why are they not backed up as part of the regular backup process? Is there any way to back these up all at once or do I have to manually back up each of these on my own?
how to enable auto complete function in script editor
i found this function in an second account that is in free trial period. but how to enable this in my paid account?
Exclude record from look up if exists in current form
I am having hard time finding anything to do with this topic, so I decided to start one. Here is my criteria Form "construction_budget" has a field that looks up from form "plans" this field is a formula field that concatenates the plans square feet and name. On the construction_budget form, this lookup field is named "plan_name" I need field plan_name to exclude records from this field lookup if that record exists in the current forms records. That way only items that need a construction budget
Optional Field Lead To Other Forms
I Create 2 forms: Customer_Form and Region_Form I want my customer when choose Region A, will lead to other form (region_form) like this, then finishing the form when he hit submit. But when my customer choose Region B, the form will finished without lead to other form. My Question, how i do that?
How to open another form with initial value
Hello I'm making a session application form. We have 2 sessions before we start our service 1. public session (about 10 partipants) 2. private session (1 participants) => start our service After public session, we arrange participants'/our schedule and decide the day of private session. Now I've finished creating public session application form and its report. and I added custom action 'apply for private session' to the report. When I click 'apply private session' button, I want to move to private
Something is wrong with ID's on a Form that I have
Something very weird is going on with Form records that I have. I am seeing bizarre behavior of not finding records when I try a fetch also in my page code. I have two records in the Form and am viewing a report, I have attached a screenshot of the report. It shows both records as having the same ID field. When I click on an ID field and copy it, the value that I paste is: 2940790000000069000 This is different than what shows in the report for this field. This is really pretty crazy and very concerning.
Domain keys or DKIM
Hi, Does zoho creator provide domain keys or DKIM? Regards Umar
What is the correct way to resell Zoho creator apps?
Hi guys, I am planning to create and deploy an application using Zoho - its not going in to the marketplace but rather is just for a client of mine. I am just wondering what the correct way would be for me to do this - should I create the client their own Zoho creator account or should I create an app in my account and then add their users to my account giving them access only to their app? Thanks in advance Dave
Question about unique workflow/assignment problem
Hello, I would like assistance in trying to figure out how to set up a somewhat unique set of workflows. For example, say I have several accounts, each assigned to the respective Stage 1 account representative. Each account should then be able to be submitted/assigned to the next stage, e.g. Stage 2 account representative, Stage 3 account representative. Each representative should also be able to send the account back down. So, something like this: Jones Account: Stage 1 Jones Account Representative
Fetching records from Zoho CRM through a sub-form
Hi, I have some issue with my app. I added a sub-form “Operation Subform” in the “New Purchase” form. The Operation Subform fetches records from SalesOrders and CustomerModule1 modules of Zoho CRM, based on the lookup field Order Number. When I try to run the subform in the New Purchase form it gives an error (something with the zoho.crm.getRecord). The script is the following: //Auto populate from Zoho CRM. Order_Number_ID = 0; for each operation in Add_Operations { crmOrders = zoho.crm.getRecordById("SalesOrders",
Limiting for loop
Hi, I have below script with JSON functions what I am facing the problem is exceeding maximum number of deluge statements. So to avoid the situation I would like to limit the for loop to a specific number like: range from 1 to 200 etc. But Here How do I do that since it is a JSON list, please help me url = ("http://api.tvmedia.ca/tv/v4/lineups?api_key=123" + input.Zip_Code + "&lineupType=" + input.lineupType + "&detail=full").toString(); response = getUrl(url); lines = response.toJSONList(); for
Fetching records From Zoho CRM
Hi, I try to fetch records from Zoho CRM's two modules to a form in Zoho Creator. The following script is written that is saved and runs without problems: crmOrders = zoho.crm.getRecordById("SalesOrders", input.Order_Number_ID); input.Contact_Name = crmOrders.get("Contact Name"); input.Billing_Country = crmOrders.get("Billing Country"); input.Order_Date = (crmOrders.get("Created Time")).toDate(); operationsList = zoho.crm.getRecords("CustomModule1"); for each operationDet in operationsList { operationNumber
Next Page