Report based workflow
Hi there, I often find myself wanting to create workflow based on reports instead of forms. Here are some examples: - On-Create of a new record from Report A, assign default value to field1, field2, field3. On-Create of a new record from Report B, assign different value to those fields. - On-Create of a new record from Report A, hide field1 and field2. On-Create of a new record from Report B, don't hide those fields, or hide other fields. - On-load of Spreadsheet report, disable field1 and field3
Integrate Zoho Creator with Contact Form 7 (Forms: 3rd-Party Integration Plug In)
Hi there, Has anyone successfully integrated a Contact Form 7 on a wordpress site with a Zoho Creator form using the Forms: 3rd-Party Integration Plug In? I believe it is possible from some comments on the wordpress plugin page: https://wordpress.org/support/view/plugin-reviews/forms-3rdparty-integration I have a paid Zoho account, I have published the form within Zoho Creator & I'm using the public URL link within the Forms: 3rd-Party Integration Plug In. I would like to set set up the form on
Clear subform B particular row when decision-box in subform A is unchecked
Form A has 2 subform's, subform A & B,subform B is copy of subform A except few columns. When successful-EDIT entry is done both have same data.Problem is that when a checkbox in unchecked in subform B onEDIT -> onUSERINPUT , I can't user clear() to remove that particular row in subform B( having same data unchecked in subform A) i tried below example also but it did't work : fetchedRecords = Employees [ Date == today ]; for each rec in fetchedRecords { rec.Job_Experience.clear(); } How can i achieve
Tip 22: How to allow employees to check in and out, and then automatically calculate their total work hours
Hi everyone, Keeping accurate track of employee hours is crucial to smoothly running business. So this week, we wanted to go over how you can automate this whole process using Zoho Creator. With this tip, you'll learn how to set up a page that will make it easy for your employees to check in and out, and help you track their work hours on a daily basis. To do this, let's create a sample application called Attendance App, and show you how you can use it to track the total work hours of each of your
Customize detail view links (click to WhatsApp)
Is it possible to customize the detail view to include links in certain fields? For example having the phone number link to start a WhatsApp (wa.me/phonenumber) chat instead of dialing. Or linking a field like invoice number to take me to a different report on my app. I know it's possible to make custom record templates but these are used for printing and saving to PDF. I am looking for a way to customize the actual detail view while viewing a report.
Sub-Form Entry Sorting
Hi: Is there a way to sort the order in which sub-form records (entries) appear on the parent form by a field other than the modify date? Case: I have a customers form with a contact log sub form that has a date selector date field. By default each entry in this contact log form appears on the main form in order by the date that the sub-form record was entered. Instead, I would like them to appear in order of date per the date selector field. Thanks
PDF file be imported and converted as a report and read as a spreadsheet in creator app?
Hi We have a query from a client, a file they receive as a pdf file be converted as a Report in Creator App and be converted as a spreadsheet? is it possible? if so kindly explain. Regs Sathya
SMS Invoice
Hello, Can i send Invoice template which is generated from Zoho creator in sms using a url?
Creator/Books Integration
Hello! I'm looking at moving one of my Filemaker apps to Creator. The app is a computer repair tracking program. We are going to be using Zoho books, and I want to integrate the new creator app with books. I'd like to have the following: A dropdown in Creator with all of our contacts from Books When a new repair RMA is created in Creator, it creates a new Estimate in Books. Is this possible? From the API, all i've seen for the contacts portion is to search by ID number, or by name. I dont seem
Time is export as 24hr format instead of 12hr
Is there a way to get the time to export as a 12hr format like I have it in my report? In my report the time is entered as 12hr but when I export it shows in 24hr format. Is there a way to change this? Images are shown below. Thanks.
Sprint API (Self Client)
I am currently creating a creator application that will automatically get a Sprint, create a Sprint, etc. from an API of another website. Now, in the developer console, I was given the option to add a client. I selected, Self Client. I then generated a code using this. But when I tried to use it in my function, I get this result. Can you tell me where I am getting this wrong? Provide me an example or any guide that will help me make this work. Thank you.
error on script deleting record of related table
I have two forms: Purchase which logs company purchases, and Cashflow which shows the cash balance of the company. when creating a purchase,if a decision box called "add to cash flow" is checked, a new Cashflow record is created with the relevant details. Purchase also has a lookup table to the newly created cashflow record. when the decision box is unchecked, or the purchase record is deleted, i want the associated cashflow record to be deleted. I know a bi-directional lookup might assist but
Error handling
On occasions, running scripts produces errors (e.g. incorrect email address format in sendmail). In contrast to the Execution error popup, is there any way of trapping such script execution errors and reporting them in a controlled way? Other languages support 'on error' type traps; is there an equivalent in Deluge?
List with Accept reject and details button in Zoho creator
I am trying to create a List in Zoho creator (Form, page) with a details button which redirects to another page. But I cant find how to create a list with buttons. I am a new user so I don't have a complete idea, Please help. Thanks.
How to calculate a "check digit" at the end of a reference number
Hi, please can you assist me with the the following: I want to create a formula that will calculate a "check digit" at the end of a reference number ie, similar to credit card numbers. The algorithm that I'm using is the Luhn Modulus 10 Check Digit and works like this: 1. I need 14-digit reference number (I will create this using the auto number field in Zoho Creator) 2. Reverse the 14-digit reference number ie. if original reference number was 246810 then the reversal will be 018642 3. Double each
Form Email as part of a Google Group
Not liking the random and unfamiliar email address that was assigned to our form (accountname-123@forms.zohocreator.com), we made the form email address a member of a Google Group (easytoremember@company.com) This worked a few times but then stopped. Directly emailing the form works. Forwarding from a Zoho Mail address (easytoremember@zohomail.com) works. But emailing through a Google Group does not. Creator Support is looking at this, but I'm curious if anyone else has tried this and succeeded.
Page Snippets
Hello, Is it possible to create charts using html snippet or ZML snippet in Zoho Creator Page?
List Form Fields API missing data
Using the Rest API: <form method="GET" action="https://creator.zoho.com/api/xml/sample/forms/fields"> returns all the form fields metadata, except nothing is returned for the 'Name' field or the 'Address' field. Is there any workaround for this?
about zoho creator
dear developers, i checked zoho creator for the first time today and was quite impressed with its features , as i am businessman i am always in need of technology helping me to keep my workflow as simple as possible , in zoho creator i found readymade applications for many business but i didnt find one for salon mangement, i tried developing it from scratch but found it quite difficult as i am a non-techie person, so i request your team to develop one readymade template app for salon management
Subform as a pop-up
Hello, is it possible to change the Subform UI ? As my subform contains too many data so it is very inconvenient to drag the data horizontally back and forth.
Zoho Creator Manual
I have searched and can't find a definitive answer. Is there a Creator manual that can be downloaded or purchased (other than the Beginners Guide) or is all the documentation web-only?
Few issues with fetch. I've gotten too complicated I think.
Form A records a product description, barcode, price at time of capture and the store it was purchased at. Store Name is a lookup field, then two single line fields and a currency field. Form B is a stateless form that when a barcode is scanned checks to see if a record exists. If so, it displays the highest price recorded, lowest price recorded and product description. I want to add in a fetch for the store where the lowest price was last recorded, as well as a fetch for the store that most often
Autopopulate subform based on other subform inputs
Hello, I have the following forms and subform: Purchase Order Form Subform X (items in packages) Subform Y (Items) Total SubForm_X (items in packages) PackagesNameX (lookup field from Packages_Form.PackageName_p) Subform_Y (Items) (*)Material_Y (#)Unit_Y (#)Price_Y Quantity_Y Subtotal_Y ———— Materials_Form Material_M (#)Unit_M (#)Price_M Packages_Form PackageName_p Subform Z: (*)Material_P (#)Unit_P Quantity_P (*) Is a lookup field to Material_M in Materials_Form. (#) Fetched from Materials_Form
Page + HTML
Hello, Here's the scenario, Following Table is i am trying to achieve in page using searchString: Design No.: Shade No.: Quantity: 55830 250 100.00 56459 Blue 50.00 But i am getting the result as follows: Design No.: Shade No.: Quantity: 56459 Blue 50.00 55830 250 50.00 55830 250 100.00 Following is the code i used: <%{ Table = "<head><style>table {font-family: arial,sans-serif;border-collapse: collapse;width: 2px;}td, th {border:
Migration Tool
Is there an updated version of the migration tool available?
Labels for Workflows
Could we please get the option to label workflows - I have some that contain 5-10 different functions and I have to go into the codes to work out which is which
Lookup-Field-Search as parameter for reports
Hi there, I love the functionality Zoho Creator is offering, its awesome! One thing I could figure out properly (probably because I'm not using the correct search terms), is how to do the following: I want to have one page with a big variety of lists and KPIs, but all the underneath data should be filtered by one criteria. I figured out, how to pass the searchstring from the search widget to reports, however the search is not the best option to provide the criteria as it is free text field. I'd basically
Are you able to add ASAP widget into a Zoho Creator Application?
I am creating a custom application in Zoho Creator. I thought it would be really cool if I could add an ASAP widget into that application so I am able to create articles on how to use the custom application. More so, it would be cool to the ASAP add-on to other Zoho applications so I am able to provide training documentation for my company in a separate internal application using a separate help center. Doesn't appear possible at the moment but I thought that would be a cool integration when Creator
Integration
Hello, Can we Integrate Zoho forms and Zoho Creator?
Weird border when printing HTML pages?
Hi all I'm sure there's an easy solution here. Whenever I print a Page, a grey border appears around the body (see attached). Strangely, I have a couple of Pages that do not have this issue, yet I don't think there's anything different between them, at least in the script builder. Anyone come across this? Thanks!
Grid View no longer working properly
Hi there, We're having issues with Grid View on Zoho Creator. We have an attendance register that has a dropdown for each field to select the register code. This has now stopped working and doesn't show the drop down menus. Can someone please help. Occasionally if you mis-click you sometime see the dropdown. Have tried different browsers, screen sizes etc. But the problem remains. PS We're using the old version of Zoho Creator and cannot see a way of upgrading it and whether it will work with our
Creating Multiple Records (tasks) from Form Submission
We have a community event where we offer services. Customers come to our booth to purchase the service. The event is about a week-long so when they come to see us they typically purchase more than one service. I'm new to Creator but my current set up is: Attendance List List of attendees, contact info and site location of where they're located on the grounds (we obtain this form the organizers) Service Request Lookup field showing "First Last - Site" 8 Checkboxes, one for each service day. Formula
purchase system
Hello there, I'm working on a system of purchase Below the form i'm using. Everything works well and i receive the orders like this: I was wondering how to get stats of how many of each item were ordered by month ? Any way to do it ? Thanks for your help.
getTime function not working
I'm using the 'getTime' function in a Creator app but when I save it I get the error "Not able to find getTime function". I'm trying to use it as a function instead of a method. The latest documentation here states that I can use it as a function. As shown in the code snippet. <variable>=<dateTimeValue>.getTime([<format>], [<show_seconds>]); (OR) <variable>=getTime(<dateTimeValue>,[<format>],[<show_seconds>]); Do you know why it might not be working?
Error - WebhookCallWarn
What does this error mean? I cannot find anything on the internet about this. It's a very unhelpful error message. This is the code that it refers to the line has been marked: folders_res_0 = invokeurl [ <this line> url :"" + base_egnyte_url + "/v1/fs/Shared/BKNG-" + input.Auto_Gen_Booking_ID_Number + folder_name + "" type :POST parameters:parameters_for_folders_map.toString() headers:headers_map ]; It came after I created a function that did a call to an api. I don't know why it'd
Can you add files for download on your app?
Hi there! Just want to say what great customer service ZOHO has, I had an issue yesterday and within an hour it was fixed! Great service and friendly employees! My question is, can you add a page where clients could go to view and download PDF files? I have monthly files for each of my clients and would like them to enter the app go to a page let's call “files’ for now and be able to download the current months file and see past monthly files? I feel this may need some code which I’m not to clued
Custom actions in report header - get selected records
I have created a custom action for a report with a. Display Type - Show action in report header b. Execution Type - Execute action for collection of records. I want to write a custom function to take some action on selected records in the report. For eg. to send a mass sms with the selected to records in a single call. I would like to know how to get the selected records. Is this possible? Any example?
hotel booking/reservation template
Please create a template for handling reservations and bookings please! thank you! Dennis ddaniels
I have a long form and want to break it up in creator
I have a 300 question form I need as a customer input form in an app I want to build in Creator. Obviously, I want to break up the long form into a series of shorter forms. I am told the way to do this is with stateless forms and a master form but I cannot find any information on how to do this. Please can someone point me in the right direction to manage this? Thank you!
Display only one Value in a table
Right now, I have a table that gets updated daily. There are separate postage amounts that get put in, and I want to only display the total of all the postage, not each individual postage import. <body> <div class="divTableHeading1">Section A: Costs / Expenses</div> <div class="divTable"> <div class="divTableBody"> <div class="divTableRow1"> <div class="divTableCellB">Invoice Number</div> <div class="divTableCellB">Date</div> <div class="divTableCellB">Description</div> <div class="divTableCellB">Status</div>
Next Page