Supporting Arabic in Imported Files(Reports) - Need Help
Hello,,, I'd like to know if there is a solution for this problem, I create a shared application between me and my colleagues and the interface and data is totally in Arabic the problem is not here... when I created the first report to import the data in PDF file it didn't display the data, it seems that it didn't recognize the language, what can I do? Your cooperation is highly appreciated :)
How to Calculate Standard Deviation
First, view my test application here: https://creator.zoho.com/niskypto/stdev This calculates standard deviation in the same way Excel does. Specifically using n-1 degrees of freedom, which is preferred. I also added a 95% CI check for any value entered. The function makes use of Creator's new aggregate record commands float calcstdev() { n = DATA_ENTRY.count(); average = DATA_ENTRY.avg(Enter_a_Number); residuals = (0.1 - 0.1); for each x in DATA_ENTRY { residuals =
Fields missing from Report creator
I have set up a couple of applications with forms and views, and now want to produce reports. BUT, the key field is not appearing in the list of fields which are used to create the rows/pivots. The other fields are all there. I've checked the properties and can't work out why this one is not appearing. Can anyone help?
Form width issue when launching from stateless form in html view
I have a form called Visit. Invoking the form by pressing the built-in Add or Edit buttons results in the Visit form being displayed correctly on screen. However, I have an Add Visit button on a stateless form that is embedded in an html view. When I open the Visit form using the Add Visit button the Form is displayed with a large amount of extra space to the right of the fields. The form is invoked using; openUrl("#Form:Visit?PatientFKID=" + input.PatientFKID + "", "popup window", "height=350,width=550");.
Exception occured
I am getting the following error. What needs to be done to prevent this error. 1 . [t_210219000001303009] Exception occured while setting value in PreparedStatement for the Column [Resolution_210219000001305173] Check whether the datatype for this column is given as specified in the data-dictionary .[t_210219000001303009] Exception occured while setting value in PreparedStatement for the Column [Resolution_210219000001305173] Check whether the datatype for this column is given as specified in the
Data Entry Form With Log In
I have a form for data entry. I would like my users (over 250) with google app accounts to be able to authenticate and enter data into the form. This would be a yearly thing were they should be able to see last years entry and make any changes or updates. These users would have no reason to use zoho for any other reason. I have Zoho with it using my Google apps account for authentication. We have the academic (enterprise) version of Google apps. How can I best have the users log in and access this?
How to get fields value from previous submitted record in different Form?
What I have: I have several forms (Contact Form, Property Form, Financial Form, Activities Form, etc.) Details: Fields in Contact Form: Contact ID, Name, Address, Phone Number. Fields in Property Form: Contact ID, Name, Property Address, Property Value, etc. Fields in Financial Form: Contact ID, Name, Current Asking Price, After Repaired Value, etc. Fields in Activities Form: Contact ID, Name, Description, Method, Importance, etc. What I need: Once I submit Contact Form, then automatically open Property
Enter 1 field, then multiple field then auto fill !!! Help !!! Brain melting
I am a newbie to zoho, but I am a quick learner. I have learned about pick list, and auto fill. Example , I pick a state, and then in my city drop down, it will only show me cities in that state. I think its called a pick list, But its only one to one.. I pick a state , then it gives me cities .. i need something that will allow me to input one item,, and have auto fill of multiple fields.. My goal is this. i want to be able to import, records that contain [store id, address, city, state, zip] in separate
Two charts one screen?
I have a chart showing items on the y-axis and counts on the x-axis. The chart is filtered by date range. The user wants to see two charts side by side showing different date ranges (this month, last month, other date ranges). What is the best way to do this? Herb Wexler
zoho.crm.update() OR zoho.crm.updateRecord() or zoho.crm.updateRecords() - is this wrapper for the API call updateRecords coming soon?
Hi, Obviously zoho.crm.create() works well...but there doesn't appear to be a function zoho.crm.updateRecord() OR zoho.crm.updateRecord() or zoho.crm.updateRecords(), which would also be really convenient. Is there any sign of this update wrapper function being created? I can use the API (XML-RPC) stuff...but the wrapper is so much easier. Hope there's some good news coming on this front? Regards, Liam.
Freezing columns
Hi, We would really really appreciate if the facility of freezing rows & columns is present in the list view and the grid view of zoho creator. It is very difficult to work with large number of records with constant scrolling up and down. If using the grid view to edit data, it makes it very cumbersome and error prone. Please do put it on your roadmap for improvements Thanks
Notification when a field has reached it's limit?
How do notify myself when a field limit is met? fetch = Registration [Course == input.Course && Finishing == input.Finishing]; num=fetch.Finishing.getall(). size(); { sendmail [ from:zoho.adminuserid to:zoho.adminuserid subject:"Enter Text Here!!! " message:"Enter Text Here!!!" content type:HTML ] } How do I send myself an email when the 16 limit is met? Thanks for any assistance...
How do I create a combined view from the data of two forms.
So I created a form that has exceeded the maximum amount of fields I can create. Therefore, I need to create a second form that is a continuation of the first form. I then somehow need to provide a view that combines the data from the first form with the data from the second form in synchronized way. Example: Customer fills out form A and clicks submit. They then use a link on my web page to bring up form B and begin filling it out. They then click submit. Data from both of these submissions need
Combining data from two forms into the same view
So I created a form that has exceeded the maximum amount of fields I can create. Therefore, I need to create a second form that is a continuation of the first form. I then somehow need to provide a view that combines the data from the first form with the data from the second form in synchronized way. Example: Customer fills out form A and clicks submit. They then use a link on my web page to bring up form B and begin filling it out. They then click submit. Data from both of these submissions need
How to make multiple fields required based on a Check Box selection
I'm creating a credit application form asking the user to check off customers he wants to open accounts with. I created a list of Check boxes for each customer (30+ check boxes). If the user checks off a certain customers, how do to I make other fields on the form required? Example: Check Boxes for.... (user can check off as many accounts he wants to have opened) - Flooring: ABC Carpet - Office: Office Depot - Paint: Our Paint Co - Flooring: Your Floor etc... If they select a flooring supplier
Creator integrate with hardware?
Hi, We are developing an application need integrate with a hardware, so can Creator support integrate with hardware? We need integrate with scanner or voip.... Andy
Function type List
Hi I have a simple function which is of type list. It has the var temp1. In this function I set temp1={"john", "elise", "jake"}; and I return temp1; However ,the above values are not being inserted into the correct form as I have would expected. Please advise. Thanks!
Importing Date-Time from Excel
Is there any date time format that creator will import? From excel, access, or otherwise? Please, I really don't want to enter 1000 time records by hand with your date picker We have a not for profit and need to upload event days to create a date picker
delete record after specified time ?
Just wondering is it possible to build an action that will automatically delete a record or archive a record after a certain amount of time? tks
Form Didn't Load in The Embedded spot !
Dear Zoho Administration From seen many USERS problems, i think RICH TEXT AREA can't work well. For this reason Embedding Form is slow down and can't load properly at the embedding Site place where USER wants to use it. just see a problem below: http://help.zoho.com/portal/en/community/topic/my-form-doesn-t-load-in-my-website#2266000002143250 Please attention on this problem and solve it. So USERS didn't lose stratification on ZOHO. Thanks With Regards NP
Displaying dialog messages in visible area of embedded forms
In Zoho Creator forms, we display success and error dialog messages during data addition. On embedded forms, this error / success dialog message is displayed close to the top of the form only. So, when you scroll to the bottom of the form, this message can be seen only by scrolling all the way to the top. That is, the message is not displayed in the visible area of the form. As a solution, you need to 1. Embed a js file using a script tag as shown in the example below: <script id='zc_external'
Sign-in Issue
I'm attempting to sign-in to my application and it redirected me to this: I tried this on both Chrome and IE. John M. Whitney
Grid View not working
Hi, When I try to edit data in grid view, I get a message that records failed to update. There is a screen to show details of the error, but it doesn't show any details. If I switch to "List" view, then I can edit the same data without problem. Cheers, Katie
data format error
when I hava used import data in the view ,the data format appear alteration. eg:The time is '2011-03-14 22:31:09' ,it display '2011-03-14 10:31:09' how to solve this problem?
Help with 30 limit on view
I need to export my data in one file, and I am unable to do this with the 30 variable dropdown limit. Please help, I can't use zoho if there is no way to access this data in one file. I am attempting to use zoho reports to analyze the data but is seems impossible with the limitations because my data is unable to be read in one table.
data does not update.need HELP pls.
Sir, In this apps, I have 3 form and 3 view. 1.stocklist 2.stock in 3.stock out in "stock in" form I have a field "quantity".each time I submit a value then it should update the value in stocklist view field "quantity stock in".Same goes for "stock out" form into "quantity stock out". Somehow it does not update any value and I've tried it on other record and only certain record is succesfully updated. I dont know which part im wrong but pls guide me to solve this problem.Before this, the previous
My form doesn't load in my website.
Hello Zoho Members, from some days i am encountered a problem with my Zoho Creator form application. At the my Website i am embedded my form, when i am embedding it that time everything is fine, now my form is doesn't load in my website. there is circle which is rounding and rounding but there is no form coming however i will waited for 1 hour. I am doing so many things with it, but it is still happening. Please suggest me immediately, because i lose my customer satisfaction. With Warm Regards Roger
Global Variables
Re-posted idea from http://help.zoho.com/portal/en/community/topic/stateless-fields-and-push-buttons-in-a-database-form There is value in having a programmatically accessible global variable list. It would be similar to our global functions in that global variables can be used anywhere in an application (similar to zoho-defined variables). Here we could define our own variable names, types (numeric, date, string, etc), and optionally add default values that could be referenced in any code or form
Form cannot be edited but only can be viewed
https://creator.zoho.com/ropdata/rop/ I cannot edit this form anymore. Only view is available and data entry can be done. How can I edit this form as I want to add new fields. Dr. Amer
New User with a few questions
1. How does one set up subforms/tables in Zoho? I don't see it yet. 2. How does one set up a "template" for the form data. For example, so that phone numbers appear as (###)###-####? 3. How does one get the "height" control for the field attributes on the form activated? At this point I can only adjunct the width.
count record of form A with a criteria from fom B linked with a lookup
Hi let Say I've got a form Account ID USER + other fields I'v got Also a form Submission ID AccountID (Form Account lookup with ID) + other fields Now I want to count Submission that has the current loginuser has user. How can I do that? I tried: Sub = Submission[( AccountID.UW == zoho.loginuser)].count(); but it doesn't work How can I do that? do I need first to create a list of accountID that is assigned to the current user and then count submission that is in this list. if yes how? thanks a lot
Using / Calling a function to create a global variable to collect a list of records
I have a registration application where I collect Account registrations and each registration has a reseller. So there are many accounts per reseller. I am building another application where when I select a Reseller from a multi-select lookup, I want it to automatically select all accounts in another multi-select lookup associated with it. I created a function in the first application string sample.getAccounts(string getaccounts) { if (count(Add_Registration[Reseller == input.getaccounts]) >
Is it possible for a form input field to span two columns?
I'd like to have most of my form use two columns, but have a large text input area that uses the full width of the page. Is this possible?
How to add labels inside drop-down?
When I view the data entered there is a drop-down box for filtering... It has un-selectable labels in it. I would like to add the same un-selectable labels to a drop-down box in my form. I have attached an image with a screen shot of each drop-down illustrating my question.
CRM iphone App Trouble
Hi, I use this app in the field to set events for appointments as calls come in. That works fine, But I am unable to view events in the calender( says no events even though I know they're there) and the Event selection has options for Today and This week but not Tomorrow. The results come up in a scattered fashion so I am unable just to view scheduled evens to see whats available for the next day. Could you guys please correct this. Or if Im missing something please let me know. Thanks,
Any plans on being able to view time as AM PM time format in views?
Any plans on being able to view time as AM PM time format in views? Hi would like to be able to view a 12 hour (example 10 am or 10 pm) clock on our view that has a Date-Time field How can I do this? Script solution is fine too
View - Not able to be edited. Get error "[ServletException in:/jsp/edit/view/viewedit.jsp] null'"
I have a view that can be viewed, but cannot be edited. I get an error "[ServletException in:/jsp/edit/view/viewedit.jsp] null'". I was attempting to create a custom criteria on a view to limit records to "This week" and another one for "last week". On saving the script I noted that it replaced a criteria formula with null. The original view is still accessible and usable, but I cannot edit the view. It always give this error message. Tried a few different back doors to edit the view criteria to
Custom Action to Print Record
Hello I am completely new to Zoho Creator and am struggling to set something up which I am sure is pretty simple. I have a Form with 20 odd fields. I also have a view set up which displays all the records. What I want is to add a button (at record level) on this form which will allow the user to print the record. I only want to print 5 of the fields and preferably without field headings and in customisable HTML format. I can see that you can use Custom Actions within the View to add the print button.
One of my tables disappeared from "Edit Mode"
Hi I edited a field type in my "Create Invoice" form in my Frozen Foods application and the form has disappeared in editing mode. All I did was add an Initial Value in the field property for the "Country" field, and the form no longer shows up. I can see the view for it though. Can someone fix this? I have given edit access to support. Thanks
Recurring events Creator Calendar
I would like to create recurring events in Zoho creator calendar. I have to schedule nurses to see patients every day and beable to keep notes on the patients. I have created a database already and I need this to work so when the nurses login into Zoho they can see their calendar with all their patients listed for the week, month and maybe yearly. All the help I can get would be great. Thank you
Next Page