What am I missing?
form Units { field alignment = left column { must have unique Unit_Type ( displayname = "Unit Type:" type = text width = 50px ) Ceiling_SqFt ( displayname = "Ceiling SqFt:" type = number width = 100px ) Ext_Wall_SqFt ( displayname = "Ext Wall SqFt:" type = number width = 100px )
Question related to integration between CRM and Creator
Hi, At our web site we use a contact form made in Zoho Creator. All collected leads are automatically imported into Zoho CRM>leads. In the contact form i would like to add a "how did you get to know us" field, so that i can track how clients found us. I am aware that i can manually add the options to the creator application but... 1: Is there a way of making the creator application use a pick-list from CRM? 2: I have also been thinking of creating all our marketing efforts as "Campaigns" in CRM,
Add/Remove form fields on demand?
Hi, Is it currently possible to create on demand add/remove form fields using the scripting languages in Zoho Creator?
Is it possible to collapse / expand custom functions (Namespaces) by default?
Hi, We have over 10 -15 namespaces, and each has 5-10 functions. So, when we open the function tab, we have to collapse each one of them before reaching the function that is at the bottom of the list. Just wondering if it is possible to set a default status collapse / expand these namespaces? or, even a collapse all / expand all option would do Any thoughts? -Deepa Govind http://homepreneur-online.com/
Cell padding
Hi, is there a way to manually change the vertical distance between to fields in a Zoho Creator application? I would like to make the vertical space smaller, since the application - in our case a contact form - takes up too much space in our web site. Regards, Bo
Links to Main Apps
I understand the challenges of coding and including a new UI to manage all your apps - so whay dont you try this easy solution for those who have many apps A small window where you can store the links to your top 10 apps ... ( just like the Link UI you have for Zoho CRM ) Thank you Ariel Segall Cloud Mobile Forms Zoho Partner arielsegall@CloudMobileForms.com (877) 436-8133
Emergency need zoho.invoice.getInvoices() to see more than 200 invoices.
When I run this script it limits at 200 Invoices. I have to be able to loop through all invoices to check status and balance of the invoice. This script has been working, however we now have more than 200 invoices in Zoho Invoice and the records are not being updated back in Zoho Creator because of this limit and therefore we are unable to pay employees. counter = 0; inv_info = zoho.invoice.getInvoices(); for each rec in inv_info { counter = (counter + 1); } alert counter;
Summary View Column width
I've noticed that it is possible to change the width of the columns in a list view but is there a way I can change the width of the left column in a summary view? Right now, the left column (with the headings) is the same width as the corresponding information (in the summary view). I would like to make it so that the information column is always wider than the headings column. Thank you.
Header option in HTML view
Hi, I've created and HTML view which includes an image. In the HTML view I have the print and pdf options = true. When I click on the print option in live mode the image is displayed with the rest of the data, but when I choose pdf the image doesn't render. Any ideas?
Need to use same form for different applications in ZoHo Creator
Hello, is it possible to save one form in ZoHo Creator so that form can be used in another application. Have several spreadsheets we need to keep separate for data tracking, but they all use the same form and trying not to keep having to rebuild form.
Best Practives Comparing Strings
Could you please share Best Practices when comparing strings. Sometimes, when I use strings that contain numbers as alphabetical characters, comparison commands only work with string.contains("____") If I use if ( check = "_______" ) , even if it is equal, that condition DOES NOT work, but if I use contains, it works Any ideas why ? Ariel Segall Cloud Mobile Forms Zoho Partner arielsegall@CloudMobileForms.com (877) 436-8133
Calendar
How do you put data from 2 different forms onto the same calendar?
How do I get a formula field to equal the result of a radio field?
I'm trying to put a formula field into a form and I want it to display the result of a single radio field in the same form (text). What would I need to put in the expression? The reason for this is because the radio field is a status field (eg " JOB CANCELLED" and I have a subform view which cant create a "criteria view" based on the lookup of the status because it's a radio field. So I've been advised to create a formula field which equals the radio field then lookup the formula field to create
All Apps have disappeared from users and admins home page
Yesterday, all users have lost their list of shared applications on the home page. Including the administrators. We can still log in if we go strait to the application, but I nor the other administrators can now administer or manage the apps. I have read that enabling a certain level integration will Google Apps will cause this problem. However we have not made any recent changes along this line. We do allow using login through Google, but this has been in effect a long time.
lookup fields with autopopulate
I have a database that has Club Numbers along with the members in each club. What I am trying to do is when they choose the Club Number from a drop down it then goes to the member number field and I can choose the member number associated with that certain club and then it autopopulates the rest of the information in that member record( for example their 20 scores on file). Also there may be duplicate member numbers not in the same club but within the database. So what is happening is when they
Is there anyway of editing the "added time" field in records
For very various reasons the data we had needed to be edited so it was done in excel. Now when we added it, the added time was all the same. Is there anyway of changing this?
Fetching a record from a dropdown/multi-select/radio List
Having trouble fetching a record from a dropdown/multi-select/radio List. I read somewehre that this is a known limitation. For Example) Form A has a field "Customer Status" with 4 radio button choices Form B want to pull the selected status into a new field Does anyone have a workaround. Thank you.
Importing: Excel to Zoho Decision Box
I'm having a real hard time trying to import a two column excel file into Zoho properly. This column contains to field: Number, True/False. I'm trying to import it to an existing table in Zoho so that the True/False field is updated. I've tried changing the true/false values to 1,0 and yes,no and it still will not update the values in my table. Really need help. This should be a simple process...
Move application to another account
I have a Zoho Creator application on my account. Now I want to move it to another account (not share!) with all forms, views and tables(with data!). (another developer will support it. And as I understand there is now ability to set two developer on one application) How can I do it? Thanks
Run schedule on certain days of a week?
Hi, Is it possible to program schedules to run on certain days of the week such as Mon, Wed & Fri? Thanks! Vishal
Initiating many records - HELP
UPDATE::: I seemed to have found the issue, but it bring up another issue. First off, what i thought was a limit on the number of records that i was able to initiate at a single time, was wrong. The problem was in the special charters that existed in the zoho reports database such as [ & , - \ () ]... After I manually removed them, the record initiation worked as it should... Now my next issue is how do i get it so it will except the special charters listed above? ------------------------------------------------
Can't rename column
I have tried repeatedly to rename a column in a view, but every time I save it (it appears to be saved on screen) but then the change disappears every time I refresh page or open it up again. https://creator.zoho.com/phillytechnews/phillytechvcinvestments/#View:venturebase_View
Relationships between applications?
I am using the free version and have created three applications - inventory, orders, and customers. I have tried using lookup fields to automate the orders form (bringing in data from products and customers), but cannot seem to get access to more than the single field I choose in the lookup field. Creating formula fields, or criteria in other types of fields, in the orders form does not see have a way to access other fields in the Products or Customer applications, except the single field chosen
Is zoho creator going to help me get more traffic by being seo friendly?
Is zoho creator seo friendly? Will the search engines look at the data as from my domain?
INserting (fetching) email via API
Hello, Is it possible to insert (upload) and email via the CRM API? That should of course include the ability to define which object to "associate" the email with, and all the relevant email fields (Subject, From, To, CC etc) with the body (in HTML or free text). If yes, is there a sample code available? Thanks,
Open a second form based on a decision on another form?
Is is possible too have a user open new form based on a choice made another form?
Zoho Creator and Zoho Recruit question
I run a temporary recruitment agency and currently us Zoho Recruit for my candidate data and Job Vacancies. I have added a few custom fields to suit to my specific needs within the Candidate Module and the Job Vacancies module, however the majority is standard setup. I have a specific group of fields in my Candidate Module for reference details within Zoho Recruit. I would like to pull this data (eg school name. school address, date of employment etc) out of Recruit and then for Creator to populate
How can I make my own template form to use over and over for data in Creator
I see the pre-built templates in ZoHo Creator, can I make my own to choose from when lodaing data in?
how to stop/cancel a form ?
Hi, i have a question : how to stop submitting a form after a period of time ? let's say i want to cancel submitting form by users after two days since i publish the form into the web page. something like a timmer.
Script Builder view truncated - no scroll bar
When I go to write script in Script Builder the right hand side of the screen is truncated slightly. The scroll bar is missing, as is the right side of the SAVE SCRIPT button. The result is that I cannot scroll, and so it is very slow to move around long scripts, which is a nuisance. If I switch to Free Flow Scripting the view is fine. Any suggestions? Is it a problem with the browser, or is it at the Zoho end? (I use Internet Explorer)
Desperately seeking assistance
I'm working very hard to make Zoho Creator work for me. I must be very dumb, but things just aren't working out. I am a volunteer book review editor, and I need to maintain a database of which reviewers have which books. There are some date calculations, easily done in a spreadsheet (I've been maintaining the list in Google Docs), but a database would just work better for me -- reports, etc. Is there someone out there who will volunteer to write the field specs for the calculated fields? I don't
Using Record ID to fetch data - Is there an issue?
I am trying to fetch data from a table using the record ID. Is there a problem with this? The script below is On Load script in a form.. The first 2 lines successfully find the record number from a form and populate the Record_ID field. The last 2 lines are supposed to use the record ID to fetch the customer name (CustName) but Test_Field remains blank. I have checked that the Record_ID is valid. It was generated from another script. I can't see why this doesn't work. EditData = (Record_ID_temp[Key_Code
Edit records using stateless form - Do I need a regular form to pass data?
I am struggling to find a way to upload the data from a table to a stateless form without creating a new regular form to pass the data. Is there a simpler way to persist the data? This is what I planned to do: I would use a 'Custom Action' that is selected from the dropdown against the record to edit. This calls a function to which I can pass the record data through the arguement to the function. Then I want to use the existing data to populate the Stateless form, but I can't see how to do this
Sending an email from a view
On a view I display a url field. When clicked it opens a new tab with the appropriate web page. Is there a way I can have this trigger a deluge script? I would like to send an email to the site owner that someone clicked on the url for their site. Herb Wexler
Creating an archive table
Please may I have some help - new to Zoho, some experience with Access. I have an application : Invoice form : Invoice_ID , Date , Cust_ID Invoice item form : Invoice_Item_ID , Invoice_ID, Item_ID( LookUp from Item) , Quantity, Price(Look Up from Item) , Discount, Tax, Extended_Price Item form The item form prices will change daily / weekly or monthly . So I need to create an Archive Invoice Item Form that has the prices saved for the day the transaction took place. So I need to be able
Totalling amounts
Hi Great idea and I am hoping I can achieve what I want to do. I am trying to create a simple application for managing accounts. I have created a form that contains, simple company information together with details of the invoice (whether credit, debit, how much, type, etc). I then created several views: 1. Debits Unpaid 2. Debits Paid 3. Credits Unpaid 4. Credits Paid 5. Accounts What I would like to do is to being to have a total box for each of the views created. i.e. This is how much Debits Unpaid.
count items in colum using aggregate record
I am tracking apartment complex units that have been cleaned. I have a dropdown field with the following values: 3 – BDR and 4 BDR units. My end goal is to get a count of how many 3 –bedroom units and 4 bedroom units in the column. How would accomplish this using an aggregate record task? Example 4 - BDR Units = 10 3-BDR units = 7 Thanks
Creator API Error 2832: [application owner] parameter is not available in the request
I have a PUBLIC form and I am trying to add data to it via the Creator API. Since the form is public, my call to the API is unauthenticated so I am passing in the zc_ownername in the call parameters. Yet, I keep getting the 2832: [application owner] parameter is not available in the request error in the response. BTW, I am passing in the authtoken and scope parameters in the call. Has anyone run into this problem? Regards Moiz Tankiwala Smart Training & IT Solutions
Custom function with openUrl to open URL that has been entered in form does not work?
I am having some issues with the custom actions. I have a form called "Suburbs" in which I have two fields, "Suburb" (which is a text field) and "RPData" (a URL field). I want to create a view which has two columns, the "Suburb" field and a custom action "View Suburb Profile" I have defined the custom action: I then have created a view, where I can select a suburb, and then click on the custom action View suburb profile, which I want to then launch the RP_Data URL for that suburb. However, when
Custom Actions and Edit menu problem in popup views
Hello ZC team, If a view is opened in a popup window, using zc_Loadin=dialog parameter, and the view has Custom Actions dropdown, look what happens I have to go to bottom of the page to access custom actions. Also, when I access Edit menu, I get a similar result and even worse, not all items are visible. Please solve this as fast as possible - it is a problem with the new views layout implementation which simply broke existing functionality. Also, even if I think that overall the new layout for views,
Next Page