Enabling public access disabled for Trial and Free Edition users
Dear Users, Due to security reasons, we have disabled enabling public access of form and application for the Trial and Free Edition users. Regards, Karuppuchamy
permalink in iframe
hi guys, i have this problem. I have created a permalink of an html view with a zoho table inside. The table allow users only to view and print records, not to edit or delete. When i check the permalink in browser everithing works good. But when i check permalink in iframe, the table allow users to edit and delete records. Why? Someone knows how i can solve this? Please help me bye
Add records by status in ZohoCreator Reports
Some example function that adds record status by the creator of Zoho Reports? I want to add up all the forms that are as "Approved". Thank you.
Check for a null date in a formula field.
In my application, I would like to create a custom field that would perform the following actions If (initial_date and clear_date are BOTH NOT null/empty) - display "Complete" else if (initial_date is NOT null/empty but clear_date IS empty) - display "Pending" else - display "Incomplete" For some reason, even when I try to check if a date is NULL in a simple formula, nothing will show up e.g. if((initial_date ==null),"Test1","Test2") Any help would be appreciated!
Custom summary view to be shared among all users
Let's say the app owner has created a personalised summary view which applies everytime he access the app and clicks on view the record (or record summary). This custom summary view does not apply to other users (whether they are developpers or regular users). Is it a way to share custom summary views with other users? Do you think in any other way around to do this? Thanks in advance.
catch post rest api response
Hello, I am using rest api to add new records to my form from my external php/javascript application: https://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html The records are successfuly added, but the response is automatically downloaded to the client machine, the customer doesn't understand xml/json/csv formats, so this causes a problem. Second, I want to use that response (the ID) to add other records that have lookup to that first added record. Can anyone help me?? Thank you
Duplicating applications
Does anyone have problems with duplicating applications. I submitted a service request but can't get any answer. I asked for an urgent status update, still no answer. Generally, I get answers and resolutions on my requests fairly quickly; however, this one is worrying me because I am not able to get any communications back from Zoho technical support. A lot is riding on this for me!! Can anyone shed some lights on this issue? Any fundamental problem with duplicating an app? Thanks
Scrolling in Sections
When rearranging sections and components in a very long list, it would be much easier if Creator scrolled up or down when an item is dragged beyond the boundaries of the Sections window.
Looking-up a record from another site or location
Hello, I need help on how to connect and retrieve a record from another file that is located externally, on some website or network drive, without having to load the entire file into a table in my application? Is it using API? examples would be very helpful. I read the guide with GetUrl, etc. and that was somewhat confusing. I would really appreciate some help on this. Thanks
Adding Custom Button to View
I need to add a button to a view. I know that I can do this by writing a function and then calling that function via custom action. My problem is that I want it to work like a static button. I doesn't have anything to do with the below records and the custom action forces me to attach the button to a record or set of records to iterate over. I want to add a simple button to a view that calls a function (function that does not reference a record) but I do not want to have to build and entire html
A question about fetching sorted records
http://kbase.creator.zoho.com/records/fetch-records-within-a-range in the above document, this: rec = Contact [ID != 0] sort by Added_Time range from 1 to 5; so, my question is, if I do a for each r in rec { list.add (r.Name); }Will it add Names from the records to the list in sorted order of Added_Time?
Mobile linking in HTML view
Hi, I'm adding some dashboards to my application, from where the users are being linked to specific views and forms. This is quite simple, linking to #View:<view name>. The problem is with mobile viewers. Since Zoho Creator doesnt support Javascript (why is that anyway?!) I can't change it depending on user agent or whatsoever. How do I solve this? Thanks in advance for your help.
How can I use a sequential number for each form?
Hi, I'm creating a form like invoice and need to add a sequential number jump automatically with each entry. How can I do it? Thanks!
HTML in Variable
I am trying to create a variable for use in an email that contains HTML (for a dynamic link). The issues I am having is with the quote signs in the HTML. I cannot seem to get the variable to save with the quotes: agreementlink = ("Please sign your rental agreement by clicking the following link:<a href=\ "http://creator.zoho.com/carlgifford/vacation-rental/Rental_Agreement/record-edit/Rental_Agreement_View/" + input.RentalAgreementID + "\ ">Rental Agreement</a>"); Is there a way to do this? Thanks
Moving from GoDaddy Easydata Base to Zoho
I am NOT a programmer. I have emailed you several times, spent hours researching your site following the links I get in response to my emails (which usually do not come within 24 hours), reading forums, all sorts of instructions and suggestions, user guides,get started guides, and FAQ sections - all to no avail. I have been told I can hire someone to customize this for me, but I think I shouldn't have to pay to understand how to create something that should be very basic. The only GoDaddy customer
Subform: Criteria rules not working correctly
Hi, Background: I have a PROJECT form that has a relationship with CUSTOMER & AGREEMENT. The AGREEMENT field has criteria where CUSTOMER_ID == input.CUSTOMER_ID. This works fine in the form. Eg When I select customer 123, I can see agreements 12 & 22. Problem: I have a PROJECT subform in my CUSTOMER form. When the user adds a new project, I expect the Agreement dropdown to show the relevant filtered agreements. However, I do not see any agreements. Eg When I view customer 123 & add a new project,
Urgent: task zoho.crm.searchRecords don't works
the taks zoho.crm.searchRecords don't works anymore in my app, i try to see crm response with this functions list test.test() { crmResp = zoho.crm.searchRecords(("Accounts"), "(CIF|=|XXXXXXX)"); return crmResp; } and show me this: [{4834=Invalid Ticket Id}]it was working 2 days ago
Sum of 3 fields depending on user login??
Would love for someone to help me out with this. I can't think of a solution and have spent SO many hours.... I am using a form, where up to 3 users can split a commission on a team. The main agent adds the file, then they add one or two agents to share commission. Then, 3 fields are calculated that shows the commission for agent 1, agent 2 and agent 3. Now, I want each agent to be able to see their commission in a view or report form. I would prefer it to show as one field only, that represents
HELP!!!! Setup form in Zoho creator, but don't know how to automatically send invoices or attachments to clients?
Hi, I have a question for anyone. I have setup a form in zoho creator but from that information that I collect I would like to send invoices and contracts to my clients. How do I go about doing this? I need help. I don't know how to write script either, so I think that is what is stopping me. Do I use Zoho crm to do this all or what? HELP!!!! Tess
Update for the whole application
fetch and record for update from one form to other form is fine. However, my application need to be very relative together. For example: Form A: a cost of something (I will call A) Form B: fetch A * with a user input num = B Form C: a cost of something (I will call C) Form D: fetch C * with a user input num = D Form E: fetch B + fetch D = E Fetch and Update record will work when I update value in update Form A --> auto update to the fetching A in form B. But can not update value B update Form C
Subform calculations
I’m having trouble adding a column of numbers in a subform. As an example I created a form with the new builder. It has a subform with one numeric field, a separate number field for the total and a decision box to calculate the total. I added two rows to the subform. The number field on row one is 1, the number field on row two is 2. The calculation gives me a total of 5. If I add a third row with a value of 0 then the total drops to 3. The last row is being counted twice. Here is the script for
hidden fields
Hi, How do I unhide fields depending on whether a particular field has been selected on a drop down list?
Federated Login Improvements
This is related to my application context post. The changes Google made recently make having both a Google and Google Apps login irrelevant. I tested out signing in via my Google Apps account using the Google login and it works just fine. Support can remove the Google Apps login option. Using the Facebook option, the logo looks rather unprofessional. Please fix that. After federated login for new users, Zoho asks for a user name. Note that the instructions mention the zoho email address which should
How to create a view which self filters using user information from one form and displaying the filtered information from another?
I have two forms. One which has all the data I wish to display on our work, the other is a list of the users and their specialities and location. I want to create a form so when they log in it will show them information on all the items that are linked to their speciality and location. Both the location and the speciality apear in both forms. In the user form has the users email. I have created similar view to display for individuals who have their name on the item, this is done with the below
warehouse development
Hi guys, nice to meet you. I'm finishing the development of a company application to manage our warehouse. To create a selected list for product, i've arranged following script: lisart = List:Int(); for each y in magazzinos [(((stock_colli > 0 && deposito == doc.deposito2) && data_scadenza_lotto >= zoho.currentdate) && (protocollo_magazzino is not null))] sort by articolo { if (!lisart.contains(y.articolo)) { lisart.add(y.articolo); } } The problem is that "magazzinos" table
How to create function that returns all the selected fields in column "Email_Address" in a view?
Hi, I'm strugling with this one - I have a form where one column is "Email_Address". Now I need the user to be able to select appropriate rows in a view and on press of a button get all the email addresses to copy&paste I've been experimenting with the following code: string Get_Email_Address() { x = i.Email_Address ; Info x ; } return x ; This just lists of the email addresses in the log, but obviously returns only the last one. How do I make it to return all of them? and how do I narrow it down
URGENT! Script no longer working
Hello, I have the below script on my application 'KiwiOz Childcare.' For some reason it has stopped working and consultants are not receiving their emails: /*if (input.Item == "7. Interview (KPI)") { sendmail ( To : zoho.loginuserid From : zoho.loginuserid Subject : "Interview booked" Message : input.Item + "<br>\n" + input.Client + "<br>\n" + input.Candidate_Name + "<br>\n" + input.To_complete_by + "<br>\n" + input.Comments + "<br>"
Dynamic List Reference
I am creating a multiselect dynamic list and would like to include specific information from the records in the picklist. For example: Deposit: $300 Payment #1: $500 Payment #2: $600 The payment amount would come from the id reference. I am able to do this using the following code: Reservations = Rentals [ID == input.Reservation]; paymentlist = List:String(); if (Rentals[ID == input.Reservation].Deposit_Balance != 0) { paymentlist.add("Deposit: $" + Reservations.Deposit_Balance);
On Add / On Success Error
I've got an issue with On Add / On Success script in "NECATNetworkDatabase" - "Show_Times" Form I can't access it. Any help is appreciated.
Custom Action to edit a with less number of fields
I am trying to create a custom action which opens the edit window for the view record. But I want some fields to be hidden in this edit window. How can this be implemented?
Due Date for Form
I am trying to create a form script in which a "due date" will be automatically populated based on the day of the week I select in a date field. For example if I enter a date that falls on a Monday the "due date" will add 11 days. If I enter a tuesday it will add 10 days, etc. Any help would be appreciated, thanks.
changes to formla triggered by update to drop down
Hello, I have a drop down list of shirt sizes and a text field for quantity of shirts. The size ordered determines price. I am using a formula field to calculate the total cost of the order (quantitiy of shirts * shirtcost). It works well the first time (user selects size and inputs quantity). But if the user changes the size of the shirt without changing the quantity of shirts, the forumla is not updated. Is there any way to force the formula to check for a new value from the drop down? Sonya
Form Printer Add-on for Creator
I need a way automatically fill out the fields on a paper form with data from a Zoho Creator report. The goal is to auto-generate and print a completed paper form that looks exactly like the original blank paper form, but with all the fields filled in with Zoho database data which was extracted from a Zoho report screen. This is important, because many applications require the filling out of forms where you must use the exact layout of the original blank form for the completed form. The basic steps
Is there a way to get data out of backup version of app, without restoring the backup?
Since zoho support still can't tell me why duplicate application doesn't work, I decided to just work on the original and backup. Seemed sufficient, till I realized I needed the original data from a previous backup.
Duplicating or Deleting An Application
I get a "Duplicating...Please Wait" window that never goes away. Also my database never is duplicated. Same for Delete chris
Refining App
I am trying to refine an app I developed. I would like to Build an opening Dashboard for ease of use, but unsure if it should be a stateless or not. I would also like to add some other buttons to my existing forms. Any suggestions? Still Learning this..
Allow users to save a partially completed form and then complete it later?
is it possible to allow users to save a partially completed form which they could then complete at a later time?
Unable to duplicate a form without data
I have a long, complex form with sub-forms. Attempts to duplicate the form according to the "How can I coppy/duplicate a Form?" knowledge base instruction lead to a "null" error (old builder or new). (I have already tried deleting formula fields which Zoho says can't be duplicated.) Suggestions? Thanks.
Joining Applications
I have multiple database applications for parking permissions for different developments within a city, is there a way I can add the applications to one application with multiple tabs so the officers can access all the developments in one form. Any help appreciated.
Back Botton Script Not Working - Dialog Box
I have a page that has an openurl(#) pop up script in it. This allows me to open a form without navigating away from the current page. the problem I am now having is that when I hit the back button it loads the dialog pop up box instead of taking me to the previous page. Is there any way to fix this? I have tried the following: #Script:page.back #Script:page.parent.back But both of them reload the dialog box instead of loading the previous page. Again, if i have opened any dialog boxes it will
Next Page