Import data field type : how to import from other applications
Hi all, I'm new to creator and I wish to link a form field to another form in a different application (shared or public), this form acts as a commun reference table for several applications. Is that possible with creator and how can I do that ? When I use the import field, I see a reference to app name, form name and field name, but I do not know how to change the app name (set to my application by default). Thanks
Having some trouble with creating a useful form to update another form
I am trying to create something of a project management app. So I have accounts, which relate to projects, which in turn relate to tasks. I want someone to be able to add as task through the "Add Task" form. Which is working correctly and obviously is not hard. It gets a little more tricky though when I create the form "Update Task". In this form I have it where I would select my task, and then add updates including time spent (a field not in the Add Task form, so unrelated and then other fields
setting label widths
Using "form properties" in the "more actions" drop down, i set the label width using the px/% option. after clicking "done" there is no change to the form layout. when i return to the form properties, the label width is set back to auto. what am i doing wrong or is this a bug?
using related field in a formula
I'm trying to do the following in a view. In the form associated with the view I have a quantity field. In a related database (based on an item that has been selected in the form) I have the price of the item. I would like to have a formula field in the view that calculates a total cost from the quantity and the price in the related database for each record. is this possible? thanks!
Can form or view title be changed dynamically?
They can be changed manually in form designer, and by changing the textual form definition. BUT: - is there a way to change them dynamically, from deluge script? This would be VERY useful, since it would allow greater application customization based on some settings, by customer information, etc. etc. Just in case, I tried setting form.displayname variable from deluge, but that did not seem to work ;) Please consider adding this simple feature if it's not there yet.
Error Message
I keep getting this error message and I am not sure what exactly is going on. 1 . [t_506841000000384059] Exception occured while setting value in PreparedStatement for the Column [invoiceDat_506841000000426035] Check whether the datatype for this column is given as specified in the data-dictionary .[t_506841000000384059] Exception occured while setting value in PreparedStatement for the Column [invoiceDat_506841000000426035] Check whether the datatype for this column is given as specified in the
Preceding space in 0 index of multi-select values.
I think I found a bug that can break quite a bit of code for users. 1. Try saving a multi-select box with multiple values selected. 2. On validate run the following code.. fields = myMultiSelectBox; for each f in fields { info "_"+f; } result...... _ home_phone _ Location _ Tour_Date _ ID_str or run this info in a list. fields = web_contact_fields; test = {}; for each f in fields { test.add("_"+f); } info test; result..... _how_did_you_hear_about_us, _ other_referral, _ doc_Name, _ pres_Location,
Feature of Creator
Hi, there, Creator Html View support Dhtml or html5? dhtml or html5 is a good feature. Thanks, Andy
Can't edit application Zoho Creator
Good evening, I can't edit my application anymore. In Firefox I still have access but can't change anything? Could you help me? Thanks, Job Sueters jobsueters
My application disappeared completely
Hi guys, I've been working on an application to manage a pilates studio, and have had so many bugs in the scripts that I decided to start over. Forms don't display correctly either, sometimes it helps to just log out and log in again, but not always. So I renamed my application to "pilatesv1" or "gestionpilatesv1" something like that, and started over with a new application named "pilatesv2". And now, misteriously, a new application appeared called "Alumnos" which should really be the name of a form
Get Contact Field with searchRecordsByPDC
Hi, I'm trying to create a formula field in a Aplication. In this formula field I want to get de CONTACTID field of a record. To get this I use zoho.crm.searchRecordsByPDC("Contacts", "email", Email).get(0). Doing this I obtain the complete record but I only want the CONTACTID field. What can i do to get this? I tried to do: zoho.crm.searchRecordsByPDC("Contacts", "email", Email).get(0).get("CONTACTID") but It does not work. Thanks, Roberto
drop down list going null on success action
I am rebuilding a few (lookup) drop down lists as the user goes through the form. When I get to the success action and try to use the field values they are null. Previously it was working, but all of the sudden I was getting null values. I checked everything and put in alerts and info to see where they were being changed. To no avail. My question is. Are the input actions executed again during Submit? This is the only thing I can think of. I rebuild certain look up fields depending on previous
Error modifying the page Lexical error at line 263, column 19. Encountered: "\u201c" (8220), after : ""
I use MSWORD to write deluge scripts and paste them to the ZOHO form. I save the text as HTML prior to copying and pasting. Works fine except for the above error message when I write a script like: input.field = "x"; the syntax check doesn't like the quote notation and requires me to reenter the quotes via deluge. What can I do to prevent this lexical error? Thanks Robin
bgiframe does not work on FireFox
Hi All, I tried to create an iframe in a div, using bgiframe as below: $("#panelrightbody").bgiframe({ top: 0, left: 0, width: 1280, height: 800 }) The iframe is created successfully in IE8, but not in FireFox (v3.6.12). I used this script: jquery.bgiframe.min.js Please help me to find out the root cause. Thanks, Triet
invio automatico di email
Salve , ho creato un form con un campo col nome invio email di tipo dropdown con valore (si, no) ed un campo per l'email Vorrei che se in nel record invio email seleziono si il sistema invii in automatatico un'email all'indirizzo messo nel campo email. non so assolutamente come si fa lo script
Can contacts be linked to different profile types?
I am trying to create a non-profit organization database (using one of the shared applications as a start). I have categories of contacts like "donors", "volunteers", and "event staff". Is there a way that I could create the database so that a contact can be in more than one category? Such as, a contact is a donor and also a volunteer, with all the fields pertaining to both categories on their contact page? Is there any way to do this in Zoho Creator, or am I trying to make something work that just
Populated drop-down not referring correctly
Oh no...!!! :-) After some great help from members of this forum I finally thought I solved a problem that I have been struggeling with for some time. But now it turns out, it wasn't solved after all... I am hoping for some help to complete the last stretch to the finish line. I have a drop-down with school-names which is populated using the ui.add function. The names come from the form "Organisation" and the name of the schools come from the row "Skolens_Navn" in that form. When selecting a school
Can i send a newsletter via Zoho using the emails generated from the database in creator?
Is there a way to take all the email addresses in our database and have a dynamic newsletter/email sent to all those addresses? thanks, Justin
Records Quota Reached Maximum, But Not Really???
I have an application that we use for employment application I noticed that over the past couple weeks I wasnt seeing any new applicants come through. Today I tried the application myself and was given an error message that the 1000 records (free acct) limit had been reached. When I logged in to my account there were actually just over 800. ???? Why would this happen? I exported and deleted 600+ records and everything is fine now. How can I ensure that this doesnt happen again? Maybe this is worth
record exist
short Q check if this record exist before adding the new record detailed Q now i have a form that i entered data to a data base using it and i want to verify that this new record is not exist before how can i do it?
Simple Question - How to auto update a field?
Hi, I am very new to Zoho Creator. I am trying develop my first application for a small company I work for. My problem is as follows: I have a one form called Estimator which has 2 fields Estimator's name Estimator's Email Id The second Form is called Estimator's Log where one of the fields is Estimator which is a "Lookup" field and the values are looked up from the Estimator list. I also have an Estimator's Email field in Estimator's log which I want the program to auto update as soon
relation between tables [forms]
how can i make a relation ship between tables? is it a MUST that i make it using MDB first and then import it to zoho?
Iterate through fields
I have a form that once submitted I want to iterate through fields from a form and keep a count based on some criteria. The only thing I am not sure how to do is iterate through using a criteria. If I have form a how do I iterate through all the fields whos subject = something?
Hiding Column in List View
Hi, I need to know how to hide a Column in the list view, but have the column and the data contained in it visable when the user selects "view" How do i do this? Thank you.
Subtraction of Hours and Minutes
I am making timesheet application and I would to subtract hours in format 08:23 (hh:mm) What would be the simplest workround to do it in Creator?
Re openUrl("#View:view45")
Dear Sirs I used to use this function in the last line (openUrl("#View:view45") of the need to open the specified view can normally open, but recently opened always www.zoho.com, absolutely not I just open the view, to help resolve, or adjust the deluge of functional? Waiting your help and thanks Stanley Guo
HTTPS - Make It Stop!
What's going on with ZOHO sign-in? It's redirecting to https in both FF and IE for my admin account My links all look like this: https://creator.zoho.com/newLivePage.do?appLinkName=pto&sharedBy=niskypto#Page:Events When I use my non-admin test account, I'm not seeing https links. Anyone else having this issue? John M. Whitney
Delete Record on Edit
How do i delete a record when a certain option is selected from a dropdown menu. Basically I have a drop down menu labeled "status" and what i want to do is when someone goes in a edits the entry, and selects "closed" from the dropdown menu labeled "status" the entire record is deleted. how do i do this? thank you in advanced
Single word response from zoho creator xml rpc api
I have been trying to use the zoho creator xml rpc api. Problem: When I send a request to the xml rpc api from java code all I get in response is the word "Success". Since there are no http errors and I'm getting a response ( just that one word in the response: "Success") I think I'm doing some small thing wrong. But When I make an html form (with the exact same values ) in an html page and submit it manually I get the correct xml response in my browser. 1. Can you think of something obvious that
Prevent Adding Record within To/From Range
I have a form that has "To" and "From" fields for a range of days (e.g. FROM 0 TO 30). There are multiple records in the table From To 0 30 31 60 60 90 I would like to prevent the user from adding a new record between these numbers on the form. I tried to do this with a on validate action as follows, but it does not seem to work: if (count(Cancellation_Policy[((Property_Code == input.Property_Code && From_Days >= input.From_Days) && To_Days <= input.To_Days)])
API not working
1. Is zoho-creator's API server down? I keep getting HTTP-500 with the message: "An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused." 2. I generated the api-key and ticket today, do these take some time to get active? 3. The request/form I am submitting is very sparse and simple and unlikely to contain errors, it is mostly a copy of the example in your api-guide. But, Is it possible to get HTTP-500 (instead of one
Can't Delete Application
I can't delete IT Asset Manager.
Image links to a view
HI, I need to know how can I do to make an Image a link to another view doing double-click on it. I know I can't do it with Formula field and I have no idea how to make it with the Image field. Any ideas? It's possible?? Thanks. Sergio
Passing information from a form to a view
A user enters their email address and selects several vendor types from a list of 10 different types. When they click Submit I want to open a view of the vendors that only shows the vendor type the user selected. On each row in the view I want a function that will email the users informatiopn to that vendor. 1) How to I pass multiple vendor types in the openurl command with an OR combination. That is show all records where type is 'baker' OR 'candle stick maker'. 2) When I'm on the view how do I
How can I access field in one application from another application
With in a single application using the lookup field communication can be done between two forms. How can I do the same thing between two forms in different application. Application A has A.field1 and application B wants to send A.field1 as part of an email.
Help with forms and functions please!
I am trying very hard to figure out Zoho but I have a quick question. My website is similar to ebay in that it connects buyers and sellers. I would like potential buyers to be able to fill out the Zoho form on the website and have that form generate an email to my seller. I created two applications - The first application houses my customer contact information including Email, Name, Phone, etc. The other application is a form that will be embedded on my website. Here's what I want to happen:
Deluge scripting failure
Hi support team, In july, I wrote a deluge script using apitite Creator-CRM library from the market place. The purpose is to retrieve a few records from a CRM custom view and populate a table in creator for reporting purpose. Everything was working fine in July, but it appears now nothing works anymore for no reason. After half a day trying to understand what was going on, deleting script parts in order to pinpoint the issue, upgraded to the latest apitite version, I tried to follow the running script
Easy way to pass ZC data to iframed html/javascript apps or widgets
DISCLAIMER: I just post what I find interesting. This was an exciting find for me that I used on my last large project..... I often daydream about what I could build in a ZC html view if I could run jquery and javascript! Wow, how fun would that be! I could lazy .load() html snippets from other views, save info dynamically. Wow! It would be great. Anyways, IT'S A DREAM for now. But, I have been able to find a way to float a javascript/html app on top of a Zoho Creator view with some fun results!
Trouble with Creator Report
I've created a report based off a table but its not collecting all the data. The report basically shows the total of metrics for each recruiter for the current week but its not showing all the recruiters or collecting all of the dat. when i export the data from creator to zoho reports it collects all the data correctly. But I want to have the report in creator. Help
auto complete for multiple textbox
I am having 2 autocomplete textboxes. One for 'product Id' and another for 'product name'. If I change ID, automatically name should be updated and vice versa. How can I do this.
Next Page