Deleting application with cross referenced functions
I want to delete the following applications that I created whilst testing the duplicate application functionality. assets_new DEV SERVICES AND ASSET TRACKING TEST (obsolete) When I attempt to delete the applications, I see the following message This application components is used in the following places, Please remove this and try deleting the application. ... In the past, I removed the all the code manually and this allowed me to delete the applications. This is a very time consuming process. Can
How to temporarily suspend access?
Hello, I need to make some changes to my application and would like to suspend all my users' access while I do this. Is there an easy way to do this? Thanks, Lindsay
Multiday Event Form, calendar view
I was wondering if anyone has ever achieved a multiday event form to view in a calendar view. EG: have a start date/time and End date/time in form. Then the all days of event are shown in a calendar view. Thanks
URGENT PROBLEM - Intermittent Email Sending
Hi, We have had the facility to email out quotes from our application for the last year with no issues whatsoever. Suddenly around 10 days ago, email sending has become completely sporadic. Some emails send, others don't. I've monitored behaviour over the last hour and only 5 of 16 emails sent, which is representative of what we have experienced. As there is no pattern with regards to which quotes will and won't send at what times, I can only conclude that it must be a platform issue. I submitted
RIP
Cheers, John Whitney
Some users on VPN can login but cannot access application
Hello, I am wondering if there would be a problem accessing a Zoho Creator application via a VPN? I have built an application for a company and users can access the application when they are on networked computers in the office but cannot access the application when they are working remotely through a VPN. Could this be because of the version of the browser they are using? Or because of VPN security settings? Or because cookies need to be enabled? Users on the VPN can login to their account but
Lookup Field
So I am an MS Access person and need a little direction. Here are my details: Table 1: Department- Fields: Department, Floor, Code Table 2: Staff - Fields: Name, Address, Phone, Lookup Field for Department Form: Employee Certifications Fields: Class, Date, Lookup Field for Department from Table 2, I need a field that holds the Name In Access I can have a Lookup Field that shows Departments when I select the Department my next Lookup Field only shows me records for the field Name that are in the Department
check if date entered correctly
I get an error on the following expression that checks if a date has been entered correctly if ( input.Data_do_Auto.matches("[0-9]{2}/[0-9]{2}/[0-9]{4}")) It seems that using string expression in a ".matches" function isn´t allowed. I appreciate any help on this issue. It would be nice if ZC could put more effort on documenting the deluge functions. This would save us a lot of time and make using ZC more viable. Thanks.
Customer Portal
I do not have the "Customer Portal" option in my account (at least that I can find). I looked where it says it should be but there are only four options there (ie General, Customize, Share, & Sections).
Public user registration?
Can Creator be used to create an on-demand database service? I am looking for a platform where I can deploy commercial database apps, where users can register for an account, and then use the app. Based on my limited playing with Creator, it appears the only way to deploy a shared database is through invites, which won't work for me. Thanks.
Hide buttons in Stateless forms works erroneously.
When a hide button-name; (or even show) is invoked upon on-load of a stateless form, it hides all the buttons on the form and not just the one being referred to. Note: The form definition with actions is attached. -Varun.
Email alerts for approaching and past due dates
I am working on a way to track required documents for a small fleet of fairly large boats. I need to have emails sent to alert us as documents are coming due. Along with this I am using a Action Tracker to alert to approaching dates repairs are due. If anyone can help me make it clear and simple I would appreciate it. I am not a computer guy I am a boat Captain so simple is better.
Syntax checking/parsing needs fix.
If there is a data type mismatch while querying for data, the ZC compiler isn't reporting any errors but the fetch itself fails. This makes it very hard to debug. Example: Consider column NumberType to be of type Number in MyForm. //This compiles fine but returns no rows floatValue = 2.0; MyForm[NumberType == floatValue]; on the other hand: //This compiles AND returns rows as expected. intValue = 2; MyForm[NumberType == intValue]; The ideal scenario would be: 1. Report an error, OR 2. In case of
Will the new app builder affect existing apps in live mode?
@Zoho Creator Team Our small business has a practice management app in Creator which we rely on to manage nearly every aspect of our business. Apart from the occasional platform change bug every so often (not so often in recent months) this app has been extremely reliable. Can you please confirm that the move to the new app builder will definitely not affect the live production operation of our app in any way whatsoever? Are you 100% certain that the new app builder will ONLY affect the development
HTML5
Is html view supports HTML5? I would like to make a form <form id=payment> <fieldset> <legend>Your details</legend> <ol> <li> <label for=name>Name</label> <input id=name name=name type=text placeholder="First and last name" required autofocus> </li> </fieldset> </form> However, the placeholder is not working in HTML view. Any suggestion? Will it support HTML5 in near future(within 3 months)?
Where is my Account ?
I am not able to login to my account associated with abhinandansharma84@gmail.com. I created so many forms and apps and using them with my various website one of them is https://creator.zoho.com/abhinandansharma84/apsplacement/record-print/Jobbish_login_View/155304000003979003/ but now i am not able to login and zoho is considering me as a new person ? Where are all my apps and how can I edit them. Please guide, It's urgent. Regards, Abhinandan Sharma 8010855550 abhinandansharma84@gmail.com
Sub Form auto add button feature
Hi, OK so here is what I want to do. I have been told that Zoho does not currently have the ability to trigger the add button of a sub form automatically from a script. This feature is vital to my project so I have been looking into this in an attempt to help you with the feature. If I could find a way of implementing the following Java code within a script, it should trigger the add button in the sub form. <script type="text/javascript"> $window.onload = function() { $eval(document.getElementsByClassName
Logout link on my website
I need to add a link to logout in my website and not found. Can anyone help me? Regards
How to use XML response from Creator form submit
I have created an HTML view in Zoho Creator that posts data to a creator form. I did this because I don't want all the form field to be displayed to the form user. My form submits perfectly. However the xml response that comes from the form submit gets returned as a downloaded file and I want to use the <status> element to provide feedback to the user of the form. How do I consume the response data since I cannot use javascript or php in a Zoho Creator HTML form?
Error in executing GENERATETJ_TASK task
Hi, I have added the following script to On Load clear Region; Regions = Geographic.distinct(Il); Region:ui.add(Regions); this is done in order to get on the unique list of regions from the Form Geographic and the field Il. But when I try to open the application I get the above error. Can you please advise what the problem is, as I have copied this from https://help.zoho.com/portal/en/community/topic/grouping-a-lookup this link? Regards,
Public Application
Hi, I developed an application and set it to public. Is there any limit on how many users can access the application at the same time? Will there be a problem it is accessed by around 300 users at the same time?
Best practice when purging records?
I will need to purge records from my 3 hosted databases to keep below the 100K usage limit. Are there any tips to making this go smoothly? For example, can the database be live (i.e. available for users to input new records) while simultaneously deleting records? If not, how do I take a data base "off line" temporarily? Assuming I want to delete 10000 records from each data base, approximately how long would that take? Should I work on one data base at a time, or can I do a batch delete on each at
Text field in forms turns numeric in mail
Hi I have made two forms one with at text field (name) and the other one with a lookup (name). When i put it in a mail - on success send mail to - it turns numeric - see below. It's the first line after "Kære" What to do? Kære 1527373000000054102 Du er tilmeldt kurset Afklaring hos os, vi glæder os til at byde dig velkommen. Vi starter d. 14-Oct-2013 kl 8.30 og satser hver dag på at være færdige kl. 13.30. Kurset afholdes på vores kontor på adressen: Gråbrødregade 14, 1. sal 6000 Kolding
FETCH record not working
I have 2 forms. One is called PERSONS (fields Account, Name and Age) while the second is called DETAILS (With fields account(Lookup) and Age). I would like to fetch the age from the PERSONS form and have it displayed onto the DETAILS form. I have used the code below (on user input for field account). However, it is returning nothing. Please help. What could be wrong here? records = person[Account == input.account]; Age=records.Age;
How to link forms.. complicated question from a newbie, sorry.
Hi all I'm fairly new to this so sorry if I get some of the terminology wrong. I'm trying to design a simple library system to keep track of hard drives in our company. These are often sent out of the office to collaborators/clients and we need to log their movements. So far, I have three forms within the library application. Form 1 - (Drive Catalogue) records the information about each individual drive (a unique ID number, the name of project it's being used on, whether it's a master or back-up
Displaying a Page within an iframe without the Zoho Header
I have created a page (Page 1) which I wish to display within an iframe another page (Page 2). I can do this with the OpenURL function, but I can't figure out how to display just the content of the page, and not the full page including the Zoho URL. How do I construct the right URL to use in OpenURL? I can find the guidance that explains how to use parameters in the URLs for Forms and Views to configure how THEY get displayed, but I can't see the equivalent for Pages. Thanks for your help. Alex
Sendmail problem
Dear Zoho team, When using a Sendmail function, Instead of getting an email message with the expected input of a droplist field, i get a Zoho ID number (e.g., 1534967000000030720). why is this? how can it be fixed?
how to put column name in fields of table in query_table
Need help to create zoho report from tables by selecting column name and respective values sorted according to date for eg: see attached file snapshot can we design zoho table by query_report or report view, if possible please provide help regarding it. and we are getting result from table please provide help if any problem in query execution and how to get pivot view on clicking on one pivot view in child window
General Form Question-new to Zoho
hi, i'm using the free trial and just seeing if we can use this for our website. I created a form and put the link in our website (since I don't know how to embed yet!). I logged out of Zoho then logged into our website. I clicked on the link to the form, but it looks like you have to log in to Zoho first to get to the form. did I miss a step or do you have to have pay status to bypass the login? we have only 200 members and will only have forms used once or twice a year. comments/advice appreciated.
Problem with a lookup field
I have a form (A) in which I incorporate a lookup field to form(B) //for client names - string field The name retrieves ok and displays ("ABC Ltd") which is what I want. Later, I wish to test that the field is actually "ABC Ltd" to then show/hide other fields. Creator specifies a lookup as type "long" and I can't then test as it will return a numeric such as 720050000. IS there any way to handle this? Thanks Greg
Can Zoho CRM Pulse and Audit Log Records be Called in Zoho Creator?
If I set up a creator form record pulling info from a CRM module, is it possible to get pulse and audit log data?
Configuration of the Maxchars on a single-line field.
The increment/decrement on the max chars field configuration allows a max value of 999 while any value is accepted if the user types into the field. Also, the maximum characters that can be used in a form (according to the known limitations document) is 80 fields of 255 chars each or equivalent. There is no validation while the developer is configuring the fields but for the run-time error that is hard to debug. Can not a validation be added when the fields are configured rather than at run-time?
Login to my site opens new tab
Added views and forms in iframes on my site, but when the login is done by users instead of opening the form or view in the same window is open a new tab. How do I remove this behavior? Must remain after login on the same page. Regards Alexandre Bacil
[URGENT] String.removeFirstOccurence is not being recognized.
The compiler throws an error that this isn't a recognized method. Please help. -Varun.
Real time screen updates
Is it possible to show a time counter decreasing in real-time eg an auction period decreasing from a start date that was set to run for a specified time. Example Auction start date 15 Sept 2013 time 9:00am Auction end date 2 Sept 2013 5pm When view item you see days, hrs seconds decreasing in real time. This element is stored and is treated as a variable that can be called referenced in the application. Thanks for your guidance
Is the source app of embedded HTML page to website should be set share to public?
Hi, I embedded HTML page/view to website with photo and text input. It's working fine and exit the ZC app and the website. When I open the website again the next day, the photo column is blank. So I click the edit and changed photo, it was reported, "data added successfully" but the photo column still blank. But when I opened the ZC app, the photo was there. Without doing any changes, I returned to the website, and the photo appeared. Is the source app of embedded HTML page to website should be set
Combining text fields into one field
I have created a stateless form to populate a main form data table. On the stateless form, I have four separate text fields that I would like to combine into a Notes field on the main form. Is that possible and if so, how could I do it? Thanks!
CRM with RSS reader
Hey guys, I'd like to find a way using either Zoho CRM or Zoho Creator to view an RSS feed and add the authors of news articles to a CRM-style list of contacts. I'm happy to spend time building this with Zoho Creator. But before I get started is there an RSS reader in Zoho creator or will I be beating my head against a wall? Also, is it possible to do this with an add-on or extension for the existing Zoho CRM? Many thanks!
Using getURL and a header map variable to login and browse an external website
How can I send a Session cookie to an external webpage? I'm trying this which doesn't work? string getstayzdata.LoginAndBrowse() { mymap=map(); mymap.put("Cookie","PHPSESSID=7351b12k6001ovsqo8dunvj0q6"); buff = getUrl("http://server.address.com/",mymap); return buff; } The return page indicates that the server did not receive the Cookie in the request headers. What I'm actually trying to do is log in to a website with a getURL call (which is working fine - I'm getting response text
Fetching a record from Creator into CRM related List
Hi, I have created an app in Creator to store information about sessions (I teach) with my contacts. I wanted to link this with my CRM so I created a CRM form field in Creator to be able to look up my contacts name from zoho crm. I then integrated in CRM. The problem is, the form field always displays the full contact name...and yet the related list mapping doesn't allow me to use the full name to fetch records. I notice I can choose the contact ID to fetch records but I have no idea how to get that
Next Page