Do Hide/Show Functions based on Dropdown Selection not work in Subforms?
Hi, I have created forms where the fields are shown or hidden based on the dropdown selection on the previous field. Can the same be achieved with Subforms? If so, How? If not, Is there a work around to achieve this?
API and donwloading pdf attachement from postUrl response
Hi any one knows if this is possible... I'im trying to to see if its possible to use an external service/site. to send and fill PDF with zoho data and download the API attachement responses after pressing a custom button. all i have manage to do is get the filename of the attachement from the API By the way i am not a programmer by any means... just trying to figure this out.. My Custom function is.. headerMap = Map(); headerMap.put("Accept-Language","en_US"); headerMap.put("Accept","application/json");
Create PDF Button in Report View ?
Hy, In Report View need PDF button in Footer . Whenever anyone click that the pdf generates with filter view at that time . Is that possible or not ? If yes then How exactly and if not then what is the best solution for that ? Im using ZC 5. Thank you in Advance .
tricky relationship
First off... I'm not savvy with the coding aspect of building a database, so I hope you'll bare with me. I'm setting up a database for one of our family programs (we have a teacher that visits families once a week). I have a main profile (form) page for each family that houses most of the information, and included in that is a subform to list all the people participating in the sessions (ex. names of mother, father, sister, uncle, babysitter, etc). I have another form called "progress report"
Possibilities
We would like to know the below possibilities : - Is there an option to directly give command to the printer to print it - on submit? (Without Pop-up print page option) - Is it possible to open a new row in a subform, by clicking Enter (Without using Add New option)
Form with one button
Sorry im new toi zoho and i want to ask how can i delete a button from form properties. I use a 14-trial version and the only action that is acceptes is the rename?
Serch form
campo de pesquisa ocultar exibido os dados que se auto completam
REST API view/get not working
Hey, I am trying to get the REST API get request working, but when I make the request, rather than getting the data from my view, I get the HTML code from the Creator frontpage. My URL query looks like this: https://creator.zoho.com/api/JSON/PROJECTNAME/view/VIEWNAME?authtoken=AUTHTOKEN&scope=creatorapi&zc_ownername=OWNERNAME Where PROJECTNAME, VIEWNAME, AUTHTOKEN, and OWNERNAME are replaced by the values that are specified by the documentation. Any idea what is going wrong here? Cheers.
Show Total in Report View ZC5
HY, How can i show Total in Report view in Zoho Creator 5? like Show in Below Picture
Tennis core tracker
I am wondering if Zoho Creator would work for this. Basically I need a app to track my sons tennis matches. I would have a list of events, a list of locations (multiple events at each location), a list of opponents, matches including the scores, and a selector for each match as win/lose. It would also be good to have opponents notes etc to plan tactics for future matches. Is this possible? Are there any templates I could start with?
Richtext field with Image in subform
I used below script to fetch the Product image into a richtext field and it works, but when i use my mobile, the image wont load, anyone knows why? product_info = Product_Master[ID = row.Product_Code]; /*Image field has two types of output when queried through the script. The uploaded file doesn't return the correct script like the one that was stored with the link. So, there is an additional script involved to get the correct image URL*/ //Remember, Product_Image used below is the Image field's
'Empty' Kanban Slot
I created a Kanban report based on a form, grouped by a specific field. The field is a drop down with four different options. Even with four different options, the Kanban always displayed an extra 'Empty' option to move items over to. Is there any way to get rid of this? I don't have an empty selection for the field and wouldn't want some of our users to drag items to this column and disrupt our workflow commands.
Fetching Data from lookupfield
Hello I want to fetch the data from a form, one field of the data is a lookup field and I am unable to fetch the information Can someone please help me with it x = SMAT_Audit_Schedule[ID == input.SMAT_EMAT_Audit_Schedule_no]; //input. refers to fields in current form input.Site_Area1 = x.Site_Area; Please note that Site_Area1 and Site_Area are look up fields. Thank you Amanda
Dynamically populated dropdown box, that I can use to filter multiple reports on a single page.
Hi, I'm currently trying to develop a user aid in Pages, for users to filter multiple reports by Job ID. I would like a dynamically populated dropdown box at the top of the page (it's populated by the Job ID's the user has created via certain forms). Then once the user has selected a Job ID from the dropdown box, this filters the reports on the rest of the page. It seems like a simple task - I understand how to set relationships for the dropbox to pull in the data for the Job ID's, but I can't find
Ordering of Graph Axis Labels
Hi everyone, Can anyone explain why the labels on my graph are in a strange order? I've tried to organise the associated form in month and alphabetical order to no avail. Any suggestions on how to organise the x axis Jan-Dec? Thanks in advance!
Record Summary Template Formatting
Hello, I am trying to use a custom record summary template to create an order that is automatically sent after a user submits the form. While this works great, I cannot figure out how to format this PDF (attached) to show the items in rows instead of values separated by commas, I would like to hide fields if they contain no value (like TAX EXEMPT ID), but show them if they do contain a value, and I would like to removed the USD label on prices and show a $ like on an invoice. Can this be configured
New C5 Map Report
Hi! I noticed the new map report in C5, great job Zoho! Fo my application, I need to map many dozen off location based on their GPS coordinates in DD MM SS rather than the complete adress. Is it possible to do that? I'have speak with one of your colleague in Montreal during the last Zoholics and it was possible. Thank you for your feedback
Search field data with spaces wields no results
Hi, I have a report with a field that contains data in the following format "KM - 18-01". When I search the field with "Contains KM" or "Contains 18" I get corresponding results. However when I search for "KM - 18" I get no results. Why is this? Thanks Michel
Creator: Making a contract; Cannot import " Account Owner" into the contract
Problem: I'm creating a contract template in Creator for my salespeople (users) to fill out to send to our clients. A field in this needs to be "Salesperson." This is the same as Account Owner in Accounts, which pulls from the list of Users in the CRM. So I tried the Integration field -- Zoho CRM -- and there's nothing in the drop-down for Account Owner or User. I REALLY don't want a salesperson to have to type their name and info in -- it should automatically pull from the system. I REALLY don't
Unwanted Chrome Address Pop-Up over Multiselect Field
I'm using the chrome browser and entering data into a form in which I have a dynamic picklist in a multiselect field. When I click on that multiselect field the picklist displays as it should. However, a chrome pop-up window blocks the view of the first few choices. This is the autofill address window and it is offering choices for my State (e.g. North Carolina). Those choices are unrelated to my field. Is there something I'm doing to make chrome "want" to assume it's an address auto-fill situation?
How to attribute data to a hidden structure
Hey all, very new to Zoho and so if there is a commonly known solution to this problem then please let me know! My problem is this: I have a form that collects data about persons who are signing up for a service as part of a family. Obviously, when adding users, they get added to the Person report, which contains all people. However I want to have an individual Person report held by each 'Family'. I need this so when performing lookups, only members of a given family will be selectable rather than
DESIGN THE CUSTOM FORMS IN ZOHO BOOKS AND MERGE WITH ZOHO BOOKS AND INVENTORY
Dear All, I have a few question on the Zoho Creator, We are accounting firm and using the zoho for few clients. But most of the templates in the zoho books are not acceptable from the clients side. So, There are some highly customization are required to the Zoho Books and it's inventory module (Inventory module having only one template and it does not seems to be good) So, My question is can I create the forms through Zoho Creator and merge it with the Zoho Books data base. As an example I will
Connecting to the Google Cloud Vision API
Hi, I'm trying to integrate the google cloud vision API into my project. I want the user to take a photo of some text, to send that image to the Google cloud vision API to use OCR to extract a number from this image and then return this number and fill a field on my form. I have got two issues I need help with. Firstly trying to format a postURL using the JSON request format as described here: https://cloud.google.com/vision/docs/request I've tried sending it as a string or using the instructions
Auto Submit of record based on data
Hi, I am trying to create an app which will allow the user to scan bar code data from a bar code scanner connected to the mobile and submit it. The use case is the user will scan barcodes of each product using the barcode scanner and when the user reads a particular bar code say "A0000" which indicates an end of customer I want to submit the form and reload it to read the bar codes of next set of products. The users of the App are Visually impaired people and it is hard for them to either
Disable Subform Row based on condition.
Is it possible that we disable a subform's row based on condition? if one of the cell is not empty then disable the field? i've tried to use disable subform.price , when i add new row ,the new row got disabled as well. anyone can shed some light? thanks Jeff
Sales Order Deluge
I need to create a Sales Order in CRM from Creator and I need to know the fields to populate and how to structure the Product information when there ware multiple product lines for a Sales Order. I know the basic is: response = zoho.crm.create("Sales_Orders", mapped_fields); It's those mapped_fields that I need the structure for to correctly populate and create the record in CRM Sales Orders.
Hide related field in Add New popup form
I have two forms: Client and Pet. Clients can be related to multiple Pets; each Pet has one related Client. On the Client form, I have a Pets multiple lookup field with the ability to Add New pets. On the Pet form there exists the bi-directional single lookup back to Client. This is good in case I decide to add a Pet through the Pet form and not through the Client form. However, when I choose to add a pet using the Add New function on the lookup field in the Client form, the popup shows the bidirectional
2 levels of subform in one form
Hello, I want to have 2 levels of subform in one form. In the form Client, 1 to n Contract. In each Contract, 1 to n Records. So I want to see all that in the form of the client. Is it possible?
Send E-mail with Attachment
Hi! I want to find a way to download multiple files in an easier way. I have a form that allows the user to input 13 files. Today, we have to download one file at a time. I thought about creating a custom action to download all the files at once OR sending an email with all of the files attached to it. I'm having trouble with both option. With the custom action, I could not find any routine to download / export a file. With the email, I could not make the expression "Attachments :file:input.NAME_of_my_File"
Deluge - list & iterate through all form fields for an audit log
Hi, I'm trying to build an audit log (I'll call it AuditLog) that will update every time I make a change to my primary form (which I'll call Form1). The form AuditLog contains 4 fields: Entry_Date_Time (date time) User_Name (single line) Description1 (single line) Description2 (multiline) In onSuccess state for On Add, On Edit and On Delete form actions in Form1, I call this code: insert into AuditLog [ Added_User = zoho.loginuser Description1 = "added record " + input.ID Description2 = "input.ID="
zoho creator
how to do checkbox deluge scripting like i have two checkbox options on which when i select one other should be disabled or other should not be able to selected...
HTML popup
HI, I would like to add a link to my Rich_text field, that opens up a popup window. So far I have this: RichText = "<a href='https://app.zohocreator.com/ccimailzoho/interhof-travel-calendar/#Form:Passenger_Form?recLinkID="+OutPax.ID+"&viewLinkName=All_Passenger_Forms&zc_LoadIn=dialog'>"+PaxPasteName+"</a>"; unfortunately that does not open in a popup window. Does anyone have any advice?
How to upload files directly google drive using zoho creator application?
Hi Team, I have to store my attachments in google drive and also i need to open my word attachements in onlyoffice. Please provide the process. Regards, Ramesh.
Zoho Creator - Download as Mobile app not working in Zoho creator 5
Hi All , Download as Mobile app option is failing on code signer for andriod. Raised the support question and they accepted it is an issue - they working on with HIGH priority it has been months - i find very difficult to get follow up from them .. for me it is show stopper issue in the product when they claim custom mobile apps as sales pitch for zoho creator looks like Zoho is not taking this as serious issue In general Zoho creator Support is below average for me Do any of you here face
Taking a printout of the Relationship diagram on one page
Right now I can scroll around and see the relationship diagram but it would be easier to take a printout on a large paper, eg A0 or A1 where I can see all the tables at once. I tried the print button and setting the Save As Pdf with landscape format and Size of Paper A0 and A1 etc. But it seems to only export whatever is in the current view. Is there a way to export the whole schema?
Creating map reports from database addresses or longitude&latitude
I need to be able to create a visual map based on addresses or long/lat of given records. Does anyone know if this possible and how to do it? Also I'm wondering if it could create a route between the addresses. Basically I use it to store bus routes and need to be able to show the data as a map. Another option is if I upload a map to my app is there a way it can break that map down into records?
How to hide HTML buttons from a pdf
Dear All, If I add in a HTML page two buttons like <button type="button" id="B2" onclick="alert('Hello world!')">Accept</button> <button type="button" id="B3" onclick="alert('Hello world!')">Reject</button> Furthermore, the Print - PDF buttons have enabled.. I know that with the @media print { #B3,#B2 { display: none; } } I can hide the two buttons. But how can I hide them in the PDF button?
On button click in report record send that record's summary as pdf attachment to an email
I have the following use case in Zoho Creator. Is there a way to accomplish this? (a) I have a Report with various rows. (b) I have made a record template as a pdf and saved it as a non default template (i.e.I don't want to disturb the default view of a record that gets generated on clicking on a record) (c) On each row I can display a button labelled "Email me pdf summary" the on click action of which I can get it to send out an email to the logged in user. But I need to have a pdf attachment
Send Mail Workflows & reports
Hello The "Forms Workflows" permits to send an automated email, "on add" or "on edit" of a record. In the email settings, it is possible to send the record, as html formatted data, according to "custom print templates". However, in the "Functions" configuration for email noticfications, the checkbox "include user submitted data", which allows me to choose the record "template", isn't available. I can only add "fields", to the body of the email. Please see the 2 attached screenshots. I'm trying to
Fingerprint
Hi, How can i insert fingerprint function on my zoho application on creator?
Next Page