Beware of Editing the Form Definition!
The form definition is found under a form's workflow. There are two options to view and edit it: without action, and with action. With action shows all the submit code and on-user action code. Without action just shows the underlying form fields. I just discovered that if you edit a form definition's "without action" part and save, ALL the SUBMIT/DELETE code is deleted. There is no warning about this effect nor an option to revert to a saved version. Unfortunately, this has set me back a few hours
Custom Action Configuration
I have been configuring my Custom Actions so that they appear in the Show Action in Edit Drop-down Menu I decided to try the Custom Action so that they appear in the Show Action in Report Header (execute for each record) The menu of Custom Action now appears, but the action is not ... activated. Any ideas on what to look at to figure out why?
Summary View via iphone
Is it my imagination, or does the summary view not work with an iphone?
Grouping application names by folder
How about making it possible to group applications into folders when they are viewed in your sign-in windows in the iphone app as personal apps, shared apps, workspace apps. If you have created a lot of apps, you have to scroll to see the rest of the apps. The apps are arranged in the order in which you created them. That means that a new variation of a certain app will be placed far from the app it is directly related to, because the original app was created earlier. For those developers who create
Add comma to record summary in report
Hello. I have created a record summary invoice template in a report. I would like to add a comma in the currency field. Currently shows $1200.00 would like to show $1,200.00. Thanks
Problem with edit button in a Report
Dear All, I have an HTML Page and I embedded a form and a report inside of it. As you can see when I am trying to delete a record the 'window' with the Delete, Duplicate, Print options is working like this. So, it is not possible to click the Duplicate button because when I move the mouse the window is lost. I tried it in Chrome and IE but I had the same problem. Any ideas?
checkbox tally
How do I tally the number of checked boxes in a multi-checkbox field?
Make Sign Out show the user's email address, not the zoho user name.
Signing in using a zoho account username has been deprecated (although you can still do it). Most people sign in using an email now. People are confused about their username showing up in the sign out link. I get requests all the time to change it to their email address or change their username to something different. The request is to make the sign out link the user's email, not username. Cheers, John Whitney
Scanning QR codes or Bar Codes to input data into form
Can you load a form, then scan a QR code so it then inputs the data into a field? Please help, if this is possible it would be of massive benefit to our company.
Customizing published report and form to mobile friendly.
Hi. As stated above, is there any where to make published report and form (especially report with long field column) to be mobile friendly. This is because the publish thing is not for us to use and we are aware that most of our customers are using mobile phone to browse alot. Thanks
Allowing users to import data through the report view.
Is there a way to enable the import option to appear for a public report view so users can upload a CSV / Excel of data?
help on for each
Hello everyone, I need to detect the inserted records a day by a single name. So I have: Form1 : name Form2 : name lookup + another field so , for each rec in Form1 And here ... I should tell him to count me the number of records for a single day but I do not know how many are the days .... Ideas ?
No access in China again
The access in China to the Zoho.com suites has always been intermittent since several years ago. Recently it has been more frequent. Some days in China we can visit zoho.com OK. Some days the creator.zoho.com suite does not load at all. Maybe it's high time you guys put some image servers in China????
Creator API - Update a record value
Trying to use the API to update a record in a view with a POST : https://creator.zoho.com/api/xml/student-record/view/myob_invoice_line/?scope=creatorapi&authtoken=xxxxxx&criteria=(ID == "1612333000000917031")&newvalues=field name = Job_Code value=1234 What is wrong with this request syntax? This request returns a zoho creator webpage.
Warning! All your profiles are inactive.
Just upgraded from free to standard and now my users cannot access the app. It is shared and they are Admins. My project has come to a standstill. I see this error dialog "Warning! All your profiles are inactive." and the users see "You are not allowed to access this application. Please click here to login as a different user." when they try to login.
Filter Embedded reports in HTML page
I have a page that has 3 reports embedded in it. When i put something like #Page:Display_job?Job_Number=8 in the URL the 3 reports continue to show all records. How can i make the embedded reports show just the Job_Number records and not show all records? If I put /#Page:Display_job?Job_Number=8 in the URL for each of the individual reports it works fine but not when they are embedded in an HTML page. Thanks
Subform View in Mobile App
The list view for all subform items in the mobile app shows just the item ID (which is a long ID number). Is there a way to display another field instead of the ID?
Add new lines to a Note<field>
I have an app that is a parts order form. I'm using a stateless form to input information. As the user selects and adds a part to their order I would like to have the items ordered appear in a note field. The action of ordering a part happens when the user "clicks" on the [Form Action] Add [on click] I've tried the below code, but nothing appears in the note field. for each r in Temp_Parts_Order [Tech_ID == User.Employee_ID] { input.Pending_Order = input.Pending_Order + r.Description + " " +
Zoho Creator - HTML view used as a form with javascript
Hello, I'm wondering if it's possible to create a HTML page View that would be used as a form with javascript? I would write in that page: <script> function myFunction() { //send request to external website (or ZohoCRM) and receive response data //if ok then: alert("Your request was successfuly processed!"); } </script> <form ...> <input type="button" onclick="myFunction()" value="Submit" /> </form>
Time and date format
Is it possible to change the time & date format to 24 hours instead of am/pm ?
Time Lapsed since Last Record meeting criteria - script Question
I figured out the problem and found a solution: The sort by Added_Time desc; actually calls the record you are creating, so if you really want the last record before that you need to insert the criteria ID<input.ID (as shown in the corrected code below). test = input.Person; LastRecThisPerson = ThisForm [(Person = test && ID < input.ID && Added_Time == today)] sort by Added_Time desc; if (LastRecThisPerson.ID == null) { input.LapsedTimeInHours = 0.00; } if (LastRecThisPerson.ID > 100)
Adding image via iphone
I have an image field. From the iphone, in edit mode, the user can click PHOTO or CAMERA. When the user clicks PHOTO, I have the error message: this app does not have access to your photos or videos You can enable access in Privacy Settings Where are Privacy Settings????
addYear function causing problems since last weeks zoho update
I have a formula that calculates an expiry date with this statement Last_Renewal_Date.addYear(1) It has worked fine for years but last week we got the error that says "Invalid field value" for this formula field. I think it is now generating a DateTime value instead of just Date --- which is not allowing us to edit the records. I have had a request into Zoho for over a week and they are not responding in a timely manner. Is anyone else having this issue?
Fetching wrong data
Hi, I have a Condo management app where I have two Condos with the same Unit Number but located in different properties and belonging to different Mngt_companies. I am using "Fetch Record" to auto fill in details such as Mng_Company and others. When I select the Property and unit number, the wrong Mngt_Company is Fetched. I have deleted the record in my master units form and recreating it but nothing seems to fix my issue. Thanks for your help. this is the script I am using: if(input.Unit_Number
Back up not working
I am trying to back up my application and I keep getting failed and null in the description. Is there something wrong? I only have one previous version.
name an excel csv on export.
Is it possible to create a name for an excel.csv export file on export? I've created an excel spread sheet with a vlookup function. When I open excel the *.csv file has to have the same name each time for the function to work properly.
Overhaul the SendMail Function to Allow for Easy HTML and Templates
I have been using Zoho creator for a while and it seems that the system to send email is VERY clunky. If I want to send HTML, I have to replace every " with a ' and other little tweaks. The Deluge and html do not work well together. Do you have any plans to overhaul this? I could envision an HTML template area where all you do is use your refer fields to add the dynamic content. This would be a GREAT and much appreciate upgrade. If not can I integrate with a transactional email program like Mandrill?
Attempting an Order Management application
Hello, I'm attempting to create an Order Management application and would appreciate any direction in helping me to think about this in the right way. This is what I'd like to do: 1) Import Order Number and related information via XLS file and automatically assign a "NEW" status to each of the records 2) Show "NEW" orders on a Home or Dashboard View with a click link to "Processing" Form that auto-fills the Order Number. The "Processing" Form would have the auto-filled Order Number field and fields
Assistance Needed With Developing an App
Hi, I'm still trying out the free version of Zoho Creator before I make the purchase and I need help with creating an app. Just a brief explanation of my business. We create and register private companies for individuals who want to start their own businesses. The process has two stages: - Name reservation - Incorporation Now these stages happen at different times (a few days apart). I want to be able to track the progress of each order from a client ie. when I enter a Job ID, I want to be able to
URL link for uploaded file is not accessible to general public
Hi Team I have a business where I upload a report for a client to my system, which then sends the report, in an email to the client. This is shown in the email as a URL link. The problem is the the client is presented with a Zoho Login page when he clicks on the link. Is there any way to remove security restrictions on uploaded file links at all so that my clients can download the report? Or simply attaching the file to the email? Thanks Jason
Help with Scripting
Hello, I am new to this type of workflow so I hope someone can help. I have a form that has 5 categories each with drop-down menus. Cat 1 has 3 variables, Cat 2 has 3 variables, Cat 3 has 26 variables, Cat 4 has 4 variables, and Cat 5 has 2 variables. Depending on what variables are selected for all 5 categories I would like a new form to open upon clicking the Submit button. Simply stated I would need to write a script for the Submit button: If cat1=variable, cat2=variable, cat3=variable, cat4=variable,
Date functions used in report criteria lost on re-edit
I have a number of reports set up using date functions such as 'Added_Time' ... Before ... today.subDay(7) to find records that are over a week old. These can be created OK, and work fine. However, when I go to edit the report criteria again, "today.subDay(7)" is always turned into just "subDay". In order to save the correct criteria, I have to retype "today.subDay(7)" into the text box before save. The same happens for other functions e.g. addDay, subMonth, etc. I've got this on a lots of reports,
Address field type
For mailing addresses, I use: 1 line for the addressee fields for city, state, country and postal code. and: 1 line (optional) for the c/o or company or to the attention of 1 line for the street or PO box My question is about the 2 lines.... I don't like how much room they take up in list view reports, and I'm wondering if I could switch to 1 multi-line field. Any opinions? Advice? Recommendations?
Send One Email for Several Records
Using the scheduler, is it possible to send one email instead of individual emails for records with the same criteria? i.e.: When three records have not been entered by the user yet by the due date, send one email for all those records.
Accidentally deleted a form button
I accidentally deleted the wrong button on a form - and therefore the code behind it. Is there any version history available or any other way to restore it?
Can I MOVE a Form from one application to another?
Hi, I am new to Creator and I ended up creating multiple applications instead of multiple forms within an application. Can I move forms or copy forms between applications? Thanks
Using the Date field
Hi, This is my first time working with Zoho creator (or any service of the kind, for that matter), your assistance will be highly appreciated. Some of my records have an exact date, and some only have a year. I can't seem to be able to use the "date" field, because it doesn't accept those with just a year as a proper date format. I would very much like to use the date to field for better search options, instead of just making it a one-line field (won't take numbers too, because then it says that
fetching records with multiple search criteria
I want to search my all the records in my Crew_DB for a name that I input. Then I want to input the data from a field in that record into the existing form. Can this be done? Example. crew = Crew_DB [(((((((((Crew_Member_1 == input.Employee1 || Crew_Member_2 == input.Employee1) || Crew_Member_3 == input.Employee1) || Crew_Member_4 == input.Employee1) || Crew_Member_5 == input.Employee1) || Crew_Member_6 == input.Employee1) || Crew_Member_7 == input.Employee1) || Crew_Member_8 == input.Employee1)
Send Reminder
Hello, I'm trying to trigger a function in which the program can automatically send an email to remind the user, who input some but not all of the data, that the deadline is approaching.
Archive Subform Data
Hello, I'm trying to archive data from both the parent form and its subform into another section, so that we can look back on old records. As a result, I created a function in which you can click a button on each record to archive it. However, only the fields in the parent form can be archived, NOT in the subform. Any advice? This is what I have so far: void deleteRecord(int ID) { fetch = Part_Information_Input [ID == input.ID]; insert into Archive [ Added_User = zoho.loginuser
Next Page