Reference Manual
Although the developer guide is o.k., I'd like a reference manual that I can download and print out with all the functions, scripts, examples and such so that I can read it. It is very difficult to find the function or call or object that I need for my programing. A list of what is possible would be super helpful. A PDF would be awesome.
my id been deactived!!!!!!!!!!!zoho team worker in please.......
today i try to login my id but it is in inactive status, may zoho team worker help me to fix this problem? if really cannot restored the id, can you copy the view of the forms i had created in that old id for me(in a new id). that's very important for me please...... my old id's email is ed.hodge1234@hotmail.com
Need help with action button
I can’t get a custom action button to work. I have two tables: Events (parent table) Fields: Event, Event_Date RSVP (child table): Fields: RSVP Date, Name, Email, EventID (lookup ) and its related fields – Event, Event_Date, ID I set up a relationship between the two tables with a lookup field in RSVP called EventID that relates to the Events’ ID field. I created the following function for the button in Events (to show on all records): void rsvp.makersvp (int ID)
Creating Additional Users
I need to set up "Additional users" in Creator. For each new user, they need to have a user name and password. Your help notes are not clear as to how this is to be accomplished. Can you send me instructions are refer me to a link or video? Thanks, Bartley Than
My Formula Field is producing errors & what is the best way to express...
When I use the formula field and input the following: (y_o_main_pts + y_o_comm_pts + y_o_demo_pts + y_o_sni_pts) it saves it this way: (y_o_main_pts + y_o_comm_pts + y_o_demo_pts) + y_o_sni_pts Also I would like to know how to write the foolwong expression: 125 - (y_o_main_pts + y_o_comm_pts + y_o_demo_pts + y_o_sni_pts) = whatever the sum totals
The template variable y_o_snip_pts is of type STRING. But you are trying to update it with an expression of type BIGINT
Why am I getting the error below, when I try to save the formula (noted below in red) in free flow scripts. The type of field is a Radio Button with Two Choices (Yes & No) (I allowed for edit access to support and share to support. The form I am having trouble with is "Mission Score Card" url mislimdb Error in statement at line number 3 The template variable y_o_snip_pts is of type STRING. But you are trying to update it with an expression of type BIGINT Here is the script I am trying to save in
Embedding a form question
I would like to embed a form on our website, but require a login to access the form (it is for our internal usage, not our customers). Is there a simple way to do this? - Thanks, Brian http://www.redpelicanmusic.com
Difficulty with free version. Especially with reports.
I have just started trying the free version and find it not very friendly. Not very transparent. How to make reports out of single records for example is not obvious. This is a basic need in all databases. I know that you are trying to sell the more advanced version but how do I know if this is a common problem with all of your soft ware. Thanks.
Make my app public
It seems the "click here to request for public access" link is permanently not working (Error on page) How can I do to make my app public then? Cheers
How do I change my form to public view?
Adding users and getting them logged in????????
I have added users and made them active. My question is how do they log into our account? Is there something else that I need to do? I can not find a place where I assign passwords. Please fill me in. I am very new to ZOHO.
Application not duplicating
I tried the solutions proposed to another with a similar posting in this forum, but none work. The last option was to export the script and import it. After exporting my application script, then trying to import it again, the process halts with numerous problems. I edited the application as best I could, but it still complained about one function missing, even though I'd cut out the form that asks for it. That particular function working fine in the original application. Help! I'll open the application
How to use a "lookup" to populate a field thats in the same record (Using a lookup to add more that one field to a record)
I am new to Zoho, however I have used another system similar to "Creator" this Caspio. I must say I love your system, very well designed and thought out. Bravo!! I have one last issue I need to solve before my web application is finished. Here is my problem: I have a form that uses a lookup to find another database table and use it for a drop down. What I want to do I pull two more values into this so that both are displayed when I submit. I am creating another form database so that I can find a
Changing column names
I've changed 3 of my data column names in order to "blind" the data. When I look at my Results Page, the column names haven't changed. How do I fix that?
Replace commas as separation for multiple entry fields
Multiple entries in a checkbox field are always separated by a comma in the list views. Is there a way to make it so the separator is not a comma, but something else (a semicolon, for example)?
Functionality based URL's - print - in Functions
Having now spent a few hours on this challenge I ask for some advice. I have succesfully created a function as below that allows me to view more information from a specific record. this idea was taken from a sample and modified for our needs. void print.MoreInfo(int LoadNumber) { openUrl("#View:InboundLoadSummary?LoadNumber=" + input.LoadNumber + "&hideprint=true", "same window"); } The concatenation works fine and I noted from the sample that the ZOHO domain, username and appname were
New url pattern for permalinks?
ZC Team, I saw that a new url pattern for permalinks can be used (and I suppose that it was made in order to fit better with Custom Domain, an important feature that will be available in the future). So, instead of http://creator.zoho.com/<zoho user name>/<application name>/form-perma/<form link name>/<private code> you can use https://creator.zoho.com/showPermaFormHeader.do?sharedBy=<zoho user name>&appLinkName=<application name>&formLinkName=<form link name>&privatelink=<private code> The same
Pivot Chart
Create Pivot Chart With Zoho Creator I have trouble creating a "Pivot Chart". To create a Pivot Chart "select report type as" Pivot Chart "the result is a" Pivot Table "Why is this problem. Thanks www.lentedingrandimento.it il giornale appalti pubblici
A bug in Creator's Reports
Hi, In Creator's build-in Reports (pivot table), when a filter uses a string field value with accented letters (ex: "Réalisé"), which are common in French, saving and using the report fails. This is strange since the very same report created in Zoho Reports (not Creator) has no problem handling accented letters. Thanks
When I set Criteria for a View, the View doesn't apply it
When I edit certain views to filter out criteria, the views don't adjust themselves when I go back and view the application. For example, I have a Criteria set to not display records with the Status Type: "Ongoing," because I only want to see projects, not ongoing duties. It still shows all the records. On the other hand, I have a second Criteria for the SAME view that says not to show "Complete" projects, and that one works perfectly. Am I only allowed one criteria setting per View?
Auto increment in 2 lines of self supporting code.
As long as you have 1 record with a number field that has a number in it, then these 2 lines of code will work: LastRecord = Magnet_Board_Form [ID != 0] sort by OrderID desc range from 1 to 1; input.OrderID = (LastRecord.OrderID + 1); So how does it work? The first line is a "fetch" it sorts all records in form "Magnet_Board_Form" by the field "OrderID" in descending order, then grabs just the top record and calls it "LastRecord" The second line then increments the "OrderID" field of the "LastRecord"
Count function to identify duplicates
I've been using the count function to identify duplicate records from several fields in a form. I've used && between count formulae to indicate each field value must be identical to those of an existing record for a duplicate to be identified. However this seems to have the behaviour of identifying any record that has a field value identical to the one specified in the new record. How would I adapt this to ensure all field values in the new record are identical to one and only one previous record?
How do I use the fetch records variable in zoho creator?
Hi im working on the app zoho application builder and am wondering how to fetch records in a html view in which all zoho users can see. Is there a way to find the amount of employees then make it so when I fetch a record it will show how much employees and volunteers I have in the view. E Industries Inc. www.eifis.webs.com
Attached file Problem
Attached files don't seem to work. They appear to upload, but when you go into the form they are just listed as names not as links to the files.
Invalid Entry -> java.lang.IllegalArgumentException
I created a form which asks for a variety of text, numbers, and picklists, and upon hitting submit I get "Invalid entries found. Please correct and submit again." and at the bottom it displays "java.lang.IllegalArgumentException". However, the record is still added to the database with all of the information.... Any thoughts on what is causing this or how to fix it? I have other forms in the same application that ask for similar information, yet they work perfectly. Thanks in advance Richard
Filter Date Fields by Nil values
I have a form with a date field called "confirmed". I would like to set up a view where results are filtered by an empty or nil value for the date field. I have tried to set custom == "" which failed silently and nil apparently is not a primative construct in the deluge scripting syntax. Is there any efficient way to filter form objects with a nil date field?
I have forms associated with different projects. Can I have a different admin.userid associated with different forms?
As an example, suppose I had ITmanager@mycompany.com as userid, and also had projectmanager@mycompany.com as a userid. For my IT forms, I want the email notification sent from ITmanager@mycompany.com but for my project tracking forms, I want email notification sent from projectmanager@mycompany.com. Is this possible?
Transfering applications to a different account
Hi, I made an application for a business colleague and I would like to transfer that application to their account. I am no longer employed by this business, and would like to give them the application so I can get it out of my apps. Please let me know, if anyone has any ideas on how to accomplish this. Thanks! emilyhoward21
Updating in Zoho Creator
I suggest to create the posibility of updating a created database from a xls or csv file. I'm using some Zoho applications in my website www.ruedadebolsa.com, Zoho works very good. Thanks for exist.
Linking Zoho Creator Apps with CRM
Hi, I'm using the deluge code given on the below link to populate a drop down select field with the vendor details in my Zoho CRM. http://zohocrm.wiki.zoho.com/Linking-Zoho-Creator-Apps-with-CRM.html I have adapted the code slightly, but it will not save and the error message I receive is not much help - "null". The field to be populated is called "Seller1" The code below is the same except I have replaced MYLOGINID, MYPASSWORD, MYAPIKEY and MYCVNAME Can anyone help? Many thanks. responseStr = getUrl(("http://accounts.zoho.com/login?servicename=ZohoCRM&FROM_AGENT=true&LOGIN_ID=MYLOGINID&PASSWORD=MYPASSWORD"));
Might be interested in modification and integration (w Zoho CRM), please contact me.
Very Cool!!!
Sluggish Apps after time
Hi, a couple of things.... 1) love the recent changes and the addition of reports etc - very awesome! 2) I've noticed over time that my Zoho Application becomes "sluggish", almost like it's hanging on to fragments of records when they are changed or deleted. I duplicated the application and re-imported my data and it was zippy quick again for a while then eventually became sluggish again. It's not the end of the world to have to do a re-load like this, but didn't know if anyone had mentioned it and
An Email Form With Email Verification
Hi, Here's my basic form: I want users to be able to write a message & send it to a recipient email of their choosing. I want to collect the senders email address, but don't want their email address to be kept on record in a database with the rest of the fields data. Instead the email will be sent from a singular address such as test@abc.com. So to clarify, from the above form the following will be produced: Email Recipients Address - [recipients email field] Email Message - [message to recipient
Moving Apps Between Accounts
Is there some way to move an application I made in my personal account to one that my boss uses? She wanted me to make a draft of the application for her before she approved its use. I didn't think ahead to the fact that she would want a separate account with a more appropriate username (I used my first initial and last name). Is there some way to either change my username and password or move the application to the other account? I have spent the past 3 days making it, so I'd rather not make it
Logarithmic axes on graphs in Reports
The title pretty much says it all. Is there a way to make the y-axis logarithmic in Zoho Creator reports? I have looked for options, but couldn't find any, and I am surprised noone has posted this question on the forum before? Thanks, Milen
May I Customize My Form?
I would like to customize a user form like the one attached. The form must be interactive and be able to update my data. Thank you for your quick response.
Can Zoho solve my problem?
Hi, I am NOT a coder and have never created a database before. I'm hoping Zoho can do what I need it to do. I have a client who does weekly CD Reviews. To date I have about 500. I need a database to include and be searchable by date of review, artist, CD Title, Label & Star Rating. Each review will also include the album cover picture and, of course, the review itself. I have been able to create the data entry form for this, but I can't create the display page for the website. I need to make
Can I have Disable the Submit/Update button in my form
if the record id is not found in the tabel,can I have disable the button in my form
Import Function not working properly
The importing data function does not appear to be working properly. To test the functionality, I went to my "Orders View" and exported one of the orders that had been entered in directly through the external link we direct people to. I then turned right back around and tried to import that same order, only changing the Order ID field and it says that a mandatory field was left blank and the import cannot happen. First of all, it is somewhat less than helpful to not know what field it is referring
Dynamically populated checkbox
I have 2 related forms. I have a checkbox in form 'A' which is dynamically populated with records from form 'B' to a given search criteria. The user then selects the applicable records shown in this checkbox. This bit works OK but I now want to write a script to automatically update these selected records back in form B. Thanks in advance - A
Next Page