Zoho Creator Application is Crashing on Android
Zoho Creator is awesome on my Apple Device. My colleague's Samsung Galaxy S6 is crashing when using the Application. Images are undersized and and will not enlarge when I press on them on his Samsung. This has provided me with a great deal of fuel to tease and ridicule him for not buying an Apple. I was wondering if the Application has a history of being unstable on Androids and if an update is coming that will rectify this in the near future? Thank you for your help. We are very pleased with Zoho
Problem duplicating / downloading ds files
Hi Zoho, When I click on "duplicate" on my dashboard to duplicate my app, I get a notification "duplication" but then it dissappears and nothing happen (no duplicate is showing). Ravid
Criteria for 1 record associated with 3 forms
Hello! I have to manage event information, and I have been struggling for days on how to develop a script that pays contractors for each event in a certain way. I have 3 forms ADD (contains info about event. Ex: date, type of event, contractors, etc) Contractors (adds a new contractor) Pay_Contractors (a form that pays the contractors for each event) I created a custom action button for the record summary of ADD. I would like to openURL for each contractor that is assigned to the date of ADD, AND
Drop down picklist populated from web page or google sheet
Hi there, I am experimenting with Zoho Creator to build a very simple physical asset library, and am new to Zoho and don't have any development skills. So any advice very gratefully received! I want to check physical media in and out, and to attach some basic details on an online form. One choice that I want available when filling out this form is a 'project' to attach the record to. The project numbering is defined from a project management system (Teamwork). A list of projects can easily be viewed
Edit bidirectional relationship form
Hello! I have created a bidirectional relationship between 2 records. Every time I click on the bidirectional link, I see the record but it doesn't let me edit it. How can I click on the bidirectional link, then edit the record that the link shows?
Pass values to pop up form after success of previous form
Hello, I have a form that pops up after the success of another form. How do I pass the values to the pop up form from the previous form? Ex: In the main form, I enter 1/1/2017 in the date field. After submitting the form, a pop up form appears and in the date field of the pop up form the value = 1/1/2017.
Zoho Creator tutorials
This looks like a good tutorial: https://www.zoho.com/creator/help/images/intro-to-deluge-workflows.pdf Wonder where are the other comprehensive Deluge/Zoho Creator tutorials? Thanks.
Filter for openURL: #View
Hello! Is there a way to automatically filter a report when opened via openURL:#View I am trying fetch_record = <fetch criteria> openUrl("#View:Report_Link?Event_ID=" + fetch_record.ID , popup window) but this opens the full report with all records.
URGENT Again. Account access restricted?
Hi, I logged on today and found the surprise that I can't see my applicatios but rather see what has been shared with me or my groups, as if I was not the account master/owner....??? all applications I did not share I now can not see.. Please clarfify this to me as soon as possible. Obviously as well I can't edit my own applications!!! the account I have been using: cncdelgolfo@gmail.com (nickname: practicorte) the account supposedly owner of my applications: yaxche (an old nickname) thanks for your
FYI: Certain file paths on Mobile Form image upload on mobile published form fail and force Zoho Login page
When we try to save a record with an image field where we browsed the local file system for photo from the following folder name /storage/emulated/0/Pictures/IMG-766471916.jpg Saving of the record fails in Zoho and forces the log in screen. If we rename the pathname to the following, it works. We have changed “Pictures” to “test”. /storage/emulated/0/test/IMG-766471916.jpg Simply moving the image to another folder seems to work as well.
Fetch values of current form to fill values of a new entry form within
Hi, I have a form called ADD with a date field Date1. And in ADD there is a lookup field to a Create Invoice form. In Create Invoice there is a Date1 field. When I click "Add New" in the Create Invoice lookup to create a new entry, I would like the Date1 field to equal the Date_of_Event field from ADD. How do I accomplish this? (Date1 and Date_of_Event are both date fields)
Need to be able to print in the form of a "citation" or "Ticket"
Hello everyone. I have a project in which a small municipality would like to be able to log, and print and track parking tickets. I'm new to Zoho Creator, but have used similar platforms. I am able to build the form that I want, but I just can't figure out how to make it print with items such as a heading, instructions, etc. (Things that would appear on a normal parking ticket). I have attached an image of a generic parking ticket. I would ideally like to have the same format. The large "PARKING
Can a Zoho Creator Form or View receive an HTTP POST?
I have a requirement to integrate a payment gateway where the payment gateway calls my application URL to send the payment information as an HTTP POST. I know an HTML View could receive custom parameters in an HTTP GET via query string parameters. Can HTTP Post be received on a Zoho Creator Form/View? Regards Moiz Tankiwala Smart Training & IT Solutions
Zoho Creator freelancer
Hi everyone, Looking for someone to assist me with Zoho Creator app that is already establish but need some fine tuning. Willing to pay $5-$7 per hour. Regards
Multi-Currency Multi Currency Zoho Creator
I want to insert an amount and select the currency. Then I want the date-exchange rate for that currency converted automatically to USD in another row. Please help
HOW TO INTEGRATE PAYPAL INR
HOW TO INTEGRATE paypal in Indian National rupee as there is option of dollors onlys
Calendar Report
I have attached two images. One is a screenshot of my calendar report. The other is the display after clicking on a name in the calendar report. As you can see, when I click on a name, the result is a blank screen. Why is this? Shouldn't a summary of the record be displayed? Thank you, David
Using postURL to access Zoho Invoice API
I need to add a receipt file to an expense in Zoho Invoice, which does not appear to be available as an option in the standard deluge script. I've written a function to use the API for Zoho interface, but cannot get the postURL function to work. I am able to get the getURL to work properly, so there seems to be a formatting issue with the postURL function. string invoicefunction.add_receipt() { true_var = true; customer_id = 485465000000073061; account_id = 485465000000082151; expense_id
Related data in reports
Ok - I've looked into documentation and forum responses here, and it seems like this might not be possible based on posts like https://help.zoho.com/portal/en/community/topic/combining-multiple-related-data-on-one-view-in-creator , but that was from a few years back so I'm hoping things have moved on ... Supposing I'm modelling Departments and Persons. Person is used in the app in a number of ways. Departments can have a number of Persons. So, on the Department form is a subform allowing a number
Using Google App Script to send emails through Gmail
Has anyone done this? I have scanned the Google Apps information and it looks like there are APIs for Gmail and one can use the Script Editor to create an App which can then be called using an simple URL. From Zoho Creator, I want to be able send emails with attachments (possible) from Gmail. This way they will appear to come from my domain and will appear in the relevant threads when viewing messages in Gmail. Has anyone done this?
Add number fields only if not null
How do I add number fields that are not null? So far, I have script that adds number fields, but I keep getting an error message when some of the fields are null. input.Total = Amount + Amount1 + Amount_3 + Amount_4 + Amount_5; For example, if Amount_3 is null, I will get an error message. I do not want to add 0 to any fields that are null. If they are null, I would like to keep it that way. Is there a way to only add fields that are not null?
To duplicate a row and refer back to original row
I wanted to have a simple script to duplicate a row, but the duplicated row has to refer back to the original row. So a new field called ORIGINAL_ID is created to hold the value of the ID of the original row... is there a generic ZOHO function to duplicate a row and then I can customize it?
Multiedit rows (cells)
Hi. I have spreadsheet (form) with square of landplot. I want to autofill another columns in this table with "size" of land plot. (if square < 1000 sq.m then size = S; if square > 5000 sq.m. then size = XL... etc). Is it possible? i wrote field action for report: if (input.Square < 700) { input.Size = "XS"; } else if ((input.Square >= 700) && (input.Square < 900)) { input.Size = "S"; } else if ((input.Square >= 900) && (input.Square < 1100)) { input.Size = "M"; } else if
Customer Portal Profiles/Permissions
Hi, I have 2 profiles setup for the customer portal. I have separate reports(same form) that should only be accessed based on the profile assigned. Under "Restrict Visibility" settings of a report the only option is to share with "All Customer Portal Users" - Is there a way to only share with a particular profile? Thanks, Damien Cregan Hire an Expert
Re-calculate Form if Drop Downs Are Changed
Hi, I'm trying to get a form to re-check if a user changes the options, so it can re-calculate. I can get it to work the first selection, but if they go back and change a selection it doesn't recalculate. e.g. I'm adding the Days Approved + Approval Date = Review Expiry Date Here's what I have that works first selection, but not when you change your mind if Days_Approved1 = "7" { input.Review_Or_Expiry_Date = Approval_Date.addDay(7); } if Days_Approved1 = "14" { input.Review_Or_Expiry_Date = Approval_Date.addDay(14);
Application Developers
We are looking to hire a Creator developer to build a custom application for loan processing. Where is the best place to go to find someone? Or are there any off the shelf applications for sale?
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");
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..
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
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)
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.
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
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.
Next Page