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
Using the Migration tool to update records
Hi, I'm trying to use the Migration Tool to update my records, but for some reason it is not working for me. I made a Test application with 4 columns. Emloyeenumber Firstname Lastname Age This application has 4 records. After that i update my excel sheet and add 1 more record and change the age of 1 record. Than I start the migration tool and open the xls file and select "Add data to existing application" After login I select the correct Application, Select the Form. Now this is the confusing part:
Date-Time Pivot chart
Hi, my boss want to see in a grapich, how many "Altas Voluntarias Report" are there between a specific time, so how can i do to create a pivot chart to see these dates in a grapich? These are the date ranges: 6:00 am - 10:00 am 10:00 am - 2:00 pm 2:00 pm - 6:00 pm 6:00 pm - 10:00 pm 10:00 pm - 6:00 am It's no use saying that on my form I have a date-time field
Technical problem with subform, add record form modal and external applications
I've found a very specific bug that's nonetheless necessary to fix. Here's how to replicate it : We have two apps in the same account whose linknames are "v5_bons" and "v5_gestion_inventaire". v5_gestion_inventaire has a form Nouveau_Produit which represents products. v5_bons has a form Bon_fournisseur which has a blank subform which contains a Lookup field towards v5_gestion_inventaire's Nouveau_Produit form. While testing the form Bon_fournisseur, I tried to make a Nouveau_Produit using the "+
Insert image in a Form
Dear Sir / Madam I have uploaded one image in "Image Hosting site" and get a link. but when I tried to attached this image using link in my form thru ADD Notes. it is not showing Image. Link is http://i1170.photobucket.com/albums/r521/shivdutt/05b3d1a3.jpg Please check and advice me, how i can attached images in my forms.
How can i get the zohologinuserid from a global variable?
Im trying to create a page in html free-flow-scripting, and i need to get the email(zohologinuserid) of the person wich is entering to the app, how can i do it?
PSA: `input.dropdown.deselect()` breaks your scripts!
Just a fair warning for anyone who's trying to use the `.deselect()` command on a dropdown/radio field in Deluge on the onAdd -> onLoad action : DON'T DO IT. It is very broken, and almost cost us hours of work. What will happen is, you'll have a script error (if I recall, it mentionned GENERATEJS_JS as the culprit) which will prevent you from loading not only the form, but also the script itself if you decide to refresh your script!!! So yeah, don't do it. Zoho devs, please fix it!
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");
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 ?
Next Page