PDF Export Issue in Zoho Creator
Hi, I've taken subcription from Zoho Creator, While exporting the report in PDF, report is not getting downloaded.. Can you please help on this.
Zoho Creator Formula variable lookup based on selection in a Drop Down list
I have a Zoho Creator form for Storage Tank Inventory Tracking where the first field is a drop down box with selections like "Tank1 / Tank2 / Tank3 etc." Another field is where the user enters the inventory level in Gallons. I have a formula field for automatically computing the lbs of inventory (Gallons * Density) but the density varies depending on what Tank the user has selected in the Drop Down. If Tank1 then Density = 1.2. If Tank2 then Density = 1.5 etc. How do I code this most elegantly?
Can you create a conditional Zoho CRM field
Hi, I want to create a field that only lists CRM contacts associated with the CRM Account I have already chosen in my Creator app. From the help documents I can see that you can filter a lookup field to restrict what appears in the drop down but I can't see any information that allows you to restrict the Zoho CRM "contacts" that appear so that they just show contacts attached to the Zoho CRM "account" you have already selected. Please help. Thanks
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'
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"
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];
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
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?
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?
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
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
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
E-mail address associated with zoho.adminuserid
Hello, I know this is stupid! But I cant remember where is the zoho.adminuserid going to get the e-mail address. I made my application last November and cant remember... So please help me here :) I wanna change to where it sends the e-mail, how do I do that? Thanks. sendmail
(
To : zoho.adminuserid
From : zoho.adminuserid
Subject : "Livros da Marta - Contacto"
Message : "Nome : " + input.nome + " Email : " + input.email + " Mensagem : " + input.mensagem
Using Zoho Creator to mirror an existing Web App...
My company already has a bespoke web based workflow app. Customers fill in details on our website and progress through various qualifying stages towards gaining a final certificate. I would like to use Zoho Creator to siphon off some of the data that they are entering for separate analysis. In other words, when a customer fills in a form on our website the data will be entered into two systems - the existing bespoke web app and a new "mirrored" Zoho Creator app that I want to build. I have read about
Zoho Crm and Zoho Creator
i want to link Zoho crm to zoho Creator but when i add zoho Crm box in Creator it doesn't give me the created tabs of zoho CRM it only shows the original ones like Leads, contacts ..... etc
Email reply action
Hello, Is there a way to have an email sent based on a form submission to a user, then have the user reply with an update to the form via email. Looking to have an approval email sent and a reply from a given email admin's address update the entry form to one of four status. Thank you.
Signature in notifification mail
Hi, What is the right url link to a signature field? I want to show also the signature in the pdf that comes with the notification mail after submitting the form. Cheers, Marco
How do I create one list/form that is identical to a subset of another list and automatically updated?
I need to create one list/form (Form A) that is identical to a subset (based on values of multiple fields) of another, larger list/form (Form B) and is automatically updated periodically? Also, I need to be able to identify when a change was made to a specific field in Form A. Anyone have any good ideas on how to do this? Thank you, zzarda
search multiple records from a list
I an trying to return multiple records from a list (column) of data from excel that needs to be bulk edited. Is there a way to enter this whole list in a search to return the records that match. I do not want to do this one at a time. For example list looks like this: email address email1 email2 email3 email4 email5 email6 email7 email8 Thanks - Phil
link zoho docs to zoho creator app
Hi I was just wondering is there a way to link zoho docs to a Soho creator app? What I am trying to do is create a portal for clients to login and access documents that are private to the individual clients. Thanks
Not able to share app???
When I try and share an app I have created, I keep getting this error message: "To share more users Upgrade your user plan". But I am only trying to share it with one person, which is supposed to be allowed on the free version. What is going on?
Can I delete the automatics reports?
Can I delete the automatics reports on zoho creator?
Not Able To Add Subform Record in Mobile App if Hidden Via Automation
Not sure if this is the exact problem...but removing my subform from being hidden through automation and just writing with hide on load deluge script allowed me to add records in the app.
How to recover deleted application?
Hi all, Is there any ways to recover an deleted Application? Any "Undo" button? Tks!
Es posible generar un documento PDF con Zoho Creator?
Me gustaria generar un documento PDF con ayuda de Zoho. Yo envío correos automáticos a mis clientes mediante el uso de Zoho.Quisiera saber si es posible convertir ese formato a PDF ya sea para descargarlo o enviarlo por correo electrónico. Gracias de antemano,
More multiline problems
This public application I just published, "Multiline Test", exhibits the behavior previously noted by ghennessy, but on a more basic level: The application consists only of one form with one multiline field. The form on load event attempts to set the multiline field to this: "foo bar" but the presence of the linefeed in the text is preventing the form from rendering at all. This is a new bug, the above application construct used to work fine until very recently. Thanks for any assistance. Regards,
Disappearing Deluge
Hello - I will find my application not working correctly, go into edit, only to find my deluge script on a particular field completely missing. It seems only to be happening on subforms - and it may have only been happening after I added //comments to my script. I am going to remove the comments to see if that alleviates the problem. Has anyone experienced this or know the reason this is happening?
ZOHO Creator to Quickbooks
is there an API that I can use to integrate ZOHO Creator with Quickbooks?
Insufficient Privileges to Perform Operation
I have written a Creator Database for demonstration to a potential client. It is simply a database of Sales with links to the Customer and Product (in CRM) database. However whenever I click on either entity it does not go to that record (as I would expect) but opens a new tab with this error message. I have produced a screen shot of this (attached). Thanks for your help. Peter
Rookie Question on Calculating
Just trying to figure out how to calculate in this: I have a form that gets: Name Date Value Name is a drop down list of people Date is the Session Date Value is a whole number Want to spit out a report that Summarizes: Name Total of all Values <next name> <Total of all Values for this name> etc. I tried things like Total_Values = Total_Values + Values but can't do that. I've done programming in the past, by no means an expert and was some time ago. Pointers of what
Generate greeting card from a list report
Hello. I have a form to introduce orders from clients. The form have a lot of fields. I would like to have a button in each record of a list report to create a greeting card based only on two field from the form. The greeting card will have a JPG image background and the two fields have to be placed over the image. The font properties should be able to be modified. It would be great if also possible to modify the content of the fields directly on the greeting card. Please, could you guide me what
Google Sheet Imports Nothing
I've attempted three times to import a Google Sheet. All three times it opens a blank page. I don't get an error or anything. Please advise.
How to condtionally set/disable a form's lookup field to default to the appropriate Company for current user.
Hi. I have a requirement where I need user context logic to control: a) the default value of a lookup field for say a company in a form b) If the the user is from the companyA, i want to automatically set the company to his/her companyA but not let them change it. So userA can add/edit assets for CompanyA only while userB can add/edit assets for company B only. I need it to work such that in edit mode the Company field will be disabled, yet show the appropriate company depending on who the user
Creator Sharing Problems: "You are not allowed to access this application."
Hi Zoho Support/Community, I am new to Zoho and testing out the FREE version of Creator which should allow up to 3 users. (a) User 1: This is my account. Under User & Permission, it was automatically assigned Manager (Role) and Administrator (Profile) when I created this account. These can't be changed. (b) User 2: Sent invite to this person via the "Share" feature under Application Settings. Assigned same Manager (Role) and Administrator (Profile) as User 1. As a FREE user, I have a warning " Warning!
Next Page