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)?
is UTF-8 character format supported for importing and exporting data?
Hi, I would like to import and export UTF-8 character with csv file on Zoho Creator. But UTF-8 character cannot be imported into Zoho Creator and UTF-8 characters is exported in garbaged characters in csv file. Regards Keita
Regarding external access to Zoho Creator databases
Is it possible for us to externally access and modify the fields in the Zoho Creator database outside of Zoho -- for example, to populate corresponding fields on a PHP form on our own website? Thank you!
"Date" field prints date and TIME from SendMail script
I am new to ZC, so this may be a fairly basic question: I created a date field called Start_Date, but when I call it up from a SendMail script it comes out with a date and unwanted time in the e-mail. (The time is always 08:00:00 - maybe because I have set the time zone as GMT) Is there a way to defeat this? It seems odd if you define a field as date only that it should produce a time as well.
documentation for executeXPath()?
Re the Deluge function "executeXPath()": Is this a wrapper for a specific Java function? Is there any comprehensive documentation on the xpath expressions and syntax that can be used?
Links in Table in HTML View
I have an HTML View that simulates my idea of a subfiorm with a table. I want to be able to move to a form with this: <td><a href="http://creator.zoho.com/peaslee/hyde-park-administrative-center/#Form:PermitComment">Add Comment</a></td> It just goes to the application's home page. Support edit enabled. Bruce
How do I test for a number?
How do I test if a string variable is a contains a number?
Order of Dropdowns
Is there away to sort the dropdown lookup menu's, I havent had much luck changing around the settings in the view
Dynamically add a value to a field
Hello, I have a form (Students_form) to add students information. Let's say that Students_form has two fields: 1) Student ID (automatically generated by Zoho Creator) 2) CostPerHour which is a currency field I have created another form called Invoice_form. Let's say that Invoice_form has again two fields: 1) Student ID (which is a Lookup field from Student_form) 2) CostPerHour wich is again a currency field What I would like to do is the following: When I select the student ID from the dropdown
Output data, taking selected information from a range of forms based on choices within each record
I have a question. I have an App with three forms in it. Form A - records contain a reference number and text fields.say A1 A2 and A3, and a lookup checkbox field which takes single line data from the records in Form B. Form B - simple records which contain only one field, single line text. This is read by form A and C to provide the check box field. Form C - Contains another reference number, a few single line text fields, and the same lookup check box field included in form A, reading the records
Bulk Editing a Checkbox Field?
I'm a new Zoho Creator user and I've been impressed with the service overall. Very robust and simple to use. But before I can bring my organization's data over fully, I need to figure out a solution to one problem ... I can't seem to figure out how to bulk edit a check list (multiple item) field without deleting the existing data in a record. This is a frequent need so I need figure out a work around. In another thread, "Suggestion for bulk edit of a multiselect field", a Zoho employee indicated
Sort Lookup Dropdowns
How do I sort Lookup Dropdowns, I tried changing the settings in the view form but when I use the lookup dropdown in a form it only shows in the order it was entered,
Embedded Grid view not updating
I have an embedded grid view in my html view. I can change the values in the grid view, but the Save at the top never changes so that I can save the change. Is this a bug or am I doing something wrong?
Backup isn't working
Just tried to start a backup, but am getting: Application Status Start Time Description Photo and Video Forms Failed 2011-09-15 16:08:12.0 null
Next Page