Create a List of Checkbox Choices
I have a form which includes a checkbox field with about a dozen different choices. In a script, I am trying to create a list of what those choices are. I am not trying to get a list of which boxes are checked, but instead just a list of all the choices available. Is there an easy way to grab those values and stick them in a list?
Zoho Creator - Local Backup & Scriptng
Hi, I want to know if I can take local backup of data and app available on my zoho creator. Also to do the scripting in zoho what I need to learn HTML or something else. Also I am trying to build two way communication program in this,let me know how can you help. Please let me know.
How to generate HMTL Code?
Hi all, I am would like to generate HTML Code in Creator. I created a products table in Creator, and I have an html template, which require to put some product information in the html template, just like a mail merge. However, after html code generated in the form, the HTML tags was trimmed. Is there any way which don't trim the HTML tags? Thank you in advance.
Customer Portal
Would it be possible to to have a system variable that returns a user's Profile Name from the Customer Portal that then can be used to determine the user type in scripting? Is there a plan for Profiles to be included when duplicating an Application? The ability to export a Profile and reload it into another version of the same Application would be equally good. Many thanks!
Edit Record Passing Parameters
Good day this is the following way to edit a record passing parameters could you please confirm how to perform this in form-perma. http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> Best Regards,
Copying values between forms & lookup/editing with barcodes
Hello all, I am build an application that I can use to keep track of my company's hardware. I have a New Hardware form for adding new entries, an All Hardware form/report, and a Check Out/In form to perform the check-out/in action. I have a couple of basic questions I need help with: When a "New Hardware" form is submitted, is there a script I can implement to create a new entry in "All Hardware" and copy values over? Is there a way that in the "Check Out/In Form" I can use a Single Line field
Bug: Stateless form buttons don't work on mobile.
Hi, Both button types (Standard and Submit) don't appear to execute their deluge script on Stateless Forms via the Zoho Creator mobile app. I have shared the application with support: https://creator.zoho.com/johndobble/bugs/#Page:Stateless_Form Please advise. Regards
Android Phone photo - unfortunately Zoho creator has stopped
Hi, I have a new app (and have a developer helping me with it) My android phone is giving the error "Unfortunately Zoho has stopped working". The cause is when I take a photo and submit it. This works fine on an iPhone. Questions: 1. Is this a common error? 2. How fix it? 3. I have logged with Zoho support. Will they be able to resolve? 4. Are photos generally a problem area? All help appreciated.
Problem with subform and adding fields to picklist and txt.
I have a form Items, and form Recipe with a subform. In my subform I need to populate a dropdown box based on the item selection. row.PurchaseTxt=Items [ID == row.items].Purchase_Txt; row.InventoryTxt=Items [ID == row.items].Inventory_Txt; row.UsageTxt=Items [ID == row.items].Usage_Txt; clear row.Usage; row.Usage:ui.add(Row.PurchaseTxt); row.Usage:ui.add(Row.InventoryTxt); row.Usage:ui.add(Row.UsageTxt); Any help would be appreciated.
Sharing records
I have a situation where we want to share some records between apps. Specifically the apps are for keeping track of leads for different websites. In some cases, the leads are common to both sites or apps. We want to have the common record available to queries from both apps. Is this possible with zoho creator. Note, the apps are identical in structure.
Select or Deselect a Field Weh the Field is Updated
I have a checkbox field called "Invoiced1". I have the following code in the Field Action, On Load section for a field called "Carrier": Invoiced1.deselect("Freight"); It works great! When I try to copy and use the same simple code into the Field Action, On Update, it fails. Saying error on line 0. Any ideas? Help is much appreciated. Thanks!
Combined Report of 3 forms
I am having trouble (since I am new to database design with Zoho) on creating a "final report" that shows results of three forms linked by a field called "exercise title". I have reviewed numerous documentation documents and forum topics. Any one have any suggestions? Thanks Adam
Create combined report with 4 forms
Greetings: I am totally new to Zoho and am in need of some help. I would like to link 4 forms together and create a "final report". I have allowed edit access in Support and would appreciate any assistance anyone could provide. Thank you in advance!
Comparing strings
Hi all, I am looking for strings comparsion But this is not what I am looking for: https://help.zoho.com/portal/en/community/topic/comparing-strings https://www.zoho.com/creator/help/script/built-in-functions/built-in-function-string-equalsignorecase.html I would like get the return of strings which are equal Example1: StringA: Project Management Software StringB: Project Management Application matchResult = matchIgnoreCase.(StringA, StringB); return matchResult; // Return "Project Management" Example2:
Issue in Duplicating Record
Hi, I am trying to create duplicate record in zoho creator report. But i couldn't make a duplicate the image for the record. Is it possible to make a duplicate record for the image.? If it is possible kindly assist me. Thanks Ashok
Mobile App Interface looks different from Web Interface
I am trying to create a default landing page post successful login for both Web and Mobile Interfaces. For this purpose, I have created multiple sections of which only one is visible (named Dashboard) and rest are hidden. Dashboard Section is the first Section in the Sections list. I have created a Dashboard Page (only one page) which is put under this Dashboard Section. This Dashboard page contains a Salutation, a Chart and a couple of links for specific Forms. On the Web Interface, the Dashboard
Organisation Heirarchy for Roles/Permissions.
Hi there, I am newbie in Zoho Creator. I am trying to build a Member Management System. Couple of questions: 1. Every time a member is registered I need to generate and save a unique ID per member in the format STATECODE-DISTRICTCODE-CATEGORYCODE-FACILITYCODE-SITECODE-AUTOINCREMENT_NUMBER. So, it is a combination of Formula and Auto Increment field types. Each of the CODEs are 2 or 3 letter CODES. What is a good way to achieve this format? I see that a solution is provided at https://help.zoho.com/portal/en/community/topic/auto-generate-field-based-on-other-fields.
Shop Maintenance Report
We invision a system that creates a shop maintenance report on a daily basis. Each time we finish a task (i.e. mop the floors) we can scan a bar code and it populates the completed task in a record. Any thought would be greatly appreciated.
Form/Report embed
I am creating a page based on a number of forms and reports. I would have parameters which filter the contents of the reports in the HTML page, depending on parameters in the URL. For example, I have 3 reports, and I want to have the date column match the date set in the url. I assume I change the Search String in the Embed Form|Report dialogue..? The other thing that is not working is if I change to Free Flow Script, and back to script builder, and edit a Form|Report it opens it as HTML, rather
NooB Form / SubForm Relationship Question
Hey all, Forgive the beginner nature of my question. I'm just getting started and don't have any real background in programming to speak of. I've been scouring around to try and figure this out, but am spinning my wheels here. I suspect what I'm trying to do is pretty simply, just need some guidance... Screenshot attached for reference. I work in the home technology installation business. We design and install custom technology solutions in high-end custom residential homes. What I want to do is
Posts being marked spam?
Just tried to post twice about a major issue I'm having and seems it was marked spam, what is going on? This is incredibly obnoxious? It's absurd to auto flag a paying customer as spam.
Issue with GET API Request to retrieve where records not equal to value
I have a query where I want to retrieve records that do not have certain text in them, so records where: Message_Status is not equal to 'Sent' I have a lot of records where Message_Status is blank and some where Message_Status is qual to 'Send' This query, however, only picks up records that DO HAVE a value for Message_Status (so are not blank) and that are not equal to 'Sent': https://creator.zoho.com/api/json/myappname/view/Lead_Marketing_Report&authtoken=xxxx&raw=true&criteria=(Message_Status!="Sent")
API, making REST query where some records are empty (null?)
I'm perplexed by the lack of documentation on the part of Zoho, I see just this page: https://www.zoho.com/creator/help/api/rest-api/rest-api-view-records-in-view.html#http_method I have a query where I want to retrieve records that do not have certain text in them, so records where: Message_Status is not equal to 'Sent' I have a lot of records where Message_Status is blank and some where Message_Status is qual to 'Send' This query, however, only picks up records that DO HAVE a value for Message_Status
Updating a status field while using a Look-up
Hi, I am trying to update a "status" drop menu when I change my Look-Up field. My Look-Up field is currently used to get names of people. I want to change it so that if my Look-Up field is set to a person, it will change the status field to "On Loan". Thanks.
ZOHO Creator Help
Our business uses ZOHO Creator to manage our daily business transactions. We take daily orders, download them using a bridge into Intuit. We fear growing out of both ZOHO and Intuit (QB Enterprise). Furthermore, our DBA/Developer has announced his retirement, and would like to have his monthly consulting / developer replaced with another person / company. 1. Can someone recommend a good company / individual? We are located in Kansas City (but our current DBA is in Georgia). 2. We are looking
Auto Generate a Number - Show on Form
I understand there is an Auto Generate Number Option, but it does not show up on the form. I want to make it so that all who input can see the auto generated number. Is there a way to do this?
Serch String in Embed Report
Hi I'm trying do embed a report in a Page The page have an input parameter of a company lockup field I want that the report show only the products related the the input company. The "Search string" field in the Embed report don't seem to do anything . Thanks
Blank new window (custom HTML page with collected data) for printing quote
Hi, I want to create a custom HTML page, with client’s logo, which the client can print (it’s a quote). The HTML page collects the necessary data and prints that in the template. It just needs to be a blank white new window, so they can print the quote on a white sheet of paper. How do I do this? When I use openUrl > new window, it opens a new window, but with the Creator header, menu, yellow background, etc. I can probably do it when I post the data to a page on own server, but I want everything
Insert Record from JSON response
Hi, I have below JSON response but how can I insert Record into my form from these JSON for each "rows" { "response": { "uri":"\/api\/ernak@abc.com\/TV%20Database%20Newsletter\/TvExport", "action":"EXPORT", "criteria":"(\"TV Station\"=\'WRNN-TV 48\')", "result": { "column_order":["TV Station","Market","Network","Market_Households, 2008-2012","Genre","Channel Type","Broadcast Management","Type of Station","Channel Added_Date"], "rows":[ ["WRNN-TV 48","New York, NY","NHK World","7,546,574","Foreign","not
problem in converting rich text to map
hi please do below items: 1- create a rich text field in a form 2- place a map into it 3- set a string variable equal value of rich text 4- convert string variable to map. you see the result of stage 4 every time is {}. if we use multi line text instead of rich text then this problem doesn't occurred. please help me as soon as possible
Pivot Table limitations
Is there a know limit to the number of records a form can have for pivot table reports to work correctly? I have a very large collection of records in one form and pivot table reports don't seem to be accessing all the data for their results.
Signature Url in Native App
Good day for you, I have a form with a script on success that get the link for a Signature field, if I access thru a browser it works perfect, but in the native app I have problems getting the png file name. I Use the following code to get the file name imagelnk = imagelnk.replaceAll("/sharedBy/appLinkName/","https://creator.zoho.com" + zoho.appuri); imagelnk = imagelnk.replaceAll("viewLinkName","Registro_Formacion_Asistencia_Report"); imagelnk = imagelnk.replaceAll("fieldName","Firma"); Result in
Embedded reports for shared data all of a sudden began asking for login
I've had reports embedded into my website for years. All of a sudden, the reports are no longer showing, but a login request is showing in their place. I logged into Zoho and checked, and everything is still Shared. They appear fine when I'm logged in, but as soon as I'm logged out, the login request appears again. What changed at Zoho?
Native App and conditional formatting
Is conditional formatting designed to work with the Native App? Colour formatting is not working on a report.
Add image Zoho creator api File Upload
hello, do you have an example in C# or php to insert many image in a field without use a simple form action as <form action = "https://creator.zoho.com/api/xml/fileupload/scope=creatorapi&authtoken=**************" method="post" enctype="multipart/form-data"> <input type="text" name="applinkname" value="sample"> <input type="text" name="formname" value="Employee"> <input type="text" name="fieldname" value="File_upload"> <input type="text" name="recordId" value="1235667754455"> <input type="text"
Select all for subform field
I have a SCHEDULE form with a SITE dropdown and an ALL SITES check box. When the user clicks the ALL SITES checkbox, I use the code below and it works perfectly if (input.ALL_SITES) { SITE_ID.selectall(); } I have an AGREEMENT form that has a SCHEDULE subform. To replicate the same logic I have tried the following code which I generated via the script builder row.SITE_ID.selectall(); But I get the following error message. 'row' does not exist in this form How can I use the select all function
File upload in zoho creator from an external website
Hello, Is there any way to upload a file to zoho creator from an RPC call or to specify a download link for a record? I tried to put a value for the upload field but I get this error : "Value cannot be specified for file upload field". Andreea
Is it possible to create a View that takes input from more than 1 Form?
I have created an app with about 10 forms and about 20 views. What I want to do is bring together all the DATES in the forms into a single view (in the shape of a calendar, rather than list). Is this possible? I guess one way of doing it would be to set up the View to receive input by email, and then to have all the forms send input that way. But even if that works, it seems rather circuitous. MANY THANKS for any tips or tricks.
Why do hard coded filter criteria succeed and variable ones fail on zc-component?
Hi I'm very confused. Why does #1 below work but #2 does not? <div elName='zc-component' viewLinkName='Properties_Report' params='zc_Header=true&ID=2811360000000011231'>Loading View...</div> <% Property_ID = 2811360000000011231; %> <%= Property_ID %> <div elName='zc-component' viewLinkName='Properties_Report' params='zc_Header=true&ID=<%= Property_ID %>'>Loading View...</div> On the surface, it seems to be a simple case of variable substitution. On the other hand, I have been fighting this
I create new apps and I want to pay through paypal to Zoho ? but that option not available???
I create new apps and I want to pay through paypal to Zoho ? but that option not available???
Next Page