Post to Url as XML On Success HELP
I am lost I have a form and after the form is filled out . I need to Post the data to an external URL as xml - I have read instruction but I am still lost - I know I need to build map - Not sure how - Any tips or a working example I can see would help tons
Having issues with script builder in Windows 8.1
I wondered if anyone else has had any issues when working on longer script sections in script builder on a pc running Windows 8.1? I don't get the issue with my Windows 7 or XP machines, just with the 8.1 machine.
Schedule a Custom Function to Run Daily
Is there a way to set up a Custom Function to run every day as opposed to when a record is edited/updated/created. I want to use an application that sets the Lead Status based on campaign recipients actions, but the sync from Campaigns which sends this information through to a field in Zoho CRM does not count as an edit, therefore the workflow to call function does not implement when even though their record is updated. Therefore I am wondering is there any way in Creator to set a rule to run the
Creating and linking data to unique identities
I'm very new to this so this is probably a silly question but how do I create a unique identity for people and organisations so that I can then link individual people and their data to an individual organisation. What I need to do is to create a list of organisations and a list of people and then be able to create forms that show the details of individuals in that organisations. So what I want to do is to create a person (first name, last name) then add details of their job and the organisation they
All images in Zoho not showing
Hi We can't see any images in Zoho including the Zoho Logo - is this a sitewide issue or specific to our user login ??
Upload using formula or barcode
Hi all, What I'm trying to do in total is create a barcode (image) in the view using input.feild... i have used this script in a formula to generate image (barcode) <img src="http://chart.apis.google.com/chart?cht=qr&chs=200x200&chld=L |1&chl=" + input.feild +" alt=""> it works quite well however i need it to display the generated image in the views... is there a way to get this done? I'm thinking of creating another formula to upload the image then render it using a "add
Duplicate application not happening
I see other postings on this issue, but they are all some time ago. I am trying to duplicate an app but it does nothing. It's a reasonably large and complex app, but I don't see why that should make any difference. I have tried exporting it, then creating a new app by importing the exported DS file, but that gives another error. Is anyone else having trouble duplicating an app please? Thanks!
How can i display the radio button horizontally not vertically
Hello Could you tell me please how to do that?
Fetching values error/problem
I have two forms set up. They are "Applicant" and "Enquiry". Applicant form has some fields like "Name", "Email" etc. In the Enquiry form, I have inserted a lookup field (theName) and have set that to lookup "Name" as dropdown from "Applicant". I have added another field "test" to this form. Now in Field Action>Name>On user input, I have entered the following code: if (input.theName != null) { data = Applicant [ID == input.theName]; input.test = data.Email; } On saving the script, I am getting this
ER Diagram?
Any idea when you will have some Entity-Relationship diagramming available in Zoho?
Fetch data in html view table
If I have a form called Details with three single fields (Name, Surname, Fathername) and in an html view I have a table <table style="width: 90%" border="1"> <tr> <td>Name:</td> <td></td> <td>Surname:</td> <td></td> <td>Name of Father:</td> <td></td> </tr> </table> how can I fill the tds with the Name, Surname and Fathername from the form (report)? I mean <td>Name:</td> <td><%what I have to write here?%></td> <td>Surname:</td> <td><%what I have to write here?%></td>
Moving Data from Zoho Reports to Zoho Creator
We would like the ability to move data or reference data from a Zoho Report into a Zoho Creator app. Is this possible? I am NOT looking to generate reports from Zoho Creator, instead I am trying to find a way to have creator use the data that reports generates or to import the data from reports into creator. Thanks!
GUI
This is a minor thing but, when views are set to more than 20 records, it would be helpful if we didn't lose them menu at the top when scrolling like the table header.
Function not working for On Delete/On Success to update a running total
I have the following function set up to calculate a running total of donations in a ‘donations’ form. float totals.DonationTotal() { total = 0.0; for each d in donations { total = (total + d.donation_us * d.exchange_rate + d.donation_mxn); } return total; } The following function is invoked on the On Add/Action on Success and On Edit/On Success in the ‘donations’ form: for each c in campaigns [campaign_name == input.campaign_name] { c.total_collected = thisapp.totals.DonationTotal();
On Success or Create Email with Attachements
I wanted to know if it is possible to have the attachment of the candidates resume sent along with there profile details to an email address that I designate. I don't know how to set that up. Thank you in advance, Trisha Rae
Cant seem to duplicate my application
I have tried to duplicate my application. It does not seem to be working.
I need to send email when when editing a record.
I'm new to Zoho and I'm trying to figure this one out. My application has a form and then a view. What I need to happen is when someone edit one of the entries and check a (yes or no) box. I want it to send a email. But the email is sent only when the box is checked 'Yes" and then saved. I went into the workflow and played around with the "IF" statements under "On Edit/Validation" but its not changing anything" Please see my screenshots.
Duplicate Application and automatically update it
Well, my question is quite general concerning the duplication of an application. My question is, if I have a huge application and I duplicate it, is there any way when I change something in the 'parent' application then automatically to make this change in the duplicated application? In other words, to update automatically the second application. For example, if I add a new form in the 'parent' application then to automatically create this form in the second application. Or I have to do it manually
How to track running totals (e.g. inventory)?
Newbie here. I trying to accomplish something that seems like a simple task, but can't quite figure it out. I am trying to track product inventory at stores as follows: 1) I set up a form that adds a store to the database (add_store). 2) I set up a form that adds product to the database (add_product). 3) I set up a form that adds a product to a store (add_product_to_store). I used look-up fields to choose store name and product name. There is a also a numeric field to specify how many units of
How to create conditional fields?
Is it possible to create conditional fields? eg, If I have a field for yes/no, i want to show a text field for data entry if yes is selected. If nothing or no is selected, i do not want to show the text field.
Horizontal arrangement of the radio buttons
Hello, In trying to create a survey that is a single page w/o scrolling, I would like to have the radio buttons (numbered 1-10) horizontally arranged rather than vertical. Is this possible? 1 2 3 4 5 6 7 8 9 10 o o o o o o o o o o I have only half a dozen questions but the survey is 70 mines long and doesn't seem like it needs to be. Thanks for any assistance any viewer of this post can provide. Cheers
Don't understand setting field by scripts
Hello! In a live view https://creator.zoho.com/smt_online/tech/#View:terminalsView I have a custom action that launches the script: Блокировать SIM blockSimDialog(terminals) The script is simple: void terminals.blockSimDialog(terminals t) { s = SIMs [terminal == t.ID]; s.blocked = true; } It's catch the sim-card and set a flag in "blocked" field. It's working - i can see, that flag is set. Then i have a handler in SIMs form, on Update the "blocked" field: if (input.blocked) { sendmail
Customer Portal Compatibility with Browsers
Several of our users keep getting the same error “Untrusted Site” or “Untrusted Certificate” with all browsers (IE 9.0+, FireFox, and Chrome). How do we make this error go away for good? Please Help!
Rename label by selecting a field.
Hi help me please!! I have the selection field "COUNTRY": if we choose "ITALY" The second label called "STATE" should be changed in "PROVINCIA". if (input.country.contains(("ITALY")) and after? Thanks
Import data from email
Hi. Unfortunately I can not change our form on our website to "text" it is "rich text" or "html" as we use a template website, so have to stick to what they supply. Our customers fill out the form on our website, and the data gets emailed to us. Because I cant do plain text emails, is there a way of importing the data from the email? If not, I know there is a way to make a form from Zoho and create the HTML code for it, which can be put on our website. However, our database on Zoho has fields like
Unable to duplicate an application
Hi I am trying to duplicate an application. nothing happens. What should i do? Thanks
Look up function, just add new entries OR Subform size definition
Hey there, I just want to use my original inquiry form with a look up field to my address database, to send it to my contacts, that they could type in there inquiries by there own. Why ever there isn't such a function in Zoho Creator, where you could set up a adjusted kind of your original form for the public use. Of cause you could create a second adjusted form, but then it‘s very annoying to add this selected data to your old main view.... So I scripted a little code, which indicates if a stranger
Can I use RegExp to split a string into an array?
Hi Cecil Adrian Can I use a RegExp to split a string into an array, if so, how do that could you please help me. like this string ="12345678" split into array = [1,2,3,4,5,6,7,8] by RegExp Thanks! Stanley Guo 2011-11-5
Customer Email ID in Customer Portal
Hi, Is there a way to get the Customer Email ID of of customer in Customer Portal ? It's not working with zoho.loginuserid... it's null. Thanks, Pascal
Populate more data into subform
Is it possible to populate some inputs into a subfrom by scripting from a main form? I'd like to create a kind of dynamic subform which could shown up based on a dropdown list and would be populated by data from other forms. With other words it would be a pre-filled subform by 4-8 rows in that. See below the sub-form. Only the quantity would be optionally editable by the user, other field should be pre-filled based on a previous choice from the main form. I was able to add data from a form but only
Arranging Radio Buttons side-by-side.
Right now the radio button option lists all options in a vertical list. Is there a way to arrange a split list so that the buttons are side by side? That way it would take up less room.
Relationship help
I have four forms: Courses Offered Employee Req Training Courses Taken Course Name Name (Lookup) Name (Lookup) Course(Lookup) Course(Lookup) Expiry Date I am having trouble making the relationships. The forms with the look-ups are working great. I would like a report that looks like: Name Required Course Courses Taken John Smith Course (required Training) Course Expiry Date (Blank if not taken) Any help is appreciated. Thanks, Wouter
Not Contains Criteria
Hi There, I have put together a demo application to demonstrate this problem at the following link https://creator.zoho.com/zoho_beth3/contains-criteria-example# I want to be able to select all records where option 2 has not been selected in the multi select box. When I manually search for records in the view "Add Option Record Report" and set the criteria "Not Contains" Option 2. I get the correct results. When I save this as a new view, the results are no longer correct. See the view "Without Option
How to change currency/number separator?
How do I change the currency separator to show the currency in reports as 12,34,56,789 instead of 123,456,789?
Request fails to enroll in a particular profile.
Request fails to enroll in a particular profile, except where the record the following message appears, and nothing happens: java.sql.SQLException: java.sql.SQLException: java.lang.Exception: cannot getConnection when the Txn Status is STATUS_MARKED_ROLLBACK Exception occurred during get connection from datasource Thank You!
Resize reports in html views
If a have two or three embedded reports in a html view, is there any way to change the width, the height and the positions of each report in the html page? If yes can you please tell me an example? Because as you can see in the attached image4 the html page is not well designed. Or if there is any way to decrease the width between the roomtype and low season which is quite huge. I went to column properties of the report, I decreased the Column Width but nothing happens.
Grandparent records
I can handle parent-child relationships readily, but what about grandparent-parent-child relationships? For example, how can I put fields from those three levels into a report?
Query related records
Hi: I am trying to figure out if I can query related records on the save of a record with a look up field. I created an app in Creator called Work Order. Work Order has a look up to Products. In Products I have a lookup to Products for Parent Products. When a user saves a Work Order with a Product filled out, I would like to query on all the Child product records and created Work Order Lines. Is this possible? Thanks
Create an app for ordering food, can I do this with Zoho?
I want to create an app that will allow restaurants to easily take orders from online. First, restaurant managers will create an account and post the list of food items. Then, customers can to the page of the restaurant, and order food for pickup. The restaurant will get an email and/or text. Any restaurant can automatically sign up. So, the restaurant will sign up onto my website, create an account, etc. The restaurant will then post menus. Then, people will go to the restaurant page and order,
Change the order of records in zoho creator report
As we know when we add a new record in a form then in the form report it shows it first. Always the first record is the last one in the report Example: 1st: Coffee 2nd: Sugar Coffee 3rd: Milk Sugar Coffee and so on. Is there any way to have the first record always first(in the report) and the others below it? Like: 1st: Coffee 2nd: Coffee Sugar 3nd: Coffee Sugar Milk
Next Page