'Data Added successfully' message optional
Hi. I use the Zoho creator app for my work. It works very well and I am mostly pleased with it, but there is one aspect in particular that is highly annoying and time inefficient. When I press the submit button and successfully submit data, it pops up with a 'Data Added Successfully' message. I then have to click the ok button to acknowledge it before it reloads the form. I would like to request that this message be optional, or even that it be like the desktop version, where the message is displayed
for each <myvariable> in
I am trying to sort records in a for each loop and it appears that it is not sorting. The records always appear to sort in the order of the record ID rather than the field name 'Priority'. Here is my actual code. for each bldCycle in Build_Cycle_Form[Status == "Pending" || Status == "In Process"] sort by Priority I am pretty sure this was working last week. I am still working in my sandbox. I have not published this application yet.
How to set report criteria to show records that have a field value that is in a list
In this past post: https://help.zoho.com/portal/en/community/topic/how-can-i-control-the-display-permission-of-report-with-deluge-script-zoho-creator An example was given for report criteria where-in only records with the department field matching the single department the user was associated with in the user form: Department.ID == User[Email == zoho.loginuser.id].Department but that only works if User[Email == zoho.loginuser.id].Department only returns one single department ID, but what if this
How to restrict user to download the attachment and is it possible to view pdf attachment in browser with out downloading ?
How to restrict user to download the attachment and is it possible to view pdf attachment in browser with out downloading
How to fetch data of a blank subform
Good Morning, I have a form with deluge name Sales_Manual which consists of a decision box (Name 'Upload') and a blank subform (Name 'Spa_Table'). Blank Subform has two single line fields 'Location' and "Main_Building_Level_3" I would like when I click the decision box then to load in the blank subform the values of a specific (already) inserted record. I am doing something wrong in my code (inside the loop) because the below returns the same value in each record of the subform if (Upload) { for
Passing a form to a function
ZC team: I saw that now it's possible to pass a certain form as an argument in a function. I suppose that this means that half of the job Passing form in the function argument and related improvement in custom action posted at http://help.creator.zoho.com/Working-on.html is done ( still no change in the custom actions - so if you pass a form parameter to a function, you can't use it in a custom action ). Regarding the use of this feature, I saw that if you have for example the form sampleform with
which field is suitable for calculating minutes. the function is with two data&time return type as string.
the function for two date&time fields is as below written. string calculator.get_hours_min(date Finish_date, date Start_date) { mil_sec = Finish_date - Start_date; actual_minutes = mil_sec / (1000 * 60); mins = actual_minutes.toLong() % 60; hours = (actual_minutes / 60).toLong(); time_string = hours + ":" + mins; return time_string; } Executed Successfully Return Value: 0:3 my requirement is to get the output on an other field. which has to be display output of above function.
Filter embed report in pages
Hello, I have a custom action that send a value to a Page by url. This is working. I have sent me the value to an email and the value is correct. I want to use this value in an embed report to filter the values. This doesn't work. When I hard code a value, it works. Here is the script in my Page: *****this does not work ------------------------------------------- htmlpage Resume_de_site(numsiteselected) displayname = "Résumé de site" content <%{ siteresume = numsiteselected; %> <%=siteresume%> <%
Custom function to create event is adding 6hrs to start time?
My custom function works except it is adding 6 hours to the event start time. I've tried various solutions but none have worked. Any suggestions? It's pulling the datetime from a custom field in my Lead record. The event date/time in my lead record field is named 'Product Demo'. My code is below. void new_event_demo (int leadId, date product_demo, string meeting_id, string meeting_url ) leadDetails = zoho.crm.getRecordById("Leads",input.leadId); start_time=input.product_demo.toTime(); end_time=start_time.addHour(1);
Filter openURL for all IDs in a list
I have a multi-select lookup field. My ultimate goal is to be able to add IDs from the picklist and then be able to edit them without having to submit the main form. The only idea i have is to have a checkbox under the lookup field that when checked, would open a report/view of ONLY the records inside the multi-select lookup field. This way I'll be able to edit the records. My question is, how do I go passing parameters thru openURL so that I see only the IDs inside the current lookup field? If
Marketplace There is no such application in Zoho Creator
Hi all, I go to marketplace in zoho creator but non of them allow me to install. When I click Install app it pop up message There is "no such application in Zoho Creator". What is the problem?
Deluge - Fetch Records
Hi, all! I'm new here, and new to using this platform. I've got a form with a whole lot of radio buttons and dropdowns, and I'd like to add a feature that would copy the previous record's entries to the current form. So, I don't have two different forms with a relationship between them, but rather a form that is filled out, and then on to the next record. I'm told there's no single function for this, but that a Decision box plus Fetch Records can accomplish this; but I'm not quite seeing how to do
Search Action on Page?
i have a page with 4 different reports adding on it , In every Report there is a field Customer so i want when i search any customer name then only related record shows up on list from all 4 reports . is that possible to make single search action for all reports ?
Passing a parameter to html page
Hi Zoho! I just realized I can pass a parameter to an html page through its URL. for example, to have the url as: #Page:test_page?Project_Name=ProjectText and than the Project_Name variable inside the html page will be updated with "ProjectText" Question - what should I write inside the html page in order it will get the parameter from the url? Thanks! Ravid
Combine Applications
Hello! I have searched for my problem but haven't find anything. So... I have two applications for my two companies. For managing payments there is a money form (fields as: date, account, purpose, amount etc.) in each application. I have third main application where I want to put all the combined data collected from these two applications into one form/table. Please, need your advise - how it is better to be developed. I have no ideas. I've tried direct links as: insert into application2.form_name
Record summary
hello, I have two templates of Record Summary, I'd like set as Active the default and I'd like create a Custom Action for generate the other. How can I do? Thanks
Automatically populate the zipcode , city name, country name based on the Address ?
basically i need when someone entering address they will get drop-down options of similar what they are typing and after filling the address other fields(Country , City , Zip-code) are automatically filled shown in below pic.
Embedded Reports in page
I have an embedded report in a page. However, I do not want all the information in the report to be included? For example, I am keeping data for 10 properties. However, On this particular page I only want the data from one particular property. Can I filter the others out? Thanks
Zoho Creator Crashes on iphone
Hi Zoho people, Zoho Creator app crashes on iphone. Please advice me to fix this. Selva
Our Forums is transitioning to a new platform - Zoho Community
Kindly refer the link below for more info on this. https://help.zoho.com/portal/community/topic/zoho-community-is-transitioning-to-a-new-platform
Readability enhancement for reports
Greetings Everyone, We are really glad to inform you all that, we are rolling out some updates which will really improve the readability of content in all types of our reports which will be updated mostly by the end of this week. The enhancements we've made mainly pertain to better font formatting, line spacing and some of the other UI elements. I'm attaching some screenshots which portrays this change, you can see how the old report looked and how the new changed one will look like. Please note
Show only date in report date / time field
So we want to have a report that only shows the date portion of a date / time field instead of the hours minutes and seconds. Also can you get rid of the seconds field when adding the date/time, we don't want to have to set them seconds or minutes really, we want to have to only set the hours and not have to worry about the minutes and seconds. even if you could make it so that the minutes and seconds were there but preset to 00:00 leaving you to just set the hour. thanks I hope my question is clear.
Please specify a valid date value in application date format
im tryng tocreate a rule that triggers action after 3 days, i dont know how to give instrution to the program to complete the rule because shows "" i dont know the way complete the action , i just put 3 bettween "" , it didnt work
Is there a way to add custom fields to the user objecty/form?
Is there a way to add custom fields to the user objecty/form? If not what is the best way to extend the table?
Schedule navigation bug
Hi Zoho, When navigating between the schedules in my app, there's a huge lag until the "what to do" tab is opened. Many times it doesn't even open on the right schedule (!!) and instead is opened for the previously viewed schedule. This is very confusing, sometimes I start to make changes in the wrong one. Please take a look and fix this Thanks Ravid
How to AND Search in Multi select / Checkbox fields?
I already this doumentation https://www.zoho.com/creator/help/script/search-records.html#newsearch but i can not do it in my application.
Problem in updating Zoho Creator form from a browser
Hi, After publishing my form, when I try to update the form from a browser, I get the following error message. You can submit this form only from the Zoho Creator mobile app. For more details visit this page. Please advice me to fix this one. Selva
DOMAIN CHANGE
please I need to beg this admin of the site that the domain am using is expired and I want to change to temporary one but the site did not accept it, please help me out
How to build business form and other documents in your own format quickly
Hi guys, Let me share a tip to develop original business form and document such as invoice or receipt in Zoho creator. Problem: When you have to write a template of invoice with HTML in Zoho creator / Deluge script, what you would do is to write a function to return HTML strings so that the invoice would be generated dynamically with client name, product and whatever. Here is an example of codes from generateInvoice function of Order Management app provided by Zoho officially. This function will
Where To Insert Deluge Code
Hello... I am brand new to Zoho and I've been handed a project. I am the sole IT Director and IT person at my company so I'm expected to take on any and all IT related projects. They had someone with coding experience in our building engineering department start on a project but they recommended ZoHo and they turned over his work in progress to me. So beyond learning ZoHo and Deluge, I also have to figure out where he left off and where to go from here. He started a project in ZoHo Creator where
Hidden field keeps adding value
I have created a form that builds an Estimate for Books. I have a field hidden depending on a previous field selection, the problem is the SKU for the hidden field keeps getting listed along with the SKU of the shown field. Can anyone help with a solution to this? Here is the code for the 2 fields, only one of those fields is shown on the form at any one time.... if(input.Container_Pref6 != "None") { sku = "6MB"; } else { sku = "6MT"; } getitemsd = zoho.invoice.getRecords("Items",orgid,"Status.All",sku);
Edit next record
It would be useful to add a button that allows to edit next filtered records after submit. Now if I edit a record and submit, I must scroll to find the next record that I want to edit. Thanks
Job Position
We are looking for a Zoho Developer with 2 years of hands-on experience building applications on Zoho Creator. This position is based in Atlanta, Georgia. See additional details below: JOB DESCRIPTION: Georgia Building Authority is seeking to hire on a temporary contract basis a ZOHO knowledge developer who shall be skilled in Application Programming, T-SQL Querying, and API Referencing. MINIMUM QUALIFICATIONS: - Two years hands-on experience designing, developing, and integrating applications with
How new ADD Note will Shows on Top in Report ??
Hie , Created a Subform (Add Note) with existing two Fields :- 1. Date Field (Date) 2. Multiline Field (Note) and created one Custom Action (Add Note) which is button , whenever we click the button the Subform (Add Note) Fields Popup on Screen . When i add new note on Add Note it shows below the previous Add Note in reports , wanna show New Add Note on top always .
Pivot Table - Filter DOB field by Month not Year
Form "Employee" includes a DOB field, and a "Manager" field. I need a pivot table to show, for each unique Manager, a list of all their employees with birthdays in each month. I want to apply a User Filter for This Month, and Next Three Months. How do I get the DOB to filter by the month only, and not the year??
Populate picklist with Zoho Books contacts visualization names
Hi everyone, I need to populate a picklist with all contacts visualization names available in Zoho Books. I think that this will be possible by this integration: zoho.books.getRecords("Contacts", myOrg). I get a map with all contact information. Is there a way to fetch only the names of my customers and add them to my picklist? Thanks
How can I control the display permission of report with Deluge Script, Zoho Creator
Hi, When displaying a Report with Zoho Creator, I want to use Deluge Script to control the report's visibility by the department of the user who is logged in: display permission user's IP Address restriction dynamic filter criteria setting to the report On Form, I understand we can run Deluge on OnLoad. If there is no OnLoad functionality to Report, please let me know the workaround to achieve the above requirement. Thanks, Junya rashiku corp.
Display picture in header of report
Hello, Is there a way to add a picture in the header of a report? If its possible also to change the picture depending on the zoho.loginuser? Thanks
Dynamically updating subform content within a parentform
I have a very simple CMR form where users can chose from a pull down list of users on the parent form. The idea is to have the embedded childform (containing 4 to 5 fields) dynamically update after a selection was made on the parent form. I am unable to find a code snippet or a clear example on how to do this.I'm a little confused as to why when a subform is added it does not prompt you for a parent or a one-to-many-relational key to the parent form. In any event here is what I'm trying to associate
I want to add data from Zoho creator to reports
While submitting a form in Zoho creator I want my data to add to my Zoho reports database. I write a code in "on success" CreatingMap = map(); CreatingMap.put("Name", input.Name); CreatingMap.put("Address", input.Address); CreatingMap.put("Email id", input.Email_id); CreatingMap.put("Mobile Number", input.Mobile_Number); MapResponse = zoho.reports.createRow("My Database", "ContactsDB", CreatingMap); But it shows me an error message while I submit the data in Zoho Creator. This is my Zoho reports
Next Page