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
Using zoho.loginuser in view does not work with API
I have a view that shows 16 records in it, 1 added by another user and 15 added by me. I have a view that limits what is shown by zoho.loginuser criteria, this is done in the view definition. If I embed the view in an HTML file and look at it locally the widget shows the correct number of rows depending on who is logged in, however if I retrieve data using an API call (to export the data). It always returns my data (15 rows) no matter who is logged in. If I use the export function of the view rather
How can I integrate a Creator app with Zoho CRM?
I'm working on an application with approximately 10 forms. So, I can't link them all to the Contact module as I would like as it limits you to 3 Related Lists. Is there a way I can link to the entire application from the Contacts Module, or the CRM module itself? Any suggestions or info would be really appreciated Steve Henry 310-850-2426
Formulas not appearing in reports
I have created a simple invisible formula in a form First_Name + " " + Last_Name When I output this in a report it is blank even though the first and last names are populates Any ideas ? Thanks
Why isn't re-branding allowed on Express plans?
I can't find the documentation that compares features across editions. And I would expect that re-branding is available on Express plans what with them being paid accounts. Varun.
Backup issue
I am trying to make a backup of my app (on new interface) or save it as deluge script (on old interface), but it never works. I made the app with the old interface. Somebody knows the problem??? Thank you.
Setting a start page
I have created a form (called: login) for my users that logs what day and time they check into the app. When they press submit they are then directed to a dashboard page that shows all of the links to the various forms and reports in the app. Is there a way that I can force that login form to always be the first page they are taken to when they login? Currently I am finding they are redirected to the last page they left off on when they were using the app. Thanks, Aaron
Creator to CRM integration
I have a script creating a record in the Contacts module in CRM from my Creator app form on submit. Works fine. I've just tried to add a similar conditional script to create a record in the Accounts module on edit and it does not work? The sendmail script on edit works fine. New script: on edit { update ( type = submit displayname = "Update" on success { if (input.Send_Confirmation.toString()
auto populate syntax question
my apologies if this has already been explained. I have two forms and would like to auto populate data from one form to the other but can't figure it out. What I am trying to achieve is have an office address information (input.Street, input.City, input.State) from "FORM A" auto-populate onto FORM B after the Office Location (input.office) is chosen from a lookup (drop down menu). I have gotten very confused as to the best way to achieve this. I could use some help - I am interested in some tutorials
Error occurred while executing the workflow. Please contact support@zohocreator.com
My user was using the following https://creator.zoho.com/essistmgmt/assets/#Page:SEARCH_ME Page. She reported seeing the following error 3 times this morning Error occurred while executing the workflow. Please contact support@zohocreator.com. My system admin thinks the zoho application may be corrupt since we have been seeing errors regularly. The error log shows the multiple errors. Sl.No. Time Message Details 1 23-Sep-2013 11:00:34 AET Error : Error Executing the workflow GLOBAL_SEARCH view script.
Need Some help!
Hello, The attached plot show a graph on some of available data for one well. The data is mostly coming from samples analyzed water samples acquired from wells at different timing. On this graph one parameter showing concentration of inhibitor (red line) is plotted. I want to make an overview showing all wells last sampled inhibitor concentration. In some wells the most recent data point may be 7 days old, on another well t might be 27, but I want to have them into an overview. As it is now I need
Setting date field to null
I've checked various forum posts about this, but not found a definite answer... How do you set a date field to null? I've tried datefield = null.toDate(); as suggested in one post, but that doesn't work in the new Builder. Thanks Alex
Allow edit access to support & Privacy.
Dear Zoho Team, What exactly can the Zoho personnel see when I allow edit access to support? I would like to understand any data privacy implications here. If Zoho has any stated policy in this regard, please point that out to me. Thanks. -Varun.
detect developer email
Is there a way to detect the developers email address? Under certain conditions I want to email the application developer. This may be the application owner but maybe not. It would be nice to have a Zoho variable zoho.developeruserid.
Total number of records entered in Zoho database?
My enterprise account allows up to 100K records. I have 3 databases hosted on Zoho. How can I determine the total number of records used? I can't find any place on Zoho that tells me the total number of records used. I can see how many users I have authorized, but not the number of records created. Please advise, thanks.
How to give a unique ID number incrementing by one?
Hi, I have a form for my users and I want to have a hidden field where the form will automatically assign a unique ID number to each user that fills the form. The ID number shall start with 1 and increment by 1 in each form submit. How can I do it? Many thanks, Vera
auto increment not working
I have an application with a master form and two linked sub-forms, one of which is for support tickets. I would like to have Zoho automatically assign a unique ID number for each ticket when it is entered. I tried following the instructions here: http://kbase.creator.zoho.com/application/auto-increment-field-values. However, there are two issues: 1. This only works when adding the ticket directly in the sub-form, but not when adding it in the master form. However, users will only ever enter support
if .... then .... image
hi is it possible that one field (image) is dependent on the second one? Image should be put automaticly (just like formula) depending to the value of the field Decimal e.g. DECIMAL | IMAGE 10 | image1 20 | image2
checkboxes in deluge ... how to access their lables and values ... I need help
My form looks like this : The list is dynamic (a lookup field with filter) I need to do something like this for each checkbox if (checkbox is checked) date = checkbox.label do stuff please help me with the script for this
Filter not working correctly
Application: https://creator.zoho.com/essistmgmt/assets/#Form:SITES Note, it is shared for support editing When I select CHINA from the COUNTRY * field, and select CHINA, then select the SUBURB, POSTCODE, STATE * drop down, I do not see any results I am expecting to see the one entry in the dropdown under https://creator.zoho.com/essistmgmt/assets/#View:POSTCODE_EXCHANGE_View?COUNTRY_CODE=CHN The behaviour is odd, since when I select AUSTRALIA or NEW ZEALAND from the country list, I always get results.
Recommended size of screenshot in publishing app to marketplace is too small...
When you add screenshot to your app you are going to publish, you will see this “165 x 145 px, optional”. The 165 x 145 px, is to small. It is just like a 2 x 2 ID picture and useless to present the highlight of the app pages. Putting optional mislead developers, other had attached images bigger than the snapshot viewer and still useless to present the highlight of the app pages. I recommend changing it to 640 x 480 pixels, it is equivalent to web image-large, enough to fit the snapshot viewer...
New App Builder : Field Size 'Custon' or 'Mediun' lazy coding or new words ?
In the new App builder, the drop-down box for 'Field Size' is not wide enough for the content, so Custom displays as Custon and Medium displays as Mediun (Google Chrome Version 29.0.1547.66 m) Whilst this is purely cosmetic/aesthetics, I would never release a piece of commercial software that has visible errors, which is why I continue to use 'Old Builder' only venturing into the New Version if I need a new feature......can't say I'm looking forward to the day it gets switched off !
Cannot find "Duplicate this View" in the new design interface.
I cannot find the "Duplicate this view" option in the new interface of Creator. In the old version, it was found in "Edit this application" -> More Actions -> Duplicate this View. I cannot seem to find how to duplicate an existing view in the new design. Please help.
Can't find Upgraded Creator
I was using the free Creator to make apps for our business Zoho CRM account. It was nicely integrated with the CRM. Now I need to move past the free account. Our account owner/administrator just upgraded to the Zoho Creator to the Standard paid version. I was added to this creator account as a developer. I was added using the same email I've used in Zoho CRM and the free Creator. However, I am unable to access any of the new features and Creator is still listed as a free account when I log in. How
Next Page