new form field doesn't appear as a column in views
I hope someone from support can can help. Using the new builder, I added a new email field to my form. I want this to appear in all my views. It appears in one view but not in any of the others, even though I went through each view to make sure the new field has added (through column properties). Everything checks out fine, even using the old builder. I'm not sure what's going on. I've already provided support access to the application. Thanks very much for your help.
Performance issues possibly related to GApps integration
I am wondering if any users of large applications are seeing performance issues in Creator, possibly related to integration with Google Apps for Business. We have a large application (almost 2.5mb of code), and our sharing is based on groups created in Google Apps. We also import Gmail addresses and usernames into several forms. The application's owner/admin virtually never sees performance issues, and for him the application works quickly and flawlessly. But normal users constantly contend with
Can you move zoho creator to zoho recruit? Would notes still work?
Can you move zoho creator to zoho recruit? Would notes still work? We have a lot of records in creator so not sure if it would be worth the effort.
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.
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
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?
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?
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
Creator - new user
I have to say, after only a couple of days using the "Creator"... it is worth every cent!
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.
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
Checkbox list giving duplicate entries when changing text
When I change the text of items on a checkbox list I get the following error message. I am using chrome. I clear the message and continue typing and the new text is saved properly. This is not a show stopper but is irritating.
Multiselect from lookup
Is there a way of populating a multi-select list using a lookup? We have several stock items that continuously change which are input/managed in a 'Service' form. I want to use a multi select list on another form 'Subs' that calls these items for selection. We need as we want to be able to select combinations of the current stock from the list. Either that or have a 'add new' lookup button that will great a new lookup line. Is there a way to do this or is this a limitation of creator?
Powered by broken image
I have a couple html forms embedded with iframes. The place that's supposed to have (I assume) the zoho icon is broken. It says "Powered by" and then a broken image link. The image URL is resolving to this: https://creator.zoho.com/appcreator/live/01/images/ which obviously won't work. I don't mind having the link there - but I'd like it to point to a valid image. As this seems to be a system thing, I don't think there's anything I can do to fix it. Thoughts?
Data refresh on a data list or grid
My apologies if there is an obvious answer . . . I am new to Zoho and would like to create a web app, but need to know the following before putting in the effort. Suppose I am displaying a data grid or data list from, for example, one table. When a user edits data which would reflect a change in that grid or form, how soon will the change appear on all web page displays of that data on other workstations? Is it more or less instant as with Google spreadsheets, for example? I tried a brief trial
Hiding subform formulas
I have a formula field LOGISTIC STATUS in my ASSET form. I have a form CONTRACTED ASSETS that contains the ASSET subform. I want to hide the formula fields from the subform in my CONTRACTED ASSETS form. Note, my requirement is that I want some forms to view the field and other forms to hide the formula. I do not want to turn it off for all forms. When I try the following code, I get an error. Note, I obtained the field name by viewing the form definition. How can I hide the subform formulas? hide
Field Null Validation not working
Hi All, Here is my code: varLeadTime = ((input.Coaching_Start_Date - input.Entry_Date) / (1000 * 60 * 60 * 24)); if ((varLeadTime < 7) && (input.Why_now_Compelling_event_and_timelines_ == null)) { alert "This is less than 1 week notice. Please complete the 'Additional Information' section (Why Now?) to help us prioritize."; cancel submit; } Basically, it is a calculation of how many days notice someone provides for a request. If it is less than 7 days, the user must complete
Isolating date part of date / time variable
I have a date / time variable declared in a form. I am using it's data entry from a calendar view such that both date and time info is input to the variable which is called 'sched_time'. I want to show a grid view of today's records from the form called 'Case' and have attempted to use the criteria as below in the view script. show all rows from Case [sched_time == zoho.currentdate] This does not work and no records are ever shown using this format. I have tried to use combinations of some
Using the API to access a Creator DB.
Hi. I and a coworker have spent quite a bit of time looking for info on this and haven't been able to find anything that works. Here's what we're trying to do. We signed up for the free ZOHO account. We created a DB using Creator. It consists of names and addresses. The only way we want to use ZOHO is as a front end for entering data into this DB, kinda like Access. We want to then use this DB to fuel other web pages. So, if I have an entry in this DB named "FirstName", I need an example of how
Adding Formula results in blank form page
I added this formula to my form: and it results in my form no longer loading:
"Data will be stored in Zoho Creator"?
When I caret new form in new Form Builder, last checkbox ask "Data will be stored in Zoho Creator". What it mean? Nothing happens if I uncheck or check this checkbox...
HTML page...can one view force a refresh of another view
Title speaks for itself. I have an HTML page with multiple views incorporated into it. If a record is changed in one view, can I force a refresh of another view?
Grand Summary Formula Column
Hello. I want to put a formula in a summary row, and have no formula elsewhere. Specifically I want something that does this. See how the Three-Day Average Column has 350 in the "My Movie" Summary line, and is determined by dividing 3-Day Gross / Screens. I've tried everything I can figure out to try. I won't bore you with what I have tried. What works? Title Venue Three-Day Average Screens 3-Day Gross My Movie Astor Theatre 1 567 Average Theatre 1 133 My Movie 350 2 700 Grand Summary: 2 700
warehouse development
Hi guys, nice to meet you. I'm finishing the development of a company application to manage our warehouse. To create a selected list for product, i've arranged following script: lisart = List:Int(); for each y in magazzinos [(((stock_colli > 0 && deposito == doc.deposito2) && data_scadenza_lotto >= zoho.currentdate) && (protocollo_magazzino is not null))] sort by articolo { if (!lisart.contains(y.articolo)) { lisart.add(y.articolo); } } The problem is that "magazzinos" table
I want to map all CRM Leads into an Array in Deluge
I want to map all CRM Leads into an Array in Deluge so that I can access each record (lead) in a FOR loop. Any suggestions? Looks like so far I can only get records by ID.
Creator App Duplication Failed
Hi Zoho Teams, We are a IT consultancy team and zoho creator paid users. We aim to promote zoho to our local SME as it's a wonderful tool. This is our app: https://creator.zoho.com/luyiheng/ucdemo It's a demo for our client. However, when we want to deploy this to our client, we could NOT DUPLICATE this app. After click "duplicate", nothing happens. Also, we could NOT EXPORT this app. Please Help! Thank you very much! Best, Yiheng
Access Request/Zoho Privacy Policy
When accessed using the URL http://creator.zoho.com/[USERNAME]/[APPNAME], the user is not presented with an warning. But then, we've converted the primary account to a domain account, added a sub-domain to point to ZC. So when I use the URL http://[MYSUBDOMAIN].[MYDOMAIN].COM/[USERNAME]/[APPNAME], the user is presented with a warning that reads like below: --- By clicking 'Grant Access', you give Zoho permission to enable [MYSUBDOMAIN].[MYDOMAIN].COM to access all your user data available with Zoho
Can I make a app in Zoho Creator for my database in Zoho Reports???
I want a quick way to make apps for my database that I have created in Zoho Reports. Would like to use Zoho Creator, but cant see anyway of doing it?
Add records by status in ZohoCreator Reports
Some example function that adds record status by the creator of Zoho Reports? I want to add up all the forms that are as "Approved". Thank you.
catch post rest api response
Hello, I am using rest api to add new records to my form from my external php/javascript application: https://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html The records are successfuly added, but the response is automatically downloaded to the client machine, the customer doesn't understand xml/json/csv formats, so this causes a problem. Second, I want to use that response (the ID) to add other records that have lookup to that first added record. Can anyone help me?? Thank you
Looking-up a record from another site or location
Hello, I need help on how to connect and retrieve a record from another file that is located externally, on some website or network drive, without having to load the entire file into a table in my application? Is it using API? examples would be very helpful. I read the guide with GetUrl, etc. and that was somewhat confusing. I would really appreciate some help on this. Thanks
A question about fetching sorted records
http://kbase.creator.zoho.com/records/fetch-records-within-a-range in the above document, this: rec = Contact [ID != 0] sort by Added_Time range from 1 to 5; so, my question is, if I do a for each r in rec { list.add (r.Name); }Will it add Names from the records to the list in sorted order of Added_Time?
Mobile linking in HTML view
Hi, I'm adding some dashboards to my application, from where the users are being linked to specific views and forms. This is quite simple, linking to #View:<view name>. The problem is with mobile viewers. Since Zoho Creator doesnt support Javascript (why is that anyway?!) I can't change it depending on user agent or whatsoever. How do I solve this? Thanks in advance for your help.
Next Page