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
Data updating from Creator Web Forms/Website to CRM
I would like to know if there's a way to have a Creator Form *update data info (that was already submitted previously) to ZohoCRM and website. I'm trying to build a database "Profile" process that if a user updates info in their profile (within our website/ZohoCreator form) that this info would update in our ZohoCRM > "Profiles" tab. Is this possible... if so please advise.
Make a hyperlink with a URL field.
I want to make a hyperlinked text, but Link is a field already established. I have a field with URL but I can not make a text. When sending an email I need to apply this function.
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.
Round decimal
hello, do you have a function to round a decimal with range of 0.5. By example if i have 16.56 i would 16.60, 22.12 -> 22.15, 14.34 -> 14.35 thanks you
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
How to clear a date field ?
How can I clear a date field ? Null does not work, nor does empty string "", nor can I clear picklist as it is a date field. e.g.: if((input.Status == "Closed")) { set ClosedDate = zoho.currenttime; } else { set ClosedDate = null; } Thanks, and I love the Zoho 2 features & look ! markv
Add Record in Quotes
Hi. . I can not create an entry in Quotes. The problem in the section of "Product Details " in Module Quotes . Either this section blank , or an error. For example : ______ mp = zoho.crm.getRecordById("Quotes",1402978000000223001); ______ mp.put("QuoteID",""); ______ resp = zoho.crm.create("Quotes",mp); ______ "Product Details " - empty. Or mp=map(); mProd1=map(); mp.put("Subject","Тест4"); mProd1={ "Product Details" : { "Product Id" : "1402978000000087066", "Product Name" : "Кухня jivo"} }; mp.put(mProd1);
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.
Dynamic Picklist not submitting selected choice on add
I set up a dynamic picklist and the options available in field 2 depend on what I selected in field 1. The problem occurs once I hit submit. In the corresponding report, the option I selected in field 2 is not recorded. The record displays all other entries except the selection from the dynamic picklist (field 2). This problem occurs even if I try to add a new record from the report. The only way I've been able to get the option to stick is if I edit the record once I add it. Any ideas on what the
printing mailing labels work around?
I was reading that you can't print labels form Creator. Is there a way to do this by connecting data to to CRM or Reports and then printing them from there? When do you project to have this work in Creator? Ray
Creator Report by Record Creation Date
I want to make what I think should be a very simple report in zoho creator. The report would show us the number of leads we get per day. Should be easy but i can't see any way to add zoho record creation date to one of the report axis. Why is this field not available to add to an axis? This is a system field and i would rather not create a new field to hold the value as it is already stored. What am i doing wrong? I cant figure out how to use the Add Aggregate Formula section either so if this
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
Page Printing - Not printing record detail
I have created a page "test page". In the page I have embedded a stateless form "job detail". The "job detail" form pulls information when the field "Job Number" is selected. The "test page" looks great on screen but when I print the page I get all the fields from the "job detail" stateless form with no data or record information. All the fields are blank. What am I missing?
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
View criteria for blank (null) date field?
Is it possible to set criteria and/or filter a view to show only rows where a particular date field is blank (null)? If so how? Thanks.
Create a Task list based on dates from different forms
Hi all, I would like to create a task list based on information captured for different forms ex: I have a Client's Birthday fields - on Client information Form Broker Birthday Field on - Broker Form Follow up Date - on Referral Form So I would like to create a to-do-list / Task list if any of the above happens it should be added to the list ex: Client's Birthday - Mr Koos is having his Birthday Today with his Cell number ex Broker Birthday - Koos Marias is having his Birthday Today with
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?
Calculate Duration with Time in text-fields
Trying to subtract to decimals and get a time in minuets and seconds. When trying to add the formula Duration_in_Decimal - Duration_in_Decimal.toLong() * 60 to a text field I am getting error : Error at line number : 4 Variable 'Single_Line' is already defined of data type 'STRING' but trying to update 'DECIMAL' data type
Zoho Creator Chrome App?
Is there a Chrome App for Creator? Seems to be an app for every other application but I can't seem to find one for Creator?
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">
problem with subform
Good afternoon. I am trying unsuccessfully to help support you in four days and no response . I'm having the following problem: I created a form and subform it loses the rules made in the original form. Form is : https://creator.zohopublic.com/zoho_bruno123/requisicao/form-perma/Correspondente/D6fpDwguR9WbGNZpv4HaNd2W5kytgBsUtB4TUXQSNCFnM2fOw7YyHuF177meO0h3tUyuFQFkbQNPXbXF9HNpW1qxt7XnHejTMus1.
When I put " city " the county should open only selected and is not opening at all. What can it be?
Formula to Calculate Total of Multiple Rows in Sub-form And Return the Grand Total to The Main Form
Hello there, I am working on a main form, a kind of invoice divided into 2 sub-forms. First sub-form is Customer Info. Second sub-form is Items list. I can calculate something like Quantity*Unit Price in one raw. But I don't know to to run formula for one column (Total Amount). So As you can see, I can work horizontally, but not vertically. This is at least the most problem I have. Hopefully, someone could fix this as I think this would be common but no clear answer I found for. Another thing is
Next Page