Plan for CSV Feed
Hi, We are planing to upgrade Zoho Creator to have the feature of linking the database from Zoho Creator to Zoho Reports via CSV Feed. What plan are we going to take? Is it available in Standard? Thank you. Kiel
Is Zoho Creator Report Shows Real Time Data?
Hi, I'm created a simple report and placed it into my dashboard using iframe. But then I noticed that it's not taking the real-time data. (I've added an record but it's shown in the reports only after like 5 mins?) May I know what is the refresh frequency?
arithmetic operators of properties in a form
Hi, I create a form and want to do some simple arithmetic operations of column properties like "column C" is equal to the product of "column A" and "column B". So how can I do that in the script? Thanks
Stuck on "Loading Form... Loading View..."
Any idea why it just says "Loading Form..." and "Loading View..." when I open the program? Nothing else happens except for displaying those two messages. Thank you.
Problem with compare date
I'm trying a few weeks ago to do the following without success, if anyone can help me i will appreciate your help. I have 3 forms one is for the employees, second are a list of projects and the third is where I assign an employee to a project. My problems is that when the user try to assign an Employee two time in same dates i need to send an informative messages to the user, without use cancel submit (if i use this line i can see the message but can't save the record) In this form (Assign Employee)
Uploaded resume from Creator form to Recruit
Hi, I'm running into an issue where when a candidate submits a form made in Creator, with their resume attached, the data does not get added to our candidates database in Recruit. But when the same form is submitted without the resume, the deluge task we're using works fine and the record is added. What can I do about this?
Back up frequency and limitations
Hi, I have questions regarding zoho creator back ups. Are they automatic or do they have to be done manually? If they are automatic, how often are they performed? What are the size limitations for backups? In the event that I want to restore a back up, what is the process for getting it restored?
Stuck on problem - Adjusting count when record is edited
Hello, I'm a newbie at scripting and am working on a database to accept registrations for classes. The database allows the students to sign up for a number of classes. Each class has multiple sessions and the students choose one session. The seats are limited for each session. When no seats are available the students will be prevented from registering for that session. I have successfully written code with help of examples in the marketplace and forums to track the number of seats available for a
Load form in edit mode
Hi , How to reload the form in edit mode.At the time of accessing the application ,i need to load the form in edit mode.(not in on add--on load )
Search form for stage
Good morning, I need to make a loockup in Zoho CRM Zoho Creator to seek a potential with a certain stage. Is it possible?
Create a List from a String
I am building a search form to search CRM and manipulate the returned rows. I want to be able to search the CRM on one or more Account Names. I am working on the basis the user will enter a string such as "account1, account2, account3" into a field on a form and the system will return the Account Rows where the name Contains account1, account2 or account3. My plan was to use the searchrecords function but as this only allows one search criteria I have to run round it several times to cover all the
Removing an element from a Lookup List
I have created a Sales form for a sculpture exhibition we are organizing so each item for sale has a unique identifier. Once an item has been sold I would like that item to no longer appear on the lookup list, can anyone help me out with this?
Script not adding fields, will not hold () in script.
Below is a script I am trying to use. The purpose of this script is to update an "Inventory" form's "Quantity" field. It will not give me the total of the two stated fields "currentinventory + Inventory_to_Add". When I enter the script via the GUI or free scripting method, Zoho always removes the () from the script. I am no scriptwriter by far, but isn't it supposed to keep the ()? So when i use my "Re-Stock" form, the script adds what I enter to the "Inventory" report but does not ADD them, it
SubDay Question
Greetings all... I am using the following to determine a date in a script: input.email_reminder_date = rec.weeklyworship_worshipdate.subDay(churchinfo.reminder_email_days); Where churchinfo.reminder_email_days is a collection pulled from a table where reminder_email_days is of field type numeric. When I put in specific number: input.email_reminder_date = rec.weeklyworship_worshipdate.subDay(4); It works fine, but when I use the code referencing the variable for the subDay it throws an error message.
'ADDTOPICKLIST' can be used only in on load actions - error message
Would like to be able to populate a drop down list based on value of another field. Works fine on load action, but on update get error above. if (input.Title == "Mr") { Singing_Voice:ui.add("Tenor"); Singing_Voice:ui.add("Base"); } else { Singing_Voice:ui.add("Soprano"); Singing_Voice:ui.add("Mezo-Soprano"); Singing_Voice:ui.add("Alto"); } Thanks Tim
Please take pity on me...
I have no idea what I'm doing, and I'm hoping someone will come to my rescue: I am trying to organize this data regarding participants in a program we're doing for children living in poverty. I need to collect this information grouped by "family" Participant Name Participant Age Participant Gender Participant Ethnicity There are 19 program sessions. I need to track who attended each session and then be able to pull out demographic data by session as well as by all the sessions combined so I can
report filter criteria based on secondary related view
Hi, I have created 2 forms , which are linked via a lookup. Is it possible to create a view/report that will just show records that are in the first form, that have no link in the second form ie in database terms Select d.* from details d left outer join subscriptions s on d.id=s.membership_id where s.membership_id is null Thanks
Automatic Update of Variable Names in openUrl Calls
If Deluge enables the name of a variable to be read then the openUrl Deluge statements could automatically update if Form and/or Field names changed. e.g. where DelugeName() is this mythical function openUrl("#View:" + Form_Report.DelugeName() + "?" + Field_1.DelugeName() + "=" + input.Pass_Variable1 + "&" + Field_2.DelugeName() + "=" + input.Pass_Variable2, "Same window"); Is this possible? If not could it be done? Does it make any sense or is it a daft idea?
Need same functionality as the Zoho CRM field (relationship to CRM data)
I want to duplicate the logic and functionality of a look up like the CRM look up field uses. The related Look Up field has drop down but when there are lots of records, that does not work. Have table of records that need to be related from the parent form. Only one record needs to be selected and shown on the parent form. I've tried subforms but can't get it right since the subform is only for the selection not the display in the way it is used for the CRM data relationships Can anyone point
Remove duplicates from a list?
I have a list variable with hundreds of phone numbers. There are duplicate numbers in that list though. How do I remove the duplicates from the list? Thanks.
Formula based on a join
Two tables: Tutor - holds records of tutors Associate - holds records of associates (students) One tutor to many associates. I have a form on each one. I have a report on associates which is grouped on tutor so shows each tutor with their associates. I have a report on tutors. I'd like it to include the count of associates against the tutor. The Associate form has a field which is a lookup to the Tutor "name" field. I've tried adding a formula field to the tutor form, with an expression based on
Custom user roles
Hi, Is there a way to provide more customization for user roles? I believe I need something beyond page level permissions and user/designer roles. For example, I have a group of 6 people: -I want NONE of them to have designer capabilities. So, 6 "users". -I want ALL of them to be able to see all the same forms/tables. -However, I only want TWO of them to be able to edit records in the table. (to update information as we receive it) Any help?
iPhone skips over non-text form fields
URGENT: 5 days since I posted. I am a paid subscriber. When using an iPhone to fill out a form, I hit the Next button on top of the keyboard to navigate from one field to the next. Non-text fields such as lookup and radio are skipped right over to the next text field. A dropdown field however, can be accessed with Next/Previous. How to prevent this from happening? Form access: http://amis-inc.org/students "Sign up" Thanks, Nelson
Refresh CRM lookup fields?
I have a form that has multiple CRM Product lookup fields, below those fields are Quantity fields. Anyway I got it to work that when you choose multiple products and quantities it auto calculates the total in real time. So that works, it is great. (All 10 CRM Product lookup fields on the form have this script on user input. It works fine.) crmResp = zoho.crm.getRecordById("Products", input.Sample1_ID); input.Sample1Cost = ((crmResp.get("Cost (L)")).toDecimal() * input.Qty1); input.CostTotal = (input.Shipping_Cost
Federated Login with more services
Hello. I am working on connecting WordPress and Zoho Creator. One of my headaches was how to sync users' data between them. Fundamentally, if Zoho Creator accepts more services for Federated Login, that would open a gate wider to accept more users. Is there any plan to add more, such as AOL, Windows Live, etc? It seems to be getting popular to user FID. Even WordPress has a couple of plugins to accept 20+ services. http://wordpress.org/plugins/oa-social-login/ http://wordpress.org/plugins/loginradius-for-wordpress/
Reports disappearing
I can't seem to find reports that I created earlier. Can you please investigate what has happened to the following reports? https://creator.zoho.com/essistmgmt/assets/report-embed/TELCO_SERVICE_ORDERS_BY_STATUS/ https://creator.zoho.com/essistmgmt/assets/report-embed/TELCO_SERVICE_ORDERS_BY_USER/ https://creator.zoho.com/essistmgmt/assets/report-embed/MONTHLY_TELCO_SERVICE_ORDERS_BY_SERVICE_TYPE/ When I try to view the links, I get the following error message There is no such view in Zoho Creator
XML Documentation has missing information - 'Page not Found'
Whilst the discussion forums are a great source of knowledge, many of us rely on the on-line documentation. The documentation I require is relating to XPATH and loading XML into ZOHO, but vital images are missing. The page in question is : https://www.zoho.com/creator/help/script/execute-xml.html I count 6 images 'not available' which is like trying to follow a recipe with pages missing from the book....! An example of one missing image : https://www.zoho.com/creator/help/images/xml-execute-ui.JPG
Using lookup fields in "Display as" for lookups
Hello, Do you plan to make availiable to use lookup fields in Display as for lookups fields?
Issues in using multiselect Field ?
Hi, I'm currently evaluating Zoho Creator. I have an access app that I am are trying to replicate on Zoho. So far I have done with replicating one of our access form. I have a MultiSelect text field in that form and I'm populating options in this field from 2 zoho database views/tables using deluge fetch function. Problem here is, I want to show data from 3 different columns in single option. So I done that by appending data from columns into a single string. Check below, for each moveReq in move_quotes
Subform code disappearing
Over the last few weeks, I've noticed that Field Action code has been disappearing for subform. The latest example is Application: https://creator.zoho.com/essistmgmt/form/1713/scriptbuilder/ Subform: INITIAL_SERVICE_AGREEMENT Field: SITE_ID Note, the application is shared for support editing I've previously added code but it has disappeared. Not only has the subform field actions disappeared but the version history disappeared too. Can you please investigate? I keep having to put the code back in.
Subform code not generating properly
Subform code does not appear to be generating properly when I try and edit the code. Form https://creator.zoho.com/essistmgmt/form/1713/scriptbuilder/# Subform: INITIAL_SERVICES_AGREEMENT Note, the green circle is active for PRODUCT_SERVICE_ID field but when I try and view the code, the code editor is blank. The behaviour is inconsistent since some fields show code and others don't. Other fields that show a green circle but display empty code are MANUFACTURER_ID, SUB_SELL_MRC, SUB_SELL_NRC, etc Although
View code not generating properly
I have noticed that for a number of views, the fields listed in the display columns are not being displayed in the view. View: https://creator.zoho.com/essistmgmt/assets/#View:PROJECT_View1 Note, the application is shared for support editing With the current example, I have selected the following fields to be displayed Fields selected Fields displayed PROJECT ID PROJECT NAME PROJECT DESCRIPTION CUSTOMER AGREEMENT PROJECT STATUS PROJECT MANAGER PROJECT ESCALATION FINISH DATE START DATE PROJECT BUDGET
Error while trying to edit a View
Hi team ZOHO I have just started to recieve the following error when I try to edit one specific View in my application. [ServletException in:/jsp/edit/view/viewedit.jsp] null' I can still edit other Views without any problems and users can still access the view in question, I just cant edit it. Any help greatly appreciated. Regards Simon
Why Not Data that had been entered and stored has been disappeared
Hi Please help me that subject on this mail. The detail is quite simple, all product data that I had entered has been gone!!! It had been stored correctly but, just a few minutes ago, all data had begun not to show up. WHy??? What the hell happened?? Please Help me.
Right Click Menu of the new UI hidden by Chrome Browser Right Click Menu
Not sure if this is already on the bug radar - See the browser right click menu appearing on top of the new right click menu introduced in the new UI. Regards Moiz Tankiwala Smart Training & IT Solutions
Really Need Help with Stateless Forms/Search Interface
I am having incredible difficulty trying to use a stateless form to create a search interface for going on a week now and I'm hoping might know what to do. I would just like to be able to search the data that people have submitted to my other forms by the email field. All my forms have an email field, and being able to search the stored data (from all of my forms) by email, will allow me to find the information that I need. I've been in contact with Zoho support and they've linked me to guide for
Disable Zoho form buttons in creator
I want to use multiple ZOHO Forms on ZOHO Page. But I want only one SUBMIT button for whole ZOHO Page. How is it possible?
Unable to create a function using the Builder
I'm not able to create a function using the builder. When I try, I get an error message. See this http://screencast.com/t/PJMeI2e0Zl Thanks Alex
Price List Price Breaks
Many of the price lists I am given by suppliers have different prices for different order quantities (price breaks). Is there a 'standard' way of implementing price breaks in databases. Obviously, I don't want to repeat a complete record of Part_Number, Description, Valid_Date, Supplier etc. but I'm not sure creating another related table/form for Quantity, Price and Lead_Time is the answer. Another issue is importing a price list - most of which list price breaks in separate rows.
Setting the value of a Lookup field in Deluge
I have imported two spreadsheets into two forms (Organizations and Contacts) to get some data into my application. The Contacts spreadsheet (and form) contains a field with the name of the organization to which the contact belongs. In the Contacts form I also have a lookup field for the organization name, and now I need to go through every contact to look up the organization in the Organizations form in order to populate that field. I've tried to automate this in Deluge but I don't know how to set
Next Page