RegEx for Numbers
This script should report "good" but is failing. I need a function that tests if a string starts with a number. string test() { street = "12 yadda"; if (!(street.matches("^\d+"))) { yo = "bad"; } else { yo = "good"; } return yo; } Ref: http://stackoverflow.com/questions/6372318/c-sharp-string-starts-with-a-number-regex Cheers, John Whitney
subforms
We are determining whether to use zoho. One of the features we are looking at is the subform creation. When trying out the subforms in the free version it says our current plan only allows a demo of the subform. Could you please tell me which of the zoho plans include the subform capabilities? I don't want to make a mistake when upgrading. Thank you.
Script stops working, can't make changes
Hi, I have set up a lightweight learning management system for an educational initiative. In the attendance form, there is script in the On User Input block of one of the fields, that automatically populates several other fields with data when called. This has been working fine for several months, but this morning the script seems to suddenly have stopped working and fields are no longer automatically populated. I can't think of anything that could have triggered this as I haven't made any changes
data-clear-btn= true not working
Hi Can someone please help as to why the clear button is not showing up for this input text ? <input class="text-box single-line ui-input-text ui-body-c ui-corner-all ui-mini" id="searchInfo" name="searchInfo" type="text" value="" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" data-min="true" data-clear-btn="true"> Many Thanks festiva_96
scripts for multiple select has stopped working
As i have seen reported. all of my scripts that need to fetch date and populate a multiselect field DO NOT WORK and have caused some forms to go INVISIBLE. of course ZERO response from zoho. PLEASE ZOHO HELP. PLEASE
image in RTF
Is it possible to paste an image in a Rich Text Field? Herb Wexler
Many to Many Relationships
Hi there, I am trying to create a database with a many-to-many relationship. Specifically, I am creating a database for a children's project, where each child is being mentored by a person. At the same time, each mentor has a number of children under their wings. The idea of a many-to-many relationship is that there are 3 tables: 1. Mentor Name 2. Child Name 3. Mentor/Child Link Table I have created tables 1 and 2. How do I go about implementing the 3rd table? And also: how do I then create a view
Secondary header on Mobile
Hi, I found a good tip in the forums saying that in order to be able to view more than 5 entries in the view on mobile - I should Embed the view in an HTML view. It worked great but the problem is that the secondary header is not big enough so that my Pagination buttons are hidden. (I added a picture) Any way to solve this? Increasing the height of the secondary header? Thanks, Guy
Parse data uploaded from File Upload field
Say I put a file upload field in my form where my users upload an excel file. How do I parse the file data? I would like the data to be uploaded on Zoho Reports but I can't directly upload the file because I have to process the data first like separating a text, replacing a specific text inside the excel file, format the texts inside excel and so on, before uploading it to Zoho Reports. Just in case you were wondering why can't we just format the excel file before uploading, we want it automated
Change Import Data lookup from radio to dropdown
I have a field that is an Import data lookup. The customer originally had radio button and now wants to change it to a dropdown box. The field is used in scripts and I don't want to delete it and re-add it. Is there an easy way to change the Display Type? I do not want to change the Field Type.
XPath Builder not working on XML data
I'm having difficulty getting XPath Builder to properly parse XML data from a URL or from a file. I've attached the XML file I'm trying to get to work. XPath Builder shows the data correctly under the data view, but when I try to parse it, it returns nothing. This is an XML file returned from a Zillow API call. Can you let me know how to get this to work? Thanks, Andy
Can't delete functions
I am trying to delete the following forms from https://creator.zoho.com/essistmgmt/assets/edit/function/# udf_telco_service_order.temp_mandatory_inherit_from_parent_order udf_telco_service_order.temp_optional_inherit_from_parent I get the following error "Error:undefined" I was able to delete other functions except those 2. Can you please remove?
Exporting forms and subforms onto one .pdf
Hey guys, I've just created my first form, so I'm still fairly new at this... I have three subforms as part of my main form. Is it possible to export the results from the subforms and the results from the main form onto one .pdf page? Thanks.
Need simple sub form.
I have a form that tracks landscaping issues. I want to add a button to each line in the view that opens another view of "comments" that people have made about the issue. I want the second (sub?) view to have the add/edit capabilities and when a person clicks add, the issue text from the first view is there. Thanks in advance for any help.
Updating code error
I want to remove this code from the form located at https://creator.zoho.com/essistmgmt/form/1696/scriptbuilder/ field action on the SITE_VISIT_SCHEDULED_NTU_CPE_INSTALL_COMPLETED_DATETIME field if (input.SITE_VISIT_SCHEDULED_NTU_CPE_INSTALL_COMPLETED_DATETIME != null) { input.DETAILED_STATUS_PHASED_OUT = "7"; } But I am getting the following error message Error Occurred. We are sorry for the inconvenience. Please try after some time or refresh the page and try again. The application is available
Auditing
I have a form with 50+ fields and there is a requirement for auditing field changes. How can I easily track which fields are updated?
Records Not Removed From View on Deletion
Hello, I am trying to delete records from my database. Every time I delete a record I am getting the message "record deleted successfully," however the record is not removed from the view. Any idea why this is happening? Thank you,
crossdomain problem
Hi, im tryng to use the .csv exported file of my aplication from another server, but i can't get access due the "cross domain access policy". Then i need a file named "crossdomain.xml" in the same place that is the .cvs file, with this code: <?xml version=”1.0?> <!DOCTYPE cross-domain-policy SYSTEM “http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd”> <cross-domain-policy> <allow-access-from domain=”*”/> </cross-domain-policy> Or maybe you have another solution. Can you help me please?
How to display a picture in Html from image field?
How to display a picture in Html from image field? Please see the app: https://creator.zoho.com/wei.wang_zh/display-pic/#View:display_pic1 This app already allowed edit access.
Workplace and personal apps
Hello, is it possible to make a personal app into a workplace app, or is it a matter of having to start from scratch in workspace? Thanks.
Calendar drag and drop - deletes data
I've found (after several user complaints) that when an event date is changed via drag and drop on a calendar view that data contained in two separate check box fields is being cleared. Can this please be looked into urgently!
Change in Lookup Checkbox Functionality
Greetings: I have submitted this via email to support as well, but thought I would see if anyone on the forum has some insight as well. I now have a new issue with lookup checkboxes. Just a few weeks ago I was able to filter a lookup checkbox based on an input field in the same form (also a lookup, but a dropdown). Now when I apply the filter the list of checkbox values doesn't show up (note: you can filter for addeduser but not based upon the other dropdown lookup field.) Also, before I could
Script button labels
Is it possible to edit the script in a form up change the labels on the button? If so, how can you change the button label dynamically?
Stateless form problems
My application: I have a form where data is stored, including several radio fields with yes/no/others options. There is an employee name and a date field. I then have a stateless form that fetches data and populates the stateless form based on the contents of the primary form. This is where the 2 issues come in: 1) It populates the yes/no, but will not populate the others option - it doesn't select radio the circle or put the right data in. 2) If the fetch returns no data (which is to be expected,
User management - deactivate
There appears to be a bug I am trying to select multiple users to deactivate their account. When I try this, I see the waiting logo but nothing happens. When I try to deactivate 1 user at a time, it works. Can you please fix?
Print a dashboard
I have a dashboard, based on HTML view, that contains a pivot table and two pivot charts. I am able to print each table/chart independently, but I would like to print to a pdf the entire dashboard. How can I set it up to do so? Thanks, Antoine
Datetime keyboard on a mobile
Hi, I am creating an app for scheduling orders, ideally on a mobile device. I have got a "work completed" input which uses the date-time field. However, I have noticed that this is actually classed as a HTML text input field, which means it doesn't bring up the datetime keyboard on an iPhone or Android device etc. Is there anyway to change this as it is very hard to use the JavaScript calendar on a mobile? I have attached a picture of the keyboard I would to use (the one on the left). Also, Ideally
Want To Develop Online Teaching/Exam Interface For My Business
Hello fellow Zoho gurus. My 30 plus years of experience is in business and sales, and I'm seeking someone who wants to throw in a little sweat equity with me and create an online training/exam program that can easily embed into either wordpress or another popular application, and still tie into Zoho's great platforms. Must be able to do both audio and video interface with other commonly related features one would expect to find in an online training seminar. There is a very lucrative opportunity
Usage Limit
Hello Zoho! Is the usage limit https://www.zoho.com/creator/help/script/usage-limits.html applicable to all plans? We are going to use Creator-CRM integration but this usage limit makes me doubt. We are going to submit massive amount of forms per day so i think this could be some kind of limitation on our part. Please help me and explain these things. Also, what plan do i need to purchase to achieve the max usage anyway?
How to show only Facebook Federated Login
Hi, i would like tobe able to show only the Facebook federated login, on the login to my application. Is this possible? (ie, i can see that Turning Federated logins on in Zoho, will display, Google apps, facebook, yahoo etc). i would like to limit this only to Facebook.) Secondly, once the user has logged in via facebook, where can I get the user information like Name, Email, Phone etc, given by the Facebook api ?
Help with reports
I want help cleaning up a report I generate nightly. In order to keep it simple I will give a made up example and then apply any direction I get to the actual problem. Example: I have a form that tracks how many pounds of apples and how many pounds of oranges I buy for the day at my 3 different locations. The fields for the apples and oranges are decimal fields and the field for location is a drop down box. I then create a report and I put the locations in the column box and i place the fields for
Custom HTML view Customer Based
I am building an app and i have difficulty to create a custom html view for my forms. I am having a customer form that you can enter a customer and 5 categories ( different forms ) that you can input some data and use a customer from the customer form. (using lookup field ) I want to create a Page that its going to contain all the results that is stored under a customer name. Customer Dimitris Car contract 1 2 3 Fire Contract 1 2 Life Contract 1 2 ... etc.
Error when importing Access databases "External component has thrown an exception"
Hi, I am trying to import an Access database to zoho creator. I downloaded the migration tool, opened it, and tried to import my database, but after selecting the file on my computer I get an error message "External component has thrown an exception" Anyone know what this means? Thanks
Uploading using the migration tool does not work when the Address field is unique
I have a spreadsheet that I would like to upload to Zoho Creator to update records when the address field matches. I tried using the migration tool many times, but continue to get errors. For some reason, the decision box fields are not updating This problem was first reported to Zoho Creator support over a month ago, on May 8th. The support team has promised a quick solution many times, but has not provided one and does not have a timeline for when this problem will be solved. Please advise! Thank
Hello? Submitted emergency request to support over a week ago, via email and phone where is the update?
My application wont duplicate, this is essential for us. What is the problem? What is the solution. Can you make anything work for us. WE ARE PAID CUSTOMER!
PDF export font problem
Greetings all, When i export to PDF Greek letters are not showing at all at PDF file. When i export to all other types ( speadsheet or html for example ) it's exporting normally. I guess it's a font problem with unicode characters. Any help appreciated. Dimitris
Zoho creator sharing app bug?
This is my view, I'm the developer This is a user, I've shared apps with, this is what they see ... Their view doesn't match anything of mine. I only intend to share 1 app, the rest are broken links. The user also has 2 references to the same database I've made everything related accessible to support.
Column width in reports
I'm tring to run reports that export to a pdf document but for some reason i can not get the column width to change. One of my columns is a text field where as the rest are only small pieces of text so i want the text box to take up the majority of the page. I have read that pivot tables are the way forward but that doesnt seem to work when it comes to report generation and whem i use the specific area defined for column width it never actually has an effect on the report, then when i go back to
Export Creator app to proposal format
So I am a marketing and project support guy that handles our "IT", just so you know who you're dealing with. Obviously, we are a small (but growing) business. I have not spent much time with Creator. So today I had the grand idea to take our project proposal (about 4 pages in excel workbook) and try to turn it into a Creator app. It's gonna take me a while but we'll see where it get's use. In doing this today I wondered...... If successful, how do we than "present" our projects. It seems as
Help please
Hi - sorry do not know the terminology in zoho... but I have an Zoho app for my business - reminders are important to my business, but two different programmers working on this have failed to come up with a solution. They both say design is the issue. So instead of trying to fix what has been created - I am looking at a new fix , how I used to solve this problem in Access. Essentially if I invoiced an item eg: ProductID =234 ( Annual vaccination) then I would post this record as a date to
Next Page