how to connect zoho creator to favebook. is that possible?
I need post my zoho contents to facebook. how can i directly post from zoho creator to facebook. i need to set autopost. not manual. how can i connect zoho creator to fb
Subform in subform
Hi, it´s possible to have subform in subform? When I do this in creator.zoho.com, in mainform (view) on app.zohocreator.com I can´t see that. First subform contains Date of order, products (it´s subform) and user. Second subform contains select products, price, quantity and total price. On the picture you can see forms and subforms. First picture is subform in mainform. Second picture is subform of Order (Objednávka). In this subform is antoher subform, but is not possible to see in mainform. Third
custom actions
Hello, Im really not a zoho creator expert, but I am using it for quite a long time.. Now I would like to explore more than basic actions and started to mess with custom actions in reports. Maybe its stupid and newbie question: I have 2 custom actions (buttons in report) and i would like to have one instead of them. First is: void Vybavene(Nova_uloha Vybavene) { Vybavene.Protokol = true; } and second: void VytvoritProtokol(date Do, date Od, string Uloha, string Technik, string Z_kazn_k) {
Passing "OR" criteria through URL to a view
i have a view in which i need to pass logic that contains OR such as displaying a list of employees whose name is Richard or Dick, how would i correct this url to include OR DICK. http://creator.zoho.com/zchelp/employee-manager/#View:Employee_View?Name=Richard
Drill down not possible
Hi, I have given a user permission to view a pivot chart. I have enabled " View underlying data" in the report. With my adminitrator account I can see the "Drill down" menu when clicking on the graph, but when I try to log in as the normal user I can only see " View underlying data " and can not drill down from months to weeks to days. Is it a permission issue?
make conditional forms for pivot chart that only include certain values in the fields
Hi I want to make conditional forms for pivot chart that only include certain values in the fields, but I do not know how to do it inside the pivt chart. Usually the code would be: ventasebay= Ingresos_Egresos[Tipo_de_ingreso== "Ventas Ebay"].sum(Ingresos); I would like to have that code for pivot chart: Example: Sumif (Region = 'East, Sales, 0)
Trying to share an application, not sure if I need enterprise for what I'm trying to do
Been thru the 'sharing' docs a lot and still a bit confused. If I have two users paid for on a plan below enterprise, can I share a form and report of an application with anyone with an email address (without publishing)? I would think that is why one would pay for a second user, to collaborate that way. But, it seems maybe the Enterprise plan is needed to do this? When I try to share my application with a user I get the dreaded "You have been marked inactive by the administrator of this application.
Customer Portal Redirect
When working with the customer portal, is it possible to redirect the user to a specific form on your application? Or will it always by default go to the first page in the application hierarchy?
input.Field = old.Field doesn't work when old.Field=null
Hi Zoho, On my "On Edit -> On Validate" I have a script with a rule, in case the rule is not applicable, I'd like to revet to the old data. for this I'm using input.Field = old.Field. but - on fields when the old version does not have data (null) the input.Field is not updated (say with the new data entered. Please fix this Thanks Ravid
Delete record using hyperlink
I want to create a hyperlink that will delete a specific record. Is this possible?
I thought I had it
I've amended a code from an expert on here as need similar functionality in a different form. It sort of works but I only get 1 digit and if error when I change it to "BB01". The new code is last_back_box_record = back_box [back_box_site = input.back_box_site] sort by back_box_reference desc; if (last_back_box_record.ID = null) { input.back_box_reference="01"; } else { input.back_box_reference=((last_back_box_record.back_box_reference.toLong() + 1)).toString(); } I need to prefix all entries
Need upload function using curl/Rest Api in zoho creator
Can you please send the example working code that to upload a image via curl_exec() function what are the fields i need to pass via curl call
Is it possible to dynamically create a filter with option of OR for a view
I have a view set. I want to dynamically filter records by saying 'Pull records with Criteria 1 OR with Criteria 2'. I know I can set it up manually by going to Summary page of a report. Is it possible to write a deluge script to pull up this view based on user inputs by setting up two different Criterias and using OR condition? For example, view name is NameReport Input entered by user Name Search: GA LastName Search: SH So the script will pull up all records from 'NameReport' where Name contain
Working with a date field
I am using an on User Input script to process the value entered in a date field. My problem is that if the user just types in a date the on User Input script is not executed. It only seems to work when the date is selected by clicking on the calendar icon. What is the best way to work around this shortcoming? Is there a way to prevent the user from typing anything in the date field so they are forced to click on the calendar icon? Thanks, Ken
Foreign characters (e.g. French accented characters) do not display properly
Hi, I have imported a file with accented characters to create an app from scratch - e.g. some French / Scandinavian names. However, they do not display in Zoho creator as such. How do I change this? Best regards, Adrian
Images don't display
Zoho creator seems like a really robust platform but my first impressions are that it is buggy and unpolished. I hope I'm wrong but I suspect this forum post will land in a black hole somewhere. I am trying to create a simple employee directory that includes a photo for demo purposes. I have followed the instructions in Zoho's help file but the image that is supposed to appear in the help file just displays the infamous black "x" icon indicating the picture no longer exists or the link is broken.
REST API and Authtokens limit
I just want to know that is there any limitation on Rest API (for Zoho Creator) using external scripts like PHP Curl etc... AND Is Authtokens are limited? what i mean, that Authtokens usage is unlimited or there is a certain limit for using authtokens, like 50/100/200 (any count) times per minute/hour/day etc..... kindly assist me and sorry for my poor justification.
How can I save a file on a File Input field using script/function?
Hi there! I need to put a file into a File Upload field using script. How can I do that?
nonprofit pricing? no response by filling our the webform
I'm curious if anyone can fill me in on what the approximate nonprofit pricing is for Zoho Creator? I filled out the webform to inquire a few days ago and haven't hear back. Thanks, Brady
Is it possible to move/copy a Personal App to Workspace App?
Inadvertently created an app under Personal rather than Workspace. Is there any way to change the type of app from Personal to Workspace, or to move/copy it to Workspace?? Thanks!
How to extract part of a text string like =RIGHT() in Excel?
I am trying to add a field to a form and use a formula to copy just the right-most 36 characters from another field into the new field. Similar to the Excel "=RIGHT()" formula. Is this possible in Creator? If not, any ideas on how I can accomplish this? Thanks, David
data saving
Hi, I run a mobile dance club in the uk. I've had a developer from this site working on a simple datadase with a event calendar with some email support.. this has taken longer than expected but looks and works ok... But i have a problem with the event payment section... Zoho does not save data automatically and the way the adding members and payments has force me to start looking at other software... the designer has given up he cannot work out a way to do it... this is how it works now . Open calendar
Get related record
Hi there, I have a Creator form with a CRM field Potentials and a field " Contact Phone" which I would like to populate with the value "Phone" of the CRM Contact related to the Potential. I can't get it working ... please help
Validating SubForm Data
Hi there I have a Parent form "Bookings" - fields include Name, Company, Email, Phone I have a Subform "Booking Detail" (field name Booking Details). I have code on the "Add Row" to populate fields on the subform - effectively transferring the parent fields to the subform. The problem with this approach is if a user adds a row to the subform BEFORE filling in the parent form, the details don't transfer down. The other scenario is where they enter the parent form fields, add a row/s, and then before
Zoho Creator Android app - offline forms with workflow workarounds
One of my main requirements was offline data entry, and I made the mistake of not fully understanding the limitations of the mobile app. I built an application with all sorts of workflow scripts and lookup filters only to find out that neither of these are supported when accessing forms offline https://help.zoho.com/portal/en/community/topic/zoho-creator-ios-app-3-7-2 My question is if anybody has found any workarounds for some specific cases: 1 - filtering lookups when accessing the form offline
Update a record through zapier
Hey zoho, I would like to update a record when a specific event from another app is trigerred using zapier. As you dont offer updating through zapier, is there a way to do it anyway ? Thanks a lot for Tour answer
calculation on date field
I'm new to zoho I have a form with date field which the user has to enter. I have another field which I want to calculate based on the date entered by the user. I want the calculation to be "the date entered + 9 days". What s the best way to do this ? thanks for any response
Error Executing Workflow On User Input Script
My scripts were working a few months ago. As far as I know, nothing has changed. I have not added or modified any of the fields nor the scripts that access the fields. This week I needed to add new records and update some existing records. I received the following error: The field CONSULTATION STATUS is changed from either "NEW" or "IN PROCESS" to "COMPLETE" when the consultation is done and I click UPDATE. At that point I have code to calculate some totals and percentages. Here is the script
Export in excel format
Dear all I have issues when I try to export in excel a report including field in a currency format. The data of an amount fiel is not in a right foramt for excel and I am not able to make some calculations with these amounts. Many thanks for your help. Isabelle from Banook Group
Unknown Error
Just got this error: Left expression is of type BIGINT and right expression is of type BIGINTLIST and operator + is not valid Anybody know what it means?
Zoho creator to Quickbooks customer mapping
So I wanted to be able to create a customer and add info from a created sheet when it is submitted. I am able to create the customer and add Family name, display name, and billing and shipping address info with the following code: //Declare Map Variable to hold the customer details Customer_Details = map(); temp = Quote_Sheet [ID == input.Customer_Name]; //Add the customer details to the map variable Customer_Details.put("FullyQualifiedName", temp.Customer_Name); Customer_Details.put("DisplayName",
Fetching and updating records from another database
While I know it's possible to use a lookup field in a form to relate a record from another application, is it possible to use script to fetch records into a variable from another application?
Making formula field data available for export/import
Hi. I exported formula field data from one application and when importing the data into another, there is no labeled field to accept the record data. How can I make a field in the form that mirrors the data calculated in the formula field so I can import it?
Contact Form Not Redirecting to "thank You" page
My contact form is not redirecting the user to the thank you after they fill out the form. I'm considering zoho for my company but having this issue is not helping. http://residencialsantaelena.com/contacto/
Issues with Web Embed
Hi all, I'm having a couple little issues with embedding my database on a webpage, I wonder if anyone has encountered similar issues and if there's an easy solution. The first is that when I embed my reports, initially they never show up. It's only when I change the display from say List to Summary that they show up. Another issue I'm having is that when I search my app on Zoho, if I have a multiple select field when I go to search that field all of my possible inputs show up and I can just select
Bidirectional lookup from one subform to multiple mainforms
The solution offered here works perfect when there is one subform and one mainform. I have a scenario where I have one subform that is included in multiple main forms, and I'm looking to somehow link them together. If I try to add bidirectional lookups to the subform based on the existing relationships - I can only choose one at a time - so it only works for one main / sub relationship. Ideally I would have a single 'Source' column in the subform that is linked to the main forms that were used at
"Other" option is added to a drop-down even when the option is not marked!
Hi Zoho, I have a form (Loan_Valuations) that for a drop-down field of its suboform (Loan_Valuations_Broker - broker name field) it takes a list from a third form (Loan_Comp_Req - approved brokers field) and append it to the drop-down list On Load both on On Add and On Edit. This should not have a "other" option, and it is not marked as applicable anywhere. But: On Edit mode, there is an "other" option available !!! Please fix this ASAP. thanks Ravid
Complex criteria in pivot reports and charts
Some time back pivot reports and pivot tables were created based on views. The criteria embedded in those views were carried over into the reports. Since pivot table and charts are now created using the form, criteria restricting others from seeing the data is limited to 'Only logged in user records' and 'all records' but not to others authorized to view it as well. What am I missing?
Filter within an sub form
How do I filter within a Sub Form? In the "wiring" form we use Filter Site.ID equals input.wiring_site on a Device drop down. I want the same filter within a Sub form but it states wiring_site is not defined?
Upload Image File via Creator API from iOS App
I'm writing an iOS app that will upload information to a Creator application using the REST API. I can upload text fine, but I can't get file uploads to work. I'm trying to use this API, but as the example is for how to set up a web form I don't know what the structure of the POST request needs to be. I've tried a few different ways but I either get back a status code 500 and a HTML error message or a 200 response with a message saying the request was successful but the image is not uploaded.
Next Page