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
Mobile form prompting users to "open in mobile app." I need this turned off ASAP
Hello I use zoho creator to add form functionality to an existing mobile app. I embed the form permalink into my app. At the top of the form is prompts the user to "open in mobile app." I know this an advertisement for the Zoho mobile app but this is not acceptable for the way I'm using it. It it confusing my clients who are already using an app I have provided them
Zoho Creator - onEdit previous values
Hello, can I somehow access previous values of fields in form in action "On Edit" - in "Validate" and "On Success"? The form creates record that can be moved in Calendar View - "On Load" is not invoked when moving block in Calendar. It's only invoked when I explicitly click paticular record and choose "Edit".
Why approvals are difficult in zoho creator?
Approvals and rejections are very prominent part of business processes, i have been using kissflow to map them easily, but want to switch to creator as it enhances possibilities such as integration with zoho crm which i use. But its strange to see i have to script (which i don't know btw) for these common approval/rejections stuff, i know you might say your dedulge scripting is easy, but to have it at all for these common actions, why don't introduce something like kissflow and help people like me
Mobile application - photo in report
Hi, I am doing some test with the mobile application builder. I have a form to input a text and do photo. Only this two fields. The application works and I can do photo and up load records. My problem is that I cannot view photo in the Report. .. Thanks Pippo
button suggestions or information?
I would like to add a button as shown in the photographs. A button or icon for suggestion to explain or put a little note in the boxes. It would be possible?
updating one column data into another column in same form
Hi, In my form one field is string type and another field is lookup that means longList.So i want to update all data from String field to long-list based on validations.I have created one custom action for that but i am getting some errors.I think it is problem of type,i am updating string to Long-list.Is there any solution for it. Thanks.
Update a Record in Zoho CRM via Creator
I got stuck in update a CRM record via Zoho creator. I have a form having the following fields. I also created a custom field in Zoho CRM named “Margin”, same as I created in Creator. Now, I want to update the “Margin” (Custom field) in Zoho CRM while we create/update a record in Zoho Creator. I already went through the help file of creator regarding “Update records in Zoho CRM” (https://www.zoho.com/creator/help/script/update-records-in-zoho-crm.html) But, I could not able to get/generate the
Imagine the power of Zoho Creator integration with App Inventor for Android
Hi Zoholics, Does anyone know if the Zoho API is App Inventor friendly. Regardless, some kind of integration between Zoho Creator and App Inventor would be an excellent thing. Don't you agree?
Subform: if - then
Hey guys, I hope the following topic hasn't been covered elsewhere... I looked for a while without success. I have a quick question concerning increasing the efficiency of the use of subforms within one of my apps in a management capacity. As an example, I have a form with a subform that tracks work order issues. Each row added represents a work order issue that must be accompanied with corrective action to demonstrate that the problem has been resolved. The overall status of the work order is governed
Next Page