Bug with Subform and loading
hello, i have a Form1 with a subform wich is a lookup to Form2. I add many rows in my subform with script deluge, no problem. but i want add a check on the Edit on my Form1. by example i write for each line in subform { alert "in the list"; } even if i have 50 rows in my subform the script don't enter in the for each ? Why ? thanks you
Using information captured on another form for dropdown box
HI there, I have two forms, one with referral data and one with broker data On the referral form I have a dropdown box which need to create a list of brokers which I create through the broker form The referral list includes the following fields Broker: (Dropdown) First Name: (Single) Last Name (Sinlge) The broker list includes the following First Name (Single) Last Name (Single) Thus I need the Broker dropdown in form(Referral) to have List of brokers that was created by through the form(broker)
Zoho Creator backup doesn't backup custom deluge script logic from pages, validations, etc?
I backed up and downloaded my application and looked through the files. It looks like pages and validations, etc (deluge scripts) are not backed up? I am shocked to see this as I invest countless hours into developing these scripts, why are they not backed up as part of the regular backup process? Is there any way to back these up all at once or do I have to manually back up each of these on my own?
how to enable auto complete function in script editor
i found this function in an second account that is in free trial period. but how to enable this in my paid account?
Exclude record from look up if exists in current form
I am having hard time finding anything to do with this topic, so I decided to start one. Here is my criteria Form "construction_budget" has a field that looks up from form "plans" this field is a formula field that concatenates the plans square feet and name. On the construction_budget form, this lookup field is named "plan_name" I need field plan_name to exclude records from this field lookup if that record exists in the current forms records. That way only items that need a construction budget
How to open another form with initial value
Hello I'm making a session application form. We have 2 sessions before we start our service 1. public session (about 10 partipants) 2. private session (1 participants) => start our service After public session, we arrange participants'/our schedule and decide the day of private session. Now I've finished creating public session application form and its report. and I added custom action 'apply for private session' to the report. When I click 'apply private session' button, I want to move to private
Something is wrong with ID's on a Form that I have
Something very weird is going on with Form records that I have. I am seeing bizarre behavior of not finding records when I try a fetch also in my page code. I have two records in the Form and am viewing a report, I have attached a screenshot of the report. It shows both records as having the same ID field. When I click on an ID field and copy it, the value that I paste is: 2940790000000069000 This is different than what shows in the report for this field. This is really pretty crazy and very concerning.
What is the correct way to resell Zoho creator apps?
Hi guys, I am planning to create and deploy an application using Zoho - its not going in to the marketplace but rather is just for a client of mine. I am just wondering what the correct way would be for me to do this - should I create the client their own Zoho creator account or should I create an app in my account and then add their users to my account giving them access only to their app? Thanks in advance Dave
Question about unique workflow/assignment problem
Hello, I would like assistance in trying to figure out how to set up a somewhat unique set of workflows. For example, say I have several accounts, each assigned to the respective Stage 1 account representative. Each account should then be able to be submitted/assigned to the next stage, e.g. Stage 2 account representative, Stage 3 account representative. Each representative should also be able to send the account back down. So, something like this: Jones Account: Stage 1 Jones Account Representative
Fetching records from Zoho CRM through a sub-form
Hi, I have some issue with my app. I added a sub-form “Operation Subform” in the “New Purchase” form. The Operation Subform fetches records from SalesOrders and CustomerModule1 modules of Zoho CRM, based on the lookup field Order Number. When I try to run the subform in the New Purchase form it gives an error (something with the zoho.crm.getRecord). The script is the following: //Auto populate from Zoho CRM. Order_Number_ID = 0; for each operation in Add_Operations { crmOrders = zoho.crm.getRecordById("SalesOrders",
Limiting for loop
Hi, I have below script with JSON functions what I am facing the problem is exceeding maximum number of deluge statements. So to avoid the situation I would like to limit the for loop to a specific number like: range from 1 to 200 etc. But Here How do I do that since it is a JSON list, please help me url = ("http://api.tvmedia.ca/tv/v4/lineups?api_key=123" + input.Zip_Code + "&lineupType=" + input.lineupType + "&detail=full").toString(); response = getUrl(url); lines = response.toJSONList(); for
Fetching records From Zoho CRM
Hi, I try to fetch records from Zoho CRM's two modules to a form in Zoho Creator. The following script is written that is saved and runs without problems: crmOrders = zoho.crm.getRecordById("SalesOrders", input.Order_Number_ID); input.Contact_Name = crmOrders.get("Contact Name"); input.Billing_Country = crmOrders.get("Billing Country"); input.Order_Date = (crmOrders.get("Created Time")).toDate(); operationsList = zoho.crm.getRecords("CustomModule1"); for each operationDet in operationsList { operationNumber
Problems forwarding to aol email addresses
Has anyone else has any issues with forms not sending to aol.com email addresses? I have a series of applications and scripts that forward user submitted data to various email addresses, and recently the aol addresses seemed to have stopped getting their emails. Thanks so much for any help! -Courtney
Render images in form and list
Hi there, I need to upload or take a photo with smartphone by Zoho Creator app and see it in form and list view, but choosing dimensions for adapt it in form/view. With previous version I attach a file and this formula ("<img width='250' src='http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Carica_immagine + "&sharedBy=" + zoho.adminuser) + "'/>" but now I have professional and it don't works Thank you
User Input (for Mobile) Field Properties not working?
Hi, Under the "User Input (for Mobile)" section of the field properties on a Single Line field, Zoho Creator allows you to enable either "QR Code" or "Barcode" input as per the documentation here: https://www.zoho.com/creator/help/fields/qr-code-barcode.html However, this doesn't appear to be working for me in the "Zoho Creator" mobile app. Help appreciated. Thanks
Using a button to open a URL dynamically
I am trying to use a button that will invoke a URL that I have associated with a particular record in one of the other modules. This is different than just invoking a static URL that I specify in the button. I'm looking through the documentation and I am having trouble finding anything. Can anyone point me to how I may handle this?
Intergration of Zoho CRM information into Creator Application
I am creating an application that would allow us to have people check into a rock wall. I am happily using CRM to manage the people that are interactive with us. (For instance, if someone fills out a trip application, signs into the rock wall, applies for a project, ect. they are all recorded into our CRM database) What I would like to have happen is when someone clicks on there name in our application using the CRM field, information about that person would automatically be populated into the form.
null = zoho.creator added to my script on save
I have a deluge function that looks like this void AddToRecents(int EmployeeId, int CaseId) { [...snip...] // no hits, insert new record rvId = insert into Recently_Viewed [ Last_Accessed = now Employee = input.EmployeeId Case = input.CaseId ViewingUser = zoho.loginuser ]; } But every time I save it and go back, a line is inserted (line 11 below). That line, of course, is invalid and the function doesn't work. Does anyone know why and what to do about it? void AddToRecents(int
is it possible to show an image when you load to edit a form
is it possible to show an image when you load to edit a form
Display Images from a Subform in a Record Report
I have a "products" form with part # and images. And I have an order form with a subform that has a lookup field referring to the part# in the products form. I would like to create a report from the order form that shows images of all of the products ordered. Is this possible? Thanks!
Adding a custom URL to Zoho app
Just wondering if its possible to access Zoho creator app via a custom URL (Like database.mydomain.com)? I understand this can be done when using a customer portal but I am not planning to have a customer portal, I just want a database that is accessible by internal staff but would prefer if it could be accessed via a company address. Is this possible? Thanks Dave
Add List:String in dropdown
Hello i want add this list of string during the loading of the form i go On Edit -> On Load -> list2 = List:String({"hockey", "cricket", "football", "tennis"}); for each e in MySubForm { e.Dropdown:ui.append(list2); } but after the downloading i have already just "Choice 1" in my dropdown. Do you know why ? thanks you
Update three forms through function
Hi, I have the following: Form A Form B Form C Form A -> Multiselect to form B (Lookup field) Form C = Subform to Form B On update of form C -> Fields update in form B -> Updates in form A Problem is that Form A only updates if I do an edit-> update on form B. Can I somehow "refresh" or simulate an "on edit" on form B through a function? Everything works, except that I have to update the form manually on Form B for it to show on form A (not even the values, just "update" and it works). Thx! /V
Automatically adding a new row on a form when a row is entered into.
I want to have a dynamically building list of fields for the database. Easiest way I can describe it is to show a picture of an example (I know it's uber simple and I'm just missing something obvious). This is just from google image search but it demonstrates basically what I want to do.
HTML view form and link that gets data from form input
I want to build an html view with the following: 1. Embedded Form 2. An html link that opens a record to edit based on a select value in the embedded form. How do i pass a selected value in the embedded form to another part of my html view so i can open the correct record in the html link? Is there a way to get the value selected in an form that is embedded in an html view and use this value for other parts of you html view? ================= The reason i am trying to set this us is because i need
Setting a variable based on another form's field that was chosen previously in the current form
I'm creating an application form and I have a lookup field that accesses another form that holds the positions and whether or not a Drivers License is requiered. I later want to restrict the field that allows you to input an id type to only drivers license if the previous lookup field chose a job that required a license. Otherwise it would allow you to select Other types of ID. Once I am able to do this I will then be able to use this technique in other areas of my main form to get specific types
Create a report and import it to Zoho CRM?
Hi, Just wondering if its possible to have a custom report and upload it to the correct user in Zoho CRM by using a function in Zoho Creator? How could one do this the best way? The emailadress required exists both in Creator and CRM so it shouldnt be a problem adding the information. Should I have a custom app, send as a email or by using the API? Suggestions? Thx for your time! /V
Embedded iFrame and Internet Explorer and Safari Not Working
When using embedded iFrame with Safari either on phone or Mac or Internet Explorer v. 9 or 11, the user experiences "please wait" and it does not submit or go to next URL. Here is a screencast: http://cl.ly/image/3K1Y0a373T33/Screen%20Recording%202014-12-28%20at%2008.31%20AM.gif The same embedded form is working fine in Chrome and FireFox. Also, when you login to Creator and submit using Safari it works. So it is the embedded iFrame code that is the issue with Safari.
Can you have more than one developer active per application?
Working on an app, but I can't give more than one person edit privileges. Even though both users are categorized as developers.
Sending email from button click event?
I tried setting up an on click event to send an email based on a form button click but got an error. Is it possible to send an email this way? I can post the code later when I'm on my laptop.
passing criteria to embedded form
Publishing a form so a login is not required results is a very long url. This is too long to include in a tweat. Is there a way to mark a form as public so it does not need the long security code? I can embed the form in a website and then use the webpage link. However I do need to pass some criteria to the form. Is there a method for a form to read the current url? If so I can then parse that string to get the passed vales.
Invalid date not showing as error 08/25/0015
If a date is typed in with the century as 00 there is no error displayed. There are very few applications where 08/25/0015 is a valid date. Is this on the roadmap or should I handle this error using deluge code?
Importing Access 2007 with auto number
Importing an Access 2007 database works without a problem using the Zoho migration tool. I have a number of Access 2007 databases that have Autonumber field and there is data already in the table. Q1) How is it possible to import data with autonumber in the access database? Q2) Is it possible to create a form with a Zoho Auto Number and import data directly? As aside I sometimes use in Access 2007 vba code Max([contact_ID])+1 to create an incremental numbering process. Q3) Is it possible to achieve
Upload CSV
Hello, Is it possible to load a CSV and work with DELUGE ? if no do you have this functionnality in your roadmap? thanks you
Validations not run on import? How can I have validation logic or other logic in import for form data?
I would like to have validation rules for when doing a bulk import (like importing via .csv file) and also, I want to have some other logic, like if a field has one value, then calculate a value in another field based on this. I have this all in place for my form for new submissions and edits and it works fine. When I run an import, however, none of this logic is triggered, I am confused as to whether there is a way to do this? This is a critical need for the app I'm building and I figure there must
Fetch record using Lookup Field?
I'm fairly perplexed by this issue.. I have a form Called Task This has a field called TestLook which is a Lookup of a form called Contractor. The lookup field is Token_Secret. I have checked and there is definitely a record in Task that has TestLook set to a Contractor record that has the value for Token_Secret match input.Token, I am trying like this in my page: tasks = Task [TestLook.Token_Secret = input.Token]; Is the way I am doing the fetch not correct? I'm perplexed as everything seems
Bug in filtering on Mobile App
Hi! The mobile App can not show any UTF8 char displayed in the filter section. Just cuts them off. /V
Upload image with API
Hello, is it possible to upload image with API ? If yes do you have an example ? thanks you
Distinct Record View
I want to create view that displays the unique (SQL: distinct) values from a text field? how?
Publishing page does not generate authtoken at end so can't access it without being logged in
I am absolutely perplexed by this issue and have been going back and forth with support on this already. I am trying to publish a page but it does not publish with an authtoken at the end. Support told me that it should, I am trying like in the screenshot I have attached. It just gives me a Permalink like this: https://creator.zoho.com/rickdane/stacksavings/view-perma/test2 So whenever it is accessed without being logged in it prompts for login. Is there something wrong with my account as to why
Next Page