Chart View
I am trying to create a chart of information in my database and when I select 'new view' only 5 options appear and the 'chart view' is missing. Is there a reason for this? or how do I enable my database to make charts for example how many people take part in project x would be what I would want to display in the chart. Thanks!
How to Expand the Display of a Field's Length in a Form?
Hello, I have some user's entering in quite a bit of text into a multi-text field through a form and I would like for that multi-text input field box to display larger on the form. Is this possible? Thank You.... and killer product by the way. I'm so impressed, and I've used a lot of tools like this and nothing touches it.
Is Zoho suitable for a database like this?
I'd like to build a hosted database solution that will be website accessible with users logging in to provide tips and/or comments on previous tips. Users will also be able to vote up or down previously left tips. Online searches will be based on a couple of fields in the tips and will be ranked based on the votes up and down. Not necessary to login to perform the search. I'm sure I'm missing info so don't hesitate to ask if you can help out on the answer. Thanks.
Consuming Rest api - Authorization header for Oauth
Hi I am trying to consume a REST api. The api uses oauth 1.0 authorization header. how can i build the same? the following code gives an error: headerMap.put(Authorization,OAuth realm="https://api.yyyy.com/1.1/search/abcd.json",q="test",oauth_consumer_key="CubXzXXXXX",oauth_token="1605380557-gW4XXXXXXXXXXX",oauth_signature_method="HMAC-SHA1",oauth_timestamp="1374470468",oauth_nonce="wn1Are",oauth_version="1.0",oauth_signature="kdCPHM5XXXXXX"); Please help.
Multiple fields which update a single attribute
I am building a form for users to update ordering data that has already been entered, for invoicing. There are a number of miscellaneous items that can be added to an order, with associated prices. There is no limit to the number of miscellaneous items that can be attached to an order (equally, there might be none). I am thinking something along the lines of a drop-down list of all the miscellaneous items, which when selected would then be added to the order, perhaps with an accompanying field for
Script for changing form elements
Hi, I am a total newbie to this, so I'm sorry if this is a stupid question. Couldn't find the answer on search. I'm building a form with a lot of fields, that need to be selectively enabled based on the initial selection of a radio button. Rather than each radio button's function having a long list of enable/disable actions, I want to have one function that disables all of the fields. Each radio button would then call the function to disable everything, then just enable what fields it needs. I can't
Newbie needs help
Hi, I need help with how to post that a vendor has paid a PO when creating a PO form. Thanks, Cindy
Lookup Deluge fields
Hello When I set up a Lookup deluge field, in the Field Actions I want to set up a 'Parents_Trust_Name' field action, please can you kindly advise how I can do that? Thank you.
Record Level Access Control by Group - any better approach?
Record level access control by group is not supported by default, and I am looking for any way to achieve it by combining various features of ZC. When "userA" add a record, it is accessible only by him by adding a criteria like this. Added User equals to zoho.loginuser The same thing applies to "userB", "userC" and "userD". Now, "userX" is a supervisor of "userA", "userB", "userC" and "userD". I want to allow userX to access 4 users' records. My idea is to create one field, called "Permission" field.
How Do a I Create a New Record Using Deluge Script?
Say I have table Users and table Locations. Now, say I want to automatically create a location for a User when I save them for the first time. How would I do this using deluge? Thanks!
Invoice Payment Subform
Is it possible to use subforms to create a invoice payment form. I am trying to import invoice details to a form with information about the invoice (e.g. invoice #, invoice amount, invoice due date) and then create a form where the user can enter select an account and view the invoices that need to be paid. They would then enter the payment amount and select the invoices to be marked as paid. For example Account: XXXXXXX Date: 07/20/13 Amount: 100.00 Invoice # Invoice Due Date Invoice
if condition other form
Hi, I use a script condition in which if the Email of student it's founded in other form request and was authotirzed for a staff member (information in the same form) I show plain field (showing alert) and I hide a field (that suggest password, because was already comunicate in the other request). The script give no result expected. if (Count(Comunicazione_pagamento [(Email == input.Email) && (Staff_Tecnico != "")]) >= 1) { show plain2; hide Password; } Any help? THanks Mic
Form asking for user id & password
Hi, I have created a contact form and posted it at http://www.savitasreeram.com/contact-savita-sreeram/ Though the option taken is to allow users to access the form without login, it is still asking for a user id & password. Can you please help? Txs
How to handle web users in Zoho Creator and their passwords?
Hi, I just read that it's against Zoho policy to store passwords in Creator applications and this violation may result in account deactivation. Please advise how does Zoho propose to handle situation when a public application (embeded in public web) has to handle registered users. I need a web user to be able to come back and update his/her registration that I handle in Zoho. There will be thousands of registrations and thus also thousands of users out of which only fraction will actually come back
Hide input text using html code <input type="password" /> in the "Add notes" field type?
HELP!!! I need a simple, minimally secure username/password function to protect access to one of my view pages. So I am trying to hide the input text for a password in a form so that it looks like this: I cannot do it from within an HTML view because the limit on javascript in ZOHO creator prohibits me from submitting (as far as I can tell at least - please let me know if this is wrong because I'm an html noob). Thus I am trying to do it from within the form field "Add notes" which supports HTML.
How can I assing a default user to Zoho CRM Field user
Hi, When I add a new record in a BBDD, I need in event OnAdd -> OnLoad assign user default that it is adding the new record as a record owner. I created a user field (type Zoho CRM field user) but in my script I don't know how assign it. I try to write: input.user = zoho.loginuser; But how they are different types I can't to asign it. Can anyone help me?
adding record via POST method
Hi, We have created a html file with following data <html> <form method="POST" action="https://creator.zoho.com/api/xml/interface/Simple/add/"> <input type="hidden" name ="authtoken" value="xxxxxxxxxxxxxxxxxxxxxxxxxxxx"> <input type="hidden" name ="scope" value="creatorapi"> <input type="hidden" name ="Name" value="Me"> <input type="hidden" name ="DOB" value="01-jan-2010"> <input type="submit" value="Add Record"> </form> </html> When we run this file through a browser it generates a button on the
Print a two week time sheet on to 1 page instead of 4
Hi I am in the middle of making a fortnight time sheet form in creator and when I test the summary print option the record is in the middle of the print page view and there will be about 4 pages... All I want to do is get it on to one page (using the whole page) or at the worse get it on two page so I can print both sides.. https://creator.zoho.com/<owner name>/<application name>/record-print/<view name>/<record id>/
Security Groups in Deluge
Security groups are a great way to partition what users can and cannot do with forms and views. However, the granularity stops there. There are no deluge commands to reference security groups for specific form actions and controls. For example, I have a work-order form process that requires one field to only be editable by admins. If I hide the field in the form, nobody can access it. So the hidden aspect must be a function of who's in my admin group. What this means is that I have to recreate the
Please help! Lookup fields
We have a main database that we input all details into. We have another database where we used a script with a Lookup field to pull details across. I want to create another database that uses the same script and Lookup field to pull details across from the main database but it wont work. Can more than one Lookup script be used on the same database?? Thank you in advance for a speedy response.
end of week/month
hi guys, i hope you can help me to solve this problem. I have a form called "clients" where i set payment terms of them and apply it on every invoice. If i have scheduled payments with "n" days starting by invoice date, i haven't problem to obtain the "due date". The problem is when i set payments with "n" days starting by the end of the month or the week. Can someone help me? Thanks in advance bye
Comment lines changing location
Hi, It's not a major bug but I have noticed that when I add comments to code, they move around Eg When I try to save the following code if (input.ORDER_TYPE == "CHILD") { show SHOW_MILESTONES; } //Show child form hide SHOW_CHILD_FORM; It get's changed to the following when I refresh if (input.ORDER_TYPE == "CHILD") { show SHOW_MILESTONES; //Show child form } hide SHOW_CHILD_FORM; I'm finding my comments move away from where they should be. Can someone please investigate? Is anyone
Webhook to an existing Creator list
I have a list of customers in creator which was imported from CRM data. A decision has now been made to update our CRM subscription to allow webhooks, while it's straight forward on how to set the functionality up am I going to be left with duplication of customers once the webhook starts exporting i.e. when the data imports to creator will it recognize the existing customer name and update data rather than creating a new record?
Alert box size
This isn't a major issue but I have found the size of the alert box to be inconsistent. I've taken a screenshot of one my alert boxes with the text removed. I show the alert when the user modifies a field. The first time I see the alert, it is a long slim box. When I close the alert box and change the field again, I see the alert box but much wider. The second layout is much more preferable. Is there a way for Zoho Creator to show consistent alert boxes that match the second screenshot?
We are unable to fetch this data problem!!!!!!
I'm trying to access my database "suppliers list form view" but it prompts the following error: We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com I've also tried to deleted a field and create another one on the same form but I just can't do it. Could you please help me to fix this problem asap. Thanks. Regards, Rodrigo Balotin
Can you move data from onen form view to another?
Hi, I essentially want to have just one form, and then have a multi-select which allows me to choose 1 of 3 options, and based on which of the three is chosen that determines which view the item goes to. For example, if i wanted to manage inventory i could have 3 choices: active, new arrival, coming soon So when I enter a new item coming soon i would select 'coming soon' and it would be displayed under the coming soon view', once the product is available i could edit the record to 'new arrival'
VieW only
Is the application a VieW only or can people that log in change the app like I can?
Hiding and showing fields for groups
I have a field in my form that I would like to show just to members of one group (which I have created) and the admin user. I know how to hide the field from everyone other than admin, but is there a way to then show it to a particular group, if necessary by iterating through its members?
Can I create a dropdown populated with user logins?
Hi Looking through the docs and searching I haven't been able to work out how to do this; I don't think it's been asked before. Is it possible to create a dropdown that is dynamically populated with the login names/emails of users who have access to the application? I'd like someone filling in a form to select from the list of users and the form to fire off an email to the user when the form is submitted with the details of the form (I'm sure I can do this using Deluge but I don't have access
Hide A Formula Filed
When I try to hide a formula field the following error message is displayed. hide/show/enable/disable fields is not applicable for formula field Is there a way around this yet Thanks
DATA PROTECTION
Can data stored in Zoho Creator be protected (or made read-only)?
Is anyone experiencing problems with emails not being received by users from Zoho Creator today?
I have added three new accounts today to my version of Zoho Creator and not one of the users have received an automatically generated email inviting them to log into the system, which should normally happen. The emails are not appearing in their spam filters either. Has anyone else experienced any similar problems today?
Creator - new user
I have to say, after only a couple of days using the "Creator"... it is worth every cent!
Login using Username instead of email confusion
The login page for my Zoho Creator app asks for email and password. My users have a username that is not an email address. This has confused a few people. I think it should say email or username.
How to determin or edit Username
I am trying to configure access control by user name. My approach is to create a folder for ACL and type user name in it. This actually works. ACL == zoho.loginuser I just need to enter user name in ACL field in advance. The problem is that I do not know how Zoho system generates or determin the user name, and I am wondering if there is any way to edit the user name. I created my admin account with my email - sysadmin@mydomain.com, and my user name became "sysadmin." I created another user account
I can´t update a rec
I am trying to update a rec with the following script recibo = Recibo_de_Caf[N_mero_de_Recibo_ == input.Recibo_de_Caf.toString()]; recibo.Estado_="Anulado"; But when I "run" the app it show me the following message: What is the problem, What am I doing wrong.
decimal field, but won't register decimal places
Hi, i have a decimal field set up in zoho (2 decimal places) but when i put in a value with decimal places it doesn't accept it. how do i fix this?
hiding fields in views
I have a view that has something like 60 fields/columns. For each of my records, however, only 10-20 of those 60 fields may be filled in. The other 40-50 fields are empty. When I am viewing, I would only like to see the fields/columns that are actually filled in with data. If there is no data in a field, I would like to hide that field/column. Any idea how to do this?
magento
hello, I want to add a drop down list on home page so that user has an option to choose magento theme. thanks.
Need help in REST API via browser
Hi everyone, I've been trying to add a record to my form thru the browser using the below link... https://creator.zoho.com/api/xml/junapp/MyForm/add/?authtoken=XXXXXe&scope=creatorapi&First_Name=Me&Last_Name=Myself and always getting the error message below, anyone else has this issue? An error has occurred. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. cheers
Next Page