Application/Theme Color Customization
I would really like to see the ability to customize the colors used in the application themes again. I'm not sure why this feature was removed, but I'd like to see it added back if possible.
Delug Script doesn´t run on bulk edit
Hi, I have developed a script to run after update a specific field, nevertheless, when I update the field in a bulk edit, the script doesn´t run. I am going to disable the bulk edit option, but I was expecting that the script run also in bulk edit. Kind regards, Mari.
Help Regarding fetching value from url to form which are embed into HTML Page.
Hello Team I need some help. I need to get value from url to Form which is embed in HTML Page. I have a form which is embed into HTML page. Please tell me how can I get value from Url to Form which are embed into HTML Page.
Is there a problem right not with CRM Update Record API from Creator?
Is there a problem right not with CRM API from Creator? This morning all of a sudden we cannot execute zoho.crm.updateRecord function. We are getting the following error: Error in executing Set Variable task. Unable to update template variable crm_quote_url. Error evaluating MAP expression We are getting this in our form Email_Quote. Please let me know if something has stopped working on zoho end or if our application just magically broke on its own. Thanks, Matt
Customer Portal Login
Hi, Is there a way to log in to the customer portal with cosign? I've read through https://www.zoho.com/creator/help/application/customer-portal.html and https://www.zoho.com/support/help/customer-portal.html and it doesn't mention anything about cosign. Is it at all possible to log in with cosign? Thanks!
Creating an approval based application, stuck
I want to create a simple application, which'll do following-: 1. Users will submit their expenses for reimbursement. 2. Manager will approve or reject or request more information 3. If expenses are rejected OR manager needs more information, then comments should be added 4. Submitter will be notified of each status update -- I created a user hidden dropdown field called status which has values of Pending (default), approved and reject. -- I created a comment box field and made it hidden in form
ACCOUNT DELETION
Every single time I try to access my subscription to change plans, I'm directed to my creator dashboard. I'm getting pissed off. How the hell can I downgrade my subscription if I can't even get to the right page.
Not Able to find 'size' function
Am I overlooking something obvious? or is this a bug? 'Total_Questions' is a Numeric Field. I get the same error when I try input.Questions.size() < 1 or input.Total_Questions == input.Questions.size()
Printing Certification Cards
I need to print onto pre-made CPR and First Aid cards. I have developed a roster using Creator, but I cannot figure out how to print only the needed information onto the cards and adjust it so that the Name, Dates and Instructor prints at the proper location. As it shows in the attachment, it will be a sheet of 5 individual cards. Can anyone help? Thanks.
Improper Statement
I have a very simple code on the decision box On User Input as: if(input.Decision_box == true); { openUrl("http://mydomain.com/newsite777","New window"); } I keep getting the improper statement error on line 2 which is the curly open bracket { Please advise
Auto populate a lookup in a subform from a lookup in the parent form
Hello, I have searched through the forums and have found similar threads but not quite the same scenario as mine. I have 3 forms, ACCOUNTS (includes all contact information including "Company_Name") ASSETS (Includes computer hardware information including a lookup from the Accounts form for "Company_Name") FILES (includes a file upload field and a lookup for "Company_Name.") The common field between all three forms is "Company_Name." ASSETS includes a subform field using the FILES form. My Goal:
Cant fetch record from lookup field
Hi, Followed the tutorial for fetching a record. https://www.zoho.com/creator/help/script/fetch-records.html Went with option 3 as this is exactly what I am trying to do. I have 2 forms Form 1 is called "Anst_llda" Form 2 is called "Uppdrag" I have a lookup at Form 2 pointing to Form 1. This lookup is called "Anst_lld" I want the Email field from Form 1 to be copied to a field in Form 2 called "UserID" Here is the code that I added on the lookup field. Even tried adding it to "On Edit" and "On Success"
PDF Engine not working today?
Hi, Suddenly I cannot export anything as pdf or attach anything as pdf from Zoho Creator. It used to work totally fine. Now a browser tab open with https://creatorexport.zoho.com/downloadExportData.do? as usual but hangs and nothing gets downloaded. I first noticed it when sendmail stopped working with pdf attachments today. I removed the attachment and it works fine. I then just tried simple export of reports as pdf and that fails too. Exporting as a spreadsheet works fine. Have tried different
UTF-8 support when sending mail to Zoho creator?
Hi, When sending Germanic characters (such as Ä and Ö) the emails bounce back as it cant recognise those characters... Doesnt Zoho support UTF8? I get an email back with the following. The Following error has occured while adding this record: Failure, Invalid column value "G�teborg" specified TicketNR : 234234234234 Uppdragsstatus : Company : 234234234 Avdelning : G�teborg
Improper Statement
I have a very simple code on the decision box On User Input as: if(input.Decision_box == true); { openUrl("http://mydomain.com/newsite777","New window"); } I keep getting the improper statement error on line 2 which is the curly open bracket { Please advise
Can't modify an application
All of a sudden when I try to modify any of my database applications, I get the immediate error message "500 Something went wrong - contact support" This happens on several, if not all of my databeses and I am unable to make any changes whatsoever. I can still add, remove, etc. data, just cannot change the format. 04/19/2015
Help regarding deleting records from subform
Hello I need some help. I have created a main form named "Shipping" and two sub forms "Shipping and Billing" and "product Info". I have created a relationship between these forms by assigning a ID at the form load in main form and assign the same id to sub form as well. When I add the record in product info sub form it works fine and on delete it is also work fine and on success it show a page with these information correctly. But when I edit the same record and add or delete product from there
Sorting lookup fields
I would like to present the options in a Lookup field in a particular order. I know I can set the field to be sorted alphabetically but none of the fields in the table relate to the sorting order. Ideally, I would like to add a field to the table in which I can set the sort order for lookup fields to that table. But I don't want to display this 'sorting' field. Anyone: Do you know how to achieve this with what we have now? ZC Support: If not possible now then please add this feature.
configure a Single Line Text
Hello I have to write text in Italic in Single Line textbox. Is it possible in zoho creator to write text in Italic?
How can i give permission to edit and delete to that user of customer portal
In zoho customer portal ,why user of that portal is not able to edit and delete anything ? I have customer portal and in that customer portal i have created users.and i am giving permissions to that user.I am giving permission of edit and delete to that user but still that user is not able to edit and delete anything in application. How can i give permission to edit and delete to that user?
How many columns i can add in database view ?
In zoho how many columns i can add in database view? I have 60 to 100 columns so is that possible to add this much columns in only one database view?
Users field update
Hi I have one form that has a filed Users.I have created one custom action that has a add record task for adding these Users field.When I ran these custom action it added only login user name.But i have other names that have also permission.But it add only login user name.Is their any solution for it to add different users?. Thanks. Siva
Create a report from data derived from another report.
Can a report be created using fields derived from another created report (ie not a form report, but a seperately created report? If so, what are the steps?
Zoho Creator Mobile Breaks images if more than one on Form
I was excited to see the Zoho Creator Mobile app get updated today. I was hoping this bug would get fixed but I quickly learned it did not. Process to replicate: 1) Create a form with two images on it. Call them image1, image2. 2) Fire up the mobile app. Take a picture and upload it in the app as image1. 3) Go to desktop and mobile app and image looks great. 4) No go to mobile app and take a picture as image2. On the mobile app it looks great. 5( Fire up desktop app and now image1 is corrupted.
Error occured while executing on load script
Multiple apps in my account are experiencing an issue. Some (not all) records give this error when editing a record There are no other issues in the logs and the code works for most other records. It's like the record got corrupt on zoho's side. Support chat verified the error yesterday. I have also submitted a support email. I'm documenting this in the forum for other's benefit. Cheers, John Whitney
Unable to add new records - have an infinitely spinning icon
Good Morning I am unable to add new records. Below is a screen shot with data blurred for privacy. The date has a infinitely spinning icon as well as a lookup field. The next field is a filtered lookup that remains unpopulated. I am experiencing this on multiple applications that worked fine last week. Please advise. Thanks for you assitance.
E-mail body HTML to attachment file
Is it available to creat PDF/HTML/DOC attachment from HTML email text in body. For example i have email message like: message:(((((((((((((((((((((((((((((((((((((((((((((((((((((("<p style=\"margin: 0px; font-size: 14px; font-family: 'Courier New';\"><span style=\"letter-spacing: 0px;\"><b>text + patient_var.age_patient .... etc Thanks !
Converting Text to Number in Report?
In my form I'm creating a dropdown (single-select) field to enter a student's race/ethnicity (API, AAB, etc.). However, when I try to generate a pivot chart from the data, it shows the race/ethnicity field as being a number field, with data points ranging from 1000 to 1400. I have no idea where these numbers are coming from and how they are coming from the text choice options in the field settings. I've tried recreating the same field many times, but it always only shows the field as a number
Dashboard Sum Value too many decimals
Hi When displaying a total sum value in the dashboard (Zoho Creator) taken from a project value box in my form it is showing the total with 5-7 decimals, however it should just display 2 decimals. I have selected max decimal 2 in the form set up. Could you advise on how to rectify this issue? Thanks
SUBMIT THRU EMAIL STOPPED WORKING
Since 11:04 this morning the submit data from email feature stopped working PLEASE FIX THIS ASAP
Add event to Outlook calendar
I have a Vacation Request form. Once the vacation request is is approved, is there any way to add a link in the email notification so that the person emailed can add the event to their Outlook calendar? Thanks in advance for your help! Joy
custom function against selected records
Does anyone have a code snipet I can use to run a custom function against a selected record/s in a report? I want to be able to open a report with multiple records. select one or more of those records with the check box, and then run a custom function against just those.
'row' is a invalid collection and update is not possible
Hello I have a form and two sub form. I have created a custom link in crm and sending data to the creator. On creator I have written a custom function which get the id from URL and pass it to the custom function as argument. Custom function return an value which i need to fill into sub form. When I write the code to fill value into sub form it gives an error "'row' is a invalid collection and update is not possible ". Please tell me how can i fill the sub form field on the on load of a form. This
Xpath predicates don't work
I've reached a show stopper as my application requires access to external data to function, using JSON to XML and/or XML direct input into the ExecuteXpath function. I have been doing some testing with multiple XML files, including using the example XML in the users guide (see below). The problem is when trying to filter using predicates, ExecuteXpath does not work at all. Using the example XML (very simple), I set up the xpath within XPath Builder as: /bookstore/book/year/text()[1] Which should
trying to fetch data from parent-form into subform-form AND creating a report of ALL subform-records of ALL parent-records
Hi please have a look at the attached pdf Thanks Kind Regards Paul
Home Page Loading Problem
When I start my app, the home page appears to try to load many many times before finally settling down. In my office I am running IE8 on Windows 7. On my laptop with Windows XP and IE7 this does not occur.
Time Field
This follows on post http://help.zoho.com/portal/en/community?ftid=2266000000242703 Until we get a time-only field that compliments the date-only field, I'm requesting a workaround via deluge script. I have my own workaround that uses and hour box, minute box and AM/PM selector. These three boxes (actually 6 due to start and end time for my application) add unnecessary length to my form. I'd like a single text box with deluge script to validate the format. For example, 2:15 am Any takers?
Page Embed Report Params
I can not locate any documentation on how to make use of parameters when embedding a report into a page. htmlpage Test() <%{ teamID = members[Added_User == zoho.loginuser].team;%> <div elName='zc-component' viewLinkName='Teams_Report' params='zc_Header=true&team=<%=teamID%>'>Loading ...</div> <%}%> The report is based off "events". I am attempting to limit the report to row pertaining to the user's team. The team ID is returned correctly. The target is events.team.ID.
EMAIL csv or xls FILE to IMPORT DATA INTO A FORM
Hi, Is there a way for the user to email a file (excel or csv) with matched column headers to import data into a form? Basically, I run a report from my database in csv format and then import it manually into the system, it would be really helpful if there is way to email this file to the form's email id in order to import the data into the form. Thanks! V
How can I configure this Embed Report, in order to show only the records that match with an certain criteria.?
I have created a PAGE with a Embed Report in this html page. How can I configure this Embed Report, in order to show only the records that match with an certain criteria.? I already tried with "Search String", but it doesnt work. ie. Search String: email_id=<%=current_Email%> thanks in advance
Next Page