Can you left align a number field in a view
Text fields are left aligned and number fields are right aligned in views. Is there a way to left align a number column?
Anyone have a step by step with regard to zoho creator and google calander?
A sample app maybe? I cant get it to work?
Lookup field is not populated in "Edit" mode
Hi, I've got an application that was working fine until a couple of weeks ago, but is now not working I'm afraid. I have a form called "Games". The only field in this form is "GameDate". This is a date field. I have another form called "Results". This has a lookup field called "Game", which references the "GameDate" field of the "Games" form. When I look at the view for the "Results" form, I can see that the reference to "GameDate" is working fine. When I *View* one of the records, the "GameDate"
Online Survey
Hi, First of all I want to say that Zoho is light years away from any Google and Microsoft online services. Zoho rules! I want to make an online survey, but Zoho has so many services that I don't know which is the best. I'm between Zoho Creator and Zoho Challenge. I need to create a permanent survey, that anyone in the web can reply. Public. The person will input data such as name, phone number, and others (personal data, so I'm the only one that can see the results). Also need radio box, multiple
Report PDF Exports do not match User Filter criteria
When I enter criteria in a user filter on a Report, such as a date range, and then go to Export to PDF, the export includes everything from the database and not just the data within the date range I had specified. Please let me know if I am doing anything wrong if there's any way I can help you recreate this issue. Thanks, Jennifer
Auto-populate fields based on Login
Hi Zoho, I have a form that I am using for our team members to log issues related to various publications. There are certain fields that they have to enter over and over again that are the same, depending which project they are working on. Is there any way that I can have the form automatically set default vallues depending on the login. For example, If loginid = xyz then Course = "Level 1" Reporter = "Jane Doe" else if loginid = abc then Course = "Level 2" Reporter = "John Smith" end if Is there
changing existing form to another
hi, I want to know how to change an existing form to the timesheet form thank you
Browser Connection Setting NOT honoured in Chrome and Internet Explorer Browsers
On this page ... accounts.zoho.com/u/h#setting/preference ...my Browser Connection: setting is UNCHECKED. When I sign in using Firefox ... my Home Page and the Home pages of my Applications are all accessed using http. But when I sign in using Chrome (v11.0.696.71) or Internet Explorer (v8.0.6001.18702)... making sure that Use Secure Access is UNCHECKED ... my Home Page and the Home pages of my Applications are all accessed using https. Gaev
ZCreator with Google Apps sharing ONLY with Google Apps users
I'm an administrator of a small Google Apps.I've installed ZCreator in my Google Apps, because I want to share ONE of my application with Google Apps users. Other applications I'd like to share with users outside the Google Apps, but now I'm not able to do it. It can't be true, can it? :)
How do I create a function in "On User input" action?
I am not really familiar with scripting languges, so I need an advice on syntax of functions definition. I understand how to create functions in "Functions" section. But I want to use "hide" and "show" keywords inside a function. As I understood I can not use it in scripts from "Functions" section, only in "On User input" action or so. Thanks in advance!
The Alert Box...
How do I do a new line in the alert box? Tried <br> as a guess, but didn't work. Also, how can I do a "for each" in an alert box? I want to list 2 fields from records. Right now, it lists all the info I want, but it does <field1><field1><field2><field2> I'd rather have this: <field1><field2> <field1><field2> Hope I explained that correctly. Thanks in advance!
Nested dropdowns?
I'm trying to create multiple nested dropdowns for use in an attribute agreement analysis, but cannot seem to get this to work beyond the 2nd column. I have a source sheet (Sheet2) that has 5 columns of data - each connected to the next. I need to be able to create 5 dropdowns in Sheet1 that populate left to right based on the prior selection. The idea is that I want people to evaluate the test cases in Sheet1, and get the right options populated in the dropdowns from Sheet2. I imported the workbook
Filter results in a lookup multiselect field according to a lookup dropdown menu
Hello, I have two databases: one concerning centres, and another concerning students registered at theses centers. I would like to filter the results in the lookup multiselect field (listing all the students), according to selecting previously the appropriate centre in the lookup dropdown menu. For instance: List of centres: AAAA, BBBB, CCCC Lista of students: Carlos (AAAA), Marisa (BBBB), Peter (BBBB), John (CCCC) So idea would be: if we chose "BBBB" in the lookup dropdown menu, then display only
Email Data into Zoho Creator
How long does it take for data to show up in a view when using the email data feature? I've sent 3 emails in, about 10 mins apart, and none of them have shown up. I'm using the same account (email address) that I used to create the application when I'm emailing in the data. Thanks.
All my zoho creator embed form down this morning?
Hi support, All my zoho creator embed form/ view down this morning, can't access at all... it seems just shut down. Kevin
MAC computers...cannot access Zoho creator...
- several users on MAC computers cannot access zoho creator .... they've tried Firefox and Safari browsers. Any advice?
SQL like queries.
Dear All, I have 2 forms with 2 views created on my Zoho creator. I am not using the ids generated by zoho, because the forms will use ID entered by the user (just because this a requirement from the place I work). So, I am trying to write a script that will do the following: while the user is entering data into form B, he will enter the ID from one item from form/view A. After the ID is entered, it will show the information from that item into the form B, and some fields from form B will be automatically
Sharing a linked COPY of an application (without using the Marketplace)
I've developed an application which I'd like to share with another company. Note that I DON'T mean simply inviting other individuals to contribute data to my application -- I mean creating a separate copy of the application's forms, views, scripting, data so that another company can use the app themselves. And if I make a change to the source code, I'd like the change to propagate to the other company. Is this type of arrangement possible? Can I do this using the Marketplace? Can I do it without
Create combined views with more than two related forms
In the help Page about views https://help.creator.zoho.com/Quick-Start-Guide.html#create%20combined%20view it's said : Create combined view You can create a combined view with two or more related forms. "or more" ... it looks like ZC is able to relate two forms and not more. Will zc be able in the future to create combined views with a 3rd (4th?) related form ? (I mean without having to write script in parent form)
Problem with Record(s) that cannot be edited and submitted! Please assist.
I have a record in a particular form that when edited cannot be submitted successfully. Here is an example: The view link is: https://creator.zoho.com/w21admin/w21data/#View:Contacts_All The record ID is: 340313000007715263 When you 'Edit' the record, the form pops up. But whether or not you change any data, when you do a Submit you get the following error: (it is impossible to resubmit this record) Please advise. If you find issues with this record, please scan all records in that form
Lookup field not retaining format
I have a form for products that includes a price field in currency format. I also have a transaction form that includes a lookup field for the product price field. How do I make the lookup field appear in currency format?
Dropdown ID
Hi! Let say, I have two forms: 1. Items (ID, Name) 2. PriceList (ID, ItemID, Price) In this variant if I make in PriceList a dropdown box with ItemID it will be very unconviniend, while very complicate to define item mane by item id. But this dropdown will be unique. Another variant is to put instead of ItemID an ItemName. It will be visible, but not correct for table connections (it must be made through ID) So, how to show in form PriceList dropdown with Item Names, but after choise save in PriceList
Easy way to auto-populate a field with last value entered
Hi Zoho, I have a project where team members are repeatedly entering the same values over and over again for a period of time (an hour or so), then values may change and they are entering those over and over for the next hour. Is there any type of short-cut key that will auto-populate a field with the value that you had previously entered into the same field on the previous record? That would save a lot of time. Thanks, Kim
PickList
I have a question regarding the picklist, I want to set a value from one particular picklist by url on a form, if I set the picklist from the wizard when I am creating the component, when I pass the parameter by url, the set is made correctly however if I populate that picklist from deluge script and I pass the parameter by url, the set is not done correctly, Why?????
Saving changed records in Grid View is *still* hanging and not saving changed records (intermittent, but frequent)
This problem was reported and acknowledged many months ago and still remains an ongoing problem: When in Grid view, if you change some records and click the "Save" link, the application hangs while displaying "Saving Records". The problem seems intermittent, but FREQUENT. After waiting a long time for the saving to complete and finally refreshing the browser, you see that NO CHANGED RECORDS WERE SAVED during the "saving" process. Could this be looked into please? Months ago you said it would
Return type for create tasks
The Zoho Tasks for creating records in CRM and Invoice has its response returned as String Variable. This String response contains the result of the Create Operation in XML Format as a series of inputs for various fields. Since it is XML as a String, you have to use the XPath expressions to access the field type that you need. Say for example, if you need to extract the First Name of the contact, then you should be using this XPath expression : contactinfo = { "Last Name" : input.Last_Name, "First
Update Html
How can i update data in a table in a HTML View everytime new data is entered in my form?
How do I delimit a lookup multi-select field with line breaks instead of commas?
Hi I understand there is no direct way to make each entry of a multi-select field appear on a new line when viewed, i.e. one two three rather than one, two, three However, there is a workaround using the replaceAll function and the <br> HTML tag, which I don't fully understand. Could someone please explain this option? The multi-select field I have uses a lookup from another form to populate the list. Many thanks Martin
Help with script
Could someone please help me? I try to make a scrip but I dont know how. I tried this: if (input.survey == "Completo") { (input.Percentual_Completo==10) } else if ((input.survey == "Completo") && (input.projeto == "Completo")) { ( input.Percentual_Completo==15) } else if (((input.survey == "Completo") && (input.projeto == "Completo")) && (input.infra == "Completa")) { (input.Percentual_Completo==45) } I did this based in the follow syntax: ( https://help.creator.zoho.com/Control-Statements.html
multiple if conditions
Hi, I´m new user and I would like to know how to combine multiple if conditions. For example: I have two fields: -Survey- and -Projeto-. I have another field named -Percentual-. If Survey is checked as "Done" - The Field Percentual have to show "50", so I did the following formula: if(Survey="Done", 50,0) I did another formula: if((Survey="Done") && (Projeto="Done"), 100,0)) Each formula works good whithout the other, but I want both formulas work together. I tried this (didn´t work): if(Survey="Done",
script editor incorrectly changing parentheses
I have a validation script which is being saved without any syntax error but when the same script is subsequently reopened for editing, not changed, and then saved again, the editor throws an error due to the automatic changing of parentheses. The following line saves correctly: if (count(Client_Contacts[((Client == input.Client) && (Is_Billing == true) && (ID != input.ID))]) = 0) However, the script editor changes it to this: if (count(Client_Contacts[((Client == input.Client && Is_Billing) &&
embedd HTML in webstite
I am trying to embed HTML into my webstite and this works properly with one page/view. I am using the referral network from which has mulitple pages to it. how am I able to place this in my website and have users access multple pages/view. Not just the single form. It reading through the help topics, I think it adding the "Get Java Script" Snippet is the way to go, however I do not see this selection on the form I am using. Please assist.
Question About Linking Forms & Records
As I am trying to learn more about how to use this, I was wondering if people could point me in the right direction for something. Say I have a product that has 1000 units available for sale. Someone orders 5 units, and I now want it to display it as 995 units available. How do I do this? Do I enter it manually, or can it be done automatically? What I do everything manually, and so I enter a record for that customer ordering 5 units. Can it automatically decrease the units available from 1000 to
Is sharing having some Problem
Hi, I am unable to execute share script . Even though i have only one user active and 4 are remaining but then too there is a problem. I even visited the Manage Users link and there it shows 4 users remaining but share script shows error that No. of users exceeded. Help me as soon as possible. I am stuck. Regards, Pratik.
need help with simple application
is there anyone out there I can hire to get me started with a simple preferred vendor list? I have the info in Excel, but want to add it to our Google Apps
Repeat until...
Hi, I'm sorry, my English is very little. This is the problem: if((input.subdep == "mag_01")) { a001.mag01=(a001.mag01 + a000.m001); a002.mag01=(a002.mag01 + a000.m002); a003.mag01=(a003.mag01 + a000.m003); a001.Quantit_IN=(a001.Quantit_IN - a000.m001); a002.Quantit_IN=(a002.Quantit_IN - a000.m002); a003.Quantit_IN=(a003.Quantit_IN - a000.m003); } Now... is possible to use a function to increase the value of form and field name? a00x with x = x+1 until x = y
Cannot Duplicate application...
Hello, I cannot duplicate my Art Inventory Management 3.0 When i click duplocate or copy application it just never duplicates. I have Enabled Edit Access to Support. When i save the application and create a new application from it I get the following error: Error at lineNumber:1 Function:thisapp.general.ArtSerial() does not exist The function is there and it does exist. Please help me correct this issue. I need to be able to duplicate this application. Thanks
How do i make an employee number auto assign to new records/form submissions
I would like to use creator to manage employee records. the last employee we hired was number 77, so I would like the next to be 78 and so on, with out having to look up the last used number every time. Please provide the script if you can.
Rich text fields are useless in stateless forms
ZC Team, I tried to access a rich text field in a stateless form with Deluge, but regardless of the field content, it appears as empty in scripts, so there is not possible to use it in records inserts and in fields updating... Thus, in stateless forms Rich Text Fields are now useless. A fast fix of this problem would be appreciated. Regards, George
How find matched record and alert?
I want users to fill out a form but if there is a match between the data they enter and exisitng data in the database I want the user alerted (by email). The email needs to contain the matched data as well as the Case_Code value from the matched database record. How would I do this? I tried my luck at this but it doesn't work, if Case_Management_form(Case_Name == input.Case_Name && input.Case_Name != "") || (Adverse_Party == input.Adverse_Party && input.Adverse_Party != "" email_body = "Possible
Next Page