HTML Snippet - Image Size Issue
I have placed a .png image in an HTML snippet on a page. Sometimes the image shows in it's full size when the page is loaded, however, it sometimes shows on only half the image and a scroll option appears on the right side of the panel. Once the page is refreshed, it usually shows full size again without the scroll option. Any way to force the image to show full size consistently when the page is loaded?
Failed to submit data"
Please be informed that when i connect the internet and synchronize im getting a "Failed to submit data" . Kindly check my account and advise accordingly. Jaeman
Different users are unable to search records
The following call is made: crmAcct = zoho.crm.v1.searchRecords("Accounts","(Account Name|=|" + acct + ")"); This call works successfully when the call is invoked by the Admin. However when a non admin user invokes this call I get the following: Invalid collection string Line:(10) Any help would be greatly appreciated.
Sum total displayed both metric and US
On my application I have batch reports. On Each batch the Kg of each item added to the batch is recorded. I wrote a report that sums all the batch records by the LOT number of each item. What I would like to do is to display both in Kg and in Pounds. The batch reports are entered in in Kg, the receiving is recorded in LBS. I would like to display both on my report so when it sums up the number of Kg used in a specific lot # I would like the report to also display that value as Pounds. I know
Pre-added text or value inside rich text or multiline?
Hi, I am looking to add a mass of text and information that is editable by a user once they are using a form - this is so the user later on can produce a custom made document (after a certain format). So it will be an example text that they can either leave be (and accept) or alter. But, I haven't found any way to pre-add text into any of the utilities in the form-builder other than as a tool-tip or help text. Any way or idea on how I can execute this? In some other, much more simple and web-based,
How the frak do we OAUTH2 w/refresh_token out of creator?
I'm using EVE Online's OAUTH as a testbed (mainly because I know what all the responses will mean from my time working at CCP). Fair note: I'm not a programmer/coder, and this was my FIRST EVER attempt at generating a script. Took about an hour to get it to validate and save, but I DID get that far! Here is what I've got so far: Published a public creator page with a button that triggers the login and initial authorization Redirects to a published creator form that catches the return values authorization_code
Debugging Tools
In developing an application, I'm constantly testing code blocks and functions for proper functionality. Since the debugging features of Creator are limited, this often takes a while to figure out why something is not working correctly. There are many forum posts that could be answered if users had better debugging tools. Also, this would help new users teach themselves. My feature request is to give the developers true debugging tools. Since I also code in Excel, I'm partial to its features: A watch
How do I add Search Parameters when creating a HTML Page for a Search Interface.
Hi there, I am trying to create a search interface. I understand that a stateless form has to be created and on clicking the button, it will be automatically redirected to a html page based on the input's given in stateless form. I know that 'open url' deluge task will be used for redirection but how do I filter the records to match the input given in the stateless form, I again understand that search parameters are to be provided but How do I provide these? Where do I provide these? How are these
fetch record from another application
I would like to create a fetch records from another application. is it possible? Example: Application 1 Form1 Field1 Field2 Application 2 Form10 Field1 Field2 In Application1, i write this function: String getApprover(string Field1) { if((count(Form1[Field1 == input.Field1]) > 0)) { rec = Form1[Field1 == input.Field1]; return rec.Field2; } else { return null; } And in Form10, field1 on User input: rec_approver
Link to form entries
Hi, I'm new to Zoho, and I have a hopefully simple request. I have form called Clients that holds client information, and that has a 1-to-many relationship with an Events form - multiple Events can be linked to one Client. In the Client report, I can see the names of the Events linked to the Client record, but I want to be able to click those Event names to go to the Event record and make changes to it. Here's an example from the Client report: The lookup field in the Client report is listing the
Combine data from lookup fields to text field
Hi. I trying to merge data from a couple of lookup fields with other fields and place them in a multi field. Here's the script: input.Map_header = input.Property_Owner_Agent + " " + input.Property_Name + " " + input.Address; Property_Owner_Agent and Property_Name are lookup fields. This is for the Map Report popup box. The below photo shows numbers instead of the names. The address seems to work although I'd like to get rid of the county and country. Please help.
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");
Join us in Singapore for a Zoho Creator Community Meetup!
Hi everyone, We're hosting our first ever community meetup in Singapore and we'd love for you to be part of it! Whether you're a long-time customer looking to sharpen your skills, or a new customer looking to learn more about Zoho Creator, this meetup is the place to be. We will walk you through some of Zoho Creator's most important features while sharing tricks and hacks to help you get the most out the platform. At the end of the session, there will be plenty of time for questions and conversation.
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!
Getting data from sub form
I've read thru a several examples but can't find or create a deluge script that does what I need. Attached is a screenshot of my form called "Business Activities". It has a sub form called "Activity Review". I need to do two things: 1. Script to fetch all the "Next review dates" from each related sub form entry. 2. Review the "Next review dates" to find the latest one and copy that into the main form "Next review date" field. So imagine there are two sub forms. One has review date 1/10/2018 and one
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
Tip 11: How to extract the time from a Date-Time field.
Hi folks, Over the last few months, many of you have been asking for a Time field in Zoho Creator. We realize how important this field is to you all, and we promise to support this as soon as possible. In the meantime, here are a couple of workarounds that will help fetch the time from a Date-Time field. 1. Using the in-built String functions The easiest way to extract time for display purpose is to use a toString() function with preferred time format we need. We shall get the 24 hours format or
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?
Error in the searches
Hello! All the search code lines to Zoho CRM and Zoho Books are giving error. I can not use "GetRecords", "GetRecordByID", SearchRecords ", etc. All the forms in which I have those searches give me the following error {"message": "Invalid Ticket Id", "code": "4834"} I need help, my company uses the application created in Zoho Creator integrally so we can not currently operate. Thanks in advance best regards.
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
call custom function in url
Been looking for hours now and didn't find any answer... The problem is: - i created a custom function for myself (let's call it fCustom in a myNSpace namespace) - and, for the sake of an example, let's say my app is called myApp so, to call (invoke) the function, all i need to do in html view is post this code: thisapp.myNSpace.fCustom(params); ok, i get all of this... and now the tricky part: is there a way to call this function from a link? i mean, i have a custom html view and i cannot add function
Formular Fields missing in Workflow
Hello, Unfortunately, not all fields (a text field and a picture field) of a form are displayed in the workflows for selection. What could that be? Maxx
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
Next Page