Trial expired
Hi, I signed up for the 15 day trial which has now expired. I created a small database for my brothers business and shared it with him. My brother also signed up for an account. Shortly before the trial ended I received an email from Zoho account manager asking if I wished to extend the trial which I accepted. Instead, my trial period expired and I now cannot access my App although my brother still can. The App currently has 2 users and about 290 records so I would have thought still within the 'free'
Zoho creator - add record api - permission error
I am trying to insert a record to a form. I am getting the error. Permission Denied To Add Record(s). - 2899. I am the owner of the application and I have generated auth token with my account. Any help?
Refer to the ZC Workbook - Advanced App Building
Hi, I am new to ZC and learning from the ZC workbook (https://www.zoho.com/creator/help/tutorials/advanced-app-building.html). It seems I can't get the correct result. Can anyone help me to point out what I did wrongly? Thanks in advance! Br, Andy
how to add user in zoho Creator
I added a user in zoho creator but this shows when i open zoho creator with email user Help Please. "You are already a user of an organization account whose admin is a Zoho Creator user. Please contact the admin to access Zoho Creator"
list urls and href
Hi, I've created a map, with 1 value for each entry - a name Now i'd like to add for each entry on the map a URL - which will be "http://" followed by the entry's value under "name" Than I'd like to show on my page a list of hyperlinks: the text will be the name, and the hyperlink will be the URL attached to it on the map. Another option - to create to lists, one with the names and one with the urls Can you please suggest a syntax I can use? Thanks!
Understanding error log
Hi, What is the best way in understand error log such as the fllowing Error details: Error in executing ABclose workflow. Error. Error in executing IF rule : Error in executing If block. Error in executing IF rule : Error in executing If condition. Error evaluating Boolean expression : Error evaluating BOOLEAN expression : Error evaluating BOOLEAN expression : Error evaluating BOOLEAN expression : Accessing the value Finalise_actions.{1}.
embeded map variables from zohobooks
Hi, next is the style of response I get from zohobooks if for instance I look for contacts. {"name":"George", "Balance":"10.50"}, {"name":"Mike", "Balance":"5.00"} I understand this as embeded map variables (?).... My question is: how can I extract data from this data format. For example, how can I generate a list containing the names of each contact, in this case (George, Mike)? thanks Luis
URL in an email
Hello I am trying to send an email with an order to a supplier. I ad text end variables and it works great. But now I want him to confirm my e-mail. So I want him to click on a link in the email and end up on a page where he can confirm, decline in a drop down field with out being logged in to soho creator. Is this possible and how do I do this? Would be great to get some help! Best regards JB
How to create a dropdown list in Creator with data from a zoho report table and/or sql table ?
Hi, I'm wondering how to create a dropdown list in creator with data imported and synchronized periodically from a zoho report table or SQL Table ? For instance, we would like to create a simple form to give an evaluation to one of our suppliers. All our suppliers are stored and updated in our accounting software (base on sql server) and we have already synchronised it in a zoho report table. We would like to create a form where: 1/ the user can search the existing supplier (in a dropdown list)
How to create record from zoho creator using custom functions/deluge scripts?
Hi, We are working on zoho creator. We want to create/add records in zoho creator using Deluge scripts and custom functions. How Can we do that? Any help will be appreciated.
Json return function
Hello, I want to send object of type JSON in return of the function , but when received I want get the values by array. result={ "Descricao" : [{ "Carro_ID" : "Mercedes", "Carro_QTD" : "10" },{ "Carro_ID" : "GM", "Carro_QTD" : "30" }] } In JavaScript I get: result[Descricao][1].Carro_ID result[Descricao][1].Carro_QTD result[Descricao][2].Carro_ID result[Descricao][2].Carro_QTD How I do in Zoho?
Auto Populate a field
Hi, Please can you help me with this query I am trying to update a field in one form with a lookup of another form var = New_Product [ID==input.Product_Code]; input,Vendor = var.Vendor Error at line2 Variable 'Vendor' is already defined of data type 'STRING' but trying to update 'BIGINT' data type Vendor is lookup in the New_Product form coming from a look up in a third form. I haev tried following an example form the forum as follows: temp = New_Product[ID == input.Product_Code];
Zoho Creator - Production Management
Hi, I am trying to use Zoho Creator for Production Management for a well known Material Processing Plant. In that plant, production moves in Phases and the materials are processed in Batches. For example, Phase - 1: Material is Issued for Production Here, I would like the Material Issuer to Record the Lot No and the Quantity Issued Phase - 2: Prcessing Here, I would like the Processing Manager to receive the Lot and Process it, and Record its completion Phase - 3: Finishing Here, the Final Aesthetic
Chain of Lookup Fields
Hi everyone, I am trying to make a chain of lookup fields across multiple forms. In other words: Form 1 = Company Names Field = Company Form 2 = New Leads Lookup Field to Company in Form 1 Form 3 = Work in Progress Lookup Field to Company in Form 2 The idea is that we collect as many company names as possible and make a database in Form 1 = Company Names. As the names are qualified they will get entered into the New Leads (Form 2), the company name being selected by a Lookup field
sum of variables inside "rowspan"?
Hi Zoho, In a table in an HTML page, I'm trying to merge a few cells (span on a few rows, depending on a previously-defined variable plus 10 extra). When I use <th rowspan=10+<%=entries_count%>>CELLTEXT</th> I get it to span on 10 rows (without the variable count). if I use <th rowspan=<%=entries_count%>+10>CELLTEXT</th> it spans on the number defined by the entries_count variable (not adding the 10) How can I sum the two inside the "rowspan" command? Adding () got me nowhere. (WITHOUT setting a
Auto Populate - in more detail
Hi there, We are busy building a database of collected company names that we want to use as leads for sales. I have two forms; New Names and Leads. This is the simple version of the database: New Names has the following fields: -Company Name (Text) -Contact Person (Text) -Phone (Numerical) Leads has the following fields: -Company Name (Lookup) -Contact Person (Text) -Phone (Numerical) -Comments (Long Text) I want to select Company Name in the Leads form and then have all the other fields in the Leads
Subform lookup to main form?
Hi, I have a form with several subforms in it. I need the subforms to be connected to the main form when looking at the reports later on, so I've created a distinct variable for all the subforms to have (same as the main form). I wish this will be done automatically - the variable will not be visible to the users in the subform, but will take the variable value using lookup from the main menu. How this can be done? Thanks Ravid P.S - the option on having a subform within a subform could really help
Backup Failure - out of memory exception
Dear Zoho, I'd like a response to the two support tickets and 15 emails I've sent regarding the inability to backup our application, which on every attempt produces a java exception. I originally posted a request on the 19th of May and have yet to receive a response other than the first "thanks for your ticket" email. After chasing via email I created a noter ticket, again we got an initial "thanks" email but still nothing. At this stage we are unable to get OUR data out and as I've explained on
Mobile datepicker won't select February dates
I have a datefield in a form that has a problem selecting a February date on a mobile device. It automatically moves the date to the same day in March. Selecting a date in January or March does not show this behavior. There is very little code in the 'on user input' that just updates another date field: // update the end date row.End_Date_Time = thisapp.com.addDuration(row.Start_Date_Time, row.Duration) ; row.edited = true ; Selecting a February date using a PC does not have this problem either.
How to use api response string
How do you go about reformatting or getting values from an api response value? I used the Lead Convert method to convert a crm lead to a potential and create a contact. I get the following response: {"responseCode":"200","responseText":" \n710378000007272009<\/Contact>710378000007272011<\/Potential><\/success>\n"} How can I use this response? I know that 710378000007272009 is the contact ID I know that 710378000007272011 is the potential ID But im not sure how to get these values out of the
Formula field based another formula field
I found that to construct a formula field, I can't call another formula field .......... is this by design or sth is wrong with my form??? thanks.
How to import data in a blank subform?
I would like to ask you if there is any way to import data in a blank subform. I have the following excel file I created a form with a blank subform like the following (with exactly same field names) then I clicked the Import data (it shows that everything is ok) but in the report shows me 3 empty records. Why this happens? How can I add these 3 records in a blank subform and to show them in a single record in the report (as we know, whatever we add in a blank subform it keeps it as a single record)?
Notifications from form entries not being sent
I set up the contact form to email me and it does not.
Linking an Account & Contact created from same Creator form
Hi, We are capturing & creating an account and contact from one creator form. We are successfully able to create a Account and Contact record in Zoho CRM but not able to figure out how to link them using the 'Update Record' integration function. Below is our code - any help is much appreciated! // Creating Account myAccountmap=map(); myAccountmap.put(("Account Name"),input.School_Name); myAccountmap.put(("Account Type"),"Boston STEM Week"); myAccountmap.put("Billing City",input.Shipping_City); Response_Customer
Trying to find and display records with null fields
Hi, We have a large database of subscribers imported from Access. We've found that a number of them are missing data in fields that need to be filled. What is an easy way to find the records with these null values and display them e.g. in a report?
Please help with some fetch code
I am having trouble with the following code if (Salesman[Name == input.Salesman].count() < 10000) { temp = Salesman [Name == input.Salesman]; input.Salesman_s_Email = temp.Company_Email; } Gives the error Error at line number : 1 at column 5 In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid but all the fields are strings Please help
adding a dot to a field
Hi How do I make a field that says 'nigel cross' to say 'nigel.cross' notice I want the dot in the middle instead of the space. Thanks
Scheduler substituting variable for Added_User
When I run the below code from the scheduler, it ignores the value for UserName and inserts the UserName for the Admin user. I should point out that this is part of a function that I am calling from the schedule. Is this a known limitation of the Scheduler or is it a defect? insert into My_Form [ Added_User = input.UserName Email_Address = input.Email_Address StartDate = tempStartDate EndDate = tempEndDate Status = input_Status
View record not displaying field values
When attempting to view records, only the field names are displayed (see first screen shot below). This happens the majority of the time but not all of the time (it worked in second screen shot). This is a relatively recent issue for me. Any ideas? Thanks.
Show field depending upon checkbox
Probably simple but can't see the easiest way to do it! I have 5 checkboxes and if checkbox 5 is selected then I want an additional multiline box to show in the form. Any ideas?
Fetch records only from this week?
Hi, Sure I am just missing something but how do I select records in a fetch script for records that have a date field greater than last Sunday so that every time I do it I get the records for the current week only? Thanks
Calling up a form in Edit mode via Deluge
I am hoping that This might save someone from the hours I wasted yesterday Zoho Creator team might enhance the documentation to make the following more clear! The Creator help files at https://www.zoho.com/creator/help/views/editing-records-via-record-id.html#Invoking_the_url_from_Deluge_Script tell us that the syntax is: openurl("http://creator.zoho.com/"+zoho.adminuser+"/"+zoho.appname+"/add_contact/record-edit/contact_view/" + input.ID + "/","same window"); However, there are traps for the unwary!
Collect Google Calendar data and process it to display on a web page
hi! I am setting up a system for trainingcompanywho uses all freelance trainers with different availability patterns. I thought about: a. giving each of them a google calendar to fill in their general availability b.collecting this data c. creating an online calendar for the customer-facing webpage d. which shows geographic availability of at least one (unnamed) trainer, for each subject which they can provide Any ideas on how best totackle this in Zoho Creator with the least amount of additional
variable from another field in Fetch feature.
Hello, lets said I have an app with 3 Forms: Local, National, Int. each form has the same information of products (Name, Code, and Price) except for the price, this is the different field on every Form. I have another form to sales, there I will select which pricelist would use, so I have a field named "Source" and it will be filled with the name of the Form I want to use, then I'd like to write an script to get the price of the appropriated list, something like: input.Price = Source [ID ==
PLEASE HELP! Zoho Creator - generate report (pie chart) based on a multi-select field
Hi there - I am aware that currently with Zoho Creator, you cannot generate a report based on the multi-select field. Is there a work around for this? For example, I want the form to offer choices A, B and C - and I would like the user to be able to select and y combination of A, B and/or C and then generate the results in a pie chart. Thanks
Calculate Current Balance
I am woring on an application that is an accounting ledger for a bank account. I would like to calculate a running balance based on the date of the transaction for the individual. Does anyone have any thoughts on how I can accomplish this? Here are some details: I am uploading the following data: - Account Number - Posting Date - Transaction Amount I will also put in a beginning balance for each individual as a starting point called: - Beginning Balance Any help would be greatly appreciated..
Specific number of digits in number field
Hi, I'm trying to set a number field to only accept a specific number of digits. I wanted the field to accept 10 digits but give an error message if more or less are entered. I would also maybe like the form to return an error if they try to submit it without ensuring the correct amount of digits. Thanks in advance for any help.
Can not duplicate o backup my app
Hi, I tried to duplicate my app on my account on zoho creator or backup it, but there is something wrong, Could you help me? Thanks
Sum field
Hi all, I have a problem, in a form I have a set of numeric fields that you fill in automatically depending on the choices that you make from the dropdown field.in a numeric field should I get the sum of numeric fields .... How can I do? the formula field does not work and I tried a script but does not return results unless I fill manually, it appears that the AutoFill not possible Add.? Thank you
Grid report not supported when using Deluge Script in form
My ability to use the grid view in reports for mass updates vanished. I found this: Grid report is not supported if there is any client side Deluge Script configured in the form (i.e) On Edit -> On Load script (or) On User Input script for any field. This appears to be a result of me adding the following for On User Input: Work_Due_Date = input.Date_Joined.addYear(1) ; The goal was to automatically populate the Work_Due_Date with a value of 1 year from the Date_Joined. Any thoughts on how I can
Next Page