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
Dynamic field names/labels, anyone have a good solution or work around?
Hello, I am currently building dynamic field choices on the same form that flex for my different clients. Using one form versus many forms is key to how we maintain our databases. My clients are in a similar industry, but sometimes they use different verbiage when referring to essentially the same thing. I have been able to get away with trying to use my "cookie cutter" form across clients, but I'd prefer to allow my clients to have their own terms used for each field display name, even though behind
Zoho Creator report page to automatically update Excel tab
Hi I have been trying to pull data from a Zoho Creator report via HTTPS into an Excel file. The format of the data does not look pretty in Excel. I have tried different formats.... what is the best practice in pulling Creator data automatically into Excel? Thanks!!!
Sendmail Feature Different in Forms from Functions
Why is the SENDMAIL feature different in FORMS then in FUNCTIONS? Example, you can not attached or include a Template when using SENDMAIL in a Function. What I'm trying to do is include the Custom Record Summary with a function request. This function request I need the template included is used during a Custom Action definition. I tried cuting and pasting from the SENDMAIL in FORMS, but it gives me an error. What I'm trying to do is include a custom record summary as a PDF attachment to be used
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.
Identifying when sendmail() didn't suceed
Hello - It's previously been established that occasionally the sendmail() script does not result in an email message being sent. In several posts to this forum, Zoho Support has replied to sendmail() problems as "potentially an intermittent issue, please try it again". I'm curious if anyone has determined the best way to confirm that the sendmail() functioned correctly so that a user or admin could manually re-fire the sendmail() function at a later time. Thank you, Kevin
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
Get the report based on user input.
Hi, I am trying to create an application with few reports. We have 10 different location. Each location as its own users and they cannot view other location data. So currently we are creating multiple report for a form with country filter. But this is time killing task and every time we create a new form we need to add more than 10 reports based on location. To overcome i was thinking if i can create a stateless form and user select the data from a drop down, and it can bring all the records they
New(er) to Creator and need help with Script
Hello friends! So I have an app called Bill Entry where I have a lookup field called Customer and a lookup field called Utility Account. The lookup field "Customer" relates to the field Account_Name in an app called Accounts. The lookup field "Utility Account" relates to the field Acct_Num in an app called Utility Info. So, in the Bill Entry app, I am hoping that when I select the Customer in the drop down field that only the Acct_Num related to that Account_Name will show. I am just beginning
Error reported when changing Field Name
I recently added a field on an existing form. The field was added and it shows up fine but the Field name is set to "Single Line". When I change the name to something more meaningful it displays "Saving Changes ..." at the top of the page and then eventually displays a pop up saying "Exception occured while publishing message to the topic :: [DataModelTopic]". I read in the forum about this error and it was mentioned it could occur if there are too many fields on the form. I deleted a few fields
Edit error messages for required fields
Hi everybody, Is there a way to edit error messages for required fields (error popup and red text below the field). I wanted to use show field (and cancel submit) when submit but we can't. Any advice will be appreciated. Thanks Pascal
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
Drop Down filter based on loginUserid
I am filtering a dropdown based on a field in the form - ForemanUserID if the current zohologinuserid == ForemanUserID the job should show in the dropdown. This works initially. When I log in as another user however, I see the list from the former user. Do I need to clear this list - somehow? This is on a subform. Additionally - this dropdown is used to filter the selection on the next field - also a dropdown. Don't know if this is relevant..
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
Json feed mime type issue
Internet Explorer 11 (I did not tested other versions) currently blocks ZC json feeds in Ajax requests (for example, when it's used with JQuery getJSON() and probably the ZCML script proposed by Stephen here because it is also based on JSON feed parsing) and the issue is a type mismatch. This is the message from the IE developer tools console: <url> was blocked due to mime type mismatch (<url> stands for the current json feed url) In Chrome the json feed is not blocked, but the following message
Excel refresh
Hi how can I embed a Zoho view in an Excel file, and let the Excel side refresh automatically on a frequency or on demand? Thanks.
Re: Lookup in a Subform
Hi, I am hoping that someone can help me with this. I have two forms: Enquiries Look Up Customer Name (Drop down) Look Up Contact Customers Name Contact (Subform): Name, Telephone, Email I am trying to make it so that when a customer is selected from the drop down, the Look Up Contact gives a drop down of all contacts for this customer. Any help much appreciated. Thanks,
Auto Number
Hi, I am trying have an auto number field that is displayed when adding/editing a record. Our reference numbers are in the format: B-879 and increase by 1 each time. When it gets to B-999 the next record is C-000. Is it possible to do this? Any help much appreciated. Thanks,
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?
Fetching Records
Hi, I have an enquiry record which records the receiving and quoting of an enquiry received from our customer. In this we have a subform which has a look up field which records which supplier we have usedand the value of their quotation. We have another form which for Suppliers. In this Supplier form, I want to have a subform that displays the previous 5 enquiries where we have used this supplier. It will display fields Our Ref.:, Customer, Date Rcd, Drop Down, Value (from Supplier subform). Any
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.
Different effects of sign-on on different computers
I ended up with 2 computers. On one computer, when I upload a ZOHO database that I DO NOT want viewers to make changes, I get the normal top heading, with SEARCH, and on the top Right SIGN IN . Without signing in properly no one can make changes. JUST WHAT I WANT. On the other computer when I do exactly the same and upload, I only get SEARCH on the left and SIGN IN is not there , and even I cannot make changes. Can you tell me what is going on. And how I can make all of my several CREATOR databases
Error Form
The request was triggered by different origin ...??????
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
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
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
Next Page