getURL and postURL not returning response body for 500 response
I have set up a temporary rest endpoint that returns a 500 error and some json to explain the reason for the 500 error. http://demo3516469.mockable.io/test500 This is common behaviour for many REST APIs to return a 500 error if something is not right and display a reason. The following test function: void testREST() { getRestResponse = getUrl("http://demo3516469.mockable.io/test500",false); postRestResponse = postUrl("http://demo3516469.mockable.io/test500", "{\"test\":\"test\"}",false); info getRestResponse;
How can I reload a HTML page opened as a dialog?
I have a HTML page with a list report and a stateless form embedded to it. This page is opened in a dialog to show info about the selected record. I wish the HTML page gets reloaded when I click on 'Update' button on stateless form. I already tried openUrl("#Script.page.reload", "same window") and it works if this page is loaded on whole window, but when it's opened as a dialog it reloads parent page. Any tips on how can I achieve this behavior? Using iframes maybe?
sum of values in report
hi! how to make report so that it will show sum of values?
Build app without forms
Hello, I only want to build a calculator - user enters numbers and page displays results. Zoho only allows me to do this on a form. I do not need to submit a form. Thanks!
Trying to be to clever
I have created a ToDo form and have two other forms, let's call them A and B. Todo's can be either general or specific to either A or B. So what I did was create a subform, first in the A form and then another in the B form. Went to the Todo view added a look field to the A form and another lookup field to B form. No problems with the on the A side but there's something wrong with the B form. On the B form when I click "Update" i get a spinning icon and "please wait" but this never goes away. I get
Retrieve data value from different tables all in a new table
Hi, I would like to know if there is a way to retrieve data values from different tables into a single validation page. For example if we have, 3 steps process Step 1: Enter customer data Customer Table CustomerID:001 FirstName: John LastName: Smith with Submit button - data insert in Customer table Step 2: Enter Appointment Appointment Table AppointID:001 CustomerID:001 AppointmentDate: 22/3/2017 AppointmentTime: 10:00 Step 3: Validate Here what I would like is to retrieve all the information from
Lists cannot be compared?
Hi Zoho, I have the following script: ListA = {"A","B","C"}; ListB = {"B","A","C"}; if ListA != ListB {%>Lists Not Equal<%} When trying to save, I get the following error: Error at line number : 7 at column 54 In Criteria left expression is of type STRINGLIST and right expression is of type STRINGLIST and the operator != is not valid This also happen when marking "equal" using double equal sign (==) , but single equal sign (=) is ok. Please fix thanks Ravid
Remove time from date-time formula result; not using .toString()
Dear Friends, I have date-time formula in a form to calculate certain date. Then, I have report (list type) based on this form, where I want to sort all records according to this formula field. The problem is: - To sort by formula field, I have to add this field into the report, and then only I can drag it into Sorting order - Consequently, this field becomes visible and occupy too much space in the report. The problem is that it shows also time stamp, which is meaningless for me, like: 28/03/17
7 day reminder automated email
Hi Guys I would like to setup up an automated email reminder. The condition would be, if a record had not been updated after 7 days of creation it would send out the remainder email. Any help, would be appreciated greatly. Thanks Chris
Send Mail with selected Records as attachment
Hi, Is this possible in Creator that I can send a XLS file as a attachment for selected Records only using Sendmail Function ? For instance If I select 10 records in the View and click on Function so it send out those 10 records' details as a XLS format to respective email.. Thanks Arfater
Can't delete function
Hi Zoho, I have several old functions I'd like to delete. When I click "x" I get the following message: Function cannot be deleted. This function is referred in the following places. Please remove the reference,then try deleting the function. I can't understand where the functioned are used (and don't think they are used, anywhere) please fix Thanks Ravid
"With Action" to all the forms at once?
Hi Zoho, How can I view the "With Action" of all of my forms as once? I'd like to replace a certain fetch command with a function, anywhere on the application. Thank you Ravid
View single public record via URL in record-summary view
SOLVED - See below. I would like to view an individual record summary (from a custom summary view) from a published database by passing the record ID via URL. I see from the Zoho documentation how to print an individual record: https://creator.zohopublic.com/<adminUserName>/<appName>/record-print/<viewLinkName>/<RecordID>/<encryptedKey> This creates a print dialog box for the single record in summary view. If I hit the 'Escape' key, I exit the print dialog and simply view the record EXACTLY as I
How to pass parameters thru HTML popup form
I am using "#Form:<Form>?zc_LoadIn=dialog" for an HTML link popup form and I would like to pass values to this popup form so that some fields autopopulate. How do i do this?
Criteria for if "date is equal to or after today"
I am trying to fetch records where the date is after today. What is the criteria for dates that are equal to and after today? I tried date After today; date After zoho.currentdate; date >= today; date >= zoho.currentdate; But none of these work
error on .contains() when value is null
Hi Zoho I have the following script : htmlpage test_page(Var01) displayname = "test page" content <%{ if ((input.Var01.contains("Yearly"))) { test=1;} %> <%=test%> <%}%> When Var01 is null, the .contains function return an error and will not load the page: Error details: Error in executing test_page view script. Error. Error in executing IF rule : Error in executing If condition. Error evaluating Boolean expression : Error evaluating BOOLEAN expression : The value of variable Var01 is null. Please
Open A Separate Form from a Separate Report
Hello, I have two forms for this example named Form_A and Form_B - the users input data into Form_A using 'Insert Into' I pass some of the inputted fields into Form_B including the 'Auto_Number' field into a number field in Form_B. I would like to in report view of 'Form_B' add a Custom Action against each record in Form_B that when clicked opens the Form_A (in edit mode) for the matching record For sample Form_A ID field = ID_One (autonumber) is inserted into Form_B number field ID_One On clicking
Zoho creator deletes code snippets /doesn't save code
Hi, The application is not saving the script I write "Edit -> On Load". I had some code entered in the above mentioned section, when looking at it earlier I noticed that half if the code I had written out is missing. Luckily I had saved it somewhere else, however when I paste the code and tell it to save the script it doesn't save it. It give the notification "saving.." then "saved", but if I switch to another view and back, the code snippet disappears again. This is the second time that this has
Copy lookup field text into single line field.
Im not really a noob but I defiantly feel like one today, Im pretty sure I've done this before but what I'm trying to do it populate a text field from the chosen result of a lookup field. This is the current code, Ive tried many but this is what I can remember. input.Nextjob = input.Which_Site_will_you_Attend_next; NextJob - Single Line Which_Site_will_you_Attend_next - Lookup Field I want to copy the result as shows in the lookup field which is primarily the client loaded from that form but
Ability to view uploaded PDF files
Zoho Creator has lovely field types to design forms to allow users to upload a PDF, but that's about it. What we really need is the ability to be able to view these files.
Added_User in formula field doesn't work?
When I try to use Added_User or Added_User.toString() in a formula field, the end result is always blank. I can use ID ... how do I get to use Added_User? Thanks in advance for any leads.
Calculating the total amount of a subform is not working correctly
Hi I was following along the tutorials on zoho site. Link : https://www.zoho.com/creator/help/tutorials/advanced-app-building.html Section: SubForm Actions --> 3rd part. When I'm testing the calculation on my app, the first product that i select within the subform and I am changing the quantity the total amount is working fine, but when I add a new product and I put the quantity at 5 The total amount doesn't make any sense. I don't know if this is a bug or maybe I have did something wrong on my code
How can I display the records from a form in HTML page by Month or Year?
I have an application that processes salary of employees and I need to create an HTML page to shows the records with details monthly of the processing. In there page must conste the details of the organization and other information, but the data must be showed monthly selecting the month in some field of type "select". I've tried to embed the Salaries's Processing report, but it don't work like I want, because, when I print the page the other informations of HTML page don't appear. Please, help me.
Loockup
How would you use Loockup when you select and search for data from another form? so i need the code
Drop down selection creates a record in another table
Hi All, Is there any way I can have the selection of a drop down list create a record in another table and auto populate certain fields ? Basically to forms with associated tables: Main form is BAU Request and the fields in question are: Service Requested Product Type Serial No Asset No. The second form is called "Repair Ticket" and has the following fields: Product Type Serial No Asset No Basically on the BAU Request form, if someone chooses "Hardware Repair" from the "Services Requested" drop down
Adjust height of Line chart
How do I adjust the height of a line chart? It is taking up my whole screen.
Differences in CSV data from manual export and API export
Hello. When I export from a report in CSV format, I get data from lookups and subforms as desired. But when I try to get the same report via API, I get IDs for lookup fields and for subforms (i.e., if my subform has 3 lines, I get 3 IDs). Is there a way to configure this in order to get the same result aI get from the manual export? Thanks in advance.
Breaking loops
Hi Zoho and everyone, how can I create loops based on variables? for example: Date = zoho.currentdate(); End_Date = zoho.currentdate().addYear(1); for Date<End_Date { ........ Date =Date.addMonth(1); } ? Thanks! Ravid
Send Mail with Mailgun
I would like send mail with Mailgun. Anyone could help me? I think to create a function that read from a record "To", "Subject", "Text". Mailgun c# code is this, how can I translate it in Zoho Creator? public static RestResponse SendSimpleMessage() { RestClient client = new RestClient(); client.BaseUrl = "https://api.mailgun.net/v3"; client.Authenticator = new HttpBasicAuthenticator("api", "key-bfac6e09124785239032fbae930fdd69c"); RestRequest
Custom Action openUrl function open in new window
Hello, I have scripted a custom action to openUrl but when I click on the action, it replaces the current page with the URL. How can I make the URL open in a new window? I have used the script below void openUrl(string Email) { openUrl("https://mail.google.com/mail/ca/u/0/#search/from%3A" + input.Email + "+OR+to%3A" + input.Email, " New window"); }
"Dont round if null" within the same script
This is the script that I'm currently using. input.Amount_1 = temp.Amount_1.round(0);I would only like to invoke this expression if temp.Amount_1 != null I have (10) amounts to do this to, so writing an if and else function for each one would be cumbersome. Is there a more simple function that will only round the number if not null ?
Determine file size after completing an upload
Is there some way to determine the size of an uploaded file using Deluge? My app will allow file uploads and I want to measure and limit the space my clients can use for uploads. These will be Customer Portal users. Thanks, Marcos
Can't search Zoho CRM records using DateTime field in query
I'm trying to use the zoho.crm.searchRecords() function. void searchCrmDateTimeField() { query = "(Zoho CRM DateTime Field Name|=|" + zoho.currentdate + ")"; todaysRecords = zoho.crm.searchRecords("CustomModule1", query, 1, 200); info todaysRecords; } The result: {"4500":"Problem occured while processing the request"} I have isolated this problem to searching date-time fields in CRM. I can perform the same search on a date-only field and get results back. This is causing major limitations in how
Column Total in Spreadsheet view
I would like to know if there is any way to display the total of a column in a spreadsheet view. In other views like List it is possible to show the total,max, average etc.
Custom Action button to filtered Report based on Field Data
Hello everyone, I started using Creator today and found it great for an outgoing proyect. I have been reading doc but can't find a simple explanation to this. TLDR Im developing a real estate app. Have a form with Buyer data and specifications (ex. property type, betrooms, etc). Have a form with Properties list. (Type, betrooms, etc) I want to create a Custom Action button on Buyer report to create-show for example a "print" view of the report filtered by buyer specifications on the Properties list.
zoho creator download images
Hi, I need to download the image when exporting to excel or pdf. The link that currently provides is not usefully if I cancel my Zoho account.
Manually edit preexisting entry in lookup field
Hello, I am aware that in a lookup field i can "Add New" entry. But is there a way to edit a preexisting entry within the parent form?
Record summary taking up whole page
Hi! I use a report in a calendar view, and I was able to click on a record and see the summary on the right side of the page. Now when I click on the record, the summary takes up the whole screen. How do I fix this? This is how I see the summary This is how I would like to see the summary
internal short code for fields
hi! there is a big amount of code that changes field_A value in form via workflow rule. and there are about ten other fields where this "big amount of code" exists and repeats. if a value in one of other fields changes - changes value in field_A value because in workflow rules of each other fields there is "big amount of code" sometimes it needs to make changes in "big amount of code". so that it needs to change same codes in workflow rules of every ten other fields it is too complex. how can i
This application is not accessible
Dear Sirs, I have Develooment ''licence'' and just created an app, but I even can't access my own app? Help please! RG Luke
Next Page