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.
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?
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 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");
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
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.
19-digit number replaces the original data in report column
Hi An error has shown up yesterday in a report. Instead of the proper data - in this case the name of the assigned caseworker ("sagsbehandler") a 19-digit number shows up. Same goes for the assigned consultant (konsulent-kontaktperson). When I group the colums by caserworker or consultant it will readily display the name but not when they are just data in a column. Please have a look at the attachments. I thank you very much in advance for your help. Best regards Thomas
to populate a subform based on a form
Hi, I have a form named "inventory" with product_name and quantity. I would like to have a new form named "inventory entry" with a subform that populate each product_name in order to fill the new quantity to add. How can I do it? Thanks, David
Free form Deluge code displayed differently than it is saved and executed. Subsequent edits cause errors.
First example: If I switch to Form Builder view and then back to workflow view, the line: lstAnswerChoices = recAssessment.subAnswerChoices.ID.getall();is changed to: lstAnswerChoices = recAssessment.subAnswerChoices.getall();If I then try to save without making any changes I get an error. Second example: If I save the following line and navigate back to the function, it is displayed without the first set of parenthesis which returns a completely different result: strDisplayName = (rec.rtfQuestion
Can I create an App to calculate Selling Prices?
I want to be able to calculate selling prices for Items in Zoho Books/Inventory, based on a number of factors including: - The buy price in currency - The Currency Type for a Vendor - The exchange rate - etc Can I create a Zoho App using Creator to do this, perhaps triggered by a custom button in Zoho Inventory? John Legg Owner: The Debug Store
Next Page