Zoho Books Integration Change Maximum Per Page
Hey guys, I have a Zoho Books Items integration in my Zoho Creator app. I have around 300 items in my Zoho Books, but the request is only getting up to 200 per_page. How can I change this maximum? Or how can I change the number of the page on the request? Here is code: myMap = zoho.books.getRecords("Items", "123456789");
Need to add a Unique Reference number to my form.
Hi Guys Hope someone can help. I need to add a field to my form that has a uniquie reference number i.e DBT0001. The form will mostly be captured via the 'submit form through email'. Am new to the system so any help would be appreciated. Thanks Chris
Allow developers to save changes to Reports
Here is another restriction I would like to see removed if logged in as a developer. In live mode if there is a change to which fields are hidden/shown the developer can only save as a New View. Since there is no option in edit mode to hide/show fields only the app owner can make these changes. Either include the ability in edit mode to hide/show fields or allow the developer to save changes in live mode.
Formatting a sub-form - help needed!
Hi I have a form into which I need to insert another form (ie as a subform). This second form has six fields, however when it is inserted as a subform I only want to display two of them. It seems that this can be done using CSS (see https://help.zoho.com/portal/en/community/topic/subform-formatting). Can anybody give me some suggested code for this, and advice on where to place it? Just use any form and field names you like; I should be able to tweak it to suit. If it works I'll make sure to report
Custom action to duplicate a row
I have a custom-billing app with a form with about 50 fields. I need to sometimes duplicate a row, but reverse all numeric fields to be the negative of each value -- essentially if the original line is a billing line then the duplicated line is a refund line. How can I write a custom action to place a button on the report to achieve this? Thanks!
I literally need to hire someone to manage customer portal report visibility...
There is a major flaw in Customer Portal and Restrict Visibility on Reports! Currently we will need to hire someone to set up users individually... it's crazy... Our application has about 75 Forms and a whole lot more reports. We have one form that makes up the majority of every record in our system. This form has 30 different views and growing. These reports are used with all sorts of different people in our organization. We are trying to use Customer Portal with 3 different groups including: Clients,
Set value of field in task + Convert simple SendMail task to Custom Action on report
Hi All! Hope someone might help me on this. I have a form called “New_Services” This form has 2 equal functioning tasks placed at: 1) OnAdd+OnSuccess 2) OnEdit+OnSuccess The task performs a very simple script The form has a dropdown field with 3 options. When the user selects option 1: “if” dropdown equals “choice 1” then “SendMail” (the SendMail gets the “to:” field from a lookup to:Driver[ID == input.Driver].email_driver) And displays a “success message: email sent” When the user selects option
Determine which record was duplicated from On Success workflow
There is a duplicate button on reports and if you duplicate a record, the On Validate and On Success scripts of the form will run. How do I determine the record that was duplicated from within the On Validate and On Success? I'd like to determine the record that was duplicated because I am using subforms and then those subforms have subforms of their own. Only the first level of subform records is duplicated with the Duplicate button and I'd like to duplicate the rest using code..
Navigating to a page after deleting some records
Hi, I want to refresh a page after deleting a record in the embedded report. The delete option works fine in the report. But I have written openUrl("link_to_navigate","same window") in on Success of Delete action. But it is not working, after deletion the page is not refreshing. Please give me some suggestions to solve this problem.
Adding rows to subform using script
Hi Zoho, I have a form, stating term length in years (for example, 5). In the subform I have two fields: "End Of Year X" and "Amount". I'd like to have rows added to the number of the terms length. (5 years = to have 5 rows, without the user having to add / delete). I Could not find an "Add Row" syntax.... How can I do this? Thanks! Ravid
I am looking for scheduling a daily import of an Excel Sheet into a form.
However, when I try to import it via the following options the subsequent errors are being displayed: Zoho-Migration Tool: After importing the data to the tool, when I click on Upload to Zoho, each time I try to enter login credentials it shows invalid username /password. This despite me rechecking the credentials multiple times. Could this be because this feature is not available in my Professional Plan? From the Command line console: the error being displayed is: "Cannot Import database: It is
Additional Records gift!!!!!
As I can see Zoho Docs surprised us the last week giving us a huge gift. https://help.zoho.com/portal/en/community/topic/get-more-with-what-you-already-pay-20-2-2017 Hopefully we would like a gift from Creator...Especially for the number of records...Then I will love Zoho more than now...
Set Expiry Time of Web Content ...
Hi: I have a Stateless Form (let us call it myForm) that looks for the value of a parameter (let us call it param1). 1) When I enter this in the Address Box of my Browser ... http://creator.zoho.com/scriptedlogic/myApp/#Form:myForm?param1=123 ... I correctly receive 123 as the value of input.param1 2) If I follow this up with ... http://creator.zoho.com/scriptedlogic/myApp/#Form:myForm?param1=12345 ... I correctly receive 12345 as the value of input.param1 3) But if I follow this up with ... http://creator.zoho.com/scriptedlogic/myApp/#Form:myForm
Reference a single script for several different events?
Hi, I have a script(Same script) that needs to run during several different circumstances (onload, on edit, on user input,etc..). Right now I have that script in 4 different places to run when various actions take place. Is it possible for me to write that script once, and reference it when each of these different events take place (onload, onedit, on userInput) ? I thought maybe a customFunction would do that, but when I wrote one, all it did was give me a button to press to execute the function.
custom action - delete entry
hi! how to make a custom action to delete an entry? there will be a button in report.
Create Invoice in HTML view or page with information from form
Hi! Is it possible to generate an HTML view, that looks like can invoice, with autofilled fields from the ID of the form that I am filling our/editing out? I would like to have a button on the form that will pop up a page or html view in an invoice format with all the information I created a PDF of a blank invoice template, is there anyway to convert this to an HTML view? Or can I drag and drop fields to create a view or page that looks like an invoice that I can print?
Create relationship between Form / Subform after import
I have imported our customers and their addresses from 2 separate files into zoho creator. I now have two forms: one customers and one addresses. I have defined addresses as subform in the customers form. What I haven't found out however is how to restore the relationship between customers and their addresses. The data was in an access db before and relationship was through a primary / foreign key 1-n realtionship. Thanks for any hint on how to achieve this (also by deluge scripting, if necessary)
No signature field in Stateless Forms?
Hi, I need a signature field in my stateless form to update it to my old report. For example, i have an order from a customer. And having a signature field in order form., I want my customer to be signed in the form when they received their orders. Thanks, George
Update iFrame with parameter when I click record
I want to create and HTML page with a report widget up and an iFrame with parameter bottom. When I click on a record I would like update iFrame bottom with a parameter that is a field of clicked record. In alternative could be a button in every row with a custom action that update iFrame. Any idea? Best regards Maurizio
Zoho Developer Wanted
We are looking to develop an cloud based app that allows our business to manage our client projects across multiple devices. We have a team of project managers that need to collaborate on keeping projects moving forward and this app will allow for projects to be tracked and modified by multiple project managers. We already have a design partner, we are looking for a development partner to help us build the idea. If you think you can help please reply.
zoho creatoer developer wanted
I'm looking for a zoho creator developer to help create a standard pdf report with a table of contents.
file upload size limit
Can I set file size limit for upload fields? This is very important as in my application, some users have uploaded monster files, and it wastes a lot of storage space as well as ruins download speeds. Thanks.
Embedding filtered report in Html page
Hi , I am looking to embed one report into html page but want to include only 2 columns of that report and records which have bookin date as today only. Please let me know how to achieve this . regards Anubhav
Default entry of today's date?
How can I make a date field produce a default date entry of today's date? Thx
download my Creator
Hi Is there a way to download what i have created on Creator? I would like to download my app in order to protect it in case of loss is it possible? If not how can i protect it ?
limit of fields
Hello the world is there a maximum quantity of field per form? because i can't add a new radio, the field is "adding" forever only the checkbox is adding well is that normal? thank you
Startup form
Hi! I was wondering if there is a way to change the first item that opens when accessing my application. Currently when I access my application for the first time of the day, I am taken to the first form I created. This is the main entry form but I have built a dashboard and would like that to be the first thing seen when accessing. Thanks in advance.
Confirm submission option for stateful and stateless buttons
Changes to data that have large consequences should have 2-factor confirmation. It would be useful to have the option to enable a 'Confirm Change' for buttons in both stateful and stateless forms. The button editor could have a toggle to turn confirmation on/off along with a text box to configure a custom message that would display in the modal confirmation dialog presented to the end user. The modal dialog would have 2 buttons: OK and Cancel.
Auto populate
If we have a "Start" Date/Time Field, how can I auto populate the "Finish" Date/Time Field on entry of the "Start" Date/Time Field in the same form as a default value to allow me to then edit the "Finish" Date/Time Field?
Add amount every time form is submitted
Hi! I have a report of contractors and I also have a form to record each time I pay them. I would like to see the total amount paid on the contractors report. Below is the Pay_Contractors form And this is the report of another form called Contractors I would like to see the total amount paid for each contractor. How do I accomplish this?
Adding line breaks in Chrome, Firefox, IE, Safari with Rich-Text troubles
Dear ZOHO, The Rich-Text fields gives me a lot of trouble. When I try to use the data of these fields, it depends on the browser whether or not line breaks <br> or </ br> are added to the field. This makes it currently undo able to use the content of this field in html-page views and the like. It seems that depending on the browser, creator adds <br> and/or <DIV> elements to the field or not. Chrome adds <DIV>, Firefox and Safari do not. I cannot tell what IE does because it will not show the RichText
Simple way to track rent received from tenants
Hello, First off, I'm totally new to databases, forms and the terminology so please bear with me. I manage a property with 50 tenants. I'm trying to create a way to have a list of current tenants that includes name, site number, monthly rent amount, and what they are paying for. I then need to be able to track the date we received their rent, amount received, payment form (check, cash, credit) and their rent paid through date. Some people pay multiple months in advance. Then ultimately an easy
How do you make a custom theme in Zoho Creator?
I've tried to look up how to make a custom theme in Zoho Creator, but all the answers I'm finding are for the old layout. It says that the "custom theme" button is under settings > customisation, but I do not see it. How do I make a custom theme in the new layout? Thanks in advance.
How do I parse JSON to use variable? toMap and getJSON are confusing...
Hey Everyone! I would love some help with this. I'm stuck. I have the following JSON. { "result":[ { "bearing":-1, "currentStateDuration":"00:53:14", "exceptionEvents":[ ], "isDeviceCommunicating":true, "isDriving":false, "latitude":34.9946861, "longitude":-106.659889, "speed":0.0, "dateTime":"2017-03-02T19:31:44.000Z", "device":{ "id":"b1" }, "driver":"UnknownDriverId",
Pass dates to OpenURL
I am trying to create a stateless form that has two fields a Start Date and an End Date. The idea is to pass these dates to the OpenURL and generate a report based that includes all the dates between Start Date and End date. but when I follow the example on the functionality based URL's, my report does not filter the unwanted records out. openUrl("https://app.zohocreator.com/notjustanothername/order-management#Report:ALLORDERS?Order_Date=input.Start_Date;input.End_Date&Order_Date_op=58","same window");
Need help with rule criteria for checkbox
I need help with a rule creation. I have a check box field for yes/no. I then have another field that I want displayed if the check box for yes is checked. I understand that the criteria has to be set as true for yes. but I'm having trouble seeing where and how to set that. Under the criteria section I have selected the field name, but under the operator menu I see the choices as EQUALS NOT EQUAL TO STARTS WITH ENDS WITH CONTAINS DOES NOT CONTAIN How do I set the criteria for a TRUE or FALSE? And
Rich text fields in Subforms
Hello. When I create a field in a subform, I get the following type options: As you can see, Rich text doesn't appear as an option. Is there an alternative way to use Rich text fields in a subform? Thanks in advance.
What does it mean "Error at line 0"?
Here is the function that I wrote: map externalapps.GetCurrentSymptoms() { symptomMap = map(); for each Symptom_ID in Symptoms [notContains(Symptom_Name,"Deprecated")] { symptomMap.put(input.Symptom_ID,input.Symptom_Name); } return symptomMap(); } When I try to save, it gives me this error: Error at line number : 0 Mismatch data type for function 'put' at argument index 2 expected data type STRING found data type SymptomsI don't really know how to debug this one? Symptom_ID
Display Image from Another Form.
Good Day, I created a form with an image and on my second form, when I select the product, I would like the image to display. Please advise. Thanks Safraz
Prevent duplicate item on same date
Hi! When I am adding a new record, I would like my dropdown menu (that is in the form) to grey-out the items that are already recorded on the same date as the field in my form. In other words, I would like to prevent an item being double-booked on the same date. How do I do this? I would like for the dropdown of "Facade" to grey out any other items that are being used on the same date. The date is in "Date of Event". I should also mention that "Facade" is a lookup field.
Next Page