Displaying All Row Fields
How can I populate or display the other fields once I pick a value in a dropdown? The dropdown was made using a lookup. Ex. If I select a contact then his email, phone number, address etc... are displayed on the other form fields.
stringlist conditioning
Hi guys, I'm not into coding too much but i have an idea of the basics. I have a stringlist in my app, and when a certain value is selected (in combination with others or just that value) I want to enable another simple string field. Could you help me with the code? Thanx Cosmin
How to get Zoho Challege records in Zoho Creator ?
Hi, In zoho creator - leadslist = zoho.crm.getRecords("Leads") ;Using this function we get records from zoho crm. But is there any function like testlist = zoho.challenge.getRecords("Tests") ; - so that I get all the test from challenge?Right now i found above code is wrong. Any help will be highly appreciated. Sorfuddin
Button next to dropdown and layout
Question 1: How can I add a button next to every dropdown? I want that button to show a hidden field when I click it. Question 2: Is there a way I can create a model window for a multiline text. If my question 1 is possible then I want it to open the model window or pop up with the multiline textbox. Question 3: Can I create a three column layout? Thanks.
XML feed
I need to develop a Zoho Creator script to import data from an XML feed into forms -- could be multiple forms with relationship set up between them. I need to let the script automatically import at intervals, say every 12 hours. Is this possible?
Zoho Creator Help Desk cannot delete: you are not allowed to view / edit the script
I had installed the application for trial. Finally, I found no interest and want to delete, but I cannot..... "you are not allowed to view / edit the script" HELP!!!
Formula field help
I have a task form to assign specific tasks to individuals to work on them. I have "Estimated Hours", "Actual Hours" and "Remaining Hours" which is a formula (Estimated_Hours-Actual_Hours). I also have a Project Length lookup field that's a in which you choose how many weeks/months you have to complete the project and it will then formulate the Weekly Hours =(Estimated_Hours / Project_Length).round(2) which will break down how many hours a week you need to devote to the project to finish it.
Help Creator Login Problem
Unable to Login to Zoho Creator, Please help beacuse I am using it daily.
I can not enter my Zoho Creator Account. So does my friend
The form is accessible in the public view but i can not enter to edit it. i need it ASAP. so you gave any idea why?
Reply to multiple email addresses
Within Zoho Creator, I want to reply via e-mail to multiple recipients using the "Reply" form. If I try to send an email to "user1@domain.com, user2@domain.com" (without the quotes) I am getting the following error message: Enter a valid email address for cc When I try to use a semi-colon ; in order to specify multiple recipients It allows submitting the reply form, but it never sends the actual email as it is most likely recognizing the input value as a single email address. Do you have a procedure
How to display data in a form field?
Hello I want to display some data in a single field when i choose some option in a dropdown o multiselect field, or when i put some numeric values in a number field i want to display the sum total of that values in another numeric or currency field without going to the view from that form. Thanks for your time and patience Greetings from Colombia
If statement not working
For a Task form I've built, I want to be able to put in the Estimated_Hours of the project, the Actual_Hours of the project and how many hours a week I want to work on a project, Weekly_Hours. If the (Estimated_Hours-Actual_Hours) is less than the Weekly_Hours originally submitted, I want the Weekly_Hours to show the (Estimated_Hours-Actual_Hours) to have a better idea of how many hours per week you have committed to a project. For example, I'm working on project X and at the beginning of the project
Format number of decimals displayed in sum totals in a view
I have some decimal number columns in a view. When I use the sum function, the sum totals are carried to a large number of decimals. Can I control the format to display two decimal places?
API Add Record throws error 2900 if there is no fieldname in form matching submitted key value.
This is also an active ticket with support, but I figured I would look to the community for insight too. We use sendgrid as an external email provider. I wanted to send an email with unique record id in the header from zoho to sendgrid's web api (which then sends the email). The results from that send attempt would then be posted from sendgrid's event api back to zoho (to record bounces, unsubscribes etc). I was able to do all this successfully. But I hit a snag. One of the fields that sendgrid's
Set criteria not working
For a dynamic picklist I want to specify the criteria to show "Active" and "Maintenance" but not "Completed." I've tried this multiple ways and none of it will work though it accepts the command. I've tried: Project_Status = "Active" Project_Status == "Active" Project_Status != "Completed" I've even tried creating a decision box with "Active" and even that wouldn't work. To test it I've even tried what has worked in other picklist criteria and even that isn't working. Is this some sort of bug?
Automatically add record
Hello, I would like to know how could I do build a script that automatically adds the zoho.loginuser into a field (lets call USER field) of a form (lets call it form 2) of a user that has generated data into another form (lets call it form 1) when a record from another field that has imported data from the form 1 is selected. Example: FORM 1 Fields: - Product (text field) - Add User (zoho.loginuser) FORM 2 Fields: - Product List (Imported data from all the records of FORM 1 - Product Field) - USER
how to get the name of an unknown XML element?
For example, say the XML data is: <CustomerID>12345</CustomerID> <Name>Bob Smith</Name> <Phone>99999</Phone> But I don't know the exact names of the elements in advance. How can I extract just the name of each element - i.e. "CustomerID", etc - from the XML? Anton
Autocomplete
@asvanberg @zohocreator Is it impossible to get autocomplete in a textfield?
Multiple problems - reports, checkboxes, fields.
Dear Zoho Creator and Reporter Teams, Many thanks for your help – your apps have huge potential. I have a number of problems with using your programmes. I am attempting to use Zoho creator/reporter to run a live audit tool, which will real-time produce reports regarding the data stored. In Zoho creator I have encountered the following problems: CHECKBOX DATA CANNOT BE PRESENTED IN A GRAPH. This needs to be fixed. It should be possible to present data such as I have 5 apples, 3 pears and
Connecting to Different CRM System
Hi, We are developing a creator application, where we are required to access different Zoho CRM instances. Currently, when we are calling records from Zoho CRM creator is fetching information from CRM connected to Creator's owner account. Please advice how this can be rectified. Also, can you please advice if we are developing an application using Zoho Creator and we would like to deploy this for the client how can we distribute this application. Regards, Kazi Hassan
Deprecating Chart view
Dear Users, With the release of Reports (integrated with Zoho Reports), we have not made any further development in Chart view. Hence we have planned to deprecate the Chart view for new users and for old users who have not used Chart views at all. We have planned to deprecate from our next update(tentatively next week). Thank you, Saran Zoho Creator
Deluge Scripting textbooks
I am looking for Deluge Scripting textbooks. Can you help in recommending some good ones?
Importing data in views is not updated in zoho reports.
I developed an application and upload my data on creator views. In my application there are different forms. From them only 2 views data is not been updated to the zoho reports, others are able to get updated.
HTML View image only seen by admin
I have an image on my home page HTML View that uses this code: <img src='https://creatorexport.zoho.com/DownloadFile.do?filepath=/1266858680427_HydeParkLogo.gif&sharedBy=<%=zoho.loginuser%>&appLinkName=hyde-park-data-center&viewLinkName=Images_View'> When logged in as admin it shows, but not when I'm logged in under my test user account. Any suggestions? Thanks, Bruce
Fetch Records to update dropdown box
Hi, I am currently trying to put a FetchRecords script in whereby a dropdown is updated with data from another table. The syntax I have is as follows: get_available_products = Available_Products [Product == input.Product]; input.Unit_Trade = get_available_products.Unit_Trade; input.Unit_Cost = get_available_products.Unit_Cost; input.VAT_Class = get_available_products.VAT_Class; The first two fields are normal single line fields and update fine. The VAT Class is a dropdown but does not seem to
ZOHO Creator & Payment Gateway Integration, is this possible?
I am in the middle of project and requirement is Form submisison created usin ZOHO creator result into payment process system, Is this possible? Please help
Paypal or electronic payment feature for Creator
Do you have a date for the release of an electronic pyament feature that works with Creator? If so, any idea what your fees, if any, will be? susanaramsey
Values derived by dates
Good Afternoon, I wonder if someone could give their advice on how to achieve the following. I wish to create a document 'due date' field derived from 3 other fields which are:- 1) Document date e.g. 19/09/11 2) Number of days e.g. 30 3) Terms e.g. from document date or from end of month. So based on a document date of 19/09/11 some of the options could be 1) Number of days 10, terms from document date would result in 29/09/11 2) Number of days 10, terms from end of month would result in 10/10/11
Household vs individual
Can someone explain how to set up a database to accomodate data that is household specific (such as mailing address and financial donations) and data that is individual specific (such as email address, cell phone, membership status, etc), for people in the same household? For each household, there could be one, two, or more individuals. Ideally, one would be able to see the info from one record inside the other. (For instance, if you are looking at the household record, you would be able to see all
Updating Quantities
Hi there If i have one form (products) And another one (products sold) and i want to update (products) table field (stock on hand) once i sell an item in the (products sold) table with the field (quantity) how do i deduct the (quantity sold) from the (stock on hand)? Thanks heaps Jason
Sharing applications forms/view to a group
In order to make management of access to an application easier I am trying to use the Sharing to Groups functionality. Whilst is looks simple to use, it does not appear to wrk for me. I have added a user to a group and then shared a view to that group. However, that user is not able to see the view. What have I done wrong?
How to store different batches for a product(Medicines)?
Hello, can any one help me in storing different batches for a product in Zoho creator/Zoho CRM. eg: 1)Product name: lipitor 40mg batch expiry qty 12121 10/2012 2000 12345 12/2012 100 2)Product Name: Januvia 100mg batch expiry qty ab121 10/2014 3000
Need a developer for sales/workflow solution
We have started a sales/workflow solution and concluded we don't have resources in-house to complete.
Problems with String Concatenation
I am trying to combine two strings. Let's call them <path> and <filename>. The result of this field points me to the path and filename of an important image asset. I have successfully implemented the input.<path> + " " + input.<filename> into my field. My problem is that a space is placed between the two strings, which then mucks up the function which does the lookup. I tried using + with no quotes, and this did not fix my problem. Any help?
Executing scripts in a subform that update fields in ANOTHER form
Hi All, I'm working on an app I created a while back that tracked orders for multiple clients, and updated client budgets each time an order was placed. The way I had orders set up was two forms- Orders, which contained an order as a whole, and Order_Lines, which then broke an order into lines for each client and charged the client accordingly. This was a little convoluted, so I started trying to use the subforms feature today but find I need to make several modifications to my script in order to
Function - assigning a value to a field and calculations
Problem 1 I want to create function that looks like the one below but it doesn't work. void namespace.function() { input.Total = input.A.toLong() + input.B.toLong(); } input.A and B are dropdown boxes and everytime I select a value this function will be called to calculate the total. Also my form have different sections with different dropdowns. Problem 2 How to do I count the non-numeric options(Options: 4,3,2,1,NA)? Because my calculator function also needs to know that to be able to compute
file uploads using zoho creater
hello, something went wrong with the coding of one my forms so i exported all of the data, then had to delete the form and make a new form, there were several files uploaded so i have attached the links to them but they dont work anymore, does this mean that all files upload are lost or is there to retrieve them? old view link https://creatorexport.zoho.com/DownloadFile.do?filepath=/ZFS1312233780013_Mohamed_El_Merghany_CV1.doc&sharedBy=soliya&appLinkName=voulnteer-management-database&viewLinkName=Registration_View
handy date comparison hack
For people that want to check if a chosen date is before or after the current date: just subtract them. It gives a nonsensical number, but the sign is all telling. dateChosen = input.Date1; dateCurrent = zoho.currentDate; dateRemainder = dateChosen-dateCurrent; if (dateRemainder<0){ // day is in the past } if (dateRemainder==0){ // day is current } if (dateRemainder>0){ // day is in the future } Just wanted to share this with you, so that you don't have to break your head about
Inserting record in Zoho Creator by API in C#
Hi I am trying to insert a record in zoho creator by API in C#,i have provided the user name, password and api key as well but when i try to add the record it throws exception 500 internal server error, can you kindly let me know what can be incorrect which is causing the exception, kindly reply ASAP, or it would be great if you can provide me any code snippet in C#. regards,
view distinct values from a field?
I want to create view that displays the unique (SQL: distinct) values from a text field? how? once I get the unique values from the view, how can I use this data to populate a new form(table)?
Next Page