Customize mobile interface
Is it possible to alter the way the dropdowns appear in the mobile browser? I would like the Lookup fields that are formatted with dropdowns to function the same way that a regular dropdown field works when mobile browsing.
Duplicate Entry when changing field type
I'm trying to change a multi-line field to a Rich Text field and I get the following error. Is there a work-around? Duplicate entry '218933000003474087' is not allowed as duplicate entries already exist Herb Wexler
How to Share App with Edit Privilege
Hi, I just want to know that If anybody wants to get Edit Privilege to one of My developed Application in his account, how it can be done. It is possible in share the application with developer mode. Please guide me about. Regards NeedCom
Multiple Rebranding Logos in the Same Account
Is there a way to have different branding logos for different databases in the same account? Right now, it seems that only one logo can be applied for all of the databases in an account.
Rebranding needs significant improvement
A few ideas about rebranding - for paid users. 1. I should be able to upload a different logo for each app that I create. I do not want my logo to appear at the top of every app, I want my client's logo to appear there. 2. I have embedded my app into a frame on my website, when the clients go to the app, they are asked to login. I have done this because I do not want them to go to creator.zoho.com/.../.../..., I want them to go to my website and then log in from there. Therefore, it is very
How can i display a textbox based on user selecting one of the checkbox option
If one of the checkbox option for a field is Other i want to show a textbox next to it when user selects that option. How can it be done on a form.
Rounding a number
How do I round a decimal value in a formula field to the nearest 0.5. For example: I would like to round the number 24.20 to 24, and round the number 24.40 to 24.50, round the number 24.75 to 25.00?? Thanks
Now Break This!
Gaev's posting (http://help.zoho.com/portal/en/community?ftid=2266000000340340) motivated me to share my app that also does not use zoho auth . Rather, it uses a user's email and password. It's designed for a school project I'm working on, but could be adapted to others. Register or request a password reminder here. Login to your personal page here. Let me know if you can see others records or stumble upon some type of error. Right now, all the screens are delivered as separate web-pages outside
Bi-Directional Relationship With A SubForm.
Dear all, I'm struggling with 3 questions for more than 14hrs and still i didn't get solved. So any one can help me on this?? 1) How to fetch records from parent form and update records in subform using Script. Example : Form - Orders SubForm - Products When i select a specific order all the products related to that order has to display in subform and when i save, that has to save to "products form" as well as in "products subform". Even if i add products related to that orders in "products
Custom mail event stopped
I have a mail event that was working before I left for the holidays, but now it appears that it isn't working. Seems the last time it worked was around the 25th. They're both enabled. I'm not sure what if anything has changed. I have re-set the execution time to see if that would trigger it to occur, but even after the time passed, the debug information shows the next execution time is in the past. data2 { execute event on '2012-12-31' at '11:33' daily } I'm not sure how the debug information
Mount zoho doucments as virtual file in the local native filesystem and access using ms office or openoffice
Hi, I prefer Zoho because, Zoho has really nice formatting features, a lot more than google docs. Thanks for such a wonderful product. I was wondering if the developers were interested in allowing users to use MS Office to edit files when they like and use the online editor otherwise. Right now what any body would do is download the file, then edit it, and then upload it again, only to find that some other user already edited the file in the mean time. What I think would be cooler and more useful is,
i want to update the values automatically plz help me urgent
i want to update values automatically using zoho time. may i use if condition to update the values using zoho.currenttime in submit button . is it possible are not? plz tell me
CRM customization Drop down boxes
I am creating an app that pulls data in from CRM. When I create a drop down pick field for the CRM file, the result is a popup window and new search box. Is there a way to do this just like a drop down field for fields with in your app
The number X is not allowed for this form. Only certain numbers are allowed for this field.
Hi, I have a form created with Creator that I use on my laptop and my Android device. The form on my laptop is still working as before, but on my mobile, since a number of weeks, the form does not allow the input of decimal values anymore into an input field. The field is set up as Currency which worked perfectly before, but when I enter a decimal value and press the Submit button, I get the warning: "The number 2.5 is not allowed for this form. Only certain numbers are allowed for this field."
Formula field that calls a function that seeks records from another form does not seem to be working
Here is my scenario (simplified): I have a function - GetCount(string Name) that queries a certain form collection say Form2 and returns the count. I have another form From1 that has a formula field that calls the GetCount(Name) function. When I introduce this formula field, it calculates the count and correctly shows me in the View of Form1 at the begining and then all the values stay as-is even though the records in the Form2 have changed. If seems to be that the formula field in Form1 was just
Someone Please Help Me - ZOHO CREATOR - Forms, Views, Data Erased!! Urgent.
Hi, My developer deleted my forms and views for my ZOHO Creator that he was developing. Can someone please help me as I have very important information that is there. There was a mis communication between us and he is trying and he doesn't know how to get it back. Is there a way for Zoho to help me recover my forms, views and data from Zoho Creator? Can someone PLEASE help me. I am having a panic attack right now. Please, let me know.
Lookup Field error
hi please help me what is this error
HOW TO CHOOSE THE BACKGROUND COLOR FOR EACH LINE IN A FORM
HI:) WHEN I AM LOOKING ON A VIEW DONE IN ZOHO CREATOR ALL THE LINES ( OR THE COLUM ) HAVE THE SAME BACKGROUND COLOR, HOW TO GIVE TO EACH GROUP OF LINES A DIFFERENT COLOR TO MAKE IT MORE EASY TO VISUALIZE FOR SOMEONE INTERESTING ONLY A SPECIFIC SECTION. PLEASE HELP
what system field to use for manager's ID on every entry?
hi i have few managers with separate logins in zoho creator's app. i need mark every creator's database entry with ID of manager who add this entry. what system field i need to add to app's code so that this app will automatically add manager's ID to every entry?
Need to create a order form for my products!
Hi, I'm in the process of creating a ORDER and QUOTE forms. I have a list of my products and uploaded the same to my account in Zoho Creator. The problem I'm facing now is, I have 4 colunms in my product list (mentioned below) 1. Category (with 3 category) 2. Product Code (46 Codes) 3. Product Name (46 Products) 4. Unit Price (46 price) Now, when my customer select one from the drop down of "Category", the "Product Code" dorp down should show only the code associated with the selected category.
How do you import an excel/google document into zoho creator?
How do you import an excel/google document into zoho creator? Please let me know! Thank you
How can I integrate different applications created in zoho creator ??
I created two applications in Zoho creator. how can i place them in a single portal ??
Creator form showing duplicate fields in email
Hi, In one of our creator forms we are using lookup fields from Zoho CRM. After the form is submitted an email containing the entries are send to us using the "set email notification" option. But in the email the lookup fields from Zoho CRM are showing twice. I have attached two screen shoots showing how the from looks in creator and also how the email looks. The area marked with a red box shows the "extra" fields. As you can see these fields are also shown - correctly later in the email. How do
hide/show fields in subform row based on input. how?
Hi, Say I have an invoice form and included a subform that should hold lines of payment details for cash/cheque/credit card. Based on a dropdown field "payment method" I would like to hide/show enable/disable certain fields. E.g. if "Cash" is selected then I would like to hide or disable all input fields relevant to CC or Cheques etc, Kindly advise, Regards, Idan
look up formula
I need to some how set a field so that when a store # (i.e 11193) is chosen from the drop down list, it's populates the district # ( i.e. 222) automatically in the proceeding field. I am not in any way good w/ formulas and need help pulling this info from an excel spreadsheet. and please don't tell me to refer to the help guide like the person on the phone did. :) Thanks!!! -Melissa
One record to converted to many
I have an import from a parent company that delivers data like this. Example Import (today, this import shows a record = week of sales) Store ID, Item #, WeekofYear, Monday Sales, Tuesday Sales, Wednesday Sales Thursday Sales, Friday Sales I would like to convert as the records load to another table as a Record = Daily Sale. Store ID, Item#, WeekofYear, Monday Sales Store ID, Item#, Week of Year, Tuesday Sales Store ID, Item#, Week of Year, Wednesday Sales etc etc.. Therefore a record = day. Any
Set Default Gateway when creating an invoice
Is there a way when creating an invoice from Zoho Creator into Zoho Invoice and setting the PayPal Getway to Checked. We are currently creating 300 invoices at the first of each month and I don't want to open each invoice and Select the check box to enable a paypal payment for each invoice.
Subform script not working correctly
Hello! We are having some difficulties with the subforms script in some of our apps. The subforms have 2 or 3 lookup or dropdown fields. Sometimes they work correctly, but if we add some code in the other subforms fields (on user input) they stop working correctly, even if they are very simple tasks. E.g.: "Products" form contains all the products available with prices and category. In the "Order" form, there's a "Order Details" subform. Subform fields are: Category (We tried dropdown and lookup
i how do you create workflow with the forms?
i see how you can build a form. how do you add workflow? how can you move the user from one screen (form???) to another screen (form?) how can you add navigation buttons and link a form(workflow) to a particular navigation button? thanks
Using CURL to Edit Records
When trying to edit records with REST API via a CURL POST I receive a 2900 error. I am however successful when adding records. Here is the code I am trying to use in PHP to edit a record. I am convinced the issue lies with reloperator or criteria. $url = 'https://creator.zoho.com/api/xml/myApplication/myForm/update/'; $fields .= '&authtoken=<authtoken>'; $fields .= '&raw=true'; $fields .= '&scope=creatorapi'; $fields .= '&reloperator=AND'; $fields .= '&criteria=field=92';
Importing a csv file. Matching records and updating fields.
Hi, I have a 'Contacts' Form in Creator from which I export the following CSV file to email marketing software. Export File: ID,Title,Name,Email It returns a report after the marketing is done in the form, Email,Date,Status as below. example1@gmail.co.uk 2012-12-17 22:47:00 Email opened example2@tiscali.co.uk 2012-12-17 23:47:07 Email opened example3@btinternet.com 2012-12-18 21:18:26 Email opened example4@btinternet.com 2012-12-19 12:06:50 Email opened example4@btinternet.com 2012-12-19 15:34:21
Criteria
I am not a programmer and would appreciate some help. I have built an app to control the rental of vehicles. I need to ensure that I do not duplicate the hiring out of a particular vehicle. I need to search the database and if a vehicle is already rented out, someone entering data must be prevented from hiring out the vehicle again. How can one achieve this? Derek
HOW TO DELETE RECORDS IN ZOHO CREATOR?
hi how to delete all records in zoho creator by using Deluge Script, is there any help link pls send. thanks hareesh
Shared Users - Access to Print Reports
I have shared one of my apps with several users in my office. I have built reports for them to use, but the system does not allow them to download to CSV and print. They have full access to all reports and views. Any ideas why they don't have the CSV download function after they run the report?
Make radio button default
Hi I have a section where when joining the customer must select if they are male or female. as its a male orientated site, i want the male default radiobutton to be selected as default, but i dont know how to do this... thanks hareesh
radio button make checked
hi how to make a radio button default checked in creator Thanks hareesh
how to delete a "field" in form definition?
hi i have created some fields in a form, and now i have to delte a field from by using form definition script,i know how to delete visually, i want to delete a form field in field definition.
gmail
hi can i make all gmail users send mail to add new row to the database ?????????
Deleting children/detail records
When deleting a record in the parent form of a master-detail (Parent form to sub-form) relationship, I am finding that the children records are NOT automatically deleted, they are left as zombies! Does that mean I have to create a foreign-key field in the sub-form that relates to the primary key in the parent form? if so, then I have to create a deluge script on "Delete" at the form level to fetch all the related records in the sub-form and delete them. Am i correct on this, or is there something
Accessing a field in the parent form
I am trying to build a deluge script in a sub-form field (on user input) but I need to use a value from a field in the parent form. I thought they were linked together but I did not see the list of fields in the criteria section, so I tried the following: (Form_name.Field_name), but that didn't work. Example: I have a field "Gender" in a customer form (parent), but the detailed sub-form is where I perform calculation based on the gender of that customer. Can you see/access the parent fields
Next Page