Is it possible to to make Aggregate Records values clickable?
I'm using Aggregate Records in an form and it works great. However, I would now like to be able to click on the numerical value created by this function and be shown the records it has matched. How do I achieve that effect?
Access to source data in Creator apps?
Several of my apps use zoho.userid data. Is there a way of changing this data after it's posted? The short version is that I had to use a public url briefly and now need to recode that field as it's used in performance measures. Is there a way to access the data through phpmyadmin, for instance? Thanks
Potential bug: migration tool loads all files in folder
Hi, Earlier this week, I reported an issue with the migration tool not loading my file. What was happening was that the when I selected a file, it the tool would hang and not do anything. I thought that the tool was not working so I re-downloaded it but had no luck. Today, I was clearing up my computer and cleaned out my downloads folder. Since I had reported the issue to support, I thought I would try and download the tool again and try one last time. This time it worked but instead of loading
'Back to Form' missing
When editing a form script there used to be a button in the upper right to go back to the Form design. It no longer shows. I use two different computers (XP & Vista) and Chrome 10 and FF 3.6. Does it still show for other developers? Herb Wexler
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
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
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
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
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
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
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
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
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
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
Cannot get image to display in HTML View in IE.
below is the code I have in my html view to display the image: <img alt="<%=rec2.abc_sponsor%>" width="200" src='https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=rec2.abc_sponsor_logo1%>&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>&viewLinkName=chhsboosterclubsponsor_View'> I then take this the script that displays the images and embed them into my website as a widget. The image displays great in zoho and firefox, but in IE I only get a red x with the alt name displayed.
Another severe error when scripts are Saved !!!!
Just as I was developing a workaround the ZOHO defect previously posted here https://help.zoho.com/portal/en/community/topic/choices-in-checkbox-field-get-truncate-in-deluge-script ... I found another error with the way ZOHO Creator's Save Script ... if I have a script of the kind ... abc = "qwerty "; if (abc == "qwerty ") { abc = "asdf123"; }... then Save it, navigate away from it and return to it ... the script is changed to ... abc = "qwerty "; if (abc == "qwerty") { abc = "asdf123";
Help please with HTML View PLEASE
Hi, Hope someone can help, there is simply no help to be found. I have a database called laptop sales. In this database I have details of laptops I have in stock that I can sell. Database fields are, Make, Model, CPU, Memory etc (you get the idea). Now before I came across Zoho Creator I had the details listed in a book and when I wanted a sheet of A5 paper with the sales bumph on I would use Microsoft Publisher to produce this using the data I had in my book. NOW.... What I am trying to achieve
zoho "issue manager" app has bugs?
I installed this app in my account: https://creator.zoho.com/public/showAppInfo?canvasurl=agxvdppbg&refererUrl=%2Fplatform%2Fpublic%2Fsearch%3FappName%3DIssue%2BManager%26category%3D-1%26count%3D8&refererText=Back%20to%20Search%20Results#readreview I have opened "support access" to this app: https://creator.zoho.com/lifengwu/copy-1-of-issue-manager-9-0/#View:All_Issues The problem is when I try to update an issue, the "update script" fails. Can you take a look?
Creator's MySQL back-end Error
Error modifying the page Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'READ' at line 1" app: buzzable form: Instant_Newsletter Occurred attempting to remove CAL lookup John M. Whitney
Linking Two Forms
Hi: I created a Product database that has two basic forms (Products & Vendors). The forms are linked together by a "lookup" field called "Vendor ID" in the Products form. I have two other fields in the Vendors form called "Drop Ship Fee" and "Percent Discount". What I need is to automatically update the same two fields in the Product form whenever I update them in the Vendor form. For instance, if the "Drop Ship Fee" field changes from $3 to $5, for one vendor, I need all the records in the Product
Searching for a match
Need to help on how to search first if there is an 1. Search existing Student_ID 2. alert the user 3. stop the data entry Newbie to this. Thanks
lable functinality
Here is my application 1) Child Names of a person I have to fetch from the database and for each field i have to asign the percentage of share . 2) And To add a another child i have to give link down to this fields "Add Another Child" once clicking on that link the new window will open then the person can add the another child information .that will automatically add here . Child Name1 ________% Child Name2
Linking two applications
Hi, I have an application which is a database full of work respondents. They fill in information themselves to be added my database. I was wondering if there was a way to create a new application that interacts with the first one so I can add information in a form about them and there previous work because they will not be able to change any information once they submit it and I will only be able to add the work they do for me in the future. So I would like something on the second application form
Trying and failing to Aggregate Records with the following criteria...
Here's my code: input.Spend = Credit_Cards[(TYPE == "Ad Spend" && PURCHASE_DATE.getMonth() == input.Date_field.getMonth())].sum(AMOUNT); This doesn't work. Can you tell me how to check the Credit_Cards PURCHASE_DATE field against the parent form's Date_field?
Free User to Enterprise trial
I initially signed up as a free user. I have been gradually building applications, which I plan to deploy using a paid version. I noticed recently that my account status changed to "Enterprise trail - 15 days". Will my account revert back to a free user account at the end of the trial period. Also I hope that all the changes I made remain, when I get back to the free user status. Thanks
Configure Custom Actions I only ever want an action to be performed on one single record
Am using functions and custom actions (In the header section of a view ) successfully Question For my view if i use "Execute action for collection of records" or "Execute action for each record" the user can click multiple records. In my case (booking rooms) i only want them to be able to book one room at a time so i a) Only want one record to be selected or b) Know if multiple records have been selected so i can check for it Any suggestions thanks
Send grid and creator?
Right now I export to spreadsheet every week, my creator list of emails. Then I mail merge with outlook and send through sendgrid. Anyone have any advice on how to "auto grab" my current list of emails ( instead of having to export manually)?
Need you help
Ruben I have not received your reply, please check to link https://help.zoho.com/portal/en/community/topic/need-help-for-deluge-script-builder Thanks Stanleyguo
Import App link not available!
where is it???
Insert record into new form
I need to insert a record into a different form in the same application so that 3 additional fields can be added by user and saved into the other form. I'm not sure where to start, please advise. Thanks in advance for your help.
Referencing forms in other applications
How to reference forms in another applications?
Does Stateless form submission bypass all other form scripts
Hi need to check I have a stateless form which is inserting values into another form as the form is referenced in the insert statement i am wondering if the insert will pass through any script (on add/load/submit/success. Reason, the stateless form submission has different rules than the normal form submission Thanks
How do I enable date specific search options when the date field is specially formatted.
Hi there, I followed this forum post: https://help.zoho.com/portal/en/community/topic/how-do-i-format-a-date-time-value-in-a-view And used this to format a Form date field into formula field: input.givendate.toString("EEE, MMM d, yyyy, HH:mm aaa") The problem is that in my View, the date specific search options are no longer visible. ie: Next 7 days, Previous 30 days etc. Is there a way to enable those for the formula field that is holding the formatted date? Thanks, David
Importing with a date that isn't auto-selected hides the "date format" option.
So, this is fun. I'm migrating data from an old Zoho account to a new one. Steps: Create a form that has a date field, where the label has a space in it. (In this case, "Confirmed On".) Add a few records. Export from Zoho to CSV. In the new app, start an import: CSV, local drive. Upload the exported CSV file, and click Next. The issue: "Confirmed On" isn't selected, even though the first row has labels, and the old form's label matches the new form's label exactly. There is no Date Format option.
Next Page