Icon in the top rigth in Creator 5 Portal page
Hi, I have a small icon in the top rigth corner of my app. I'm using portal. See attached. What is this? Thanks!
How can I create a download button on a report that downloads the file but doesn't show the file field?
I have created a document library. I realize that if you add the file field to the report the user can download the associated file by clicking the file name in the file field on the report. I don't want to show the file field on the report. Instead I want to show just a field for each record that shows a download button, that when the user clicks the button, it downloads the associated file in the file field.
Subform Data
I am wondering how the data entered in a subform is stored. Is there a hidden table under the hood with a foreign key to the table for the main form, or is it somehow serialized and stored in the main record. I have looked through the documentation for these details, but I have been unable to find any information.
API Integration Basic Authorization postUrl()
Here is my code and I am getting Internal Error for postural() call. By the way, one more thing I want to know how we can use verify_peer to 0(zero) for not using SSL things. What is wrong with my code? void SendSMS(SMS SMSObject) { //CONFIGURATION URL = "https://example.com/send_ack.php"; wbLogin = "wbLogin"; wbPwd = "wbPwd"; wbAccount = "wbAccount"; label = "label"; applicationName = "ADR SMS v1.0"; //BASE64 ENCODING Base64Encoded = zoho.encryption.base64Encode("httpLogin:httpPwd");
Do I pay a 1 time fee for the Customer Portal or each time based upon my app?
If I pay for the customer portal once, will that allow me to create a sepearate customer portal for each app I create or will I have to pay an addtional fee for each customer portal for each app I create? SC
scanning barcodes and the Customer Portal
I have a page that scans in a barcode and retrieves info based on the scanned value. It works perfectly. But...I can only get it to work if I'm using the ZOHO mobile applet to run my app. I can't get the scanner to appear if I use the app via the Customer Portal. I know that using the barcode option is only available for mobile devices, but since I can have potentially lots of customers using the app, it makes sense to use the Customer Portal. So...is there a way to make the Customer Portal know
Mapping Zoho Creator fields to Zoho Subscriptions
We are currently doing a ZOHO Creator to Zoho Subscriptions integration and are unable to map the billing address fields in Zoho Subscriptions from Creator. We are able to map fields using the following format params.put("display_name",input.Display_Name); but the billing fields seem to be an object as below. Is there a way I can map the object/array fields? billing_address": { "attention" : "Name" "street" : "Street Name" "city" : "City" },9 },
Sending out files
Hi Zoho, I have a form with a field to upload file. I'd like this file to be saved on my Google Drive directly. What is the best way to do this? (Currently I have a schedule to send the file to my email and from there it's saved using a Google script, but I feel this is not the best way to do this...) Will appreciate any idea. Thank you Ravid
Mandatory but hidden fields silently cancel Submit
Hi team I have a Creator form that does not save to a Creator table because it's a public access form (Stateless). On Submit it takes a bunch of actions like emailing the form info. The form has a Radio Button field that controls which fields should be shown/hidden further down the form. Problem: Most of those further-down fields need to be made mandatory. BUT if they are hidden by the Field Actions of the earlier Radio field, there is no way to submit the form. Submit silently doesn't work.
if ( condition ) for C5
Anyone have same issue with new C5 The new version C5 has been problem for me with Deluge Script in many times my if conditions for the Operator<opr> has to be in reverse. For example; Correct statement should be "if(Sch_Weekday == 2)", but I have use Operator<opr> "!=" (not equal) in reverse. if(Sch_Weekday != 2) { input.Monday_Date = input.Sch_Effective_Date.addDay(7); } else { input.Monday_Date = zoho.currentdate; }
How to create recurring revenue with Zoho services?
Hi Team, I am looking to create a software company where I can provide consultancy to companies and help them improve their business processes by using Zoho services. Before that I want to understand how can generate recurring revenue from Zoho services. Looking forward to this community so that I can achieve my dream. I want to create $10k to $15K per month. If anybody already working on something similar we can do something together also. Thanks
Backup and download all attachments
Hello, I am trying to backup and download all the data and file attachments stored in my application. I can download all the data without problem. But I don't know how to download all the attachments together. To do it one by one is not an option. I have been trying to find a solution in the forum without success. I found a file downloader tool but I cannot login. Could you please tell me how I am supposed to download all my data and attachments at once? Sincerely Jacobo
Report doesn't filter based on contains/doesn't contain criteria for checkboxes
I have a form with a checkbox field and I have created different reports to show data based on checked boxes. For example: Opciones does not contain "Factura". show all rows from Nueva_venta [!Opciones.Contains("Sin factura") && Distribuidor.Facturacion.contains("Individual")] This is not working and it's still showing all records.
New Page Builder - openURL in different panel?
Is it possible to have a button on the page open a URL into another panel on the page, like how an iframe works?
Workflow Not Working as Expected
I am trying to use Zoho for Risk Assessment calculations I have written this code if(Liklihood = "Low") { L_number = 1; } if(Liklihood = "Medium") { L_number = 2; } if(Liklihood = "High") { L_number = 3; } if(Impact = "Low") { I_number = 1; } if(Impact = "Medium") { I_number = 2; } if(Impact = "High") { I_number = 3; } Total = I_number + L_number; if(Total <= 3) { input.Single_Line = "Accept"; } if(Total >= 4) { input.Single_Line = "Manage"; } I have a field on my form with a deluge ID of Singl_line,
Need help in updated a record when a linked field is entered
I have two forms: Form 1 - Order_form Form 2 - Booking_Details In my booking_details form, i have a v lookup which links to the order number in Form 1 (Order_form). This is a drop down option where the customer can select the Order number. When a user selects the order numbers, I want the system to fetch relevant date to populate 2 fields in Form 2 . These fields are : Customer_name_bookingform and Port_of_Discharge . In Form 1 ( Order_form), the required date fields correspond to the following
How to Fetch Records for "this month"
Hey! Need some help with a fetch records request. I want to fetch records for "this month" based on a field called Next Occurrence (or Next Occurrence Date-Time, if an actual Date-Time field is required... Next Occurrence is only a date field) Here is the script (which works to fetch the records with the given criteria) KathiExpenses = Add_Expense[Owner == "Kathi" && Category1 != PaycheckCategory] sort by Start_Date; I assume I need to add a criteria of && Next Occurrence == "whatever necessary to
Iterate in a loop based on certain condition
Hi, I want to iterate between from date and to date and do certain tasks on each day increment based on the day of the week. How can I do it.. Pls. help Thanks, Milind Manohar
Access Form Image fields in HTML page using fetch records task
Hi, I have a form for Bikes master with Bike photographs (as image field) and I want to use these images in my HTML page using fetch records task. How can I populate these images in my HTML page. Once populated, I want to invoke an order form when a user clicks on the image. What should be image source for these images as they are somewhere on ZOHO servers. Thanks in advance for helping me out. Thanks, Milind Manoha
Record Summary Alignment/Paragraph
Hello All: I have not used record summaries much to this point and am running into two issues with a proposal form I am setting up. When I set up an image or paragraph to be centered, it is not centered on the page when printed. I selected letter size for the record summary but it is still off. Also, I have a paragraph that is cutting of the last couple of words on each line on the right side of the paragraph. It doesn't seem like it is wrapping the text correctly. Any insight would be greatly
Only getting one record returned in my Page script
Hello, I am having a hard time figuring out this script for a page I am creating. As far as I can tell, it should be returning several values, but I only get one record returned. I am trying to get all the expenses for owner Kathi and show the payee and amount. When I write my script and access the page, I only get the last record to appear in the table. I do not understand. Can you look at my script and tell me what I might be doing wrong? htmlpage expense_test() displayname = "expense test"
Old records
Lets say that we are May 1st. I want to see records that are before April 15th. So I want to see the records before the last 15 days. Is it possible? Thank you
Auto-populate Sub-form Value
Hie , Have Three Forms A, B, C In Form C have 2 Single Line Fields In Form B have 2 Lookup Fields , a1 and b1(Based On Form C) In Form A have Sub-form (Based on Form B) whenever any customer fills Form A with Sub-form ,when value of a1 entered, automatically b1 value will auto-populate How we can achieve this? Thank you in Advance !!
Subform Lookup Field - no search option on mobile device
We have a Creator form which has a Subform. The Subform has a Lookup field linked to another module. That other module has over 800 records. When selecting the Lookup field value on the Web/Desktop interface, user can start typing text and selections will filter based on contains text. But on Mobile device/Creator App, this is not possible? User must scroll and find only using very big list. Please advise if there exist a workaround.
iPhone app does not work
Hello everybody, I use Zoho Creator (great app) and I wanted to also use it from my iPhone. I installed the last version, logged in and ... nothing. The app seems to reset to the initial state (little button to login at the bottom of the screen). Can you help me out? iPhone 7, iOS 11.3.1, Zoho Creator 5.9.4
Send Confirmation Email from Email Address other than zoho.adminuserid
Can anyone recommend a deluge approach (or 3rd party plugin approach) to allow for sending from any outside email address (smtp, etc...) other than from deluge defaults of zoho.adminuserid and zoho.loginuserid ??? Surely there is a method to call email functionality from outside zoho?
Search interface for dummies?... Please?....
I need a simple search interface to allow users to search one field at a time. I've found the "search function" template, I've created a stateless form, I just can't get it to work. I know the field I want to search. I just want the button click script to return records containing a matching term in the field. Maddeningly simple but I can't navigate the HTML and scripting needed. I know it is possible to use the search function in the list view. It's a lovely function. However I need the simple search
Ask the Experts 2: Live Q&A: Find out all about the new Page Builder in Creator 5.
Hi everyone, As you all know, we recently released the latest version of Zoho Creator 5. The update includes features and enhancements that reduced the complexity involved in app building. One of our favorite enhancements is the new page builder. With the new Page Builder, creating interactive dashboards is extremely easy. It eliminates the need of coding in HTML or CSS — users can just drag and drop the elements they want onto the builder. Also, they can customize them by using a range of pre-built
Report with old record
Hi! I want to build a report that shows only the records that the "Last modified date" is greater than 15 days ago. Is it possible? Thnaks
link to live event?
How do I log in to here this live event?
bigint * bigint gives "mismatch of data type expressions found"
Here is my script - ---------------------------------------------------- lineItemsCostWithTax = 0.0; lineItemsCostWithoutTax = 0.0; lineItemDiscount = 0; discountOnAllLineItems = 0; //Get details of the customer in current order detailsOfCustomerInCurrentOrder = Customers[ID == input.Customer]; selectedProdInOrder = detailsOfCustomerInCurrentOrder.Customer_Discounts.Select_Product.New_Product_Name; discForSelectedProdInOrder = detailsOfCustomerInCurrentOrder.Customer_Discounts.Discount_in_Rs; info
Subform field delimiter in reports
Hello. In the previous version of Creator, when I was designing a report with fields from a subform, I was able to specify a different delimiter for each field (with exception of the first one). Now in C5 I cannot find that functionality (it allows me to specify only one general delimiter, not one for each field). Is there a way to accomplish this in C5? And if the answer is "no", is there a way to go back to the previous Creator version? Thanks in advance.
Zoho Creator -- a product catalogue -- image links from Dropbox broken
I'd really like to use images from Dropbox in my product catalogue on Zoho ... so I only need to have one copy of a file for almost every application I use. I've tried adding ?raw=1 to my links from Dropbox to make the image embeddable, but I get broken image links displayed in my report. Dropbox image links are formulated like this https://www.dropbox.com/s/000000000000/test.jpg?raw=1 Is there a way I might be able to get Zoho Creator to display images from my Dropbox in a report? I could host all
Import old version application to Creator 5
I have a working application in old version. I want to install this application in new Creator 5. Is this possible?
How do you auto fill a lookup field based on input of previous lookup field?
I'm getting the following error when I try to auto-fill a second lookup field based on the information I entered into the first lookup field: Error at line number: 2 In Criteria left expression is of type STRING and right expression is of type BIGINTLIST and the operator == is not valid The data I'm trying to fetch is in the Commodity Codes form. The form I'm trying to input the data into is the Contract Summary form. Commodity Codes (form fields) Commodity_Codes1 (Number) Goods_Services_Category1
Printing Custom Reports - Headers and margins
Hi there, I'm developing an app and have a report with a custom printing template to automate the drawing up of agreements for clients. When I save or print the report, the margins and header are not set for any page apart from page 1. Is there a way to correct this? The idea is to generate a PDF in A4 which covers multiple pages. Any suggestions?
Customer Portal
I have created a customer portal with multiple forms & reports and two html pages - one containing an embedded form & report, and the other an invoice template. I have set all the Module-Level permissions to access for the report. The forms and reports can be accessed fine by the customer portal user, but when the portal user hits the html pages - they are prompted for another log-in? One thing of note - If I am logged in as a zoho user in another browser, they portal users can access the HTML
How can I print report from other forms with together
Dear, How can i print report format from other forms with together. eg. I have Fuel, Maintenance together as one report format in Transition -> all Expense Thanks
Fetching data from lookup field third level
How can i fetch third level field when is using lookup field (bigint) I have only use for String format for that field, not bigint. Field to fetch =========== Transaction -> WO_Customer Name Form ==== Customer - Customer Name Work Order -> WO_Customer Name Transaction
Is there a workaround for the date field language limitation on user level?
Hi, I have a client that uses Creator in Mexico. He has the basic user access and multilanguage option for the date field is not available. He needs to show dates in spanish. Is there a way to work around this limitation using code? Thanks
Next Page