Checklist made of hyperlinks
Hi, I'm trying to create a checklist, using a few checkboxes with a few options in each one. I need every line (every option under every checkbox) will link to a file in our Google Drive (the name of the option will be a hyperlink) Another (maybe better) option will be an "upload a file" link next to the option text, that will upload and save the file to out Google Drive, and after the upload will change to a link to the uploaded file. Is any of these options possible under Zoho? Thanks! Ravid
Mobile app IOS Split screen only partly working
Using an IPad Air 2 It would be very useful when filling out some ZC forms to have information available from a different app in a split screen. For example contact information from Contacts, to use in the active ZC form. Although this works fine with most apps, for example the Contacts app can be open in one half of the Ipad screen and Safari can be open in active window next to it, the ZC Mobile app does not appear to currently support this. It appears that both apps cannot be active at the same
Sub form "+ Add New" function not available on mobile app
Hello I have an application that has a number of subforms that hold lists of items. The number of items per use can vary. In the web application, the subforms have a + Add New button that allows for adding additional rows in the subform to add additional items. The mobile app of the same does not seem to have this function and does not allow me to add additional rows to the subform. Any ideas on how to get around this other than setting the Default Entries to a large number to allow for a range
Copy to a lookup field
Hi, I would like to populate the value of a lookup field through a a copy of a field using custom action buttom. Example. Form1 have the fields CustomerID, Product1, Features and several more The CustomerID field is a number Form1Report have the same fields and a Custom Action Buttom for copying fields CustomerID, Product1, Features into Form2 in Form2 I want the CustomerID field to be a Lookup field to a table called customers. So the fields in the customer form can be used in the reports created
store script in record
Will try to explain this the best I could . I am trying to be able to create email templates to be used in the send mail function . A new record comes in it validates its ownership and fetches a record from its owner how to be notified record. In the end I will need to do this with sendmail and posttourl but right now just trying to get one to work . So I added a multiline txt field to the needed form and it fetches correctly . The problem is that it doesnt pull information from the new form / I
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
Next Page