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
Problem with zohocreator.exe import
When using zohocreator.exe to upload csv files into a form, there appears to a file naming convention issue.. For example, the following command picks up all the PS* csv files in the same folder Eg : zohocreator.exe c:\myfolder\PS2.csv john mypassword -e order-management -a Order_form imports PS2.csv as well as PS1.csv There also seem to be some issues when Excel is open, but that might be related to the above. The above error is adding incorrect records to the form - please advise.
Auto update child form when parent form data is update?
Hello guys, I'm really in stuck with this issue. Here is the scenario. App: apparel costing system. Form 1: Material which have Fabric {cotton,silk,fleece..etc} Price {100,200,300,400..etc} **100usd/1kg for example Form 2: Product Costing which have Product Name Norm {0.3,0.4,0.5} **0.3 mean 0.3kg/product Fabric : lookup from Form1 Price: fetch record from Form1 with criteria form2.fabric == form1.fabric Fomula: form2.fabric * norm (product price) Everything quite good when create new product calculation.
Assign Pay Rate to Team members
Hi, I have a workAssingment app that i use to assign tasks to individuals or to Teams. my issue is that not all individuals are paid the same rate and not all teams are comprised of the same people. Also, pay rate per job varies. Thank you.
Can't generate private permalink
Hi support, I haven't use creator for a long time, and I can't generate the private permalink rite now. Suppose the url look like this https://creator.zoho.com/2217098/education/view-perma/aboutus/Q3NK0G00nsTDaxzrZbBCWCdSRprgxQ9aDuq7mRj1m7ObAt1kfymNU4ENKmOprQJEVhgTyXAgPTmW3V but now look like this https://creator.zoho.com/2217098/education/view-perma/aboutus/ZC_PUBLIC_REQUESTED/ how can i find the code? Thanks.
Can I access database information from my website?
Here is what I am trying to do, will this software allow me to do this? I will have a basic database of names and contact information that I would like a page on my website to pull from. For example if I push someone to www.mypage.com/janedoe that page will pull basic data fields from my database and fill them in. It would be different for each page. Will Creator allow me to interface with my website?
Conditional formula not working
Hi I am trying to use conditional formula in my form to calculate a value from 2 other fields in my form I am using if((Chargeable > Weight),Chargeable,Weight) to calculate Price. But it always returns the Weight value instead of the correct one. Chargeable is also a formula that is calculation by multiplying 3 other fields in the formula. Weight is just inputted. Please help. thanks Antonis
Tables in zoho creator forms
Hi, Is it possible to add a table to a zoho creator form? In my case, I need users to enter a balance sheet to a form. The data entered will then be calculated and presented in different formats. Thanks for any help!
Is user activity tracked and how do you report the info? And how to backup application data on daily basis?
If users edit and delete records, is this information tracked? How can it be reported? Do I need to code tracking specifics? Is there a way to automatically backup record data?
User parameters
Good day, I'm waiting with impatience when you will make system table (or Form), where developer can see all users with access to application, and developer can create fields in this form (like in other forms in zoho) to assocoate different parameters with users (and also lookups to existance forms). And very important is to have ability to use this extra user parameters in criteria fields, deluge scripts and so on. So, for example, if I have add "group" field to this Users parameters table, I can
View application under specified user/group permissions
Hello! I'm very missing feature to access applications under specified user/group permissions. It's very usefull to understand how application is looked like and can be used for some users. This mode can emulate only permissions, userlogin and userloginid can be real
Passing parameter to form field
Hi, Anyone know how to passing parameters from View to the Form and theirs field using script? I know this metod with URLs, but I want to use script for that. https://kbase.creator.zoho.com/forms/passing-parameters-via-url
Can't Use Lookup Fields in Reports?
I have a form with a bunch of lookup fields in it. I'd like to create a report on this but in the report builder non of the columns that are for the lookup fields show up. Do reports not allow use of these fields? Is there a work around for this? Many thanks! G
Where is publish option?
Hi, I checked tab "Developer Zone" but i can't find option "Contribute your apps to marketplace" (as per the help @ http://zohocreator.wiki.zoho.com/Publishing-applications-to-market-place.html) plz help me.. i need to transfer the application to my fellow team member who will be working no onwards. A quick reply will be highly appreciated.
how to itterate through items of a multiple select list on related form? help me understand for each with lists
I have a Child form, with fields Last_Name and first_Name Parent form has from called Children which is a multiple select list .. picklist to Child form In Data form, drop down field to select Parent, and a Notes form called listOfChildren to display list of Student names. listOfChildren = myParent.Children gives me a list of Child ID's like 12234233, 1231342 I need the children's names John Smith, Jane Smith (given that John is First_Name and Smith is Last_Name
zoho.loginuser to show full name instead of username
Hi, Can the command zoho.loginuser show full name instead of username. I have several field which i want to default to the user that can then be changed to other users (full name) that are in our system. We are using our system internally so the users will be set up by an admin therefore there wont be users accounts that doesn't match our list. Thank you in advance!
When ZC can support safari or iPad?
Hi When ZC can support safari or iPad? Thanks Stanleyguo
An If statement based on the difference between 2 fields.
How would i go about writing an if statement to says if (x is +/- 1 or more of y) { Do this action } else {}
Upload files to Writer.
We know that Creator is not integrated with Writer,Sheet,Show, so if I want to upload files to Writer via Creator Upload field and Writer API, how should I do then ?
How do I control the defualt pop up menus in a view?
The menu for delete, add, edit fields that comes up in standard list view, how can I hide it? Or just allow view?
Line numbers are wrong in HTML view error messages
Hi Zoho, I want to alert you to an issue with the error messages for HTML views. The line number reported in the stack trace is incorrect. It seems to reset every time I break up deluge script with an %> It makes it very difficult to debug code in HTML views.
broken link in creator help
http://www.zoho.com/creator/help/fields/add-notes-field.html link to " Display Custom Error Messages" goes nowhere
Sign-up for Free Page
When a new user is directed to "sign-up for free", the sign-up experience for the user should not also be used to advertise zoho email and the zoho newsletter. I just did a test run with a new app and this is the feedback I got: they found it confusing why they would be making a new email address and what this newsletter is all about. Otherwise the sign-up experience within the application context is good. Cheers, John Whitney
User Input with digits and letters?
Hello, i have this code: if (!(input.Galileo.toString().matches("^\d{3,4}$"))) { alert "Office ID Galileo should be between 3 and 4"; // cancel submit; } but it only work with numbers, how can i get him with letters and numbers? regards Carsten
Workflow is causing data duplication in Creator
I setup a workflow alert following https://lounge.creator.zoho.com/tips-and-tricks/fetching-leads-from-zoho-crm-into-zoho-creator-automatically set for created or edited record, the data is copied across to Zoho Creator. However if the record is edited again it will recreate the record in Zoho Creator. Is their a way of preventing the duplication and still having the Zoho creator record updated. I tried not allowing duplicate records for the name field which results in an email saying data can not
New Form Builder Suggestion
It seems to me the new form builder should have a delete button to delete to form rather than going back to the dashboard to find and delete the form. But, also leave the delete function on the dashboard. Also, if there's an error when attempting to delete a field, the pop-up should hyperlink to the section in question as a new page. Cheers, John Whitney
Next Page