How to add an image in a description tooltip text?
I would like to ask you if you have plans to change the description tooltip of a field as a rich text? Until now is a simple text box. For example, I would like to have an image as tooltip Something like the below https://www.scriptol.com/css/tooltip.php I know that there are alternative ways like add notes field but it is not working with mouse hover like the tooltip.
Send an Email
I want send an email data to my department which is approved in last month.
How to Split the String to Array/List?
Hi.... I have an string like "ABCDEF"...But I want to convert it into list/array like "[A,B,C,D,E,F]"...... Can any one help me?
Financial Year
Hello, How do i setup financial year in Zoho Creator.
Help counting and calculating date differences in arrayed data
I have no experience scripting for arrays, indexed lists, etc. and need help to deluge-script the following business need: I have an event_form, with a date_field, employee_field and time_field. For any given date, the number of records logged by a employee varies from one date to another. I also have a summary_form, with a date_field, employee_field, recordcount_field, and hours_field. The script should accomplish something like this, diagramed in plain English: For each date_field value and each
Form Script Not Work When I Open from Report Edit Menu
Hi, i wrote some script for my form and they working well. But when i open a form with edit menu in report scripts not work at all. For example i use some hide, diasble script for some fields. But i open the form from report edit menu all hidden fields are appear and all fields enable. How can i fix that. Add some codes to a report? or add a diffrent edit button to report. Can you help me? Thank you... (i am sorry for my English if confused)
Printing to Dymo Printer in Zoho Creator
I'm trying to build a system that lets volunteers sign in for their shift. After filling out the form, I would like to use the data from the form to print a nametag on a Dymo printer. Is that possible?
Creating a Lookup Field that Dynamically Filters
Hi Zoho Community, I'm having trouble understanding the best way to create a dynamic dropdown. Let's say I have 5 Product categories: A, B, C, D, and E. Within each category, I have 4 components: 1, 2, 3, and 4. But each component is unique to that product. So product A has components A1, A2, A3, and A4; product B has components B1, B2, B3, and B4; etc. I'd like to create a form that allows our system administrators to edit the products and categories, and I'm currently using a form and a subform
How do I store historical data of customer records for trend analysis?
I am attempting to build a customer profile database that tracks historical data. I work in high performance athletic care. Almost 100% of our business centers around long term care rather than Sales or Deals. For that reason we need a robust solution for tracking incremental incremental changes in a great deal of information over time for each individual, similar to a hospital patient care system. Examples include practice attendance records, injury and therapy progression over time, improvements
Color-coded records in calendar report
Hi, When displaying records in a calendar report, it would be nice to group records based on a field and assign a color for each group. Alternatively this could be done automatically with autogenerated colors like in Page's graph. Here is an example. This would help a lot when reading staff workloads, calendar events per company department, tasks by locations, etc.
Filter report based on subform's column?
Hi there! So i have created a report based on a form that also has a subform in it. They are related with a bidirectional relationship. The problem is that in the report (where i have 1 column from the form and 1 column from the subform), filtering options doesn't work when applied to the subform's column. If you see the attached image you will understand better what i'm traying to acomplish. In that picture there is a filter aplied to show only records from the last month (date is from subform).
How to include the multi Picklist field in Fetch Record Criteria in Deluge Script?
Hi All, Need an help. I have a problem to restrict the fetch record based on multi pick list value( Look up field having capable to select more than one value- bigintlist). Problem Outline. I have a Attendance Form which has a Absent-Students multi picklist and date field. for getting the student information for a month or certain period. To get the Attendance details for a particular student i have to restrict it based on course and semester details. but not on student id to the absent-students
Multi (More than 2) Level Form Relationships
I know that relationships are formed between 2 forms using lookup fields. Is there a way to add a 3rd level to the relationship? For example I have an app that contains Sales Orders. Each Sales Order has multiple Shipments and each shipment has multiple Inventory items. So I have a 1:M relationship between the "Sales Order" form and the "Shipments" form. And I also have a 1:M relationship between my "Shipments" form and my "Inventory" form. I need to create an invoice that has fields from all
Zoho API returns incorrect IDs from what I see on the report
I successfully created an entry in a form using the Zoho Creator Api and I got back a response with an ID of 62389000000083070 but when I look on the report page the actual ID is 62389000000083083. Interestingly enough, thinking it was just a timing issue I then queried the api and again it returns the ID as 62389000000083070. This is causing an issue for me as once the record has been added I actually want to upload the required files for that record and I need the exact ID to do it. I have included
Can Zoho apps exchange data with internal corporate applications?
I'm experimenting with Zoho Creator as a possible tool to build some data entry forms for some internal corporate applications. I quite like the ease of creating forms with Zoho Creator, but I don't know how data collected by the forms could be passed to our internal batch processes. Is there some way to send the data from a Zoho form submission as XML or JSON to an internal business application?
Subform calculation
Hi, I have made a form with 4 subforms. I have added 4 fields that calculate the total for each subform (just adding numbers from each row). Used following code to do that: t = 0.0; for each spolu in Platby_CP { t = t + spolu.Suma; } input.Spolu_platby_CP = t; Where Platby_CP is my subform and Suma is the value that I add. For each subform I only modify the name of the subform in line 2 and the field in last line. I ran into the following problem - some subforms I get the right number. In some however,
Pictures (icons) beside matrix choice when building form
Hi, I have tried to build online version of our word document safety form. However while in the word form we have only 2 A4 pages on the online form we have 6 pages when converted to pdf, and there is no option to put small icons besiade matrix choice name. I attached our pdf version for my original document called Safe system work plan. And zoho form version called Form 26-Nov-2019. I have to admit that prefer version with icons. It is any chance to get layout similar to original version? TIA
How to prevent overwriting data when using stateless forms to add data to larger form
I have 2 stateless forms that populate a report. For the second stateless form, want to prevent users from re-entering data and overwriting the existing data. I have a look up field that locates the record and the user enters the additional data on the stateless form which is input into the master form. How do I write a deluge script on submission to: -only transfer the data if certain fields are null - if fields are not null cancel submit and show alert I tried to write multiple if/else scripts
ZOHO CREATOR DATA PUSH TO CRM
I am attempting to add a potential to my crm through creator. The script saves and there are no errors on the form. The potential is not however created in the CRM. I have posted the script below. Some feed back would be appreciated. fund = Map(); fund.put("Funding Opportunity Owner", Submission_Owner); fund.put("Closing Date", Predicted_Closing_Date); fund.put("Funding Opportunity Name", Business_Name); fund.put("Business Name", Business_Name); fund.put("Expected Revenue", Avg_Monthly_Revenue);
Are HTML pages indexed by search engines?
Hello I am wondering if HTML Pages (created in Creator and made public) will be/can be indexed by search engines? We would like to start developing modules to appear in our website, but need the resulting pages to be indexed. By this I mean we would have a search function page - let's say search for property - and when that property is found and selected, the relevant property page would be indexed. Is this possible please? Many thanks
Why does this formula not work?
I have a simple formula that is triggering as true, even when it is not. if(Due_Date != null && Status!="Repeat") { input.Status = "In Progress"; } In that formula (my interpretation), if the date is not blank and the status is not Repeat, then change status to In Progress. However, it is still firing when the status is Repeat and changing the status to In Progress. I think it has something to do with the date field. Really not sure why it isn't working at expected Any help? Thanks Michael
Shopping Basket in creator.
Hi, i want to implement a "shopping basket"-like functionality in ZOHO Creator. Does anyone have a hint, how to approach this? Problem: Normally i would create an order form and sub-forms to create the items of an order - selection via lookup-field. the problem is, the amount of products is so big and i need something to pre-select the items somewho e.g. product vendor, product category, sub-category,... so my thought was to display a list of products (report) and add a custom function "add to basket"
How can I see custom fields while integrating CRM modules into Creator
I'm trying to integrate CRM and creator. I created a form and the form has a field which is integrating the CRM module into the form. However, the form doesnt give me option to choose the relevant field. The field I'm trying to choose is a custom field.
compare 2 reports for the same data
Hi All, I seem to not be getting any information back in my emails when executing this script. " b = Collections[Bin_Number != ""]; bincheck = Master_Bin_List[Bin_Number != b.Bin_Number && Ignore_in_count != false].Bin_Number.getAll(); if(bincheck != null) { sendmail [ from: zoho.adminuserid to: "email address" subject: "bin check" message: bincheck ] } " I am essentially checking if any bins have not been used, and then send an email list if they have not been used. Anyone can help?
Finding sample apps
I am reading this https://www.zoho.com/creator/help/forms/creating-relationship.html and it mentions the "Employee Manager" app. Where is this app? How can I copy it? Zoho: If the tutorials do not make sense anymore, please take them down.
ZOHO Creator Developer
HI All, we are looking for Zoho Creator Developer (Permanent job) with the below : Website Integration - Integrated Zoho product (Zoho CRM, Zoho Books, Zoho Campaign, SalesIQ, Desk, etc ). - Created Reports and Dashboard in Zoho Report and CRM - Custom Function. - Zoho Creator. - Third Party API Integration. Location: Jordan if you are interested please email inbox me with your CV at: a.freij@e-megatech.com
Importing .xls / Column limit/ Subforms/ Converting radio buttons to numerics/
I had a form working well in Zoho Forms but decided to turn it into a Creator project because Creator allows you to use a camera on an iPad etc. The application is really just a form that allows me to go onsite and fill in a bunch of details- this in turn merges with a Zoho Writer doc and spits out a report for the client. But I have a couple of issues - my form was 148 columns but Creator won't take more than 70 via Excel. I got around this by creating each section as a different Excel Sheet, but
Find out if course register is already registered
Hello, I have a form for a course registration with a field of Delegate_ID. I want that field when entered to check whether the Delegate_ID is already registered against the Delegate Registration form (report). I have tried this but it doesn't work... Looking for some guidance: check_id = Delegate_Registration [ Delegate_ID == input.Delegate_ID ]; if (Delegate_ID.count == 0) { alert "Please register first "; }
How do you populate an address field using Deluge?
I can't see this documented anywhere. There is auto complete but it seems buggy. Would be great if you could create a documentation page for this. Same for Name fields (there appears to be no autocomplete at all for Name). For reference: input.Address.address_line_1 = address_line_1; input.Address.address_line_2 = address_Line_2; input.Address.district_city = address_city; input.Address.postal_Code = address_postal_Code;
Calculate the the CRC-16-CCITT in Zoho creator function
I need a custom function in Zoho creator to calculate CRC-16-CCITT with polynom (hex): 1021 Initial value (hex) :FFFF the function is use to calculate CRC-16 by returning a 4-digit Hex value with a string input. like input the string of "00020101021126270012hk.com.hkicl020782419455204000053033445802HK5902NA6002HK6304" it returns "6674" (hex) or "00020101021226430012hk.com.hkicl0418wsdinfo@wsd.gov.hk060115204000053033445406174.605802HK5902NA6002HK62150111979072028366304" returns "65CB" (hex)
Programmatically set the selected item in dropdown on form open ?
Hi all, I have a form in a Creator App with a dropdown of 15 items. On opening the form, I want the first item to be selected. After hitting submit, the same form is shown but this time I want the second item selected. And so on to item 15. How would I achieve this ? I see there is a pattern of field aliases discussed here https://www.zoho.com/forms/help/settings/field-alias.html . would I use this ? e.g. https://forms.zohopublic.com/.../?fieldalias_gc=Group1&fieldalias=option2 Thanks in advance,
Translate lookup field value into single line field
Hi All, I have two separate applications: app_one and app_two app_one contains a form with a single line text field "email_one" app_two contains a form with a lookup field "lookup_email" and a single line text field "translate" When a user selects a value from the lookup I would like the value to appear in "translate" I've attempted the following with no joy: hello= app_one[ID = input.email_one]; input.translate = hello.lookup_email; Can someone tell me what I'm doing wrong? Thank you in advance.
Send confirmation email using the default template on submit if the Status field == Submitted
Dear Zoho Creator Team, Is it possible to write in Deluge script to trigger the Send confirmation email using the default template on submit if the Status field == Submitted ? The currently default template is fine however can I trigger Creator to use this template to send an email conformation to several departments when a user updates our Status field for the form to equal "Submitted" Currently, the form sends the default template when the form is first submitted. However, I would like to only
Related dropdown fields
I have the following master table of States and Cities. How do I insert related fields in another form, so when the State is selected, only those cities in that particular state are displayed in the City field. Currently the lookup fields in separate forms show all states and cities. State City California LA California San Diego California San Francisco California Fresno Florida Jacksonville Florida Miami Florida Orlando
Limit some profiles to web and others to mobile portal
it would be great if we could control which profiles can access the web portal version and which can access the mobile version of the portal. that way we can give access for administration to the portal web user, and acceas for the regular user to the mobile app only.
Hide/Show section based on a subform entry
Hello Creator community, Question - can I hide/show a section based on whether or not a value exists within a subform? Example: A subform contains a picklist called "Tax Forms". If an item is added to the subform with a "W-2" in the "Tax Forms" field, can it then show a section elsewhere in the app called "Additional W-2 info"? Where I'm at: Here is the screen I would normally add the workflow to hide/show a section. But the "Select a field" drop-down doesn't allow me to set the condition to a value
Counter from 2 dates
Hi I am trying to create a formula where it gives me a number by subtracting difference from 2 dates Completion_Counter (result to go here) Reported_Date - Date_of_Completion = Completion_Counter Is this possible so for example if report by date is 20/11/2019 and Date of Completion is 21/11/2019 the result on Completion Counter will be 1 Thank you for help
Creator Change Title Housing Forms and Reports
How can I rename the portion highlighted in red in attached image
Add parent form fields to subforms pivot report?
Hi there! Is there a way to add the fields from a Form when creating a pivot table based on it's subform??
How do i add Deluge strings into an html snippet in a page??
Hi! I know nothing about html... I'm trying to add the current date to the html code, but i don't know how. If i put it like this it shows the text "zoho.currentdate" instead of the date. HTML SNippet Code: <%{ %> <table border="1" cellpadding="0" cellspacing="0" style="width: 20cm; height: 2cm;"> <tbody> <tr style="height: 1cm;"> <td align="center" rowspan="2" style="width: 3cm; height: 2cm;" valign="middle"> <p> <img src="https://i.ibb.co/1GbhqLd/Marca-Madre.jpg"
Next Page