Usage Limit
Hello Zoho! Is the usage limit https://www.zoho.com/creator/help/script/usage-limits.html applicable to all plans? We are going to use Creator-CRM integration but this usage limit makes me doubt. We are going to submit massive amount of forms per day so i think this could be some kind of limitation on our part. Please help me and explain these things. Also, what plan do i need to purchase to achieve the max usage anyway?
Custom HTML view Customer Based
I am building an app and i have difficulty to create a custom html view for my forms. I am having a customer form that you can enter a customer and 5 categories ( different forms ) that you can input some data and use a customer from the customer form. (using lookup field ) I want to create a Page that its going to contain all the results that is stored under a customer name. Customer Dimitris Car contract 1 2 3 Fire Contract 1 2 Life Contract 1 2 ... etc.
Hello? Submitted emergency request to support over a week ago, via email and phone where is the update?
My application wont duplicate, this is essential for us. What is the problem? What is the solution. Can you make anything work for us. WE ARE PAID CUSTOMER!
Help please
Hi - sorry do not know the terminology in zoho... but I have an Zoho app for my business - reminders are important to my business, but two different programmers working on this have failed to come up with a solution. They both say design is the issue. So instead of trying to fix what has been created - I am looking at a new fix , how I used to solve this problem in Access. Essentially if I invoiced an item eg: ProductID =234 ( Annual vaccination) then I would post this record as a date to
How to reformat the Date-Time string (e.g. 05/28/09 11:00:00)?
Been searching through help docs and trying substring manipulations, but getting nowhere, so asking this kind forum for assistance. The "Time" field in a form generates values that are formatted like this: 05/28/09 11:00:00 When building a Dashboard, I don't want the trailing "seconds" to show in the time, so I've tried several things: - looking for a preferences setting that would change the default time format -- None exists that I can find - searching Help Docs for a code statement that allows
hide/show not working on Edit
In one of my forms (Inventario) I have been using the script hide/show to hide or show fields based on the condition of other fields. They work as they should on a new form input but when I go to edit a record the form doesn't hide the fields, it just shows everything. Am I using the script correctly or am I missing something? Thanks.
dons't work for current view to total number
Hi When associated with another table, dons't work for the view to total number,although the show yellow， like bellow screenshots Stanley Guo
Can Creator duplicate everything that Zoho CRM can?
If so, I need for someone to develop an App for me... I'll pay. It needs to duplicate everything in my CRM
"Duplicate Application" function not working for one of my applications
I contacted support, they could replicate the error. But I haven't received any confirmation and don't remember if they gave me any kind of support ticket number or anything of the like. My application is available for support to access. What would be reasons, for application not duplicating?
What is the proper code indentation convention in HTML pages?
I'm finding it confusing to read code with both <% type tags with zoho script code. For instance how would you tag and indent a block of code for each, which fills in cells of a table? What if you have nested loops? <% for each i in IForm { %> <%for each j in JForm { %> <%=j.data %><% }}%>So maybe its not so so confusing with this simple dummy text, but then the editor automatically does some corrections of its own and spaces things like crazy, so what rule is it following?
Importing incorrectly triggers "length of field" error for related field
Issue: Form has a lookup field to another form When importing, Creator occasionally--and incorrectly--indicates imported value for this field is too long Workaround is to rename value to something very short, import, then change the name back Example: One form called "Restaurant Types" with value "Fast food restaurants" One form called "Restaurants" with fields "Name" and "Restaurant Type," the latter referencing the "Restaurant Types" form CSV import attempted for "Restaurants" with record having
Script for "Today and prior"
If anyone can provide this, I'd appreciate it very much.
Script doesn't update
I am trying to modify a user defined function that I have called udf_ccc.get_ccc. After I make my changes, I get an endless "Updating Script..." message. The function would not update and I would close it after 5-10 minutes. As a test, I added the following code test_variable = 0; The first time I saved the script, I got a "null" message. I'm not sure what it means so I tried saving it again. The second time I saved the script, I get the "Updating Script..." message and it does not finish updating.
Code for Form Being Ignored - Urgent!
Shared to support Form:Contact_Record Try to edit a record: The type option for student and parent is not working to show/hide field values App: buzzap/edirectory Cheers, John Whitney
Setting privileges
I am restricting data access to views by using the filter Added User == zoho.loginuser. This works great to ensure that separate users do not see each other's records, however, I need the Admin to have access to ALL records from ALL users. How can I do this? Thanks.
large database support
Our database of consumer records is now pushing well past the 100,000 limit for Creator and I would expect it will continue to eventually grow into the range of several million. Has anybody worked out integration with SQL type service to manage the larger datasets while still being able to import/export in campaign sized groups of say 25,000 and be able to keep using the applications we've built with Creator? Malcolm.
Urgently need help for execute event in Sheduler
Hi Akash I try many times for execute event in scheduler,but they all failed and I checked the email address is correct,the screen disply as bellow: Error details:Error in executing 房源状态图示 script(Custom Schedule). Error. Error in executing Send Mail task. InValid email Address Found. Thanks for your help Stanley Guo
Reply to: not functioning properly in new app builder
If I add a reply to: or change and existing one in the new app builder, I get an error when I save: zoho.sendmailtask.rpltonotallowed And a red box around the line. If I switch back to the classic app builder, it saves fine.
Cannot remove records from linked application
To help simplify the structure of my complicated application, I created a separate External Application to deal with a particular section. In the Main Application I used Sections and Pages that contain the forms of the External Application. They show up nicely, and I can input information. I also constructed a page containing all the views related to the external application to allow users to edit their entries. When I try to delete records from the External Application's database (via the Main
Calculating linked field
My application contains a form that uses linked fields to input information into the database as follows: Field A | --------> If Field A = x then Field B = y | --------> If Field B = y then Field C = z Field C is a percentage field in the original form and when used inputs the correct value in the linked form. So the data is correct. However, when I perform a Deluge calculation with the value using the value from
Encode URL Question
I am populating a string field on a form via an email with some text from another system. I am then using a URL to open another form and default this data on that form. This works great EXCEPT when there are line feeds or other non-allowed characters in the initial string feed (e.g &). I have tried to use the encodeUrl function, but instead of converting the spaces in the string field to %20 (as I would expect) they are being converted to "+" and passed to the new form this way. Am I doing this
Issue with Sub-Form not linking properly
Hi there! I've created two views. Using this form: https://creator.zoho.com/reedmiller17/prisoner-profiles/#Page:Prisoner_Profiles Our volunteers can enter prisoner information, and then at the bottom, write a short letter to the prisoner. I have it set-up like a subform, so my expectation was that the prisoner's ID would show up in the Correspondence view: https://creator.zoho.com/reedmiller17/prisoner-correspondance/#View:Copy_of_Prisoner_Correspondance_View Similarly, under the Prisoner Profile
I need to link two forms together and make relationship!
I am needing to create a relationship between forms that will allow users to submit a form (embedded into website) that will populate data into another or have a view that can access both forms.
formatting strings in html reports
I couldn't find any built in function to format stings for currnecy For example a = 2.1; I want to display "$ 2.10" anything built in already for things like this? Has anyone wrong a function to do this already?
Is this possible?
Hi all Would it be possible to call a creator form in the leads view ? What i would like to achieve is from with in the leads view call and calculate some values and the update the given fields without of having to call the creator form and searching for the lead and then submitting the creator form
SQL Querying between reports/views/tables on Zoho Creator
Hi Zoho! I would like to suggest integrating also the Query Tables from Zoho Reports into the Zoho Creator. I find it hard to produce an output whenever I use the "Lookup" fields in Zoho Creator. It just loads the Row ID without it's equivalent rows like description, etc. Customer Name is automatically loaded upon entering this form, but upon saving, I save the ID as reference. But when I create a report using this table/view, the Customer table is not included in the columns (Pivot table) unlike
Dropdown - filtering values conflicts with preset values
I have a form with a CUSTOMER dropdown lookup field and a SITE dropdown lookup field. The SITE lookup shows the SITE ID, SITE NAME and SITE ADDRESS. The SITE field has criteria CUSTOMER_ID == input.CUSTOMER_ID I have preset the form to the most common customer using the on load script. CUSTOMER_ID.Select("INT"); However,when I load the page, the SITE dropdown is empty even though CUSTOMER "INT" has SITES. If I change the CUSTOMER, then the SITE dropdown gets populated correctly. If I change back
Script doesn't work in edit mode
Hi, I have an issue with the edit mode of a form. My form is loaded with a lot of scripts, both configured "on add" AND "on edit". It works fine, except in one case. I created a view to allow some people without login to edit some records. It's a search form, that opens a view with selected records through a "non login" link. In this view, users are allowed to edit records. The problem is there: in this specific case, the scripts doesn't work... Has anyone an idea ? Regards.
Can the user add additional fields as needed?
Hey all, What I would like to do is allow for multiples of select fields such as email adresses and phone numbers if needed. For example if someone has multiple email addresses you could fill in the first one then add an additional email address. It would be great if they could name the email with a tag of sorts like home, work etc. Is there a way to accomplish this? Thanks
URL Encoding Error
I am populating a string field on a form via an email with some text from another system. I am then using a URL to open another form and default this data on that form. This works great EXCEPT when there are line feeds or other non-allowed characters in the initial string feed (e.g &). I have tried to use the encodeUrl function, but instead of converting the spaces in the string field to %20 (as I would expect) they are being converted to "+" and passed to the new form this way. Am I doing this
How to make a condition in zoho creator
How to create a condition for example I create a checklist field and then when I select no nothing will happen but when I am going to select the Yes button I want to display below the checklist which is a single line "How many" and in that i can be able to put a number on that. Please help me.. or contact me in skype i need an answer skype: srepoyo
UpperCase all text
My client wants all data in zoho to be stored in upper case. What is the easiest way to do this? There is already data in mixed case and there are over 30 forms.
Extracting Account Name from CRM Contact Records in Creator
I'm building a Creator application where customers submit a monthly status report. I'm provisioning a representative at each customer as a Creator user, using the email address that is in that representative's CRM Contact record. Then that representative will log in to my Creator application after each month ends to submit a report. When a representative logs in to Creator, I retrieve the login email. Then I want to look up all CRM Contact records with that email, retrieve the Account Name for
Null error when saving html view
I have a html view called GLOBAL_SEARCH which I want to modify. I have tried adding in new code and I get a "null" message when I try to save my changes. As a test, I refreshed the page and made no changes to the script. When I clicked Save Script, I still get the "null" error. Why can't I save any changes?
Open URL problem for Edit
In the Workfolw application i am using an OpenUrl for form edit like: Urlstr = "#Form:Job?recLinkID=" + input.RecID + "&viewLinkName=Inbox&zc_LoadIn=dialog"; openUrl(Urlstr, "same window"); It is working perfect when logged in as admin user and owner, but if i share the application with another user the Job form is not opened, but instead the first TAB /Dashboard in the application. The openUrl call is done in the function Forward. Application is Workflow, and it is open for support. Dan Andersen
Criteria for Lookup Field - Non-Consistent Results
I have a FORM called People, and consider it to have only two fields : NAME COMPANY Second form is 'CATEGORY' with two fields COMPANY CATEGORY NAME I have another FORM called 'Request', with the following Fields NAME - Lookup from form 'People' COMPANY - Single Line CATEGORY - Lookup from 'CATEGORY' using Criteria Category.Company=input.Company Request Detail - Multi Line I have some deluge script on 'User Input' for the FORM 'Request' whereby, I get the 'PEOPLE' record corresponding to the name
Carriage Returns without XSS security set to low
Hi all I have looked through previous posts to find out how to insert a 'carriage return' in a multiline text field using script and have tried using "<br>" and "/n" however to do this you have to set XSS security set to 'Low'. However I belive that it is now longer possible to do this. Has anybody else come across this and know how to achive this. Script below takes each record and adds two fields seperated by a hyphen to a string then adds the string to the mutiline text field followed by
Field types don't match?
Hi, I am trying to write a function that will go through a set of records and sum a given field (Field B) if criteria for another field is met (Field A). So if Field A = "Yes" then add Field B to a sum. Below is a function I use to sum all the values in Field B (Man_Months in this case): float TotalJobsCon() { countMonths = 0.0; for each r in JobCreationSchedule [Man_Months != 0] { countMonths = (countMonths + r.Man_Months); } return countMonths; }This works perfectly
create link for downloading
I am uploading a file as an administrator, and trying to share this file with a non-administrator, ideally without necessitating a login. I have found the link, and instructions on how to create it (thought haven't actually successfully used deluge to generated this link). However, when I try to follow this link (by using 'inspect element' in Chrome) I receive an error message: You have logged in as AdministrativeAcct. You are not allowed to access this view. Please click here to login as a different
creating a Link to the website created in Zoho.
Hi, I have a website created in Zoho. I would like to create a link in another website to which it will redirect the user to the Zoho website - to login and access it. So how do do you embed the link? Regards Shavendra
Next Page