Form On Add -> On Load executed twice
I have the following simple form with no fields, just a debug statement in the On Load and On Success of the On Add section of the form. the debug function just writes out the parameters to a debug form. form DoubleOnLoad { success message = "Data Added Successfully!" field alignment = left actions { on add { on load { // Test to see if the on load executes twice thisapp.com.debug(1, "On Add", "On Load",
Public form --> filled in field
Hello everyone, Is it possible in a public form to automaticly fill in a field value? For example: https://creator.zohopublic.com/<domain>/<application>/form-perma/<form-name>/sue8yw5sn56ZdOqGrSQwPKnYXYeSmMekaTCezj4Nq2UBSKOfszEyCYGdWkVzZNb9pX4FNq83TjCQmOEMxmftm7S6jzn6Pvs7eQRX/?Automaatnummer=2404003000002793141 Greatings, Erwin
How to "Auto Genearte PDF" and "Attach it in Email"?
Hi, I have a question, how to : 1. Auto generate a PDF based on a form record? (e.g. a PDF of student profile based on a record in student form) 2. Then attach this PDF as a email attachment and sent it out? (e.g. send the generated PDF by email to this student) Thanks for help! Best, Yiheng
Record Summary
I am creating a record summary based on a form and sub-form. For each form record there are multiple sub-form records. When I create record summary based on the sub-form and insert fields in a section, all records are printed (displayed) on one line (with comma separated) instead of on a separate line. Since all fields have the same name, how to get a line break after each record. Please help. Thanks in advance. Milind
Extract data from "Notes for Sales Order" in SalesOrder module via Creator
Hi, I have been trying to pull data from "Notes for SalesOrder" and wondering if there is really a way to do it via the creator deluge script. Really appreciate it if someone would be able to guide me on this. thanks in advance.
Mobile link form not scrolling properly
Using the "form-mobile" method in my permalink to embed in my mobile application. The app "auto scrolls" to the top. When my user tries to fill out fields at the bottom of the form and try to scroll down it forces them to scroll up, not allowing them to complete the form. Seems to be an issue in Android only, users on A galaxy note 5 and galaxy s6 have reported this, may be a javascript error.
Create DB View Report
Hi there. I have an app with the following columns MemberName, MemberLastName, MemberQualified, PartnerName, PartnerLastName, PartnerQualified In this application either the Member or his Partner or both can be "Qualified". The Qualified field can either be YES or NO. I want to create a report or view that will show one line FOR EVERY Member OR Partner that is qualified. In other words, if there is only one entry in the DB, but BOTH THE MEMBER AND PARTNERS IS QUALIFIED, I want to show TWO LINES
Changing the formatting of a web form
I would like to put a form on our website to gather data that will feed Zoho CRM. The default 1 or 2 column format will not work. We would like sections, some of the fields in a table, etc. In other words, we want to customize the look and feel of the web form. What is the best way to create a custom formatted Web form?
Customer Portal - Customer Portal ID matching up to Database ID
I am looking at Zoho to create an idea I have in mind. I'd like to find out if the features I need are available before I sign up. Perhaps I may be thinking about this wrong but I am perceiving the customer portal, and the users (persons) in that, as a separate entity from the people in my database - but they are one in the same in my app and the person in the customer portal must be able to access his/her info in my database...is there a way to do this currently? Let me explain: My database will
Remove previously selected lookup choice in subform
Hey guys, I've been thinking and working on this concept for a little while now and haven't been successful. The closest remedy I could find was the the thread: " How to remove item from picklist which have been selected in previous entries in a subform context?" The user found a solution but never posted the results. I've been using the methodology that he outlined in the post as a means to get started but I haven't been successful. For reference, my code nearly mirrors the code presented in this
Route Google
Hello, Does anyone know if it is possible to create a route in Google Maps based on records in Zoho containing GPS coördinates? Greatings, Erwin
Mobile Creator form style, can I use it for my normal Creator form permalinks/embeds?
Just started playing around on mobilecreator.zoho.com. It is a nice looking tool, but not really useful for real implementations in my opinion, versus the normal Creator. This one thing I prefer about the Mobile Creator is that the forms look so much nicer for mobile, the data entry is much more mobile friendly, and the big green submit button is easier. Currently I am embedding forms into my apps by changing the "form-perma" to "form-mobile" in my published URLs, but would much prefer to have similar
Image field in view on creator android app not showing image
Hello. I have an image field on a form and created a view that shows the image. When I access the view from the mobile app the field name is there but no image. Is there setting to turn this on? Arlan
Running a code within html progress graph
I'm trying to make a code that you enter the variable in HTML code, a progress bar, but when I run the code the varible remains the variable name and not as the result: Grafica1 = "step1 visited-checkout-step" <div class = "checkout-progress"> <ul class = "progress bar"> <li class = "grafica1"> <span class = "triangle2"> </ span> <a href="#"> <em> 1 </ em> Order placed </a> <span class = "triangle after"> </ span> </ li> I want to run the code and that it isinstead of to stay as the original. Grafica1
Record Summary
When I format my Record Summary and save it even then some of the changes are not saved, however on screen it shows the changes as required. When you access the application it still shows the earlier version, even though you get a message "saving" on pressing the SAVE button. What is the problem ?. Is it saving the changes or not ? Can someone help. Thanks, Milind
render a list of product records and create a new quote record
I have a requirement where I need to show a list of product records and allow the user to select certain product records using a checkbox and then create a quotation by clicking on a custom button. Can this be achieved with ZOHO creator?
Reset Counter Daily??
We want to assign each entry a date code with index. So each submission would look something like YYMMDD-[Index] I can get the YYMMDD-[Index] and i have the function working to increment the index after each submission but what i can figure out is how to get [index] to reset every day so each day it starts at 1.
Search page and pre-populating values in form
Hey Guys, I have a form in ZC which is used for simple data entry process(name tf2 ). fields: Name Age Mobile I have another stateless form(name stateless) in the same application. Here I'm entering a mobile number and checking whether any record for that mobile number exists in my previously entered data (in tf2). In the stateless form, when user enters a mob. no and hits "Search" button, I'm redirecting the page to show the available records found for that mobile number using OpenURL script.
Customer Portal Customization
I'd like to change the text under the "New User" Sign Up link on the login screen, which says this: "Create an account and contribute to the community.", which is not at all appropriate for the application I'm building. Can this be done? Thanks, Len Len Kamerman Hero Technical Solutions www.yourcrmhero.com
Cannot get "old" data.
In Edit|Verify, Script Builder still has a tab for assigning a value to a variable that says "Old", but the code it creates won't compile. Is it still possible to get and use the previous field values? Bruce "Speedy G" Peaslee The World's Fastest Programmer
Time Zones
I've asked this question before, but I got no responses to my actual issue so I am trying again. I have multiple users who are in different time zones. I also have lots of date-time fields. I know how to determine what time zone a user is in. What I don't know is how to display the date-time fields accurately for the user who is viewing it. So for example I want user#1 on the east coast to enter a time stamp for the current time let's say 8:00 AM EST. I then want user#2 on the west coast to
Drop-Down Error on Subform w/ Mobile
I have an equipment leasing app. The main order form is the order "header" information (customer name, address, phone, etc.). A subform is used to record the individual items on the order. Two pieces of information are entered for each item leased - the item and the serial number of the specific unit that was leased. The application has a table with the serial numbers of each item (a child relationship to the parent of items). On entry of a lease, 1. The user selects the item from a drop-down
Not able to duplicate an application
I have created 3 applications in ZOHO creator. I am not able to duplicate a particular application only. All other applications I am able to duplicate except this one. Is there any settings issue? I am not able to understand. It does not give any error message as well. Please help. Thanks, Milind
How to manually set a file name when I click the pdf button
I created an html page and I enabled the pdf = true. I would like to ask you if there is any way when I click the PDF button and starts download the file to change the name of the downloaded file. I mean if I can manually set the name of the PDF file somewhere in the html page and by clicking the PDF button to set this name to the file
Email a PDF attachment to a specific existing record?
We can create a record with an attachment using the email template but is it possible to email an attachment to an existing record? Thanks...
Calendar view ('Month' view) question
"Month" view: is it possible to freeze the 'Days of Week' pane/row, currently it scrolls up with dates. I realize that it can't be changed in the report/view settings. A question for developers? Thanks.
Enabled ZC Chat changes colors of the links to black
I have fields in some views that are linked to other views (lookup fields). The color of those fields used to be blue, but now they are black. They are still clickable. but they should be recognizable by color. in the view record they are blue. It happens only when the ZC Chat is enabled.I see that .authorChatPresence in a FF inspector when Chat is enabled. After I disabled the chat, blue color is back. I guess, this is a question for developers. Thanks.
Remove creator header from edit record custrom action popup window
I have a view with a custom action button that will open up a form and allow you to edit the form. I want this window to open without all the zoho creator header stuff (compay logo, creator tabs etc). Below if the function I am using. I think that there is another way to write the url that might remove the creator header stuff from the top of the popup window that opens but i do not know what it is. Please any help is appreciated. My function: void Quoting.editQuoteItem(int ID) { openUrl("https://creator.zoho.com/<zohoaccountID>/<AppName>/#Form:Quotes?recLinkID="
Create multiple records in blanc form
Hello, I have a question about the insert into function. I have three forms: Form A: containing the fields: Name, group and Number ; Form B: containing the field: Name, group and Number and Message; Form C (blanco form): Containing the field Group and Message; When I select the blanco form I have made a submit button with has to do the following action: Based on the selected group, it has to search in Form A who is in the selected group. It has to input the users who are in the group into form B.
Understanding Schedule
I am trying to wrap my head around the schedule feature in ZC. Say i have a Task table with contains Date Time when the task is due. I want to send out reminder email 1 day before the due date time. This schedule is good from 1/1/2016 to 12/31/2016. Under the schedule, there is a Start Date option. Is this the "execution start date" or the series start date (1/1/2016)? I assume it's the "execution start date". Am I correct? Now how can i specify this schedule is only good for 2016 only? Am I correct
Pass "input" as function call argument
How come I can't pass input as argument to function calls? A valid scenario is this, in On Edit-Validate, the input is the form before it's persisted to database. Let's say I have form called Company, input is of form Company. I have a custom function that uses fields inside Company to send emails. void mySendMail(Company c) {...} I want to be able to call the function in the following two ways: 1) mySendMail(input); 2) x = Company[ID== 2341252]; mySendMail(x); Now, because i can't pass input as
Drop down field, send e-mail on selection.
Hi, We have a form for members to submit a request to become a member. One of the fields is a drop down with status that the admin uses for approving a member. Status: 1. pending (default) 2. approve 3. inactive When the status changes to "Approve" we would like the system to send a welcome e-mail to the user. How can we do this? Thank you. Sami
Calling XML RPC API to add a record to a form with sub-form
I am trying to add records to a form with sub-form in Zoho creator using the XML RPC API in C#.NET application. I am getting the error below when using Web Request class to create the request. { "The remote server returned an error: (400) Bad Request." } I am using ASCII encoding and Content Type as application/xml. Can anyone provide me an example with C# code to make a call. Thanks!!
Related to Stateless Forms
I am new user of Zoho creator.I am facing problem to fetch data from Main form to a stateless form with a look up relation between them.Can some body help me.Thanks
Show all months on graph even if data = 0?
We have an application that tracks shipped product, each shipment is a row of data. however if no shipments for that product occured in a given time period the graphing engine does not display those months,. Is there a way to set it to show months even if there is no data in them? below the line graph is a running summation of product shipped. There were no shipments in October or November so it doesnt show them on the X axis. Ideally this would have flat lined for Oct and November.
Create Zoho Calendar Event on another uses's calendar
The guide here only shows how to create an event on one of my own zoho calendars. Is there a way to create an event on another zoho creator account's calendar? The scenario is that we have a scheduler who uses zoho creator to assign tasks to technicians. We want the scheduler to create events on the technicians' calendars, not on the scheduler's calendar.
Show all months on graph even if data = 0?
We are using Creator to track shipment of products. Each product shipment is a row. The line graph shows a running total of that product shipped over time and the column graph shows shipments by month. No shipments occurred in October or Novembers, so the graphing utility is not populating Oct and Nov as intervals on the X axis. Is there a way to have the graph still show the months when activity = 0?
Autofill
I'm new to this and struggling with a specific requirement (mentioned below): I have created a form in zoho creator. After which I have entered some data using the form. The data I have entered shows up in the list report which was auto created along with the form. What I'm trying to do: I want to enter a mobile number in my form, which is already present in my data (was entered before) and all other data related to that mobile number should be populated in all other fields. Example: I have the following
Close html view popup from a form in the html view inside of a iframe.
I have an html view that opens in a zoho popup dialogue box. The html view has a series of record views and forms all inside of separate iframes. When one of the stateless forms inside the html view is submitted i need the entire zoho dialogue box to close. I cannot seem to get this to work. I have tried the openUrl functions but they all seem to apply to the iframe that the form is in rather than the whole window that the html view is in. I cant seem to get the whole dialogue box to close. Please
I have tried making a script in Creator to push data to CRM but it is not working? Why???
Creator does not recognize the CRM field (of course). But why is this example script not working? https://help.zoho.com/portal/en/community/topic/push-data-to-zoho-crm
Next Page