Code for printing record using a Record Template
I have a Form named "Invoice". On the Report "All Invoices" I created a Record Template to print it out nicely in an invoice format. Is there a way to automatically print 2 copies of an invoice (not generate a PDF, but send it to the printer) using that Record Template whenever a new record is submitted on the Form "Invoice"? Thanks, OV
Loop through days -- more looping limitation
I need a workaround for Zoho's lack of conventional looping functionality. I have a form that asks for a start and end date. The success function will create a record in another form for each day from the start to the finish. I cannot figure out how to make it loop through and do an insert for each day. If I could do a for-next type of loop, I'd simply do: numDays = days360(startDate,endDate) for ( i=1; i <= numdays; i++ ) { insert into ... blah, blah ... } But Zoho doesn't allow you to
Updates — May-Jun, 2019
Hello App Creators, It's been quite some time since we interacted on the upcoming updates in Zoho Creator. We very recently got through releasing all but one from the Apr-2019 list of updates ; it took a while to sort out the kinks in them. We appreciate your active engagement, continued patience and understanding in this regard. That said, we're gearing-up for the next set! We'll shortly be posting about the upcoming updates for Jul-2019. Meanwhile, below are the other notable updates that were
Hide entire subform
Hello there, I'm creating a db for real estate. I created a page "clients" with some general info... I also created 2 subforms. One should be used for the terms of research of a client who is looking for a property (Max price, Min sum ....). The second one for the owners who would like to sell their property (Sqm, floor, bedrooms, floor). When a client is an owner, the system should hyde the subform for the research. When a client is looking for something, it should hyde the Owner subform. I'm using
Custom app Realtor
Hi there, I'm a realtor and I'm actually used a dedicated crm linked to my website. I'm not really happy since it has predefined functions and it's not 100% suitable with my needs. I'd like to know if it's possible to connect the db of my website (It's been populating with my properties and properties of my colleagues with mls system), matching these properties with client requests and send mails in case of matching (If certain conditions happen) with a custom app. I also do need to send mails ie
Calculate Total Revenue according to Branches in Zoho Creator Pages
Hey there, How can I calculate (Sum) total revenue generated according to different branches in Zoho Creator Pages. Any help would be appreciated. Thanks in advance!
Add subform rows to another subform, based on Date
I've a pretty complicated flow to build, hope someone want to help me. I have 2 forms, the New_Retail_Order (form1) and Credit_Card_Expenses (form2) and 2 subforms, Products (sub1) and Orders (sub2). Every time I add a record in form1, if Payment_Method = "Credit Card", a new record in form2 has to be created, and all the products added in sub1 have to be added in sub2. Moreover, when I add a second record in form1, the process repeats, BUT, if there is already a record in form2 for that given month,
Maintenance Schedule
Hello everyone, I am very new to this and I have been tasked with creating a maintenance schedule. I work for a printing company with quite a few printers. We want to make a calendar that shows daily/weekly/monthly maintenance tasks for each machine. I have the generic forms built to input the data, but I am having trouble figuring out how to automatically apply future dates without manual entry. Thank you.
Lookup based on autopopulated field
Hello, I need help :) First I have to select and ''entreprise'' once this is done, i have a lookup field that shows all the ''fields'' i have associated to this entreprise. Then, once my ''field'' is selected, the lookup field ''crop'' autopopulate based on an other form. MY PROBLEM is that once this crop autopopulate, i have a lookup field dependant to this autopopulation into ''crop'' but it doesn't work .. and I don't understand why since the writing is the same (info comes from the same form).
Add field if click a button
Hello, I'm a new Zoho creator use so my question might be very basic.... I need to create a button called " Add link" that, when clicked, shows me an url field. For some records I might need just 2 url fields but for other records also 5/6...so every time I click the button it should show me a new url field. Thanks in advance for your precious help
Custom Function - using Lookup across two apps
Hi all, Looking for some help. We have two apps (Planner and Works) In works I have a form that uses a lookup to get a list of places from Planner. I've created a custom function in planner that will pull the address. But when I am trying to get the address to populate when the right address is selected from the lookup it keeps saying expecting string but encountering BIGINT. I've searched for an answer for a couple of hours and can't find anything that helps. Please let me know if you know how to
Add Subform Data to Main Form for Visualization
Hey there, How can I add subform fields to main form for the purpose of visualization in pivot charts and pivot tables as zoho itself has some limitation for subform data on reports as given on url: https://www.zoho.com/creator/help/general/known-issues-or-limitations.html#Reports_Limitation. How could I get this to working? Any help would be appreciated. Thanks in advance!
How to update record without creating a new one?
Hello I want to update the fields of Test1 and Test2 of an already existing record in the form 'Form1' when the same input of Scan is submitted. So far the existing record is update but a new record is created as well. Is there a way to stop the creation of a new record but only update the already existing one? This is how far I got with the script on success: Variable1 = Form1[Scan == input.Scan]; Variable1.Test1 = input.Test1; Variable1.Test2 = input.Test2;
Add a new field every time a button is clicked
Hi, I'm a new user of Zoho creator and my answer is really basic. Trying to build a database in which I'd like to add new fields when clicking on a button. It's a description of a news and I'd like to add links of this news from different websites. So my form has a text field called news, a drop down called subject and should have a button (How do I create a button?) that when clicked makes appear an url field. Some news might have just 2 links but others might have many more. Every time I click
Calculating average time report on a page from a formula field
Hi Everyone, We would like to see the average time our engineers spend on site working. We have a form they fill in for each site they visit. On this form they have a time arrived and time departed fields. I then run formula field that works out the time they had been on site see below for the formula. We then have a page that details various things. But i cannot work out how to get the average from the below formula field into a chart or panel in a page. Thanks for any help :) (((input.Time_Departed
Zoho creator API error code: 2945, INVALID_TICKET
I'm trying to create sample api web request, but following http get request: https://creator.zoho.eu/api/xml/vms-oxleas/view/Interpreter_Attendance1?authtoken=0e28996e1088baba42fb8dd481eb83d5&scope=creatorapi&zc_ownername=lc.ben Does return below: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <response> <code>2945</code> <message>INVALID_TICKET</message> </response> Status Code: 400 Bad Request Cache-Control: no-cache Connection: keep-alive Content-Length: 126 Content-Type: text/xml;charset=UTF-8
Update New Records and delete old records from Report
Hie , Have 2 forms :- In form 1 fields In form 2 fields ID ID (lookup from form 1) first quantity quantity second quantity option(dropdown) first , second , third third quantity Needed when Fill form 2 ID = 1 quantity = 50 option = first create new record in Form 1 report like And in form 2 report ID = 1
Interacting with small portions of a large form
Looking for ideas to approach this business need: I have a form that holds customer project details, and I want different departments to edit/update different portions of the form. Sales updates customer requirements, Production updates parts purchases, Install updates employee assignments, etc. Right now I have Sales seeing everything and just scrolling thru and ignoring what they don't need. I have Production set up on a separate small form with lots of workflow to update changes made in the
Display records from another form in a report view
Hey there, How can I display records from another form as I have used lookup field on another form to record all the activities and want to aggregate all the fields on a spreadsheet view. But in another form (in which lookup field is used) my records are duplicated for keeping transactions of records to show transaction of a particlar ID. I need to display only distinct records with all the duplicated records on detail view. How can I achieve this. Thanks in advance!
Calling a workflow from a custom function?
Is it possible to run a workflow using a custom function? if not is it possible to run a workflow with an action button? Any help would be great
getURL response handing
I'm not a programmer by training, and am trying to use getURL to import data from an external site via their published REST API. I have successfully executed the HTTP GET, passing the proper parameters, and have the json file returned which I can put into a record, but only as straight JSON formatted text. Now I'm unclear on two things - how do I convert the JSON into XML (assuming that is necessary) and then how do I parse or map the XMLvariables to populate fields within the Creator form? So my
Count the number of weekends
Can anyone tell me how to count the number of weekends between two given dates? The reason I ask is I'm developing a scheduler for orders in production - each job has a certain amount of hours allocated to it. So In theory I have a start time (the time that the last job finished plus the allocated hours = the finish date. But because we don't work weekends, I need to insert 48 hours for each weekend between the two dates?
Page break in record template
i have a record template(landscape) and when the subform record show more than 4 rows, the 5th row will get separated in page 1 and page 2. anyway to make it seperate it after X rows? thanks Jeff
Accessing Record Template through Page
Hi! in Zoho creator, is there any way to print the record template through the page(HTML snippet) I mean if the page contains the data of "Person 1" then I need the exact record template with the same data of "Person 1" by clicking a button associated with the Html snippet
Restrict visibility of custom action (function) in reports
I have created some functions and integrated them into reports as custom actions. Is it possible to restrict which users can access this custom actions? Currently they are viewable to all.
Formula to add fields from SubForm
Hi If i can get some help that would be grateful Basically have a form with number field called "TotalPoints" On the subform i have various blocks being added and on those blocks it has number field called "BlockPoints" Basically want everytime there is a block point added for it to be added to TotalPoints
Correct application development workflow
Hi All, I'm newbie here, trying to develop application for my own biz. in my understanding, Zoho Creator is starting up with Forms (which in the back end converted into underlying Tables). I've made some forms, say Customers-Orders-Products. The way I made is by using Single Line field for a field which I know it will be Lookup to other tables. My thinking that I will change that Single Line field with a Lookup later on after I've created the associated Forms. But it turn out wrong. I got confused
Need Kanban board to manage tasks in a particular record of Zoho creator
Consider an engineering company who designs a car, pre-engineer (Checklist involved), Assemble the car parts and ship the product to Vendor. Between this, there are 70-80 tasks (may be more) involved for several teams. Currently, we do not have kanban view of tasks to manage the operations smoothly and in a quick way. This is much needed feature medium sized organizations.
Drop Down Default Value
Hi, I have a linked drop down box that imports the user choices and I would like to have it show "N/A" as the default value until a user selects a value. Is this possible? Thanks Nick
Dynamically populate conditional drop down on two lookups
Hey there, Is there any method to dynamically populate fields based on two lookup fields as given in the guide here: https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html I have two lookup fields on which I need to have conditional drop down. Any suggestions would be appreciated! Thanks in advance!
Confirmation email from Zoho form goes to junk mail
Hello there, We subscribed to Zoho forms so we can manage the event registrations from there and to map it with our Zoho CRM. However, confirmation emails to the registrants go to their junk mail. Are you able to help please. Melinda
Text cutoff
The app I'm working with has a text input for client email history, but the text box can only hold so much data (about 50,000 characters) before the text gets cut off; some email histories are a lot longer than that, so data ends up being lost. We've implemented a system to create a Googledoc to hold text that doesn't fit, but the system is annoying to manage and we're thinking of phasing it out. We need some way to store large amounts of text (preferably in rich text format) without it getting cut
No option to create a subscription payments via PayPal
Just signed up with Zoho forms, and when setting up my form and followed all instructions here: https://www.zoho.com/creator/help/forms/accept-payments-through-forms.html#Creating_a_Payment_Form I cannot see the following in my From Settings. I was able to do a single payment but no option to check for recurring payments ? Please guide me how to achive this or have you taken that option off ?
Add 2 Default Values To Multi-Select Lookup Field Not Working (On Load)
Hi, I'm having problems setting a multi-select field to have 2 default values on form load. The field is a lookup field with 8 options to select from and 2 of these always need to be selected, as standard. I have approached this many ways but can't seem to get it to work. I am trying to pull the 2 default options through using their ID's and have 2 to set manually. What I have tried: Scenario One: input.field = 123456789; input.field = 987654321; This works, however, it only sets the last ID as it's
Report do not regenerate
am unable to regenerate data in my report. When I select regenerate it is desable and I see the message "Regeneration has been initiated for this report... but never end. Beside, the number showed are wrong I have allowed edit access. Our URL is https://app.zohocreator.com/lepanem/point-of-sale-2-0#Report:VENTAS_DEL_DIA
Any kind of popup in HTML view??
Hello, I have been searching the forums for this and keep hitting a brick wall. I have a permalink HTML view of worldwide meetings that will be searchable by the public. Each meeting record contains a lot of information making it necessary to offer a summary of each one, and allow the public to click on a "More Information" text link for the meetings that pertain to them. I provide a screenshot of my HTML table: I have modified the default List View's "View" link and it works great, except that
How to get user email of the zoho user?
Hi , I have a lookup field that get the user name of the zoho users.[Like Lead assigned to functionality]. Whenever a user is assigned to I want to send a email from the admin user to the assigned to user. How can I get the assigned to user email based on the user name?
Grid/Spreadsheet Style Field?
Hello- I'm new to Zoho Creator and Web App development in general so be nice :^D. I'm really enjoying converting an old FileMaker database I have over to Zoho Creator. Creator is awesome! But here's the question: Is there a way to create a very simple grid or spreadsheet style field? I use this to quickly capture 'to dos' inside a database I have. I'm enclosing a picture in case it helps. It looks like I need to create a separate form and then add it to my main database as a subform, but I could
Create Invoice with 2 or mor lines on Quickbooks with Deluge
Hi, Do you know how to create an invoice with 2 or more lines on Quickbooks from Zoho Creator with deluge? I've tried many times, but when I add a text variable to a map variable like this: Invoice = map(); Invoice.put("Line", TextVariable); The map variable ends up with a lot of "\", and I can't do anything about it, even after removing the "\" with replace all because it ends being a text variable. Thanks.
Total items selected in mulit select field
Hi all, Sorry I think this will be a really easy question to answer. But I can't work it out. I have a mulit select lookup field called schools. I want to use a formula field to calculate the total amount of items that have been selected. Thanks in advance.
Next Page