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???
Lookup displays as list on mobile
I have created an application. The lookup dropdown is displaying as a list on one form and as a click on the dropdown select from a seperate list page on another form. Does anyone have any ideas about why the same lookup dropdown would display differently? Cheers, Jon
Record summary condtionally
Hello everyone, Is it in any way possible to make a record summary conditionally? For example: When, in a form, question 1 is not answered and question 2 is answered I want only to be shown question 2 and the answer on question 2. So the question 1, which not has been answered, is blank. Or is there an other way to generate such a summary? Maby trough pages? I really hope someone can help me I even want to pay for the solution and maby you can help me build it. Greatings, Erwin
Report
Hello, I have a form with 30 questions. A customer answer these 30 questions with answers. Some questions can't be answered. So a couple of fields will be empty. Now I would like a report or export to excel with only the answers which have an answer. Is this possible? Or how can I fix this problem? Maby I can use the On Edit --> On load functionallity like: if (input.field1 = null) { hide field1; } The problem is I can't export a form in the on edit mode. Or is it possible to generate attachment
Data based upon Form responses?
I'm looking for a way to capture Form answers and turn them into numerical "score" outputs. For instance, if a respondent answers A to Question 1, I want answer A to equal 6 points, and if they answer B, then B might equal 9 points, etc. Instead of me manually tabulating the numerical scores based upon respective answers, is there an "If/Then" feature that would make these calculations for me and then send to me via email?
SQL Server select script upload from local server.
I am new to Zoho and still learning the ropes. We have a project that we think would fit Zoho well. We would like to use Zoho Creator as a look up table. To do this we would like to upload a SQL Select query to the Zoho database that the creator would use for the lookup. This would need to be done several times a day as the data is constantly changing. I have downloaded the uploadtool but as of yet have not gotten it to work. In reading all the info that comes with it I see a lot of references
Criteria to show today
I have a view which I would like to show only entries that were made that day. Added_time = today This results in nothing showing, even though there are entries that I have made. If I put: Added_Time in this week it will show what was entered. But I don't want to see anything other then just what was done today....
Function to import JSON data to Zoho Reports Table
Hi, I am trying to create a function in creator by passing parameters that would retrieve JSON data from external website(GET method) and import that json data to Zoho Reports Table using ZOHO Reports API. I am new in API related issue so I could not figure out how to write the script in creator. Can any help me how to code in deluge script ? Zoho Report API : https://zohoreportsapi.wiki.zoho.com/importing-bulk-data.html Thanks Arfater
Customer Portal to view their own account ONLY
I am looking at the Customer Portal for my application. I want to be able to allow users to view their record and be able to update it, view their invoice, pay their invoice, upload a file, etc. My understanding is that the Portal just gives access to areas in your application to those that you invite. How are others tackling this issue? Or is this an issue at all, am I just mistaken?
Criteria for Chart on Load
I have a database which contains records for 30 companies. I want to show a chart showing information for each company. A User Filter is not a good solution since each company should not see other companies data. Since I can't specify criteria when opening a report can I access global information such as the current login ID or IP address? Is there any way to display charts specific to each company without creating 30 separate charts?
Integration between zoho calendar and zoho creator
I am loving being able to send calendar events in Zoho Calendar, but wish all the possible fields in zoho calendar could be defined in the script. I would have thought that functionality of zoho calendar internally should be at least as good or better then the google integration. I'd prefer to keep all my eggs in one basket, ie, in zoho rather then bring another program into the mix. At the moment according to: https://www.zoho.com/creator/help/script/create-an-event-in-zoho-calendar.html you can:
Relate forms rows rows (pivot table)
Hi, I´m looking for your advice about a problem. I have two forms Team and Player. In team form I declare the name of the team and in a subform I have some more information which come from a other form (Season & Competicion) In the player form I declare the name of the player and I need to get in a subform where he has participate each season (the information I have input in the team subform) Any advice? Thanks.
Trying my hand at creating a Page
First of all, let me say that I am using ZOHO Creator for a number of things. I have been developing apps creator for around a 1 and a half. I use some pretty complex deluge scripting to achieve my desired results. I have to thank all of tech support for all of their support and help over the past year. Now for the question. Is there an easy way or can someone give me a piece of code to create a page. I am seriously just now getting to the point where I am looking at creating some pages. I
HTML page - iterate rows - first row repeats
Hello all, I've taken a Zoho example (https://www.zoho.com/creator/help/views/create-html-page.html) to try to create a dashboard of my own. Starting simple so I understand the syntax (since I don't know HTML very well), I took a sample page (which works) and replaced hard-coded values with a "for each" loop. However, when I run it, the first row repeats for as many values in the table. My pertinent code: for each SP_row in SP {%> <tr class="zc-viewrow zc-row-2">
Next Page