Chinese in zoho creator sorting solution
As the zoho creator of Chinese currently no sorting, sort in use is very convenient for the Chinese, only to be sorted manually addedin front of a Chinese phonetic alphabet, can not be automatically added to the program of the alphabet, so he wrote a hands-oncontrol of Chinese automatically add the phonetic function, very practical, since the function accounted for a little space, is herebyomitted, however, still feel the creator's execution speed is quite satisfactory test stanleyguo 2011-10-22
Customization of FROM field [Sending emails from Creator]
Hi I'm sending emails from my application using a schedule task. Is it possible to customize information about email sender? I can send emails from zoho.adminid (in my case: "system[at]tufconsulting.pl"). I know that changing this email address is forbidden now, but can I add some more info in FROM field, for example "Name <system[at]tufconsulting.pl>"? system[at]tufconsulting.pl is my primary email address in Zoho account. Is it possible to add a few more addresses in the Zoho account (ie. "system2[at]tufconsulting.pl",
Creator and Constant Contact Integration
Hello, We currently use a Creator form embedded on our website to capture the information of people who would like to volunteer for our organization. I would like to automatically (through API?) add these people to our Constant Contact mailing list. Does anyone have any tips to get this started? Thanks! Mike
Allow Zoho IP
In order for the zoho app have access to our internal database what zoho IP should we allow? IT wants to know the ip address and if it is static
Email selected people
I me building a very simple events form for my project team of 6 - 10 people now very simply i would like the user to fill the form out and pick whom from the list of people they want to email the form data to. it may be all of them or 2 or 3 of them. what is the best way to achieve this. kind regards Tim garret
Best way for user to change information
I have a registration form embedded in my website. What is the best way for the user to change or add information after the form is submitted? I have written script that runs after they enter their email address which checks to see if there is an existing record with a matching email. If found it copies the data from the existing record to the input fields. This works fine except for file upload fields, URL fields and of course the new subforms data. Herb Wexler
Red Alert : Grouping Suddenly Not Working
As per title. All grouping in form view suddenly not working. I am using it this morning and everything seems alright. And now in the afternoon all grouping gone......HELP!!!!! Regards Andrew
Application publishing problem in marketplace
Hi, I want to publish my application created on Zoho Creator in Zoho Marketplace, but during the publishing the following error showed: Error in statement at line number 3047 api functions can be created only by application owners. Can any one help me why its happen.
Random code in comment tags
Hi, I'm sure there is a logical explanation for this but for some reason, I can't figure it out. I have a HTML view and have added a comment. For some reason, every time I add a comment, random html code gets added to it. For example: Get details of the shop that is selling the goods;<span id="Comment-CloseTag-235736000000613005-5-0" class="normalcode" style="display:none;"> %></span><span id="Comment-CloseTag-235736000000613423-5-0" class="normalcode" style="display:none;"> %></span><span id="Comment-CloseTag-235736000000615081-5-0"
Formobject passed to a function cant seem to locate it via script builder
Hi I pass a formobject to a function and can seem to access it via the notation formobject.field name Therefore at this point i am thinking that the formobject now exists as a standard collection variable does when u fetch etc, however using scriptbuilder there is nothing listed in the collection variable tab. Should i be looking elsewhere or thinking different Thanks
Set criteria by "added time" field not working as it should
Have an application set on EEST. Added a new event and created a view and set criteria for added time field on this week but the event can't be viewed. I think the problem is that the comparing time is PDT, not EEST so the event can't be viewed as expected. Same problem with all set criteria fields (Last 7 days, Last week, etc.) Can you Zoho team fix this problem please?
How do I display form contents before submitting
Hi, How do I display or verify form contents or before submitting Thanks
Dropdown Field Not Working in IE7 in embedded forms
As of yesterday (Oct. 17, 2011), the drop down fields are not functional when using an embedded form using IE7.
VERY URGENT ISSUE
The record quota limit on my Zoho creator account has just been reduced to 50,000 records with now warning making my application unusable as I already have over 140,000 records. I requested an increase in my record quota, not a decrease. Please re-instate my pervious quota immediately and contact me ( I have emailed my contact details to you ) to discuss why this has hapenned. My username is paulansell1965
My reports keep saying I need to upgrade
Every time I try to create a new report it says I have used them all up. You guys have already reset this error once, but it keeps happening. I don't even have any reports that I'm currently using. Please help.
Error occured in the insert Html task
What is causing this? Error details: Error occured while executing the script. Error occured in the insert Html task Error on Form
Linking Database Entries
I am making an application that will help me manage information on contacts (ie people that I meet) for a project. In the form I will enter information on the contacts and it will then store it in a "database" for me. However, I would like to be able to show connections between the contacts, such as if one person knows another contact in the database. What I would love is a field where I could link to other contacts already in the database and then could add a description as to the nature of the
Formatting forms
I'm brand new to Creator and have managed to make my first form. How do I format it to make it more user friendly? For example I'd like some horizontal lines, or some other way to break it into sections more clearly. TIA, Graeme
Zoho Creator and Scheduler
Hi, We have build an application, that needs to automatically call some functions on a regular basis. For that we are required to add scheduler in our code to automate series of function calls. Due to the type of the application, we do not want to publish code for install by users in marketplace. The issue is when we try to add a scheduler this keeps failing to publish in marketplace. We tried form and custom scheduler both without any luck. Please let us know if this is a limitation, if so how
Newbie question:sharing application
Hi, I've just made my first application and have attempted to share it with a colleague. She has made her ID and username, and can see the application in the pane on the left, but it won't open. Any suggestions? TIA, Graeme
Adding a record to another form
form Add_New_Course_Details { displayname = "Add New Course Details" success message = "Data Added Successfully!" field alignment = top column { must have Format ( type = picklist values = {"Self-Video", "Self-Written", "Group", "One-on-one"} width = 206px ) unique Course_Title ( displayname = "Course Title" type = text width = 200px
Having one field populate another in the same form
How do I get one field to populate another. I have a field in a form called Author (last, first) and when a user enters the data, I would like it to automatically populate a second field that is Author (first last). I can't seem to figure out how I would accomplish this.
Multiple items in single form
will it be possible to add multiple items into a form with quantities, rates & totals as depicted in excel sheet attached here?
HELP with HTML view please
Hi, I wonder if anyone can help please, I have 3 files "Jobs" "Which job to look at" "Job progress HTML view" When I put the job number in the "Which job to look at" form the chosen fields I have in the "Job progress HTML view" appear. The process works fine an I am very happy with the system. So to my problem. I have taken the "which job to look at" code for website embedding and places it on a web page. The form shows up fine but when I click submit it doesn't jump to the "Job progress HTML view"
Can I build an app (an order form) with auotmatic invoicing?
Hi all! Is there a chance to connect Creator and Invoice in that way, that f.e. if somebody is ordering something, there is an invoice generated automatically - and saved as a draft? Any help is highly appreciated! Many thanks! Benedict
Group and Sort by System fields
Hi, When i edit a view and go to sort or group, i can see "System Fields"at the bottom of the list, but I cant select it as an option Sort or Group by System fields does not seem to be supported. Can any advise on this feature ? thanks
Version Number NOT incrementing when taking Backups ... again !!!
Over here https://help.zoho.com/portal/en/community/topic/version-number-not-incrementing-when-taking-backups I reported a problem when requesting backups ... i.e. the version number was NOT being incremented. At the time, Balasankar reported that this problem was fixed ... and I was able to verify it. But now, the problem has returned ... see screenshot image below ... Note that this is the 5th problem I have encountered with the platform in less than two weeks ... and how do problems supoosedly
Newbie question about printing.
Hi, I have created a html view of something I want to print. My printer can print either A4 or A5. In this instance I wish to print in A5. When I print to A5 in other programmes, I set the condition in page setup. Could you please tell me how to tell my HTML view page to print onto A5. Thanks
Is it possible to have 2 admins in Creator?
Hi Zoho, We have an Enterprise account. I would like to add another user as an Admin so that they can create databases, modify existing databases, etc. Is that possible? It doesn't seem that adding someone as a Developer gives them those kinds of rights. Thanks. Kim
How do I report on number of records in a database?
I'd like to create a report from Zoho Creator which shows the number of records created in my database in a given month. The drag and drop fields in the reporter don't give me the option for total number of records. How can obtain this figure to graph?
Creating pages with multiple forms
Is there a way to create pages with multiple forms from different applications on them? I'd like to be able to create a page with a 2x2 table with a form in each cell. Would using Dreamweaver to create the page, then pasting the permalink link info work?
Is it safe to use Zoho Creator for important financial information?
Is it wise to put credit card statements and other financials in to Zoho Creator?
HTML Duplex Print
Hi, I have set-up a html view page for an invoice. Can someone please advise me on how to set-up the HTML view to print my terms and conditions on the reverse using my duplex printer. Thanks
I know that a "file or picture" field is string type.
Hi, I know that a "file or picture" field is string type. I know that it's default value is "" on every case except "on Delete" only then is "null". Please, trust me, I am not making you waste time. I executed this function to populate a few records' "Decision box" field. for each r in Buscar [Propiedad == "Terreno"] { r.FFF1 = true; } The result was that all the "Decision box" fields displayed true. This is correct. Then I executed this fuction to update some of this fields.
Calling Function on edit - success
I am getting the following msg when calling a function. Can the error be improved to show the line number or the variable that has the problem? This function has over 400 lines including comments. Error occured while executing on edit - success script. on invoking a function Refresh_Single_Family_Summary Unable to update variable Error occured. Herb Wexler
Database locking on edit
Hi, It appears that more than one user can access the same record in a database for editing purposes without locking. PLease can you advise why this is, and what can be done, as this could cause seroius problems on input? Love the service btw :D
Function requiring user input
Hi, I want to create a function that does two things: 1. Updates two field values automatically 2. Asks users to specify values for two other fields that are required. At the moment, I have the following function that updates the two field values automatically: void global_variables.Mark_Paid(int recID) { thisRec = Expensives_Specials_Order_Form [ID == input.recID]; if (thisRec.Status == "Ordered from supplier") { thisRec.Status = "Received without invoice"; } } I want
How do I modify a record in another form from a stateless form?
I am trying to modify a field based on results from information provided in a stateless form. The form I am trying to modify the record in is called TEST_TRACKING. It contains 1 record that will match a test number and zoho.loginuserid. When I try and use the formula below I get a null error when i add myStatus.Passed = "Y". if (input.Percent < 80) { openUrl("http://failedtest.blablabla.com", "Same window"); } else if (count(TEST_TRACKING[(zohouser == zoho.loginuserid && Testnumber == input.TESTNUMBER)])
How to create an event in Google Calendars
Hello, 1) I have a GOOGLE APPS account for my domain, where I have created multiple CALENDARS for my users. 2) I have created a FORM with fields representing the info required to add a RECURRING EVENT in a google apps calendar. 3) I would like when I hit the submit button in my form to automatically create a recurring event in google apps calendar. Is this possible? What will be the code to do that? I would appreciate very much your help.
This script keeps throwing an error...
I am trying to display records in a HTML View with certain fields in a random order, but it keeps generating an error: Error details: Error occured while executing the script. sublist operation failed as the 'end' index(5) is greater than the list size(1) This is my code: htmlpage Test(recID) <%{%> <%ran = zoho.currenttime.toLong();%> <%record = Make_Test [ID = input.recID.toLong()]; qlist = record.idlist;%> <%for each q in Question [ID in qlist] sort by Added_Time ,Added_User_IP_Address ,Enter_Correct_Answer
Next Page