Setting a numeric variable.
I need to set a number or currency field based on another value. My if condition is working perfectly fine but I cannot get the correct syntax to set a numeric field using the script. I can set the text fields perfectly fine. I've tried the following: number_field = 14; input.number_field = 14; set number_field = 14; set input_number_field = 14; I've set the number_field as a currency field and tried 14.0 as well but didn't work. I have a radio buttons and based on the selection I want to populate
PDF Report Margins
On a PDF report, the content shows all the way to the edge of the page on both sides. Is there a way to create a margin on the reports?
500 Something's not right...
Hi people ...are happening with your applications too? Also "no transaction to commit". News from Zoho Creator? Thanks Mike
Need to switch between lookup field types, and radio button not working with lookup field
The options for a lookup field display type are Dropdown Radio Button Multi Select Checkbox Once the field is created, how do I change between types. Also, when I select a radio button in a lookup field, it is displayed as a dropdown and not a radio button. How can this be fixed? Thanks
Call another form
Hi, Can I call a second form from one form after data is saved by having a "Save & Next" button. Also I want to have access to all the input data from the first form in the second form before it is committed to database. Please suggest. Thanks, Milind
Help with dynamic lookup example from documentation
Hi, can you help me please with a question about the dynamic lookup example in the documentation: https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html#Create_Dynamic_Lookup I need to implement a form that, when the user access the form, all the countries and states are available on the dropdown lists, so: 1. If the user first selects a country, the second dropdown list will be updated with only the related states, so he can select a state 2. If the user first selects a
API getURL multiple records
Hello, I have created the following script: //BASE 64 Encryptie van gebruikersnaam, wachtwoord van Undagrid headerMap={ "Authorization" : "Basic secretcode=" }; x = getUrl(("https://api.url.com/history?count=1"),headerMap); nodeName = x.executeXPath("/root/json/nodeName/text()"); nodeUuid = x.executeXPath("/root/json/nodeUuid/text()"); N=(x.executeXPath("/root/json/value/x/text()")).toDecimal(); E=(x.executeXPath("/root/json/value/y/text()")).toDecimal(); dX=((N - 155000) * 0.00001.toDecimal());
Function to create new form record, then delete subform record
Hi, Got some questions regarding a function that I am writing. Main form "Parents" With subform "Children" Linked together through a lookup field "Parent_Field" in the Children form The function I write will make a "Child" into a "Parent". The function will be manually triggered by a button in the Children table, for each record. So far: void child_to_adult(Children rec) { insert into Parents [ Added_User = zoho.loginuser Date_of_Birth = rec.Date_of_Birth
Persistent variable/collection again
I have a client with app that has about 20 reports. They would like to look at these reports without having to select the customer from a filter. I imagine a system where, upon login, the user is asked to select a specific customer. Then all reports and forms are pre-filtered for that customerID. The CustomerID would not change until that initial form is brought up again. Is this possible in Zoho Creator?
Download pdf from iOS/Android
Hi I have problem with download pdf from link On PC/MAC is OK, but when i try click on link on smartphone, it just redirect me to page inform about app for Zoho Creator and pdf file is not downloaded. I have to refresh page to download it. That is not comfortable for customers. Any help how to skip this step about zoho app?
ui.append using multiple fields
Is there a way to list multiple fields instead of a single field with ui.append? ie: first name (and) last name first name (and) last name first name (and) last name instead of: first name first name first name
Formula
Hello, Can someone tell me why this formule can't be saved? I'm losing my mind. N=(x.executeXPath("/root/json/value/x/text()")).toLong(); E=(x.executeXPath("/root/json/value/y/text()")).toLong(); dX=(N - 155000) * 10.power(-5); dY=(E - 463000) * 10.power(-5); It says: Error in saving the script: Error at line number : -1 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
number of deluge statement
Hi, let suppose we have a Function A that calls two other functions A1 and A2. Function A1 has a for each cicle that iterates 1000 times and in the loop there are 4 tasks...A1 should "spend" 4000 statements Function A2 has a for each cicle that iterates 1000 times and in the loop there are 3 tasks...A2 should "spend" 3000 statements Function A should spend 4000+3000 =7000 statements. The maximum limit for deluge statement should be 5000..right? This means that A1 and A2 can be executed by themselves
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
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,
Next Page