Incorporate Multi-Select Option into Calendar
I'm trying to incorporate a time-off feature into an app, and I'd like to allow an employee's days off (selected via a multiselect menu on the employee record) to be reflected on a calendar view report alongside any vacation time they've entered. Is there any way to do this?
Select All and Add Values of Lookup Field in Subform
I'm working on creating a class registration application that has three main components: -A "Curriculum" component that allows us to define programs that can be used across groups (think a class) -A "Groups" component that allows us to create meetings that may or may not involve a particular curriculum (think a section of a class) -An "Add-Ons" component where we can define materials for a given curriculum (i.e., a workbook), and then when creating a group we can define whether the add-on(s) are
Creator Pubished Public Forms Time Out
All of our published public forms no longer work. They are timming out in Internet Explorer, Firefox and Chrome. We have 2 different published forms and neither of them can be accessed. Anyone else having this issue? What is going on? We have not enabled the new " Login changed for private embedded components in Pages" update . Here are two forms with the problem: https://creator.zohopublic.com/precisionsailloft/prod/form-perma/Website_Product_Quote_Form/5HDCVB7eJtSA8Ddj7qTbZSUKM7P80H5ydOhPUFANbsSby2ahOrsTYEef4KRXnQJRyPY2zyzyn5Rqrer0Qbfgf3wAsUM0TT98AwN6
String with angle brackets
I'm trying to set a string variable to "<Test", however I get an empty string back. Tried "\<Test" and results in "\". Tried "<<Test" which results in "<". Any help with this would be greatly appreciated. Oliver
Sub form data not sending in mail
if i add sub form data in mail but first row of the sub form only send in mail remain row are not displayed sub form Code - deluge mode "<br />\n<br />\nGiven Name - " + Passport_Details.Given_Name + "<br />\nSurname - " + Passport_Details.Surname + "<br />\nPassport No. - " + Passport_Details.Passport_No + "<br />"As Rich text mode Given Name - <%=Passport_Details.Given_Name%> Surname - <%=Passport_Details.Surname%> Passport No. - <%=Passport_Details.Passport_No%>
Question about the customer portal feature: individual user based content?
Can the new customer portal in Zoho creator allow each user to see data unique to him after logging in? For example, can I make a custom quoting application where the user will only see his own quote? (also this needs to be done automatically - if a quote is created for a specific user, he and only he should be able to see it after logging in. Manual permission adjustment for each user would be way too much work) Also can it allow him to update his contact information (Zoho CRM integration)? Thanks.
Lookup and Forumla Fields Not Working!
Hi, When I use some(not all) of the lookup fields in the form: https://creator.zoho.com/crocked/embryo-web-app/#Form:Recoveries whether or not they call "On user input" the processing icon shows constantly. Similarly when update any Number field whether or not it's calling "On user input" is showing processing icons and not updating formula field. I have logged a support request and enabled edit access. Damien Cregan
Bulk insert via the RESTful API
Is there anyway (or what are the best alternatives) to inserting multiple records at once through the Creator API? I need to insert 300+ records at once and I'm currently posting for each individual record which takes 1 - 2 minutes.
Help on linking data from two forms
Hi again I am trying to create an application but I have a problem. I have a form named Documents The Fields in this form are DocumentDescription, DocumentType, DocumentStatus, DocumentClass I have also another form named companies The fields in this form are CompanyName, CompanyType, CompanyStatus, CompanyClass What I would like to do is the following: In another form or view, when I select a company I want to have a list of the matching documents That means when I select the Company XXXX ( with
Error in executing Send Mail task: TO address is NULL
Hi all I have coded 'input.emailaddress' under the TO address using the Send Mail task in Form - On Success. The Send Mail task works perfectly fine from Creator Zoho itself. I have embedded the form in a website, but it returns 'Error in executing Send Mail task: TO address in NULL' when I submit the form from the website. Please assist asap. This is an emergency. Thank you.
Error: We are unable to fetch this data, sorry!
I am trying to log into Zoho creator and I keep on getting this error. How can i get this resolved? Thanks
Default image size in Email
I want to send an email with images from a URL box, and I want to define a size, example 141 x 141 What is the code that allows me to have a specific size? I have tried normal html codes but not funcionana or get error: http://mx.tuhistory.com/files/escapebacteria.jpg" width="141" alt="" />
A way to identify browser a user is currently using?
Hello, Is there a way to identify what kind of browser a user is currently using to access an apps via a deluge script or built in variable? Appreciate your help. Cheers!
Changing Account Owner
I have created an application with Zoho Creator at the company that I currently work for. I will be leaving the company and need to assign the application to a new owner/admin. Can someone please point me in the right direction as I have been unable to find any information online to help me out.
Basics of Deluge
Hi, I'm getting into the basics of using Deluge. I know php and mysql and could build it from scratch but I like the Zoho Creator framework a lot and want to make it in this. First of all I want something very simple: I have a table (form) which is called Enrollment. Enrollment contains a field called EnrollmentStudentID, which is added to the form by dragging the Look up field in it and relating it to Students>StudentsID. In my Deluge scripting I have this code: enrolledIn = Enrollment[EnrollmentStudentID
Different logo in applications under the same Zoho Creator Account
Dear All, In the same Zoho Creator Account I created two different applications. I would like to ask you if there is any way to change the logo so each of these applications to have its own Logo. Now, both of these applications have the same logo. In other words, is it possible (under the same Zoho Creator Account) each application to have its own logo?
Expense Tracker?
Hi We have a team of 5 people working internationally. Everyone makes expenses using personal cash. Which we then reimburse. I would like if you can tell me how I can create an expense tracker? The features would be: A user enters his expense claim (date of expense, description, Amount claimed, upload of a receipt image/pdf file) After this an administrator will receive info this via email and then approve or reject it Your help is much appreciated Kind regards
Create page with linked info from multiple tables
Hi, I want to built this but I would like to know if it is possible in Zoho Creator: Let's say there are 3 tables: - Students (id, name, etc) - Courses (id, name, etc) - Enrollments (id, courseid, studentid, etc) On a detailed student page (coded by myself in my own layout i guess, not a report?) next to all the student details that are in the Students table itself I want to list the enrollments of this student. In sql i would just simply query 'select * from enrollments where studentid = x' and
Can be used java in ZOHO creator?
I wonder if you can use java script in ZOHO creator. Using java to create a pair of graphics and insert them into Zoho creator to use ZOHO variables.
Bug: filter look-up field when adding record
Hello, The filter on look-up field is not working as expected when a new record is added in the table used for the filter' criteria. Here is the scenario. I have a form "Users" that contains two look-up fields: "Company" and "Office". The User-Office and Office-Company relationships are one-to-many. On the "Users" form, I filter the "Office" field in such a way it displays only offices belonging to the company that have been selected. The issue arise when, starting from the "Users" form, I create
how to immediately send email with uploaded file from form?
hi! user fills form and upload file in form. after submission - form sends email. how to send in email uploaded via form file as attached file?
Drop down menu in zoho creator
I have an application created in zoho creator and the professional layout for the menus. To simplify the use and feel, is there a way to create drop downs menus? Example: Mouse over the Menu "Fruit" to select one of 3 submenus "bananas", "apples", oranges. Thank you Edith
Group Sorting Problem on Android
Hello, I'm having a problem that just popped up, everything had been working perfectly until now. All search functions seem to work fine when I go online but when I try to group sort the data on my phone it groups the data correctly but when I tap a row to bring up the details it takes me to a different record. My phone is a Moto X 2nd Gen but as mentioned I don't think it is a compatibility problem because it's been working great up until now. I have been able to sort the data even on multiple fields
LookUp Dynamic Filter
Good day for you, I have a Subform with 2 Lookups, I set a filter for the second Lookup based on the first lookup selection, I script that when the user add a row the first lookup take a value for the parent form, the problem is that in this scenario the second lookup filter doesn't work. This filter only works if the user select manually the value in the first lookup. Is there a way to set filters for this second lookup thru deluge? Best Regards,
passing parameter to HTML View in Search Field
Hi, I have a HTML View and I am using a OpenUrl task to reload the parent window after on Success action of another Popup window . What I am having trouble I would like to retain the search keyword in the search field which is applied before reloading the page. See below screenshot for your convenience ... Screenshot 01 : Here you can see there are Two search result before on Success action of another form. Screenshot 02 : After adding new entry of another form the above search result will contain
Problem with adding Number field
Hi, I cant add to the form i created (by Zoho creator) "number fields". The message i got is "adding..." and nothing really happen, its stuck without doing anything. Can you please check the issue ? Thanks, Cory R
action for printing
Hi, I am working on a simple app that manages warehouse. The user should input some data about a pallet and getting a printed label with these data on it. Printing will be done on a common local laser printer. I suppose I shoul use record summary to generate the label. I would like the printing process starts automatically after data insertion, any idea about this? Thank you
Verifying Lead ownership in Zoho Creator
Hi All, We are considering using Zoho Creator to update the Lead Module of Zoho CRM. At present, our secure users log into Wordpress using a username and password. I would like secure users to update cases they are working on - from within Wordpress - but need a means of verifying they are the user ascribed to an individual Lead record. The secure user will login into Wordpress and then enter: Unique case of Lead record number originally generated by the CRM. Surname of the client stored in the Lead
conditional pick list
Hi, I am using creator and in my application I want to offer three drop downs to select vehicles. So the first drop down may contain "Ford" as an option. I need the second one to contain a list of Ford models (such as Focus or Mondeo) The third one needs to have the door for the model picked before. Any help would be great here please. Thanks Dave
Problems Duplicating applications
Hi I have seen a few threads regarding this, but no solution. I am trying to duplicate applications in my Zoho Creator account. Zoho Creator indicates that an application is being duplicated, and when the process ends, no copy of the applicaion is found. Please assist. Tal
Manual restore of data to app
Is there an easy method to reload your app with the CSV files that are created in the backup process? It appears I have to re-map all the fields in all the files and wonder why the exported csv columns don't simply match the new db structure. Am I missing something? Thx!
forcing a UI refresh (Form and Field events) from a function triggered in a view
We've got Zapier integration nicely adding new records into our app. However, when the records are added, the UI functions are not evaluated, and as such some of the values we compute during a normal On Add event are not completed. We could always duplicate the calculations into a Function. Instead, is there a method to trigger the UI events against a collection of records using a Function triggered from a view? Thanks in advance
Email data - Authorization failed
Having issues emailing data into my form. The form is published, still get the error. Tried it using the admin zoho email, and other emails, none are working. How do I fix this?
Pdf that is emailed is different from Exported Pdf
Hi Experts - I need some help. If I manually export a view as a pdf by using the gear wheel button on the top right, the pdf looks really nice and it reflects the same formatting as the view. If I set up a daily email with the same view as pdf attached, the pdf looks horrible. The column widths are all different and it is very hard to read. Does anybody know how to set up an automatic email that send the same pdf that I exported manually? I struggle to understand why there are two different formats
No split function in string methods?
Hello, i would like to have a confirm that there is no split function in string methods in Deluge. I have written a custom function that use getUrl function to get data from an external service, the response can be very long (each value on a different row) and it would be really useful to have the capability to split the response string in an arryay for each single row.
Lookup fields that can lookup each other.
I have two lookup fields on FORM1 pulling information from FORM2. I would like it if these fields could lookup each other. Example1: If a customer service representative knows the customer number and selects the number from the Customer_Number field on FORM1 then On User Input would pre populate with the information from FORM2 into the Customer_Name field on FORM1. Example2: If a customer service representative knows the customer name and selects the name from the Customer_Name field on FORM1 then
Emailing a record from within Zoho CRM
Hello, So I have created my app in Zoho Creator and connected it to Zoho CRM. I was wondering if there is the ability to email a record to a contact from within Zoho CRM. Thanks!
DB Structure / Multiple Lookups Question
Hey there, I'm trying to build an order management system and I'm a little new at this. Here's what I'm trying to figure out: Each item we can order comes in multiple sizes Each size for a given item has its own pricing Pricing is based on the quantity in an order, with different combinations of item + size having different quantity breaks As an example, say we could order Flour in a 20lb bag or a 50lb bag. The 20lb bags are $10 each if you order 1, $9 each if you order 3, $8 each if you order
String
I need to accept a string of 8 characters and in the On User Input field action I want to add code to simply put a dash between the 4th and 5th characters. In other words, if the string is entered or imported as ABCDEFGH then I want to convert the string in field to ABCD-EFGH. Here's the code I added to the On User Input field action for a field named Course. s1 = input.Course.subString(0,3); s2 = input.Course.subString(4,7); input.Course = s1 + "-" + s2; This code does not work at all. The code
zoho creater / zoho projects
is it possible to integrate a zoho creator form into zoho projects? thanks best regards eike
Next Page