Subform Functionality in the Mobile App
I use subforms in a workflow app that allows the user to add records as needed. In the web version there is a "+ Add New" button in the subform that adds a sequential blank record to be filled in. Is there a way to replicate this in the mobile version without just setting the number of default rows in the subform to a high number? Thanks Kirby
Need help using data from one form to another
hello, I am trying to pull data from one form to be used in another. I have 2 forms that I am using Form 1 Rates Form 2 AWB Entry the Rate form has 3 fields: Location Airline Rate The AWB Entry has drop down fields for Location and Airline. AWB Entry also has a Rate field. I want the rate field to be populated automatically from the Rates form by matching up the Location and Airline fields in the AWB Entry form to the Rates form. Any help would be greatly appreciated.
Dowmload File
Dear Executive, I am sending an uploaded file as a link in my sendmail deluge script of the form on Add -->on Success event. The file gets listed in the e-mail as hyperlink. See the attached screen shot. However when I try to download the file it gives following message : You have logged in as amilind2010@gmail.com. You are not allowed to access this view. Please click here to login as a different user. Click here to go to your Home Page. I am the administrator and user of the program. What is the
Want list to not filter on "edit" form
Need advice on how to edit the deluge so a lookup field is NOT filtered when the form is edited but is filtered when a new record is added. I tried just pasting this section again after the "on edit" part without the filter in the values but it didn't work. What would the correct syntax be? must have Pad_Name ( displayname = "Pad Name" type = picklist values = Frac_Pads[Current_Pad].ID displayformat = [ Frac_Pad_Name ] sortorder = ascending
E-Mail Attachments
Hi Everyone Just wondering if it is possible to add an attachment with an e-mail message being sent out As example, I have the following script I use to blast out e-mail messages. Just wondering if there is any way to add code to prompt for an attachment? Thanks Chris for each record in Students[Student_Status == "Active"] { sendmail [ from:zoho.adminuserid to:record.Email subject:input.Subject_field message:"<div>" + input.Message_Text + " </div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><i></div>"
How to create recurring subform entry?
I have a customer form that contains a subform which contains different job dates. I want the subform to automatically generate an entry after [x] days (i.e. create new job every 7 days). How to do this?
subform script to delete matching record
whenever I delete a subform row I want the matchings record to also be deleted, what the easiest code? I'm braindead right now. thanks Larry PS in trade here's a code I just added to tips and tricks
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
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());
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?
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
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.
Next Page