Date Filed not displaying
Hi, I 'm having a bit of an issue displaying a date date filed when trying to Set Criteria for a view. The field is viable everywhere else, excpt under the Set Criteria area. I it is not vislae in order form me to chose it as a criteria. Thanks.
Make each user only be able to view records that apply to them.
I have a form that customers fill out and Users/Sales Reps will have access to the records. What I want to accomplish is for each User to only be able to view the records that apply to them. I have chosen a User ID field to be the identifier/filter for this, but I'm not sure if this is the best way to do it. Also, I'm not sure how to set it up on the backend. Would there be custom DS involved in this? Any help on this would be much appreciated. Thank you, Mike
Mod is not working
I made a function using info in this post: https://help.zoho.com/portal/en/community/topic/how-to-randomly-generate-a-3-digit-number It only returns a ZERO each time. Also fails in an HTML Cheers, John Whitney
disable mandatory field?
I want to conditionally disable a mandatory field, but can't get this to work! I have three payment options. If someone selects "Credit Card", I want the PO# and Account# fields do disable, but this doesn't seem to be working. I currently have PO# set to be a require field, and this seems to be causing the problem. Maybe I should simply define the goal instead of the problem: I want the user to pick either Credit Card, PO or Acct# - this is a required selection. I then want a new field to
I can't edit my application
Hi, The app I'm trying to edit is https://creator.zoho.com/zohocreator/cobe123/zc-tutorials-15-0. It was working fine yesterday and all of a sudden, I can't edit it anymore. It gives me a blank page. Someone please help. Thanks
How to attach pdf document of record in Email templete to send these attachment on a custom action in zoho creator
How to attach pdf document of record in Email templete to send these attachment on a custom action in zoho creator
Back Up Failed
Multiple attempts at backup have failed, with the following message java.sql.SQLException: java.sql.SQLException: java.lang.Exception: cannot getConnection when the Txn Status is STATUS_MARKED_ROLLBACK Exception occurred during get connection from datasource Please advise Regards Mark
Need a form to send an email to a client, retrieving the email address from another form in another app
I have a form (call it formA) in an application (call it applicationA) in which I register all my clients service requests. And all the information of my clients are located on the client form (call ir formB) on a client database application (call it applicationB). What I want to do is for the applicationA to execute an action, "on add" / "on success", that sends an email to the client with a confirmation of the service request registered on formA, using his email (the client´s) located on the client
Broken LInks in help files
At least the ones associated with this topic: http://www.zoho.com/creator/help/url-pattern/functionality-based-urls.html#To_convert_HTML_view_to_PDF
link does not load and application is restarted
Hi all! I am trying to develop an application for data collection for a master thesis. I have a form where people have to encode some words according to a rule in a certain amount of time. After they submit their answer they press Finish and should get to a form that would show them their score. I built an HTML view that loads 2 Zoho forms, one with the encoding algorithm and one with the exercises. Since I couldn't built a timer in Zoho, I had one built and stored at a certain web address. All Zoho
Please help me solve this GENERATEJS_TASK task error
I am trying to fetch a record and update a stateless form with the results. I have been getting a cascade of errors; Error in executing On Add-On Load script; Error; Error in executing IF rule: Error in executing If block; Error in executing For Each Record task; and finally Error in executing GENERATEJS_TASK task. The section of the script that is causing the error looks like this; if (input.Email1 != null) { for each myPhys in X_Physical_Profile [Email1 == "xyz@gmail.com"] //hardcoded the
Tooltips on buttons in new editor not saving with FF or Chrome
Here's a video demonstrating the problem in Firefox 20.0.1. The same problem exists with Chrome 26.0.1410.64 m Thanks, Jeff
Please help a newbie
Hi, I'm trying to create an extremely simple registration form to embed within my moonfruit created website. I need to capture basic name email which is fine, but I also need to get people to select from a pre populated list of schools. As there are over 16,000 in the UK I need people to be able to to first click on their county. This will then bring up only schools which are within that county. Can someone tell me how to do this?
show action in view header
I recall a discussion of always showing custom actions on top of the view for actions that are not record specific. Currently they only show if the user clicks on a record. Since the action is not record specific the user has no reason to select a record. Is this on the roadmap? Herb Wexler
Has the validation on eMail field Changed ?
My users have been successfully using my applicaiton for over a year, but last week, an error message started to be displayed : Enter a Valid Email address.... The address it doesn't like has an apostorphe in it (example john.o'reilly@domain.co.uk) An apostorphe is a valid character (if it occurs in the name, prior to the '@' symbol) Please advise if the checking routine has changed, as this worked and has worked for one year ! Thanks Neil
URGENT! Filter on lookup field not working!
Hi, I use filters on lookup fields as follows: Lookup A = Company Names Lookup B = Items by Company (filtered by company name) Lookup C = Item type (filtered by selected item) I was able to add the filter to Lookup B without any issues, but no matter what, as soon as I move to another field and come back to Lookup C, the filter I add disappears. Please Help!
Create Formula in Reports other than the Aggregate Formula
Exploring through the Report Tab in Zoho Creator is very easy and convenient, however, I have some problem regarding on producing the right output. I wanted to create summary report where I can collect the sum of the values, identify the highest and lowest value, or the most redundant value within the recordset. Browsing through the sub-form upon clicking "Add Agreggate Formula" in the left panel of the report tab (see image), i found different options from the Click to Insert Functions dropdown.
Using a formula to count non-numeric row
Hi, I am having trouble creating a View I need from a form. I want to count each text input in a row, but am having trouble using this formula: "Lead MP + JGA + TF + PB + JD + JA + CS + CM + MF + KC + AW + SS + MB + DB + MC + DD + AG + CA" Only 4 of these fields will ever be selected at once, so an example of what this returns in the formula field I created is: "NullJGANullNullNullJANullNullNullKCNullNullNullDBNullNullNullNull" What I want it to show is: "4" Is there a formula to do this? Thanks,
Updating record in zoho creator using webhooks in zoho crm.
Hi, Is there any way to update already existing record in zoho creator from zoho crm using webhooks? Thanks Nidhi
Purposely update only the first in a collection of records
I'm trying to build a simple inventory management of printer resources for my school. One table contains the Inventory of our printer cartridges; each individual cartridge has its own record - so, for example, there are three records, one for each of the three Q1234 cartridges in stock. I want to be able to update only one of those records - when a patron "checks out" one cartridge of that model, the records matching that cartridge number are fetched (multiple records), but only the first of those
Multiple Sections in Zoho Creator
Hi All, I need to create one form, using Zoho Creator. Now the problem is, i am not able to find how to create different section in it. I am using 2 sided layout. For example, i want to create expense form, in which below are section and field. User Information - ID - Date - Head Quarter Travel Information - From - To - Mode of Transport - Fare/km - Total KM - Total TA - Daily Allowance - Trip Description Other Expenses - Courier - Courier
Zoho Creator
I would like to use the Creator tool to send a request to a web service which returns a list of records (in XML) and then display those records in a View. I do not see anything in the documentation which lends itself as a good starting point. Can you provide an example application or documentation on how to integrate data from a webservice to a Application View. Thanks!
how get linkSubViewCompId
Hi I want to open a summary view when click Decision box,I saw your system sample code as bellow: https://creator.baihui.com/lg8888b/jk/record-summary/view1/72686000000012866/ZC_REC_ID=72686000000012866&linkSubViewCompId=72686000000081256&linkedViewAppLinkName=jk&linkedViewLinkName=view10&isSubFormLink=false but I don't know how get the "linkSubViewCompId=72686000000081256"? if know can I open the summary view? Hope your help Thanks Stanley Guo
Can I embed a creator report in a crm tab?
I have a daily sales graph that I created in creator, but will not show in crm tab. I can see the database and grid views, but not report views. Is this a limitation or did I do something wrong.
View - Edit, Delete, Search etc. no longer working
During the editing of a newly added record in a veiw, a problem appears to have occurred whilst saving changes, which has resulted in the loss of editing, delting, searching, in fact, I can no longer do anything with the view other than look at the existing records. All other views in the same application are unaffected. Mark
Purposely update only the first in a collection of records
I'm trying to build a simple inventory management of printer resources for my school. One table contains the Inventory of our printer cartridges; each individual cartridge has its own record - so, for example, there are three records, one for each of the three Q1234 cartridges in stock. I want to be able to update only one of those records - when a patron "checks out" one cartridge of that model, the records matching that cartridge number are fetched (multiple records), but only the first of those
How do I check if an input field is visible?
Hi, I'm trying to using Deluge script to evaluate whether a field is visible or not, but not sure of the syntax. Is it something like input.Field.visible = true? I basically want to write, "If field_x is visible, do this; if field_x is invisible, do this." Any help is appreciated. Thanks.
how to show the distinct values from reports database table in a dropdown field of stateless form
how to show the distinct values from reports database table in a dropdown field of stateless form... i was getting error when i used code example as given here https://reports.wiki.zoho.com/Creating-Data-Entry-Forms-for-Zoho-Reports-using-Zoho-Creator.html#check%20data%20in%20zoho%20reports by prameena>>>
Error while getting values to a dropdown from Reports table through api call.......
Hello I have a problem in fetching data from reports in dropdownfield in a stateless form , i m getting this error ("unable in executing set variable task and error evaluating string expression ,invalid xml/json format") i have attached the same code below <with wrong password and username and api> // Gets the authentication for your account. ticketDetails = getUrl(("https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=123456&PASSWORD=abcd")); ticket = (ticketDetails.toString()).subString(((ticketDetails).indexOf("TICKET=")
CATASTROPHIC FAILURE - All script dropped from my Form and not present in Version or Trash. It.Just.Disappeared.
Planning to demo to my manager tomorrow as a means to sell the product into the company as a viable enterprise-level product. I am currently on evaluation and have built an app to automate some of my teams more arduous tasks. Making some finishing touches to roughly 2 weeks worth of work, when I access the application and none of the scripting appears to be functioning. Back into Script Builder and Zoho has dropped ALL code from one of my forms. That's several days worth of work in validation and
REST API - List Applications
Hi guys, I tried to follow this: http://www.zoho.com/creator/help/api/rest-api/rest-api-list-applications.html In here: <form method="POST" action="https://creator.zoho.com/api/xml/applications/limit=20"><input type="hidden" name ="authtoken" value="************"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="submit" value="List applications"> </form> How can I make this get/post request? I tried variations of: requestMap = map(); requestMap.put("authtoken", "valid authtoken ************");
As an Admin, How do I upload avatar/pictures for my users?
I am an admin for ZoHo. I have a team of 11 Sales Reps that I want to upload a picture of each of them to their ZoHo account. How is this done as an admin?
Login page for non-zoho account -
We are Pharmaceutical company, started building our CRM application on Zoho. Apart from CRM, we also need to have some forms which can be used by our employees, without having Zoho User account. For example, - Medical Representative would travel City to city for marketing purpose. - We are planning to have an form (expense form), through which they can submit their daily expenses, so that at the end of the month, we can reimburse those expenses - For this purpose, we need to create a form using
Difference between Personal and Workspace app
Can anyone enlighten me as to the difference between the personal apps and workspace apps. If I'm just trying this out to see if it will fit in our organization and want to eventually share the "app" database I am creating with my team, can I use personal for now and still share it with them later? Looking at what we need to do to create a workspace app is more than I really want to tackle at this point.
"Powered by Zoho Creator" logo is not displaying in HTML views
Hi! I notice that Zoho Creator banner in HTML views is not displaying. Powered by https://creator.zoho.com/appcreator/live/01/images/ -> 404 not found Cheers
Unable to save notes field with new App Builder
I switched to the new Creator interface - wow! I really like it! I think I've encountered a bug with notes fields. After I add it to the form, then edit the properties by adding text into the notes area, the "Done" button doesn't do anything. Thanks, Jeff
Auto number generate based on lookup/customer type
I've added an auto number generator to my form based on http://kbase.creator.zoho.com/application/auto-increment-field-values. However I need to go a step further as the job number that will be generated in my app need to be based on which franchise the customer belongs to, so I've renamed and duplicated the 'MaxValueHolder' form/view so that 'fr1valueholder' starts numbering at 1000, 'fr2valueholder' starts number at 2000, etc. My confusion is how to implement changes to the validate script(s) to
Doc link not loading in Creator
Team, This seems to be an ongoing issue. When linking a Zoho Doc link in creator the file does not show. Several blogs over the years attest to that bug. I was hoping that with the new DOCS 3.0 upgrade, this bug was addressed. I'm not an expert in Creator but I can't make a Zoho doc doc file link download. I placed a blog with the DOC team hoping a team approach could fix this bug Team, You have done a great job upgrading this platform. I have been testing for the last few days and most features
How to remove zoho logo from the embeded forms?
The forms created by zoho and embeded into a web page show zoho logo at the bottom right corner of the form? Is there any way to remove this logo and replace with another logo/hyper link? Ansari
sendmail - sending a email coded as HTML
How do I sendmail as HTML code rather than just plain text, I have added my HTML code, script just rejects it DC
Next Page