PRINT /EXPORT PROBLEM
Print|Export stopped working on 02/16/2011. I can see my view, but when I select More Actions - > Print or Export, I cannot get connected to the server and system hangs...
Problem with Usage Limit
Hi, I'm trying to execute a function, but it keeps failing: Execution Failed Error details: Error occured while executing the script. The execution is stopped since the number of deluge statements that can be executed in an action has exceeded the maximum limit. You can view your usage limits here. But when I check the suggested link to see my usage limit, it says I have not exceeded any limits. I have shared my app "GolfHandicapCalculator" with Support. The function I am trying to run is called
inactivated account
I have asked a few months ago to reactivate my 2nd account : VIF. Can you reactivate it and tell me what was wrong with it (to solve the pb if relevant)
Permissions
Is there a way where i set permissions where my users can only see what they add in but me as a admin can see what they added in?
Formula field, number of digits
I have defined a formula field in a form, calculated from other fields. How can I define the number of digits displayed on a VIEW? Even if the formula field result has 10 digits, can I define the VIEW to display only 2 digits? Thanks a lot.
Null field to be "zero" for "null" values
I have a formula field which 5 fields. Manipulating the 5 fields to reach a formula field value. If any of the 5 fields is null, then the formula does not give any value.... how to solve this issue. Thanks.
Created new application under my account and gave user developer rights. The they don't have the option to edit application
I created a new application under my account. I added the usersemail to the share under the edit application. I marked them as developer. I assured the username under account settings is developer. However, when the user logs in to the application, they ddon'thave the edit application feature. Please help! Thanks you in advance
A href link in mail
Hello, I am trying to put the link in mail body of my email in Zoho creator. I need to provide the link to the uploaded document through mail sent. I have the link - "<a href='https://creatorexport.zoho.com/DownloadFile.do?filepath=/" + input.File_Upload + "&sharedBy=" + zoho.adminuser&appLinkName=test&viewLinkName=test_view+ "'>Uploaded File</a>" But it is displaying the entire link instead of the "Uploaded File" caption. The HTML tags are also enabled in Application settings. Please help me to
Error in Importing DATA. HELP ASAP!!!
Sir, I've got a problem here. I used "create apps using DS file" and it work. But when I tried to import data into it an error occurred. Picture as stated below. This is the only apps in my acc. Why does it said I've reach record limit even though there is no record is inserted yet. No one reply to my previous topic so i've created new one.HELP ASAP pls...
How do I pass data from one form to another form?
Hello, I'm trying to build a personal financial planning database. I want to pass the "Transaction Amount" from a Transaction Entry form to a similar field in a Transaction Summary form. The link between the two forms is the Transaction ID ("ID" in the Transaction Entry form and "Transaction ID" in the Transaction Summary form). I have been able to create a link between the two forms and pass the ID, but I'm confused about how to pass the Transaction Amount. Thanks so much, Ann
Aggregate Records - Sum
What I'm trying to take the sum of total earnings and have that put into a field called Actual Earnings. But i keep on getting this error. On Success Actual_Earnings = Business_Plan[Recruiter == input.Recruiter].sum(Earnings); And this is ther Error message: Error at line: 1 Variable "Recruiter" is not decleared
Rename a form button in real time
Hi, Is it possible to change the text that is used as a button's caption while running the application? I know I can change it when creating the form, but I would like to have it changed dynamically or when loading the form Rob
Sort lookup field by second column
Is there any way to sort a lookup drop down menu based on a second (hidden) column. My lookup table is [Item | Order] I want item displayed and order hidden but used for sorting. Asc 1 - xx But I see I can only sort alphabetically. Any ideas would be great. Thanks
OpenUrl only works in Firefox
Hi, I have a On Success Add script and a SendMail script also. The OpenUrl executes by opening a new window in firefox only and does not work in Safari and Chrome. Data entry and send email works fine. Any bug with other browsers? Thank you, SL
Creator to Invoice API Problem
Hi, Stuggling with creating a new customer in another users Zoho Invoice account. Using the following: invinfo = { "CustomerName" : input.Company_Name, "CurrencyCode" : "GBP", "BillingAddress" : input.Address_Line_1 + "<br>" + input.Address_Line_2 + "<br>" + input.City_Town + "<br>" + input.County + "<br>" + input.Postcode, "FirstName" : input.Your_name, "LastName" : input.Surname, "Email" : input.Email_Address }; invResp = zoho.invoice.createcustomer(invinfo, "OTHER-ZOHO-USER-NAME"); I'm getting
Stateless form
Hi, I have a view 'reservations' in grid. If I click on add the Form of all my data (Order_Management_Form) pops up for data entry. I would like to use a stateless form instead once I click on add called (Add_Order) How? Please help kind regards Michael
Plz help
Dear Sir, First of all, I would like to pay thanks to zoho as I recently got one serious query for my application. In same regard, plz guide that how can I allow my client to download my application through marketplace, once I confirm the receipt of payment. It's bit urgent hence plz guide. Regards, Abhinandan sharma apsplacements@gmail.com
Can multiple forms be integrated in the form of single application?
My requirement is as follows: Create 3 different forms with associated views. Have one user as owner of each of the forms. Have another 4th user with only view privilege to all 3 forms(access to views) Finally export all the three forms as a single application with specific access rights to those 4 different users One more question is as follows i: Is it possible to read data in one column of one view in a different form (in validation script)? Regards AAP
Link gives 404 error
Hi Thanks for the response to my last question. In the answer you provided, the link gives a 404 error?? Can you provide correct link Regards Wayne
"Create a new Stateless form from an existing form" feature problem
The new feature Create a new Stateless form from an existing form - throws an error "Stateless forms can not have unique fields..." when it's used for the fields which have Unique property. Probably this is a situation not taken into consideration when this feature was built. Also, the error with the reference line doesn't make sense for the developer, because the code is not editable in there. Regards, George
Help - I don't think I'm doing anything wrong here. So what's the problem?
I keep getting this error:1 . [t_695252000000024060] Exception occured while setting value in PreparedStatement for the Column [Successor__695252000000054001] Check whether the datatype for this column is given as specified in the data-dictionary .[t_695252000000024060] Exception occured while setting value in PreparedStatement for the Column [Successor__695252000000054001] Check whether the datatype for this column is given as specified in the data-dictionary What am I doing wrong? I have a "single
Totally New....wondering if this site can do what I need....
I have developed a website for people to share book trailers, using FrontPage. I would like to incorporate a search feature on the site, using data from a spreadsheet. Does anyone know if this is doable? I already have a spreadsheet with all of the details in it. Can I create a database with this information and then create a search feature from it? Does that make any sense? Here's my site: http://booktrailersforall.com
New users not getting password
My new users are not getting thier passwords sent via email. Please help.
Display records in a form depending upon lookup selection
HI, i've created a form with lookups to another form. I want the user to be able to select an item in the lookup field and depending upon their selection, information is shown to the side of the form fields. For example: User selects Country. If user selects Australia, a message displays to the side of the form which says "Australia has these States..(and then pulls the states by doing a lookup from the States table where the state relates to Australia) Any ideas how I achieve this? Thanks Daryl
How do I create a script based on a selection from a dropdown list?
I want to create a script in a creator form so that when a user selects a city from a dropdown list, another dropdown list appears with all of the neighborhoods in the selected city. At this moment I am stuck trying to create a Actions on User Input script and I can't make an If condition that recognizes the dropdown items as variables. Thanks for any help you can give me.
Rename application does not work
When I try to rename my application from the Application Settings page, my new names always reverts back to the original name after I click "Done". Is there something else I am supposed to do get the new name to save properly?
How to Export App & Database Together and import into another zoho creator account?
I can "Save as Deluge Script" and import the .ds file into the other account, but I can't copy the .ds and database together or import together. I don't want to manually export each view as an .xls and then manually import each view as an .xls for 2 reasons: 1. takes more time than I want. 2. the import feature doesn't work perfectly for certain fields (e.g. date & time) thank you, josh
How do i shared my Creator Apps with one of users as a developer?
How do i shared my Creator Apps with one of users as a developer?
How do I create a form that populates some of the fields from another table?
I am trying to gather addresses for all people that will be attending an event. What I want to do is be able to send people that are helping me to an online form. The online form will have the names of people populated in the name fields that it picks from another table where they do not as of yet have their addresses filled in. Then, the person helping me, just fills in the address for that person and submits it. Once it is submitted, their name will no longer show up on the online form. How could
How to hide fields while editing a view
I am working on a database -- I'm creating a custom view for Rayma: http://creator.zoho.com/spcorppm/pm1/#View:Rayma Currently I have it displayed as a grid, which is a little clunky. It would be better if she could edit it from the "list" format -- but when you hit "edit" you see all the fields, not just the ones that are included in her view. Is there a way to limit the field that appear when you hit "edit"? -- Kristy
Would be great to be able to rotate view titles
I have a bunch of views that are basically check boxes -- yes it was done, no it wasn't done. I want to work on them in "grid" but since the titles of the fields are long I have to scroll through pages and pages. I've tried adjusting the width of the fields, but then I can't read what it is. It would be great if I could rotate those labels to landscape, still have the field width autosize and see all of my checkboxes at one go. -- Kristy
How to display the no. of days
This was made in Function tab int calculations.CalculateDays(date start_date, date end_date) { Days = (((input.end_date - input.start_date) / 86400000)).toLong(); return Days; } Now I want to display the value of "Days" in form i tried input.Days=input.Days; but not working How to do it. Any idea
Deluge/Plain Text/Rich Text Not Functioning
I am working to generate a "sendmail" script, but currently, anytime I create a line break it isn't converting over correctly and is showing a "\n" tag at each break in the rich text. No matter where I create the message (rich text/plain text/deluge), it is sticking the "\n" at each line break. Here is an example: When I enter the following deluge code: "Test <br> Test" I end up with the following text in the Rich Text editor: Test \nTest
Newbie
I have a form called Case Data with a field called "Status" with options of "Open", "Closed" and "Suspended". On another form called Investigation Data I have the same field with the same response. What I need is when I put in a response in the "Status" field of Investigation Data is for it to update on Case Data???? Any help with steps needed would be appreciated...just started with Zoho this week and trying to fumble around with everything. Thanks
Email notification \n inserted in body
When using "email notification", the character \n is being inserted in into each row of text in the body of the email message. This is a new issue. I have been using Creator for over a year and never experienced this problem. PLEASE HELP
Image from Webcam
Quite simple, we already have the ability to upload an image from disk. Currently I take the image using Photobooth, then attach it. This could be streamlined by having a form object that could access the webcam (iSight) and take the picture there and then. Ross
Reports and HTML View
Is it possible to embed reports in a HTML view?
HTML view sum example
Can someone provide me an example of how to calculate the total absolute values of a field in an html view? For example: FormA One entry is this: Field1=10 Field2=5 The second entry is this: Field1=5 Field2=5 The third entry is this: Field1=2 Field2=1 HTMLView Field1Total=17 (10+5+2) Field2Total=11 (5+5+1) I'm assuming this can be done with the "for each" clause, however I'm stuck on figuring out how to calculate the sum in an html view.
Email the actual reports
Hello, Is it possible to email a copy of an actual report that is generated by Creator? I have several reports created that have special filters, and functions applied to it, and I would like to email the finalized reports as a PDF, instead of just a PDF of the VIEW that I created the report from. ANy help would be greatly appreciated. Jason Rapp
How to Execute action for collection of records
I have a form, that when in the list view, i want to be able to select certain records and execute a function that will display only the results that i have selected in an HTML view. I know how to launch an HTML view for individual records, but i do not know how to do so with a collection of records. Can someone please post the post. Thank you very much
Next Page