You have reached maximum number of rows. You can not add further
When I try to use a subform and add an entry I am getting the following pop up message that prevents me from adding new items in any of my sub forms across all creator applications: "You have reached maximum number of rows. You can not add further" Seems pretty self explanatory except we are no where near our record limit so this doesn't make sense. Is there a way to increase the number of rows allowed? Clearly either i do not understand what this message means or there is something wrong with
Update formula field with schedule
Is there any way to update a formula field that calculates the number of days between the current date and a future date using a daily schedule? I know you can't get a formula field to automatically recalculate (totally ridiculous but let's ignore that now). Is there a way to use schedules to update the formula field or another field that contains a number? I'm thinking pass the difference between the current date and a future date to a numeric field. Then on a daily basis use a schedule to subtract
Delete User After form is closed? Unshare/ deactivate users shared to app?
I am trying to delete users as soon as they use the application that I have set up. Is there a code that could help me do that? I tried "unsharing" the user in the "on success" part of the application but it doesn't seem to unshare the user at all. In fact, the command seems essentially pointless. I need users to log in so that an email can be sent from their prospective email addresses, but then I would like said user to be automatically deleted from the account. OR If there is a way to use their
Mobile forms
Hi, Is there an option to turn off the zoho header on mobile form? I can understand why Zoho doesn't support customization in mobile, but the ability to turn off the header should be available. Something like ‘form-mobile/formname/zc_Header=false….’ Having the ability to link to mobile forms without a menu back to the entire application seems like a big oversight... Is there a workaround for this? Thanks in advance.
Anyone else having issues posting a requirement on Marketplace?
I have reached the limit of my capabilities and was looking to post a requirement for developer assistance having a new html page populated with fields from my database, but every time I attempt to post, I just get a posting error. Anyone else having trouble with this?
How to specify the start marker for the form
I am new and I have created a survey form in zoho creator which I have embedded on a webpage. When the survey loads it loads at the bottom of the survey instead of the first field. Is there a setting I am missing or some other task I need to do to specify the form load at the top at the first form input field? Thanks
Help with a formula please
I need some help with the following code please.... visitDates = Signing[(Run_Number is not null)].distinct(Run_Number); for each dt in visitDates { code = ""; for each r in Signing [(((Run_Number == dt && Post_Code != "") && (Post_Code is not null)) && Job_Status != "Completed")] sort by Time_of_Visit { code = code + ":to:" + r.Post_Code; } for each r in Signing [(Run_Number == dt && Job_Status != "Completed")] sort by Time_of_Visit { //r.Map_Location
Variable sales price
Dear, I'm currently testing Zoho to replace our excel based order and quotation system. Up to now everything what we need seems to work but 1 thing I can't grasp. Hope someone of you knows how to tackle this... The sales price of our products are depending on the order qty. for example: from 0 to 5 pieces = 10€/piece from 5 to 10 pieces = 9€/pieces from 10 pieces = 8€/piece I would really appreciate any guidance on how to approach this? Kind regards, Noel
Zoho Creator Blues
Is anybody else having problems sharing apps in Zoho Creator? About a week ago I started getting calls from Users with whom I had shared apps. They were logging in as usual but getting an error message: You have logged in as (xyzabc). You are not allowed to access this view. When I checked the apps it showed they were still listed as shared users. I had not exceeded my user quota. My own login (as Admin) was working fine. Despite all that, when I tried to log in as them, I got the same error message.
Setting criteria for execute script with .getDayOfWeek()
Good Morning, I'd like to create criteria for execute a schedule. My intention is to have an alert with differencial text based on the days missing for the event and also according to the day of week in which the event will be occured. The first step is done, how you can see from the image. I used DATE.FIELD= zoho.currentdate.addDay(2), in this way the mail will be sent when missing two days, but I had problem with second criteria. When I try to differentiate the days of week to have a different
Linking a subform after data import
Hi, Im trying to import my data and structure from an access database into Creator. While the import works, after I have edited the forms i want to add subforms based on their relationship. I can set this up but there is no way I can see that links the 2 records. Please can you show me how to link a subform to its parent after data import? Thanks Amy
Unable to open attachment files in Google Doc Viewers
Even though I imagine this is not your top priority. I'm looking for a way to attach documents in the system PDF or DOCS and be able to view them in the browser. The problem is that Google Viewer does not work with Zoho attachment links. I've tried to translate a working link here: http://docs.google.com/viewer and copy paste the address to the browser address bar, google is stuck with translating DownloadFile.do script. Any chance you have a work around to not download attachment, but work more
Record Summary customization problem
I am trying to set up a record summary view very similar to the sample invoice shown on this page: https://www.zoho.com/creator/help/views/record-summary.html The problem I am having is that the subform area (like the Item, Quantity, Price fields on the sample invoice) are not displaying multiple records. Instead, they show the multiple items in one field (like instead of showing two records for Item "Widget A" and Item "Widget B" they show one record and list the Items as "Widget A, Widget B."
Currency field not formatted in HTML View
I don't know if this is a bug or expected. A currency field that is appropriately formatted for a normal view, is not formatted when using the <%=field%> tag in an HTML View. I am having to hard code format it. Please advise if this behavior is expected (and why)...or is it a bug? Thanks! Robert P.S. By formatted, I mean it is not rounded to two decimals, there is no currency sign, and there is no comma insertion.
Custom Button Function
Hi There I have created a Stateless Form with a Custom Button, in order to copy records from one form to another. My Script is: for each x in Project_Info[ID!=0] { insert into Install_Project [ <Job_No>=x.<Job_Number>; <Project_Name>=x.<Customer>; ]; } I however get an error on Line 1 - Improper Statement Please assist in explaining why this error is being received? Thanks Kevin
Double floating header in custom action button glitch
I have a custom action button that seems to have a strange glitch attached to it. The custom action button opens up a view and the header seems to be duplicated. I cant get rid of it with out navigating to another page and back again. This is very frustrating. What is going on and why is this happening. Someone started to look into this but I have not got any response yet and its been a while. THis happens in the following view: https://creator.zoho.com/precisionsailloft/prod/#View:Sent_for_RFQ
Summary View does not show all data. Specifically embedded external data. HELP.
I created a form that includes the "rich text" column. From there I am embedding external data. That data is not showing up in my summary view - which was the entire point of creating this form. Please advise. The html code I use elsewhere works fine, so its not the source code. Also, the document I am embedding shows up fine in the form when I embed it. It's just not showing up in the summary view. HELP Please. Rene
Switch Display Type for embedded view
Is there a way to display the cogwheel to change the display type when a view is embedded in a website? When the view is seen in the Zoho Application the cogwheel gives choices for View As List, Summary, Grid, Spreadsheet. When embedded this option is gone.
Writing condition
I'm new to zoho creator. Recently created a form. Now I need to create an automatic task. I have these fields in the form: Quantity Unit of measure Total Weight Here is what I want : When Pallet is selected as unit of measure each Quantity is multiply X 45 lbs. So if I enter Quantity: 10 Unit of Measure: Pallet I want the form to return automatically Total Weight: 450
How do I make prices not a preset value, rather a custom value that is subject to change?
I am trying to let users be able to set their own prices when they create a new order using the Order Management database for Zoho Creator. As of now, the price section is grayed out when I try to create a new order. Since we are a wholesale company, I want this to be a custom price that is subject to change depending on the volume of the order.
Help with some code please
In a multi line text box I use some script to populate the box The script is input.Map_Address = input.Clients_Name + ", " + input.Clients_Address + ", " + input.Post_Code + ", " + input.Telephone + ", " + input.Place; This produces Ian Mitchel, Benfleet Close, SM1 3SD, 07860635993, Sutton I want it to be Ian Mitchel Benfield Close SM1 3SD 07940635993 Sutton How do I add the carnage return and how do I centralise
Creator not getting CRM data using Zoho CRM field
I am new to Zoho Creator and have searched the help, support, this forum, and the web for a solution. I am having a problem getting the Zoho CRM field to work. I upgraded my CRM account to Enterprise to get the Creator integration and am paying for the Standard version of Creator to get CRM sync. (I'm still not sure if I needed to upgrade from CRM Proffessional to Enterprise to get Creator to pull data from CRM. But, because I'm having this issue, I upgraded to see if it would solve the problem.)
can't hide or disable fields in subform
My Creator app uses sub forms. As of today, the app produces an error if one or more of the fields in the subform are disabled or hidden through deluge script The error message: Error in executing GENERATEJS_TASK task. I verified this problem in a brand new form that only contains a subform with one field disable/hidden, so it can't be related to any of the other deluge code.
Time Comparison
I need to check if user has performed some form action after 10 am but before 11:45 am. While I can easily look at hours as shown below, is there a solution my question? if ((zoho.currenttime.getHour() > 10) && (zoho.currenttime.getHour() < 12)) { //some code; } Cheers, John Whitney
Passing a multiples select lookup field to a function
How do you pass the contents of a multiple select lookup field (in my case a list of IDs) as an argument to a function?
Formula field: text formatting?
Hi! I have a text only db and I need to concatenate and format text strings in a forluma field. Could you please help? It is a bibliography so my formula should return something like this, Reilly, Rahtz, 1992 Paul Reilly, Sebastian Rahtz (eds), Archaeology and the information age. A global perspective, London, Routledge, 1992 I am ok with concatenating fields and with adding commas and periods or fix words among them, but I have a couple of problems: 1) Is it possible to manage style (e.g. Italic or Subtitled)?
Multiple Select Lookup fields
How do I set a single value in a multiple select lookup field using the insert into statement?
Possible bug
Hi All, Apologies if someone else has spotted this but when duplicating a form by copying the With Action definition from the original and pasting it into the new form, if the word "unique" is in the script, an "null" error message will be shown. If you remove the existence of the word "unique" from the xml, the script will then save correctly. Perversely, once the script has been saved, you can put the "unique" word back and the script will still save ok.
Zoho Creator and Google Drive
hello, is it possible to create a directory in Gdocs in Zoho Creator ? thanks
Connect applications in the sections of a main application
My company needs a huge application with a combination of subapplications. So I would like your opinions for the structure of the application. Let's say that I have a main application (Extranet) with sections Inventory, Managing, Trading. It's section is a separately application. For example Inventory has forms for hotel details, type of rooms, room prices etc, Managing has another 4-5 forms etc. The same with Trading. My question is how can I connect these 3 subapplications in the main Extranet
Update on ZohoCreator apps && ZohoCloud SQL
Hi Team, Could you please provide an update on the integration of ZohoCreator apps && ZohoCloud SQL Presently only ZReports is supported. Even that doesnt seem to have the oDBC diver support. (or did i miss it) Please advice Thank you Regards -Deepa Govind
Multiples addreses in sendmail
If you send a single email to multiple persons then what is the correct syntax? What is the address separator and are spaces ignored?
And If
Is there a way to perform an "And If" I have work orders being sent to my office when they are completed by the tech. I also want to be able to send some of my customers a copy of the completed order when complete. But not all of them, just certain ones. Example; Work Order If input.Billable = yes then email else If input.Billable = No then email and if Customer = Joe send email to Joe's boss "I only want to send email if the customer is listed"
Create HTML view of records
Hello I would like to know if its possible to create a HTML view which shows a summary of two forms that are related. My situation is as thus: I have two forms Clients and Commissions. In the Clients form I have an agent and client. In the Commissions form I input the commission for each client. [This is the related link]. I would like to know if its possible to have a HTML view which allows me to show the total received by each agent, and I can also choose the month. The HTML view should show all
Cancel button not working when I open record in a new window for editing
I've created a field that displays a link in my view allowing users to open the form in a new window for editing (to avoid the popup/floating window, which creates problems for us in certain situations). The problem is, the "Cancel" button no longer works in this window. "Update" works fine, and the user can close the window to avoid updating, but I'm afraid that if the cancel button doesn't work, they will feel forced to click "update", which could lead to data loss or input errors. Is this a bug
Function tolong()
What's wrong with the following that I keep getting the error message below? temp_list=List(); for each selection in Team_Members { e = Team_Members[ID == selection.tolong()].Email_ID; temp_list.add(e); } Team_Members_Text_List=temp_list.tostring(); Error at line number : 4 Not able to find 'tolong' function
Uploading data
Hi, I have a view in which I want to upload data periodically. The data language is portuguese and there is a problem during data upload for words with accentuation("á", "ã", "â", "ê" "õ" "ç", etc). The data is in .xls format and when the data is imported the accented letter displays as unknown. Do you have any suggestion to prevent unrecognized letters? This Zoho's limit doesn't allow us to have a good use of Zoho Creator because we have thousands of data and most of them has accentuation. If it
function page error
Hi, When I'm trying to click on define a function in Custom Actions it gives the following error
Subform and Mainform relationship
Hi all, I have created one main form and one sub form A is the parent form and B is the subform or child form 1- Form A has a unique mandatory field and I added a subform field in A that pointed to B 2- Created a lookup field in B that points to the unique field of A mentioned above 3- In form A Report added the autonumber field of B and all the relationships seems fine except if I create a record using form B, it does not show up in the Form A which is the parent although I select the right record
Android native app for Zoho Creator
Team, What is the latest update on the availability of a Zoho Creator native app for Android & iOS? Thanks
Next Page