i am facing issue in inserting quotes in zoho crm
the xml date is like below $xmlData = '<Quotes> <row no="1"> <FL val="Room Design">http://creatorexport.zoho.com/DownloadFile.do?filepath=/1355684768006_Classroom.jpg&sharedBy=somebody&appLinkName=applinknam-lab&viewLinkName=room_templates_View</FL> here in the value i am getting the following error string '<response><error><code>4600</code><message>Unable to process your request. Please verify if the name and value is appropriate for the "xmlData" parameter.</message></error></response> ' (length=184)
facing issues in inserting quotes
the xml date is like below $xmlData = '<Quotes> <row no="1"> <FL val="Room Design">http://creatorexport.zoho.com/DownloadFile.do?filepath=/1355684768006_Classroom.jpg&sharedBy=somebody&appLinkName=applinknam-lab&viewLinkName=room_templates_View</FL> here in the value i am getting the following error string '<response><error><code>4600</code><message>Unable to process your request. Please verify if the name and value is appropriate for the "xmlData" parameter.</message></error></response> ' (length=184)
Rounding Problem
I have created a simple form to capture data from our locations. I have set all the key numerical fields (used to capture transactions and hours) to be decimals. However, I have found that it is not capturing the decimal points and is in fact truncating off the decimals. I checked the fields and all are set to 1-2 but if I edit a record at a later date, it's truncated and if I pick 2 numbers it adds to the truncated amount (4.5 & 4.5 for instance add to 8). Can someone assist me in getting this
How to automatically assign an ID number
I'm creating a property database and I need to assign an ID to each property acquired. I'd like the ID number to be automatically assigned so that users don't have to input an ID and also so that they can't adjust the value. I'd like the first property to be assigned an ID of 100, then the next 101, then 102, and so on. Does anybody know how I can do this? Thanks for your help.
Glitch in the Add Records Deluge Script Builder
This is hard to describe. On Success, I was trying to use the script builder to add records from Form A into Form B. The script builder in not functioning properly. When Selecting Form B as the target, the available field list is showing fields from Form A. Switched back to the old script builder and it works fine.
Deluge script not working
I am having many problems using the Zoho Creator application builder. First of all, changes to an element action do not save. Instead, if I make a change and click "Save" it wipes out the script and saves as though I cleared out the script. Second, I cannot add more users to the application. Third, I cannot share the application with any of the current users. Fourth, the "My Account" window does not load anything except a white screen. This application needs to be launched ASAP so a response would
Where is "Share to Support" in New App Builder?
I've looked under Settings> General and Share it cannot find it. Where are you hiding it?
Lookup Field - Set Criteria
Hi I am using a lookup criteria that is retrieving a list of names (Assessor_Names). In the set criteria section I want it to only show a select few of their names. E.g. Assessor1, Assessor 2 and Assessor3. I can get it show only one Assessor by using: Assessor_Name == "Assessor1" But I want to specify three different Assessors to display. Sorry for the dumb question! Still learning! Thanks
Desparately Seeking Fetch Help
I am very new to this and attempting fetch the value of a formula to populate to populate a field on another form. This is the script: PropPub1 = LUX_Enrollment[Street_Address == input.Prop1]; if(input.Prop1 == PropPub1.Street_Address) { if(PropPub1.Pub1 == "") { PropPub1.Pub1=input.PubNameLPC; PropPub1.Pub1Cost=input.Insertion_Cost; PropPub1.PubIssue1=input.IssueLPC; } My other fields work fine but the formula is exhausting me. The number fields are set as
zoho.gapps.createEvents
Hi All I see it could be possible to write events into Google Calendar from my Creator App. Its possible to have many Google Calendars so which one does the entry go into or is it configurable? It is possible to create an entry but what about deleting an entry. I noticed there is a return code for a successful entry. Can this be stored and then used to delete an entry when prompted to by the Creator app? Cheers
Automatically assigning an ID number
I'm creating a property management database and need to assign an ID number to each property acquired. I'd like the ID to be automatically assigned so that users don't have to input an ID and so that they can't adjust the ID. I'd like the first property to have an ID of 100, then the next to be assigned 101, then 102, and so on. Does anybody know how to do this?
combined view from different forms in new app bulider
Could you please explain how to create a combined view(report) from two or different forms in the NEW APP BUILDER? You had given the explanation for the old builder but such things are not possible in the new builder. Please someone suggest me
Simple list of items and add-on's to a total price?
I would like to create a simple form that a customer could make several choices and see the total price. Question 1. A dropdown list of sizes of a product available. (10x10 = $100.00) (20x20 = $200.00) (25x30 = $230.00) Question 2. Optional Paint Color (Red + $2.00) (Blue + $1.00) (White + $0.00) Question 3. Optional Clear Coat (yes) or (no) if yes add $5.00 Total ________ = (Selection 1 + 2 + 3) Submit button would forward the selections and the total price to an entered email address? Can someone
Rename uploads automatically?
Hi, all. I'm researching the possibility of using Zoho Creator to organize an academic conference. I'd like to know if Zoho Creator has a way of automatically renaming files as a user submits them (or else batch-renaming all the files at once). In the past, we have manually collected conference submissions as email attachments and then numbered them by hand, associating those numbers with a last name in a Google Doc. With hundreds of submissions, this is a laborious process. But, if each user could
Script name change
When I change the script name of a field or eliminate it, Creator doesn't recognize the change. I have to exit Creator altogether and restart.
Filter rows and then batch-download attachments?
Hi, all. I'm researching the possibility of using Zoho Creator to organize an academic conference. We plan to have users upload their submissions to a central database, where we will later blind the filenames and assign them to referees. It would be great, once the referees were assigned, if we could run a report that would filter all the rows in the database that match Referee X and then download all of the file attachments from those rows at once to ZIP and send to the referee. The alternative
Educational pricing for Zoho Creator?
I'm researching the possibility of using Zoho Creator to organize a conference at my public university. I understand Zoho Creator has a free tier, but I would like to know if they have discounts on the higher tiers. I think the next level up would be perfect for our use, specifically because of the higher number of reports that tier allows. Thanks for your time! Ryan
Button in Zoho creator view/report.
Hi All, I was looking into marketplace to get idea on designing my application. The first application i found is "Order Management". In some of the reports (views), it has given button to perform some actions. For example in "Pending delivery", it shows list of items, which needs to be delivered. For each items, it has given one button called "Delivered". When you click on button "Delivered", the entry will moved from "Pending delivery" view. I want to implement same where in in my form view called
Where is the Customize Theme feature in the new builder?
Folks, I am reading the article on Theme customization using the following link: https://www.zoho.com/creator/help/customize/theme.html But in my new App Builder under Setting -> Customize section, I am not seeing the "Customize Theme" option. Is this option only enabled for paid user? I am using the free version for now. Any input will be greatly appreciated. Thanks.
Embedding a report without displaying menus and edit features
I have no technical knowledge and do not understand the majority of what I am reading. I have report embedded on my site (iframe). Someone set it up for me so that only the records of the person searching are displayed, while suppressing all records not belonging to the person searching. Everything works fine - but, when the report displays it also shows all of my menus and edit options that the person can see and click on. I only want them to see their results - not all the administrative options
Issue about Richtext.
An issue occurred after disable Richtext in Layout "Pane Left"or "Tabbed Pane left". Please see the screenshot. Please fix it asap.
Images from iphone too big
Hi there, Just created form to use from iPhone. When I attach an image from iphone into form, the form will not upload to Zoho server. Red error message says that image is too big. Anyway to reduce size of image prior to attachment ? What image size is preferred ? THanks Jai
Notice of not secure web page in Zoho Creator Application
One of my application (on going development) has this this notice: What does it mean and how to deal with this? Thanks!
Creator Graphs can be so powerful !
Whilst the Report capability within Creator appears quite basic, it can still be very powerful. A simple 'Stacked Bar Chart' can provide my user with a simple yet powerful interface to easily review the data they need access to without having to review long reports. However, I am still unclear as to the mechanics within Zoho that executes the 'regeneration' of report data. I display some of my reports, via a HTML view with a 10 minute refresh, and sometimes the data displayed is not always up to
Re-posting: Issue with new application builder's look-up feature
My app has a number of forms that have look-ups to a database of room names. Thus, records submitted pull these room names using the look-up. The reports of these records show the room names as expected. However if I try to write any code to reference a room name, only the ID values of the room names are available, not the text versions. How can I write any functions that have text value inputs when only ID numbers can be referenced? Here's an example
Record Template (New App Builder)
In the new app builder, under form settings, I found "record template". It is described there as "A Record Template allows you to create beautiful visualization of your data. Some uses include estimate, brochures, certificates, newsletters, campaign mails, visiting cards, product phamplets* etc" So I made one and it looks like this: Please explain how I can use this to present my data? *spelling error
Creating a view
In zoho Creator with CRM: Is it Possible to have a view that doesn’t need à form but only a view that calculates automaticly many fields (from another Tabs… like the amounts of the potentiels Tab)?
how to create a login for affiliates to check their commission earnings
Hi, I have a real-life Business Scenario that Calculates Sales commissions in Zoho Creator App, such as in this example: https://www.zoho.com/crm/help/automation/webhooks.html#Business_Scenario1 The commissions calculated belong to affiliates, and since affiliates are not staff members, we do not give them staff login access to our Zoho CRM/Creator. However, they would like to be able to log into their affiliate account (the above app) and check what their commissions are to date. Question: How do
About zc_LoadIn=dialog and zc_NextUrl=
The recent additions to the navigation features of ZOHO Creator ... using zc_LoadIn=dialog and zc_NextUrl= ... in the url values of the openurl command and links (within HTML Views) ... can significantly enhance the overall ergonomics of applications built under the ZOHO Creator platform. So, I decided to investigate the behaviour of ZOHO Creator in response to user actions when such features were deployed. With few exceptions, the responses are as expected ... and will add a lot of versatitlity
Towards a generalized HTML table-generating scipt
I'm trying to generalize the table-generating script presented in https://help.zoho.com/portal/en/community/topic/html-views-18-2-2013 (which is quite useful as is). My current version is as follows: htmlpage Table_script_test1() displayname = "0Table script test" content <%{ Width = "1200"; Table_Caption = "WBS Info"; Col1_Header = "Activity"; Col2_Header = "Main Dependency"; // Form_Name = "WBS"; Criteria = "ID != null"; Col1_Field = "Activity"; Col2_Field = "Main_Dependency";
Can't upload excel sheet into Zoho Creator Application
Hi there I am trying to upload an excel sheet (.xlsx) with 9 columns and 140 rows. Whenever I browse on my computer for the file, then select it and click "create", I only get to this URL https://creator.zoho.com/importData.do and it stops doing anything. It's just a blank page. Is there anything specific that I need to do with the excel sheet? Is there a limit of character I can use in the cells? I am looking to use Zoho for my new product launch but I need it to work properly. Thanks for the feedback.
Spell Check
I note that Spell Check does not continue to work after I make the first of the suggested changes. Once I make a correction, any further spell check is absent. But if I highlight the entire paragraph, right click and de-select spell check, and then re-select spell check any mis-spellings are again shown.
Importing Excel spreadsheet
I am having trouble importing an excel spreadsheet. Creator says the import is successful but the data doesn't show
Multiply
I have two number fields; cabHeight //inches cabWidth //inches another field on the same form called sqInches I want to multiply the first two fields and put the total in the third field. What would this script look like and where would in go "on user input, update, success field level or form"?
Adjust Column Width on PDF
Hi, I am running a few schedules where I send some "views" as pdf attachments. I adjusted the column width for each of the "views" using "Set Column Width" but these adjustments are not showing up on the pdf attachments. Is there a way to adjust column width for the pdf attachments generated for "views" via Schedule Function? Thanks! Vishal
How to improve performance
I am wondering if there is any way to improve the performance of Zoho Creator. While I was making a presentation, one of audiences did not like the delay of page loading. I found that somebody posted some basic advices about writing a script, but is there anything else I can try? Our database does not have much data yet. Only 10-30 records for each table. When I jumped to menu to menu, we saw "loading" icon. Should I just say it is common because database is a memory intensive application? I do not
Problem in downloading PDF from Zoho creator.
I have created a form in zoho creator and I have created a custom view for this form in HTML. Now i want to downlaod the PDF from this form. But everytime I try to download the file from this form it prompts me to log in. I want to download the PDF without sigin in the zoho creator. Help me out as how can I do this.
how can i import more than 70 columns all at once from Excel table?
Hi, how can i import more than 70 columns all at once from Excel table? Thx!
Want to create a Dashboard for Response Rate and Converted Lead Rate
I want a visual dashboard that shows the percentage of contacts who responded to my mass e-mails and a conversion rate from being a contact to a lead. How can I do this? I apologize for the broadness of my question, but I am not familiar enough with the system.
Displaying views with many subform rows
I'm using subforms for a few of my forms. Some of the records have many subform records, ie 50+ children. I have views that display the form and subform results. The views currently display 1 subform entry per line. For entries with multiple subforms, it is very hard to read. My suggestion is to have subform records either comma delimited or per lined as an option. It will make it easier to read rows with multiple subform rows.
Next Page