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
Cant duplicate my application?
When i want to duplicate my application, it says Duplicate for 2-3 minutes and then nothing happends. Whats the problem?
Show/Hide Fields Based on Checkbox Selection
So I've created a form with a Checkbox containing 3 options. I would like different fields to be hidden/shown based on what selection the user made. Thus, I created a deluge script similar to the one described here: https://help.zoho.com/portal/en/community/topic/hide-or-show-multiple-fields. While this method has worked in many ways, I've encountered some problems. First, when a user tries to select more than one option from the checkbox, none of the hidden fields that should be revealed are shown.
Changes to column widths in custom list view are not displaying.
I am new to using zoho creator. I created a simple form and report. I have been unable to customize column width in the list report I created. I changed column properties from auto width to specific px. I tried values that would be very obvious to see if are being used. I removed a column and that changed the view. But no changes to px values changes the view. https://creator.zoho.com/jackalves/service-providers#View:Entry_Report
zoho view starting from first page when clicking back button
Hi, I have a published view containing products. Every record contains a link to a detailed summary view of the product. My problem is that if one clicks on the link to open the detail of the product and then clicks on the back button of the browser the listing of products allways go back to the first page, which is annoying if one is already several pages ahead. is there a way to go back to the page number one was before clicking on the detailed view? here a link to see what I mean. thanks for
Duplicate Shared App
Is there a way to duplicate and app that another user is sharing with you into your own account? Thanks!
convert String to LongList
Hi how to convert from String to LongList?. Thanks.
geoposition on zoho creator mobile
Ok, perhaps I'm going to far with requests.... ...but today, reading something about gps and my position future offered by google mobile maps, I fought it would be something really amazing to have also in zoho creator mobile. I've no idea how this should work, but would be very useful for many different applications to have an hidden and automatic field, similar to "added user", providing the position of the user when he/she add a record in a form. Exactly as in google maps, this should work with
Upgrade Standard to Professional account
Hello! When I upgrade to a Professional account before my account expires Standard.It will be charged the difference between the two accounts, or again would be charged total to pay? I have a week with my account Standar this month.
Safari compatibility
Hi, Is Safari 100% compatibile with Zoho? Tks Pippo
IgetPrefix not working
Hi I have sr1 = "CIVEL - NITEROI(RJ)"; sr1=sr1.getPrefix(")"); Sr1 returns an error - any reason why? Raul
Database relationships
Is there a way to show the database relationships as they exsist within a zoho creator set of applications, from lookups?
Contact info extractor for Outlook
Currently there is a contact info extractor that works with google chrome. Can you PLEASE make this work for outlook as well. It would be so helpful. Right now when I add a lead/contact from an outlook email, I still have to manually type in all the other information except the email address. I would prefer to have this work for both Outlook for Mac and PC as I use both but will settle for just PC.
Restrict editing capability on one column only
Is there a way to have one column visible but have it restricted from editing while leaving the rest editable?
How to remove comma from string.
Hi I have a string "Hello test, How are you"!. I need to break that string into "Hello test" and "How are you" and assign these value to input box. There is no split function. Please tell me how can i break this string?
page of customer details
i have no idea how to make customer details page for each customer with reports associated with the client like this: https://creator.zoho.com/demo/stompalot/garage-managment/zsdemo3/#View:View_Customer_Details?CustID=4082000002338235 Customer view report : https://creator.zoho.com/demo/stompalot/garage-managment/zsdemo3/#View:View_Customers When i choose customer and click "Go to customer" i go to page of customer detail. Could you help me with that which functions are involved here or may be free
Customer Portal: How to Hide the Navigational Menu
How can I hide the menu (on the left with sections etc.) for the customer portal? I have html pages that are being shown to the customer, that's it. I dont want them to see the actual page names listed to the left. Can I hide this? Thanks!
Next Page