Align data in the middle of column instead of left or right
Hi, Like the title stated. How to do it if possible? Thanks
Fetching Data problem, Number of arguments mismatches
I could use some help on determining what is wrong with this code. I get the following error message: Error at line number : 1 Number of arguments mismatches if(Time_Sheet_Entry [ID == input.Employee].count() > 0) { x = Time_Sheet_Entry[ID == input.Employee ]; //input. refers to fields in current form input.Employee_Name = x.Full_Name; input.Status = x.Status; input.License_Level = x.License_Level; } Thank you in advance for your advice.
Zoho creator showcase
Hi guys, Just wondering if there is any place where some cool Zoho creator projects can be showcased? Or maybe there is some material out there that I haven't seen, on Youtube or something? I am building away at Zoho creator but I would really like some inspiration from others and to see what is really possible in terms of layout, functionality etc...? thanks Dave
Zoho Creator - build dynamic forms
Hello, Is it possible to create dynamic form in Zoho Creator? I want to create a form with multiple elements. Count of these elements is known in request-time (Actions on Load). This would be something like this: 1. Get all records (returns e.g. 11 records) 2. And now -> add/append "Single line" element and after it - "Checkbox" element. I can't find any function that adds elements to the form.
How to create a printable invoice
Hi guys, I have been using zoho creator for the past week and I find it amazing! I have build a simple time tracking app and a project management app for my own use. I would like to use zoho creator for invoicing as well - at the moment I just use a word file, edit it and save/print each time a do an invoice. All I really need is a set layout that automatically fills in invoice number and allows me to add a few details and then print. What is the best way to do this in zoho creator?
PDF functionality on published report links not working. Forcing Zoho log in
Hello I am using published reports in a separate website. I want to use the PDF functionality to export record summary's as PDFs. I have tried two methods, and they both redirect to the zoho log in page. First in the "View Record" option where my users can view their record in a record summary template, there is a specific PDF button and this leads to the log in page even after published. Then I tried to use an open-url custom action to open up a record as PDF and automatically save the file. This
Record Summary doesn't appear in the Schedules feature
Hi, I have a question: Why when i want to send an email with the record summary template attachment through the form schedule, i don't see the relevant template in the list? The form chosen in the "When to Do" is the same on which the record summary report is written. Also, what is the difference between the send mail and send report tasks, when i want to use the record summary attachment? Thank you
Error while following tutorial
Hi, I'm following this tutorial https://www.zoho.com/creator/help/tutorials/advanced-app-building.html When I do this and enter the script mentioned in the tutorial: Click on Workflow tab on the left to go to the script builder. Select Field Actions - Products - Product - On User input and add the following code in the editor box I get the following error: Error at line number : 2 Variable 'row' is not defined Any ideas in what I'm doing wrong? Kind regards, Johan Boerema
detect popup blocker
Is there a way in Creator to detect when an openurl is blocked by the browser? The browser may only put a small x in the upper right. The user may not notice the small x. If deluge can detect if the blocker is on then a message can be displayed on the screen alerting the user to the problem.
Hide Subform fields On Edit ??
FormA has fields: FieldX, FieldY, and Subform SubformB with Fields: Field1, Field2, Field3, Field4 In the On Add, On Load for FormA I have the following script: hide FieldY hide SubformB.Field3 hide SubformB.Field4 and it all works fine while I'm entering a new record. In the On Edit, On Load script for FormA, I have the same script: hide FieldY hide SubformB.Field3 hide SubformB.Field4 But when I Edit that new record by doing an 'Edit' from a Report/View, only FieldY on the main form is hidden,
Code generating application (returning values of new entries based on count function of existing records and display automatically)
I am currently working on a way generate codes for items. I have two main questions concerning my application, which are: - How can I have zoho automatically number based on existing records and a specific criteria - How can zoho automatically display a code which is based on another field AND a count function Let me explain in detail... My application has two forms: Items & Product Code Generator In a first step I will add an item to the Items form. The form has three fields which are Item Name,
Help regarding showing value in dropdown in subform on edit of record.
Hello I need some help. I need to show value in dropdown on load of a subform during the edit of a record. I have a form and a subform. In subform, I have created a dropdown in which I am displaying product name from view. When I Click on the add new button on subform, dropdown is displaying all the product name. When I save the form its information are getting saved in the view. But When I edit the same record, then value which was selected previously from dropdown is displaying, but when I want
Do I need to pay for Customer Portal?
Just so I can have a site where visitors log in and edit information about themselves into a directory?
fetch data from subform in page
Bit of newbie question here: I'm working on an app where there are two forms: form name: section_builder field1: letterTitle field2: textSnippets There is a subform: form_name: text_snippets field1: snippetTitle field2: snippetContents Field 2 in form 1 is a multi-value selector which corresponds to field 1 in form 2. What I want to do is create a deluge script in a page which will simply output a list of all the text snippets that correspond to a single letterTitle. I have read the article https://www.zoho.com/creator/help/script/fetch-records.html,
Firewall issues with published links
Hi there I am having troubles getting around the firewall for one of our clients. They have whitelisted all the Zoho links used, even those opened by openURL commands, and they are still not working correctly. This includes published forms and databases. Is there a list of IP addresses or generic URLs I can give them to whitelist?
Function - custom action - fetch and use - I don't succeed in assign a date to new record
Hi Please hava a look at the attached document. I’m trying to create a function. When pushing the button (that triggers the function) in form Cluster, a record should be created in form Planning. Fetching the ID’s of the relationships seems to be working. Creating a planning record goes ½ well when I hardcode the content of the fields. Assigning a date fails. Thanks for helping me out.
Fetch troubles
Let me start by saying, I just started using Zoho Creator today. I cant seem to get Fetch to work on my form. I have created the script below and placed it on the On User in Put. But it will not fetch the Broker name. if(Inbound_Form [ID == input.Customer_drop].count() > 0) { x = Customer_form [ID == input.Customer_drop]; y = Broker_form [ID == x.Broker]; Broker_name = y.Broker_Name; } Can some one help me figure this out? Thanks
Function for REST API
Hi Guys, I would appreciate if anyone can guide me a little bit on how do I create Function in Zoho Creator to be able to POST API to 3rd party. I know this cURL works, but I just not sure how to build function around it - any help and guidance would be much appreciated I am OK with someone helping me out for a fee as well Here is an example with cURL: curl https://api.signable.co.uk/v1/envelopes -u d41d8cd98f00b204e9800998ecf8427e:x -X POST -d "envelope_title=My envelope" -d "user_id=1234" -d 'envelope_documents=[{"document_title":
sending a mail not including just the fields the user didn't fill
Hi, I have just asked this question but I didn't solve the problem. I would like to send a mail to my costumer just including the fields they have filled. If editing the notification mail I insert costum fields that are not filled by the customer the Mail will be full of square brackets [] [] [] or code-words like "null" Is it possibile to do it? I hope I made myself clear...my english is not very good! Thank you very much!
Customer Portal - client upload content then view report of only their content
Hi, I am trying to create an app to allow my clients to upload content (text, image or video) to a database which is then translated by my team and then posted on social media. I would like to use the customer portal feature to allow clients to access to the form I have built, which contains 5 simple fields (text, upload image etc.). I would then like for the clients to be able to view a report of all the content they have uploaded via the form in calendar view - but only the content that specific
change payment
Hi, How can I change the payment (change the Credit Card number)? tks, pippo
Viewing attached files
I have a few fields that are file attachment fields. It appears that the only way to see the files once uploaded is to download them. Is that correct, or is there a way to click on the file name and view the file in the browser? Thanks
How to send a mail including just the fileds that have been filled but not some other that are not useful?
Hi, I would like my customers to receive via mail a summary of some products and services that they have selected and purchased in my form. How Can I automatically send them a mail that contains just the fields they have filled but not some others that are not useful? Thank you very much and sorry for my English. Paolo
Web based forms
I have created a Zoho Creator application wherein I would like to be able to direct applicants to my company to a website where they can fill in a form that results in the data populating my application. I assume this is possible, but would appreciate direction on how to do this. Thanks
Next button click is inserting new record on click
I have five forms.On each form I am accepting data and on next button click.For all four forms i have only one table.I am passing the DocumentID as query string and on next button click i am inserting that data in table and opening new form. While opening new form i am passing that DocumentID as query string .But when i click next my record in inserting as new record.Its not inserting in exsting row.I want that all data of four forms should insert into only one row. How can i do that?
Multi language support
I am using a trial version and have added data in multiple languages, as well as have fields in multiple languages. Will this feature still be available to me after the trial period is over?
triggering a beep/tone/sound as an event
When filling out a form, I'd like to provide the user an audible confirmation during certain events (for example, On Edit/On Load). The user is entering data away from the monitor and the tone will indicate a new record is loaded and ready for inputs. Is there a method to provide an audible indicator that's triggered in an event?
Zoho creator api authtoken changing on their own.
We seem to experience a very regular problem where the zoho creator authtoken is deleted or removed from our account. When this happens crm stops sending records to creator via webhook and we loose records, sms messages that should go out to clients etc. We need something to let us know when this happens. The authtoken gets deleted and we loose all of our sms messaging systems. It is difficult to know if they are working or not and this is becoming something we need to check weekly in order to
Using Form and Note field to display images but the images will not work in published links
Hello I have a custom action that opens a URL to a Zoho Form that my clients use to edit and approve reports. We use a note field to display images, but it has come to our attention that the images do not display. We have recreated the problem and it seems the pictures only display within Zoho and not in published links.
Lookup Refreshing
I have 3 lookups (for another app) in a form that Fetch Countries. The problem is that if I create in the first lookup a new Country record this will not appear in the second and third lookup selection. So I need to refresh the form. Which is the best way to update the other lookups without refreshing the form and loosing the already filled fields. Thank you,
Customer Portal Allow New Entries
Hello, I setup a customer portal for the app A, I have a form with a lookup that fetch information for the app B also I enable the option to Allow new entries. When I access thru customer portal the Allow new entries option doesn´t appear even though the user have all permissions. Its not possible to create records to another app thru the customer portal? Best Regards,
How to check the value of lookup is selected or not
I have one lookup in which i have names and after selecting names i am displaying the address of the selected name.but if the lookup value is not selected then i want to display the text-boxes to accept data from user.I have "-Select-" field at top if user selects that "-Select-" then i want to display the text-boxes to accept input from user. how can i do that.
Pros and Cons of sometimes using a separate app (vs. adding to existing app)?
Could we use this post to collect wisdom on the behavior / capabilities / strategy of adding more as a separate app vs. adding to the same app? I'll give a start from our limited understanding. I haven't seen this discussed in the Help or on the Forum -but please provide links if it is. (We have a "main" app with a suite of some 30 tables/forms and associated reports, etc. But for 2 others, we've made each separate apps, mostly for their own unique security -Enterprise license- and unique customer
Add records from zoho crm to zoho creator raise permission denied using rest api
Add records from zoho crm to zoho creator raise permission denied using rest api
Search across all fields in a form to return matching results
Hi all, I've got an application that contains a form (A) that has several linked parent forms (i.e. so form (A) has many drop-downs that change dynamically based upon results chosen). I have created a stateless form for a search function. I'm now trying to search each of the fields to see if it contains the value I am searching on. I I have create a HTML view ready to display the results (using field names and op_26 - i.e. Field1=<value1>&Field1_op=26&Field2=<value>&Field2_op=26&etc...). However,
Basic Student/Class Enrollment Example Needed
Hello, new to Creator and just can't figure out what I'm sure is the most basic of requirements: I have two forms: Student Class Student form has a lookup field to Class as multi-select with Bidirectional Relation checked Class form has lookup field to Student as multi-select with Bidirectional Relation checked I can easily enroll a Student in multiple classes the issue comes with reporting I need to run a report that shows the individual students enrolled in a class: Class Name (3) Student 1 Student
Record adding from zoho crm to zoho creator gives permission denied
zoho creator give error permission denied while adding record from zoho crm to zoho creator using creator api
Conditional payment based on user input
Is there a way to make the recurring payment on the form conditional based on a particular input the user gives on the form. Example : if the user says Monthy Payment it is process as a monthly payment . If the user specifies Annual payment it should process the payment as one time. Thanks.
image on user input
There is no 'on user input' for an image field. Is there any way to detect that the user changed the image before they submit the form?
[SOLVED] How to change a value from one form which resides in another & create a function that changes the status.
Hi, This whole "Not having to code a single line" for Zoho is proving itself not quite true... So.. I have two forms. A and B A has B as a subform A has a status dropdown I wish to change this status dropdown on form A FROM form B(From standalone form, not as a subform) . How do I do it the best way? AND Can I change the value of a radio button depending on the value from a textbox? Thanks for all the help! /V
Next Page