How can we make the magin on top adjustable
Hi, Im developing an operating tool and UI is really important. I found that the space on top of the application is to big, probably by reducing it we could gain some screen space. Is there something that can be done?
Update a field in second form from Look Up
Hello I have 2 forms that have a relationship through a lookup. I am trying to update a status field to complete when that record has been looked up. The lookup field is looking up an auto number from the first form. Can someone guide me on this Thanks Amanda
Fetching Records from another Applciation
hello I am trying to fetch records from another application Current application name is SMAT Application trying to fetch record from is HR Training, below is what I have tried but getting an error on the first line. x = hr_training.employee_details.employee_name[ID == input.Employee_Details]; //input. refers to fields in current form input.Email_1 = x.Email; Any Help would be greatly appreciated Kind Regards Amanda
Add note/ description to CRM contact via Zoho Creator
Hi, I want to add a new note to a Zoho CRM Contact via Zoho Creator. I have tried different versions of the following code on "on success": crmResp = zoho.crm.updateRecord("Contacts", input.Zoho_CRM_1, { "Description" : input.Info_02 }); But it doesnt work. Could anyone give me an advice on what the problem is? Thx Bo Thygesen
Currency Field Formatting
Howdy - Seems simple. I added a Currency Field to the Form. However, when in runtime, the Form isn't formatting the field as currency ($#,###.##). It's instead (#####.###). How can I get a Currency Field to format itself on the screen as Currency? Thanks for your help - R
Images in JSON REST API
Hello, I developed a contact-like form using Zoho creator and I access the content through a view using an authtoken and JSON. I have an image field in my form and this field is set to appear in the view I use. However the data that I get does not make any sens in the context of JSON because I get an HTML IMG tag. Furthermore, the url of the image in that tag is relative. So to actually get the url of the image I would have to parse the HTML then contextualize the url, but this won't work because
Fetch record not working in subform
Hello I have a form(child) called Training Attendees and a (parent) Training Details The fetch record works when in the training attendees form but it does not work when being used in the subform. Can anyone help me with this Thanks Amanda
Schedule on Workflow not picking correct records
Hi I am new to Deluge and I was assisted by one of the Call Center guys to create a Schedule in my workflow. The schedule works fine except that the records that its emailing to my clients based are not correct. I have a date-time field. Based on the date-time field, i would want records only for THAT date and not to include records from the previous days as well. Below is the deluge script. Pls assist if(zoho.currentdate.getDayOfWeek() != 1) { sendmail [ from :zoho.loginuserid to :zoho.adminuserid
zoho.books.getRecords dropdown get items from Books
Hi For an order form i am creating i want customers to be able to select the items i have (in Zoho Books) to be shown in a dropdown list. Is this possible by using the zoho.books.getRecords or by an API? I checked the following article but with no luck. https://www.zoho.com/creator/help/script/get-records-zoho-books.html#Example Kind regards Kevin
Change Form Title on Edit
Is there a way to change the title of a form for each individual record when editing? For example, if I have a form to add employees, can I have that employee's name listed at the top of the page if I ever go back to edit their record, instead of the original form name? Thanks for any suggestions!
Invalid Authtoken (Code 14)
Hi, I am trying to access contact data from Books from within Creator with the below: I have omitted the organisation ID for zero's for obvious reasons: if(group_client != null) { response = zoho.books.getRecords("contacts","00000000000","contact_name=Gina"); info response; } I keep getting the following message: {"message":"Invalid value passed for authtoken.","code":14} I have tried everything and nothing works... Can anyone help!?
Sliding Commission Scale
Hello All, I have two tables. The first table is my sold jobs and has the Profit Margin. The second table has my commission rates. In this table there are two records. The active commission scale and an inactive commission scale that is not being used any longer, but associates with some older Sales. Each record has the commission rates and the breakpoints . see screenshot: for clarification. The sliding scale works like this: If the profit margin is between 0-20.99% it pays a 2% commission,
Display uploaded image in HTML view
I'm new to Zoho Creator and need help understanding how to render an uploaded image onto an HTML view. I've read other posts and I've tried different things, but I still can't get it to work. Maybe I'm not understanding something??? I have a form with the upload_image field and display_image field with formula (as noted in the forum). I created a List View based on the form and the image renders as expected. Now, on each record listed in the List View, I have a custom action called [View] which
Problem fetching images, and displaying in Creator App
I'm designing a mobile interview process application for my school system. Applicants can add a photo to their registration, but getting their uploaded image to display in another form was problematic. Instead of just displaying the image field value, I had to use: person.Portrait.replaceFirst("sharedBy","[MY USERNAME]").replaceFirst("appLinkName","fcss-job-fair").replaceFirst("viewLinkName","Registrants_Report").replaceFirst("fieldName","Portrait"); This allowed me to display the image in a Notes
Creating a custom page
Hi there I have a report called "All Transaction List" which lists all transactions including date of transaction, chart of account code, Dr and Cr amounts. I now want to create a Profit and Loss report using this information. So I am trying to create a Page for that. I have written some code for doing that but it gives me errors when trying to save it. Can someone please help me with what I am doing wrong in that code?? The error shows up in line where the Myfunction is defined? It keeps saying
Zoho Creator - "Underlying Data"
I am running a chart report in zoho creator. I drill down and eventuallly select "view underlying data". I wantr to be able to email or print that data... How do I do that?
Print and save form
Trying to build an app for our Racquet stringing business. Want to be able to print customer information and save as a separate record. If they have multiple racquets want to save separately.
Wordpress plugin for creator is not working
Hi all, I can't get Wordpress plug in to work. I see it in the menu after installation, which means to me it was installed. When I click it, it will start but never finish loading. Anyone can give some pointers? Thanks.
Fields not showing in report builder
Hi, I am not seeing several fields that I need to build reports. They are not multi-select fields, just look up and drop down fields. Found this from 9 months ago, but going to properties also didn't help. Thanks, Jeff
Export as Excel; Can I do it all at once for all reports in my App
My App has some 10 to 12 reports. So far I take app backups on a daily automatic schedule but to get the report data in excel format once a week I manually go to each table and export the data as xls or csv. But is there a way to get (say) all 10 to 12 excel or csv files at one shot? Rather than go to each report which is time consuming? Alternatively, the.ds file that is produced, does this have all the excels or something within it?
Tip 1: Avoid the most common error while using a Lookup in Deluge.
Hi everyone, Today, we'll look at how to compare different data types. Like other programming languages, Deluge supports seven different kinds of data types -- String, Bigint, Decimal, Timestamp, Boolean, List, and Map. To perform particular actions, we often try to compare or match two different data types. Let's look at a simple example: In the below given IF condition, we are trying to check if the left expression which is a text field is equal to "Jack". if (input.name == "Jack") { alert "Hi
zoho creator backup will not contain the files that were uploaded using the File upload field.
I just read this warning buried in the zoho documentation: "The backup will not contain the files that were uploaded using the File upload field" I think this is a serious flaw. In any decent application today there will be elements that are uploads. e.g. scans, pdf's photos etc. In case of a crash how does one recover these? Are there workarounds? It's like an online Photo storage app saying they can recover metadata but not photos themselves.
Rounding non decimal number
Hi, I have created a function which takes 2 numbers and performs our calculations perfectly. However, I can't seem to find a function to round the number such as: 2214 -> round to 2210 2218 -> round to 2220 I have tried all the functions and searched the forums to no result. Does anybody have any ideas? Thanks
Calculate Pivot Table Column Difference
I would like to have a pivot table calculate the difference between columns in the table but I don't see how to do that. My data is rows of expenses by month by expense category, for example Category, Month, Amount Power, January 2018, $115 Water, January 2018, $25 Power, February 2018, $120 Water, February 2018, $22 My pivot table has Category as the rows Month as the columns Amount as the data in each column For example January 2018 February 2018 Power $115 $120 Water $25 $22 Is there a way that
How to filter a unique row with highest number of interaction in a list report?
Hi, I have a view named Customer Interactions in which I have captured multiple interactions of a customer. Fields are Unique ID, Customer Name, Interaction No#, Interaction Date and Follow up date. It is possible to have a multiple interactions with a customer in a same day with same follow up date. For those type of multiple interactions I just want to show a single row having highest Interaction Number(On every interaction ,Interaction No# increment by 1). ref: Figure - it contains 3 record of
link in html page in dialog
Hello, I have a HTML view open in dialog mode (zc_LoadIn=dialog). Inside the html code I have links to other views (<a href="#View:XXX">link name</a>) When I click in a link, the site is loaded but the popup windows (html view in dialog) not disappear. How can I do it? <a target="_top" href=.... <a target="_self" href=.... etc... not working. Navigator: Mozilla 3.6 Thanks
Pivot chart axis reverse order
Hi I’d like to create bar chart whose Y axis is reverse order. Means smaller value will show higher. Please advice.
Azure SQL Database
How do I make a live connection to SQL Server on Azure from ZOHO Creator?
How to have a graph (from the values in the entry) show in the record summary?
Is it possible to build one/two graphs form the data inside a record and show those graps in the record summary/print summary? Thanks
Field in a record to be updated based on some conditions in another condition on the same form.
I am new to Deluge Scripts so am posting this issue here so someone can assist me. I have a form with the following fields. (1) Date, (2) Priority, (3) Due Date, (4) Past Due Date Priority is a drop-down field with three options namely High, Medium and Low. High Priority will have 30 days, Medium will have 60 days and Low will have 180 days. Below is the scenario: If someone enters date into the Date field and selects High from the Priority drop down field then automatically the Due Date should
Add AVG value of selected records into dashboard
Dear all, I created a Dashboard and displayed a report up in the screen. Right below the "List" report I'd like to add a field that displays the AVG value of a "VOTE" field that I'm displaying up in the screen. This field must be dynamic because it should reflect the average vote of the above selected report. Say for example the report is displaying all the votes a student got for multiple topics, it has multiple lines per student with different votes depending on the subject. The field should calculate
Round to the nearest 5?
Hi, Is it possible to round to the nearest 5 or so in Zoho Creator? So 30.5 would round down to 30 and 30.6 would round up to 31 and so forth? I'm sure it's an easy answer and I'm over-thinking this... Thanks
QUERY
Can we use a SQL Query in ZOHO Creator; I have a form and then I want to have a query based on information contained in the form report; Can we create a form which can query this report
Date Time Format
Hi I have to create a calendar entry as follows: Departure Date and Time Arrival Date and time I would like the date and time to be displayed as Date: Hour; Min and no seconds Can I have both these vaues displayed side by side ( horizontally) rather than one after the other vertically
Email Quotation through 'Quotation Management' App
I'm new to using Zoho, and been playing about with the 'Quotation Management' app, pretty much set it up the way I want it (not really changed that much from original app), There is a decision box for emailing the customer the quotation, but it is actually sending 'You've been granted access to Quotation Management by Company Name' email, where I thought it would send a PDF document with the actual customer quotation details?. Can anyone point me in the right direction? Thanks in advance, John.
How to Move a Record from One Form to Another Using Condition
Hello, I've seen one or two similar questions regarding moving data from one form to another, however it did not involve the same scenario and testing out the code (customising to my own variables) on their solutions, did not work. So I just created a new database, I'm new to Creator since it's to replace an old database. I currently have one form/report named "Live" (since they're live jobs being dealt with), and another named "Archive" - used for what jobs have been completed... but keeping a log
One Dashboard for customers with only their personal data
Hello, I want to know if I can make a Dashboard for customers that when they access they only see information they have submitted? I want to create an app for customers so they can see how much money they have spend in our products. Thank!
How to change account status and send email to customer (non-repeatedly)
Hi, I have created a client form. On the form, I have 2 options being "Operational" and "On Hold". I have created the code that triggers "On Update" an email is sent to the user about the account change, however, I can't figure a way to stop it doing it - as in only once. Each time I update the form it resends. Do I have to capture the existing status and compare or something similar to only send it once? Thanks
ist of URL's to be whitelisted for using zoho projects
List of URL's to be whitelisted for using zoho projects without interruption, as there is no direct access to any application in our environment.
Date-Time Error on record update,
Hello I have this simple loop script to update a date-time field with a date/time specified. I have the variable being passed in as a DateTime, but im receiving and error that the timechange variable needs to be datetime? It already is? Can you look and see why this is erroring out? //Define the query to locate all the records that match a zip code. query = "Zip_Code:equals:75056"; //Create the list col_leads = zoho.crm.searchRecords("Leads", query); //Date-Time for the record update. timechange
Next Page