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
Having trouble with email rule
I have a checkbox set up, I will give an example of 3 options for a field called "Drivers" Jim Sue Thad I want each selection to email a notification to the specific person included. This works if you only select 1. Unfortunately if I select more than one it seems to break my rule and doesn't detect it. For instance....If I set up a task for emailing Thad when it is selected and the form is sent, if Thad is only selected it will work but if I have Sue and Thad selected it wont. I'm sure I'm just
Is it possible to have validation on insert of record that checks if field value exists in another form?
I want to do something like have a validation that on insert of record into a form of field for email address checks if the email address value exists in another form. If the same email address does exist in the other form, I don't want it to consider inserting the new record. I've been doing some research but still not quite clear if this is possible? Would appreciate any insight. Thanks
Page is pubished and so is the report that it uses but can't view it without login
I've been struggling with this all day, I have a support request open too but haven't gotten any traction. I have a page here that can't be viewed without login even though it is published: https://creator.zoho.com/rickdane/stacksavings/view-perma/testpage The report that is in the page is also published. What is the issue?
Is there any problem with the Sendmail and HTML?
Dear All, Is there any problem with the sendmail in Zoho Creator and the HTML? One of our HTML templates is shown like plain texts in all our mail accounts clients. We test it with a simple <div>Hello World</div>...It shows it as plain text in Zoho mail. Please check it URGENTLY!!!!
Responses from Creator API Changed in the past 8 hours
Hi There, From what I can see, the responses from the API have changed recently. The following example should illustrate. If I make a request to the api that does not validate I get the usual response see: curl --data "authtoken=<yourtokenhere>&scope=creatorapi&First_Name=test&Last_Name=test&Email=test@test.com&Mobile_Phone=1234567890" https://creator.zoho.com/api/zoho_beth3/json/talent/form/Appointment/record/add/ response: {"formname":["Appointment",{"operation":["add",{"values":{"Email":"test@test.com","Last_Name":"test","First_Name":"test","Mobile_Phone":"1234567890"},"status":"Failure,
Email notification on success
Hello, I would like to send an email notification for the Sales Person Assigned, once a new Quote Request is submitted. The email notification would be with the Customer Name, Project Name, Job Type, Additional Information data, as well as link to the relevant record view in the App. I tried to wrote a script on the New_Quote_Request Form Actions > On Add > On Success: quoteURL = " https://creator.zoho.com " + zoho.appuri + "#View:All_Quote_Requests?quoteRecId=" + Quote_No.ID sendmail
[SOLVED] Send Report Summary not possible anymore?
Hi, I tried to follow your instructions, but it seems as the function to send a report summary has been removed? I have a Record Summary (on a list), I should be able to select it as a template. I dont even have a template button. When I try to add it manually it wont allow me to add templates on edit, function or as a schedule (even though the instructions seem to say it should work). Has Zoho removed the function of sending a report summary by email that is not on create? /V
[SOLVED] Create a report based on form and subforms
Hi! How do I create a PDF report from a form with several subforms. Do I use a HTML view with "for each"? Or is there a better way? /V
Using Google Forms with Zoho Creator
I have a client that has created an extensive Google Form, with many fields consisting of radio buttons or drop boxes. Currently the data goes to an Excel spreadsheet, but I have convinced them to use Zoho Creator instead. My question is whether i can use their existing Google Form and have the data go into a Zoho Creator database. Would appreciate any feedback on this. Thanks, David
Forms that contain Subforms will not save on Edit
I have contacted Zoho by phone and email regarding this issue, but still have not received a response (despite having an Enterprise subscription!). When I try to Edit a form that contains a sub form, i get the error message "Invalid Entries found. Please correct and submit again." The form does not have any mandatory fields and I can create new records using the form just fine. I spoke to the gentleman at the Zoho Helpdesk who was able to reproduce the problem and confirmed that this is a back-end
Can I display record summary "On Success"
Hello, Can I display record summary after clicking Submit button? I have Auto Number field which is basically tool serial number in the system. Unfortunately it is not visible in ZOHO form, only later in report view. I would like to display that field with tool description after clicking Submit button. Or is there other way to display auto number field in form view? Thanks, Pawel
Dynamically fill subform
Hi, I'm building a rental system. In this system orders are created of the rented items to a customer. Each order also has a project. One project can have multiple orders. When the items are returned, a project is selected and then a subform should be filled with all the items on orders in this project. In this subform the returns will be entered and saved. How can I dynamically build this subform? Kind regards, Johan
OpenUrl called from a web link
Hi I have an HTML page which displays records from my database. I want the user to be able to edit individual records by clicking an 'EDIT' link alongside each record. I would like the form view to open as a popup/modal window above the HTML page. Once the edits are done I want the popup to disappear and the HTML to reload (updating the data). To this end I am trying to display a web link which will trigger: #Script:page.open(url, popup) I have a function which generates these weblinks for each
Next Page